db-v0.14.7_2021-04-20_23-53-07.dump

BEGIN TRANSACTION;CREATE TABLE "analytics_pingbacknotification" ("id" varchar(50) NOT NULL PRIMARY KEY, "version_range" varchar(50) NOT NULL, "timestamp" date NOT NULL, "link_url" varchar(150) NOT NULL, "i18n" text NOT NULL, "active" bool NOT NULL, "source" varchar(20) NOT NULL);CREATE TABLE "analytics_pingbacknotificationdismissed" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "notification_id" varchar(50) NOT NULL REFERENCES "analytics_pingbacknotification" ("id"), "user_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"));CREATE TABLE "auth_group" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(80) NOT NULL UNIQUE);CREATE TABLE "auth_group_permissions" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "group_id" integer NOT NULL REFERENCES "auth_group" ("id"), "permission_id" integer NOT NULL REFERENCES "auth_permission" ("id"));CREATE TABLE "auth_permission" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "content_type_id" integer NOT NULL REFERENCES "django_content_type" ("id"), "codename" varchar(100) NOT NULL, "name" varchar(255) NOT NULL);INSERT INTO "auth_permission" VALUES(1,1,'add_logentry','Can add log entry');INSERT INTO "auth_permission" VALUES(2,1,'change_logentry','Can change log entry');INSERT INTO "auth_permission" VALUES(3,1,'delete_logentry','Can delete log entry');INSERT INTO "auth_permission" VALUES(4,2,'add_permission','Can add permission');INSERT INTO "auth_permission" VALUES(5,2,'change_permission','Can change permission');INSERT INTO "auth_permission" VALUES(6,2,'delete_permission','Can delete permission');INSERT INTO "auth_permission" VALUES(7,3,'add_group','Can add group');INSERT INTO "auth_permission" VALUES(8,3,'change_group','Can change group');INSERT INTO "auth_permission" VALUES(9,3,'delete_group','Can delete group');INSERT INTO "auth_permission" VALUES(10,4,'add_contenttype','Can add content type');INSERT INTO "auth_permission" VALUES(11,4,'change_contenttype','Can change content type');INSERT INTO "auth_permission" VALUES(12,4,'delete_contenttype','Can delete content type');INSERT INTO "auth_permission" VALUES(13,5,'add_session','Can add session');INSERT INTO "auth_permission" VALUES(14,5,'change_session','Can change session');INSERT INTO "auth_permission" VALUES(15,5,'delete_session','Can delete session');INSERT INTO "auth_permission" VALUES(16,6,'add_collection','Can add collection');INSERT INTO "auth_permission" VALUES(17,6,'change_collection','Can change collection');INSERT INTO "auth_permission" VALUES(18,6,'delete_collection','Can delete collection');INSERT INTO "auth_permission" VALUES(19,7,'add_facilitydataset','Can add facility dataset');INSERT INTO "auth_permission" VALUES(20,7,'change_facilitydataset','Can change facility dataset');INSERT INTO "auth_permission" VALUES(21,7,'delete_facilitydataset','Can delete facility dataset');INSERT INTO "auth_permission" VALUES(22,8,'add_facilityuser','Can add facility user');INSERT INTO "auth_permission" VALUES(23,8,'change_facilityuser','Can change facility user');INSERT INTO "auth_permission" VALUES(24,8,'delete_facilityuser','Can delete facility user');INSERT INTO "auth_permission" VALUES(25,9,'add_membership','Can add membership');INSERT INTO "auth_permission" VALUES(26,9,'change_membership','Can change membership');INSERT INTO "auth_permission" VALUES(27,9,'delete_membership','Can delete membership');INSERT INTO "auth_permission" VALUES(28,10,'add_role','Can add role');INSERT INTO "auth_permission" VALUES(29,10,'change_role','Can change role');INSERT INTO "auth_permission" VALUES(30,10,'delete_role','Can delete role');INSERT INTO "auth_permission" VALUES(31,6,'add_classroom','Can add classroom');INSERT INTO "auth_permission" VALUES(32,6,'change_classroom','Can change classroom');INSERT INTO "auth_permission" VALUES(33,6,'delete_classroom','Can delete classroom');INSERT INTO "auth_permission" VALUES(34,6,'add_facility','Can add facility');INSERT INTO "auth_permission" VALUES(35,6,'change_facility','Can change facility');INSERT INTO "auth_permission" VALUES(36,6,'delete_facility','Can delete facility');INSERT INTO "auth_permission" VALUES(37,6,'add_learnergroup','Can add learner group');INSERT INTO "auth_permission" VALUES(38,6,'change_learnergroup','Can change learner group');INSERT INTO "auth_permission" VALUES(39,6,'delete_learnergroup','Can delete learner group');INSERT INTO "auth_permission" VALUES(40,6,'add_adhocgroup','Can add ad hoc group');INSERT INTO "auth_permission" VALUES(41,6,'change_adhocgroup','Can change ad hoc group');INSERT INTO "auth_permission" VALUES(42,6,'delete_adhocgroup','Can delete ad hoc group');INSERT INTO "auth_permission" VALUES(43,15,'add_assessmentmetadata','Can add assessment meta data');INSERT INTO "auth_permission" VALUES(44,15,'change_assessmentmetadata','Can change assessment meta data');INSERT INTO "auth_permission" VALUES(45,15,'delete_assessmentmetadata','Can delete assessment meta data');INSERT INTO "auth_permission" VALUES(46,16,'add_channelmetadata','Can add channel metadata');INSERT INTO "auth_permission" VALUES(47,16,'change_channelmetadata','Can change channel metadata');INSERT INTO "auth_permission" VALUES(48,16,'delete_channelmetadata','Can delete channel metadata');INSERT INTO "auth_permission" VALUES(49,17,'add_contentnode','Can add content node');INSERT INTO "auth_permission" VALUES(50,17,'change_contentnode','Can change content node');INSERT INTO "auth_permission" VALUES(51,17,'delete_contentnode','Can delete content node');INSERT INTO "auth_permission" VALUES(52,18,'add_contenttag','Can add content tag');INSERT INTO "auth_permission" VALUES(53,18,'change_contenttag','Can change content tag');INSERT INTO "auth_permission" VALUES(54,18,'delete_contenttag','Can delete content tag');INSERT INTO "auth_permission" VALUES(55,19,'add_file','Can add file');INSERT INTO "auth_permission" VALUES(56,19,'change_file','Can change file');INSERT INTO "auth_permission" VALUES(57,19,'delete_file','Can delete file');INSERT INTO "auth_permission" VALUES(58,20,'add_language','Can add language');INSERT INTO "auth_permission" VALUES(59,20,'change_language','Can change language');INSERT INTO "auth_permission" VALUES(60,20,'delete_language','Can delete language');INSERT INTO "auth_permission" VALUES(61,21,'add_localfile','Can add local file');INSERT INTO "auth_permission" VALUES(62,21,'change_localfile','Can change local file');INSERT INTO "auth_permission" VALUES(63,21,'delete_localfile','Can delete local file');INSERT INTO "auth_permission" VALUES(64,22,'add_attemptlog','Can add attempt log');INSERT INTO "auth_permission" VALUES(65,22,'change_attemptlog','Can change attempt log');INSERT INTO "auth_permission" VALUES(66,22,'delete_attemptlog','Can delete attempt log');INSERT INTO "auth_permission" VALUES(67,23,'add_contentsessionlog','Can add content session log');INSERT INTO "auth_permission" VALUES(68,23,'change_contentsessionlog','Can change content session log');INSERT INTO "auth_permission" VALUES(69,23,'delete_contentsessionlog','Can delete content session log');INSERT INTO "auth_permission" VALUES(70,24,'add_contentsummarylog','Can add content summary log');INSERT INTO "auth_permission" VALUES(71,24,'change_contentsummarylog','Can change content summary log');INSERT INTO "auth_permission" VALUES(72,24,'delete_contentsummarylog','Can delete content summary log');INSERT INTO "auth_permission" VALUES(73,25,'add_examattemptlog','Can add exam attempt log');INSERT INTO "auth_permission" VALUES(74,25,'change_examattemptlog','Can change exam attempt log');INSERT INTO "auth_permission" VALUES(75,25,'delete_examattemptlog','Can delete exam attempt log');INSERT INTO "auth_permission" VALUES(76,26,'add_examlog','Can add exam log');INSERT INTO "auth_permission" VALUES(77,26,'change_examlog','Can change exam log');INSERT INTO "auth_permission" VALUES(78,26,'delete_examlog','Can delete exam log');INSERT INTO "auth_permission" VALUES(79,27,'add_masterylog','Can add mastery log');INSERT INTO "auth_permission" VALUES(80,27,'change_masterylog','Can change mastery log');INSERT INTO "auth_permission" VALUES(81,27,'delete_masterylog','Can delete mastery log');INSERT INTO "auth_permission" VALUES(82,28,'add_usersessionlog','Can add user session log');INSERT INTO "auth_permission" VALUES(83,28,'change_usersessionlog','Can change user session log');INSERT INTO "auth_permission" VALUES(84,28,'delete_usersessionlog','Can delete user session log');INSERT INTO "auth_permission" VALUES(85,29,'add_learnerprogressnotification','Can add learner progress notification');INSERT INTO "auth_permission" VALUES(86,29,'change_learnerprogressnotification','Can change learner progress notification');INSERT INTO "auth_permission" VALUES(87,29,'delete_learnerprogressnotification','Can delete learner progress notification');INSERT INTO "auth_permission" VALUES(88,30,'add_notificationslog','Can add notifications log');INSERT INTO "auth_permission" VALUES(89,30,'change_notificationslog','Can change notifications log');INSERT INTO "auth_permission" VALUES(90,30,'delete_notificationslog','Can delete notifications log');INSERT INTO "auth_permission" VALUES(91,31,'add_exam','Can add exam');INSERT INTO "auth_permission" VALUES(92,31,'change_exam','Can change exam');INSERT INTO "auth_permission" VALUES(93,31,'delete_exam','Can delete exam');INSERT INTO "auth_permission" VALUES(94,32,'add_examassignment','Can add exam assignment');INSERT INTO "auth_permission" VALUES(95,32,'change_examassignment','Can change exam assignment');INSERT INTO "auth_permission" VALUES(96,32,'delete_examassignment','Can delete exam assignment');INSERT INTO "auth_permission" VALUES(97,33,'add_devicepermissions','Can add device permissions');INSERT INTO "auth_permission" VALUES(98,33,'change_devicepermissions','Can change device permissions');INSERT INTO "auth_permission" VALUES(99,33,'delete_devicepermissions','Can delete device permissions');INSERT INTO "auth_permission" VALUES(100,34,'add_devicesettings','Can add device settings');INSERT INTO "auth_permission" VALUES(101,34,'change_devicesettings','Can change device settings');INSERT INTO "auth_permission" VALUES(102,34,'delete_devicesettings','Can delete device settings');INSERT INTO "auth_permission" VALUES(103,35,'add_contentcachekey','Can add content cache key');INSERT INTO "auth_permission" VALUES(104,35,'change_contentcachekey','Can change content cache key');INSERT INTO "auth_permission" VALUES(105,35,'delete_contentcachekey','Can delete content cache key');INSERT INTO "auth_permission" VALUES(106,36,'add_deviceappkey','Can add device app key');INSERT INTO "auth_permission" VALUES(107,36,'change_deviceappkey','Can change device app key');INSERT INTO "auth_permission" VALUES(108,36,'delete_deviceappkey','Can delete device app key');INSERT INTO "auth_permission" VALUES(109,37,'add_sqlitelock','Can add sq lite lock');INSERT INTO "auth_permission" VALUES(110,37,'change_sqlitelock','Can change sq lite lock');INSERT INTO "auth_permission" VALUES(111,37,'delete_sqlitelock','Can delete sq lite lock');INSERT INTO "auth_permission" VALUES(112,38,'add_networklocation','Can add network location');INSERT INTO "auth_permission" VALUES(113,38,'change_networklocation','Can change network location');INSERT INTO "auth_permission" VALUES(114,38,'delete_networklocation','Can delete network location');INSERT INTO "auth_permission" VALUES(115,38,'add_dynamicnetworklocation','Can add dynamic network location');INSERT INTO "auth_permission" VALUES(116,38,'change_dynamicnetworklocation','Can change dynamic network location');INSERT INTO "auth_permission" VALUES(117,38,'delete_dynamicnetworklocation','Can delete dynamic network location');INSERT INTO "auth_permission" VALUES(118,38,'add_staticnetworklocation','Can add static network location');INSERT INTO "auth_permission" VALUES(119,38,'change_staticnetworklocation','Can change static network location');INSERT INTO "auth_permission" VALUES(120,38,'delete_staticnetworklocation','Can delete static network location');INSERT INTO "auth_permission" VALUES(121,41,'add_lesson','Can add lesson');INSERT INTO "auth_permission" VALUES(122,41,'change_lesson','Can change lesson');INSERT INTO "auth_permission" VALUES(123,41,'delete_lesson','Can delete lesson');INSERT INTO "auth_permission" VALUES(124,42,'add_lessonassignment','Can add lesson assignment');INSERT INTO "auth_permission" VALUES(125,42,'change_lessonassignment','Can change lesson assignment');INSERT INTO "auth_permission" VALUES(126,42,'delete_lessonassignment','Can delete lesson assignment');INSERT INTO "auth_permission" VALUES(127,43,'add_pingbacknotification','Can add pingback notification');INSERT INTO "auth_permission" VALUES(128,43,'change_pingbacknotification','Can change pingback notification');INSERT INTO "auth_permission" VALUES(129,43,'delete_pingbacknotification','Can delete pingback notification');INSERT INTO "auth_permission" VALUES(130,44,'add_pingbacknotificationdismissed','Can add pingback notification dismissed');INSERT INTO "auth_permission" VALUES(131,44,'change_pingbacknotificationdismissed','Can change pingback notification dismissed');INSERT INTO "auth_permission" VALUES(132,44,'delete_pingbacknotificationdismissed','Can delete pingback notification dismissed');INSERT INTO "auth_permission" VALUES(133,45,'add_buffer','Can add buffer');INSERT INTO "auth_permission" VALUES(134,45,'change_buffer','Can change buffer');INSERT INTO "auth_permission" VALUES(135,45,'delete_buffer','Can delete buffer');INSERT INTO "auth_permission" VALUES(136,46,'add_certificate','Can add certificate');INSERT INTO "auth_permission" VALUES(137,46,'change_certificate','Can change certificate');INSERT INTO "auth_permission" VALUES(138,46,'delete_certificate','Can delete certificate');INSERT INTO "auth_permission" VALUES(139,47,'add_databaseidmodel','Can add database id model');INSERT INTO "auth_permission" VALUES(140,47,'change_databaseidmodel','Can change database id model');INSERT INTO "auth_permission" VALUES(141,47,'delete_databaseidmodel','Can delete database id model');INSERT INTO "auth_permission" VALUES(142,48,'add_databasemaxcounter','Can add database max counter');INSERT INTO "auth_permission" VALUES(143,48,'change_databasemaxcounter','Can change database max counter');INSERT INTO "auth_permission" VALUES(144,48,'delete_databasemaxcounter','Can delete database max counter');INSERT INTO "auth_permission" VALUES(145,49,'add_deletedmodels','Can add deleted models');INSERT INTO "auth_permission" VALUES(146,49,'change_deletedmodels','Can change deleted models');INSERT INTO "auth_permission" VALUES(147,49,'delete_deletedmodels','Can delete deleted models');INSERT INTO "auth_permission" VALUES(148,50,'add_instanceidmodel','Can add instance id model');INSERT INTO "auth_permission" VALUES(149,50,'change_instanceidmodel','Can change instance id model');INSERT INTO "auth_permission" VALUES(150,50,'delete_instanceidmodel','Can delete instance id model');INSERT INTO "auth_permission" VALUES(151,51,'add_recordmaxcounter','Can add record max counter');INSERT INTO "auth_permission" VALUES(152,51,'change_recordmaxcounter','Can change record max counter');INSERT INTO "auth_permission" VALUES(153,51,'delete_recordmaxcounter','Can delete record max counter');INSERT INTO "auth_permission" VALUES(154,52,'add_recordmaxcounterbuffer','Can add record max counter buffer');INSERT INTO "auth_permission" VALUES(155,52,'change_recordmaxcounterbuffer','Can change record max counter buffer');INSERT INTO "auth_permission" VALUES(156,52,'delete_recordmaxcounterbuffer','Can delete record max counter buffer');INSERT INTO "auth_permission" VALUES(157,53,'add_scopedefinition','Can add scope definition');INSERT INTO "auth_permission" VALUES(158,53,'change_scopedefinition','Can change scope definition');INSERT INTO "auth_permission" VALUES(159,53,'delete_scopedefinition','Can delete scope definition');INSERT INTO "auth_permission" VALUES(160,54,'add_store','Can add store');INSERT INTO "auth_permission" VALUES(161,54,'change_store','Can change store');INSERT INTO "auth_permission" VALUES(162,54,'delete_store','Can delete store');INSERT INTO "auth_permission" VALUES(163,55,'add_syncsession','Can add sync session');INSERT INTO "auth_permission" VALUES(164,55,'change_syncsession','Can change sync session');INSERT INTO "auth_permission" VALUES(165,55,'delete_syncsession','Can delete sync session');INSERT INTO "auth_permission" VALUES(166,56,'add_transfersession','Can add transfer session');INSERT INTO "auth_permission" VALUES(167,56,'change_transfersession','Can change transfer session');INSERT INTO "auth_permission" VALUES(168,56,'delete_transfersession','Can delete transfer session');INSERT INTO "auth_permission" VALUES(169,57,'add_nonce','Can add nonce');INSERT INTO "auth_permission" VALUES(170,57,'change_nonce','Can change nonce');INSERT INTO "auth_permission" VALUES(171,57,'delete_nonce','Can delete nonce');INSERT INTO "auth_permission" VALUES(172,58,'add_sharedkey','Can add shared key');INSERT INTO "auth_permission" VALUES(173,58,'change_sharedkey','Can change shared key');INSERT INTO "auth_permission" VALUES(174,58,'delete_sharedkey','Can delete shared key');INSERT INTO "auth_permission" VALUES(175,59,'add_harddeletedmodels','Can add hard deleted models');INSERT INTO "auth_permission" VALUES(176,59,'change_harddeletedmodels','Can change hard deleted models');INSERT INTO "auth_permission" VALUES(177,59,'delete_harddeletedmodels','Can delete hard deleted models');CREATE TABLE "content_assessmentmetadata" ("id" char(32) NOT NULL PRIMARY KEY, "assessment_item_ids" text NOT NULL, "number_of_assessments" integer NOT NULL, "mastery_model" text NOT NULL, "randomize" bool NOT NULL, "is_manipulable" bool NOT NULL, "contentnode_id" char(32) NOT NULL REFERENCES "content_contentnode" ("id"));CREATE TABLE "content_channelmetadata" ("id" char(32) NOT NULL PRIMARY KEY, "name" varchar(200) NOT NULL, "description" varchar(400) NOT NULL, "author" varchar(400) NOT NULL, "version" integer NOT NULL, "thumbnail" text NOT NULL, "last_updated" varchar NULL, "min_schema_version" varchar(50) NOT NULL, "root_id" char(32) NOT NULL REFERENCES "content_contentnode" ("id"), "published_size" bigint NULL, "total_resource_count" integer NULL, "order" integer unsigned NULL, "public" bool NULL, "tagline" varchar(150) NULL);CREATE TABLE "content_channelmetadata_included_languages" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "channelmetadata_id" char(32) NOT NULL REFERENCES "content_channelmetadata" ("id"), "language_id" varchar(14) NOT NULL REFERENCES "content_language" ("id"));CREATE TABLE "content_contentnode" ("id" char(32) NOT NULL PRIMARY KEY, "title" varchar(200) NOT NULL, "content_id" char(32) NOT NULL, "channel_id" char(32) NOT NULL, "description" text NULL, "sort_order" real NULL, "license_owner" varchar(200) NOT NULL, "author" varchar(200) NOT NULL, "kind" varchar(200) NOT NULL, "available" bool NOT NULL, "lft" integer unsigned NOT NULL, "rght" integer unsigned NOT NULL, "tree_id" integer unsigned NOT NULL, "level" integer unsigned NOT NULL, "lang_id" varchar(14) NULL REFERENCES "content_language" ("id"), "license_description" text NULL, "license_name" varchar(50) NULL, "coach_content" bool NOT NULL, "num_coach_contents" integer NULL, "on_device_resources" integer NULL, "options" text NULL, "parent_id" char(32) NULL REFERENCES "content_contentnode" ("id"));CREATE TABLE "content_contentnode_has_prerequisite" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "from_contentnode_id" char(32) NOT NULL REFERENCES "content_contentnode" ("id"), "to_contentnode_id" char(32) NOT NULL REFERENCES "content_contentnode" ("id"));CREATE TABLE "content_contentnode_related" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "from_contentnode_id" char(32) NOT NULL REFERENCES "content_contentnode" ("id"), "to_contentnode_id" char(32) NOT NULL REFERENCES "content_contentnode" ("id"));CREATE TABLE "content_contentnode_tags" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "contentnode_id" char(32) NOT NULL REFERENCES "content_contentnode" ("id"), "contenttag_id" char(32) NOT NULL REFERENCES "content_contenttag" ("id"));CREATE TABLE "content_contenttag" ("id" char(32) NOT NULL PRIMARY KEY, "tag_name" varchar(30) NOT NULL);CREATE TABLE "content_file" ("id" char(32) NOT NULL PRIMARY KEY, "preset" varchar(150) NOT NULL, "supplementary" bool NOT NULL, "thumbnail" bool NOT NULL, "priority" integer NULL, "contentnode_id" char(32) NOT NULL REFERENCES "content_contentnode" ("id"), "lang_id" varchar(14) NULL REFERENCES "content_language" ("id"), "local_file_id" varchar(32) NOT NULL REFERENCES "content_localfile" ("id"));CREATE TABLE "content_language" ("id" varchar(14) NOT NULL PRIMARY KEY, "lang_code" varchar(3) NOT NULL, "lang_subcode" varchar(10) NULL, "lang_name" varchar(100) NULL, "lang_direction" varchar(3) NOT NULL);CREATE TABLE "content_localfile" ("id" varchar(32) NOT NULL PRIMARY KEY, "available" bool NOT NULL, "file_size" integer NULL, "extension" varchar(40) NOT NULL);CREATE TABLE "device_contentcachekey" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "key" integer NOT NULL);INSERT INTO "device_contentcachekey" VALUES(1,1618951042);CREATE TABLE "device_deviceappkey" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "key" char(32) NOT NULL);CREATE TABLE "device_devicepermissions" ("user_id" char(32) NOT NULL PRIMARY KEY REFERENCES "kolibriauth_facilityuser" ("id"), "is_superuser" bool NOT NULL, "can_manage_content" bool NOT NULL);INSERT INTO "device_devicepermissions" VALUES('5153602b5a84aa3ed3df788ff77dae8f',1,1);CREATE TABLE "device_devicesettings" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "is_provisioned" bool NOT NULL, "language_id" varchar(15) NULL, "default_facility_id" char(32) NULL REFERENCES "kolibriauth_collection" ("id"), "allow_guest_access" bool NOT NULL, "allow_learner_unassigned_resource_access" bool NOT NULL, "allow_peer_unlisted_channel_import" bool NOT NULL, "landing_page" varchar(7) NOT NULL, "name" varchar(50) NOT NULL, "allow_other_browsers_to_connect" bool NOT NULL);INSERT INTO "device_devicesettings" VALUES(1,1,'en','f122768d86e4aa9c5649cf4fb920ecf7',1,1,0,'sign-in','kolibri',0);CREATE TABLE "device_sqlitelock" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT);CREATE TABLE "discovery_networklocation" ("base_url" varchar(100) NOT NULL, "application" varchar(32) NOT NULL, "kolibri_version" varchar(100) NOT NULL, "instance_id" varchar(32) NOT NULL, "device_name" varchar(100) NOT NULL, "operating_system" varchar(32) NOT NULL, "added" datetime NOT NULL, "last_accessed" datetime NOT NULL, "dynamic" bool NOT NULL, "nickname" varchar(100) NOT NULL, "id" varchar(36) NOT NULL PRIMARY KEY);CREATE TABLE "django_admin_log" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "object_id" text NULL, "object_repr" varchar(200) NOT NULL, "action_flag" smallint unsigned NOT NULL, "change_message" text NOT NULL, "content_type_id" integer NULL REFERENCES "django_content_type" ("id"), "user_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"), "action_time" datetime NOT NULL);CREATE TABLE "django_content_type" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "app_label" varchar(100) NOT NULL, "model" varchar(100) NOT NULL);INSERT INTO "django_content_type" VALUES(1,'admin','logentry');INSERT INTO "django_content_type" VALUES(2,'auth','permission');INSERT INTO "django_content_type" VALUES(3,'auth','group');INSERT INTO "django_content_type" VALUES(4,'contenttypes','contenttype');INSERT INTO "django_content_type" VALUES(5,'sessions','session');INSERT INTO "django_content_type" VALUES(6,'kolibriauth','collection');INSERT INTO "django_content_type" VALUES(7,'kolibriauth','facilitydataset');INSERT INTO "django_content_type" VALUES(8,'kolibriauth','facilityuser');INSERT INTO "django_content_type" VALUES(9,'kolibriauth','membership');INSERT INTO "django_content_type" VALUES(10,'kolibriauth','role');INSERT INTO "django_content_type" VALUES(11,'kolibriauth','classroom');INSERT INTO "django_content_type" VALUES(12,'kolibriauth','facility');INSERT INTO "django_content_type" VALUES(13,'kolibriauth','learnergroup');INSERT INTO "django_content_type" VALUES(14,'kolibriauth','adhocgroup');INSERT INTO "django_content_type" VALUES(15,'content','assessmentmetadata');INSERT INTO "django_content_type" VALUES(16,'content','channelmetadata');INSERT INTO "django_content_type" VALUES(17,'content','contentnode');INSERT INTO "django_content_type" VALUES(18,'content','contenttag');INSERT INTO "django_content_type" VALUES(19,'content','file');INSERT INTO "django_content_type" VALUES(20,'content','language');INSERT INTO "django_content_type" VALUES(21,'content','localfile');INSERT INTO "django_content_type" VALUES(22,'logger','attemptlog');INSERT INTO "django_content_type" VALUES(23,'logger','contentsessionlog');INSERT INTO "django_content_type" VALUES(24,'logger','contentsummarylog');INSERT INTO "django_content_type" VALUES(25,'logger','examattemptlog');INSERT INTO "django_content_type" VALUES(26,'logger','examlog');INSERT INTO "django_content_type" VALUES(27,'logger','masterylog');INSERT INTO "django_content_type" VALUES(28,'logger','usersessionlog');INSERT INTO "django_content_type" VALUES(29,'notifications','learnerprogressnotification');INSERT INTO "django_content_type" VALUES(30,'notifications','notificationslog');INSERT INTO "django_content_type" VALUES(31,'exams','exam');INSERT INTO "django_content_type" VALUES(32,'exams','examassignment');INSERT INTO "django_content_type" VALUES(33,'device','devicepermissions');INSERT INTO "django_content_type" VALUES(34,'device','devicesettings');INSERT INTO "django_content_type" VALUES(35,'device','contentcachekey');INSERT INTO "django_content_type" VALUES(36,'device','deviceappkey');INSERT INTO "django_content_type" VALUES(37,'device','sqlitelock');INSERT INTO "django_content_type" VALUES(38,'discovery','networklocation');INSERT INTO "django_content_type" VALUES(39,'discovery','dynamicnetworklocation');INSERT INTO "django_content_type" VALUES(40,'discovery','staticnetworklocation');INSERT INTO "django_content_type" VALUES(41,'lessons','lesson');INSERT INTO "django_content_type" VALUES(42,'lessons','lessonassignment');INSERT INTO "django_content_type" VALUES(43,'analytics','pingbacknotification');INSERT INTO "django_content_type" VALUES(44,'analytics','pingbacknotificationdismissed');INSERT INTO "django_content_type" VALUES(45,'morango','buffer');INSERT INTO "django_content_type" VALUES(46,'morango','certificate');INSERT INTO "django_content_type" VALUES(47,'morango','databaseidmodel');INSERT INTO "django_content_type" VALUES(48,'morango','databasemaxcounter');INSERT INTO "django_content_type" VALUES(49,'morango','deletedmodels');INSERT INTO "django_content_type" VALUES(50,'morango','instanceidmodel');INSERT INTO "django_content_type" VALUES(51,'morango','recordmaxcounter');INSERT INTO "django_content_type" VALUES(52,'morango','recordmaxcounterbuffer');INSERT INTO "django_content_type" VALUES(53,'morango','scopedefinition');INSERT INTO "django_content_type" VALUES(54,'morango','store');INSERT INTO "django_content_type" VALUES(55,'morango','syncsession');INSERT INTO "django_content_type" VALUES(56,'morango','transfersession');INSERT INTO "django_content_type" VALUES(57,'morango','nonce');INSERT INTO "django_content_type" VALUES(58,'morango','sharedkey');INSERT INTO "django_content_type" VALUES(59,'morango','harddeletedmodels');CREATE TABLE "django_migrations" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "app" varchar(255) NOT NULL, "name" varchar(255) NOT NULL, "applied" datetime NOT NULL);INSERT INTO "django_migrations" VALUES(1,'kolibriauth','0001_initial','2021-04-20 20:35:59.592175');INSERT INTO "django_migrations" VALUES(2,'contenttypes','0001_initial','2021-04-20 20:36:00.141938');INSERT INTO "django_migrations" VALUES(3,'admin','0001_initial','2021-04-20 20:36:00.811074');INSERT INTO "django_migrations" VALUES(4,'admin','0002_logentry_remove_auto_add','2021-04-20 20:36:01.491107');INSERT INTO "django_migrations" VALUES(5,'analytics','0001_initial','2021-04-20 20:36:03.121787');INSERT INTO "django_migrations" VALUES(6,'contenttypes','0002_remove_content_type_name','2021-04-20 20:36:04.866807');INSERT INTO "django_migrations" VALUES(7,'auth','0001_initial','2021-04-20 20:36:07.672934');INSERT INTO "django_migrations" VALUES(8,'auth','0002_alter_permission_name_max_length','2021-04-20 20:36:08.241771');INSERT INTO "django_migrations" VALUES(9,'auth','0003_alter_user_email_max_length','2021-04-20 20:36:08.715358');INSERT INTO "django_migrations" VALUES(10,'auth','0004_alter_user_username_opts','2021-04-20 20:36:09.645701');INSERT INTO "django_migrations" VALUES(11,'auth','0005_alter_user_last_login_null','2021-04-20 20:36:10.380060');INSERT INTO "django_migrations" VALUES(12,'auth','0006_require_contenttypes_0002','2021-04-20 20:36:12.073417');INSERT INTO "django_migrations" VALUES(13,'auth','0007_alter_validators_add_error_messages','2021-04-20 20:36:12.475026');INSERT INTO "django_migrations" VALUES(14,'auth','0008_alter_user_username_max_length','2021-04-20 20:36:13.086395');INSERT INTO "django_migrations" VALUES(15,'content','0001_initial','2021-04-20 20:36:13.312847');INSERT INTO "django_migrations" VALUES(16,'content','0002_channelmetadatacache_last_updated','2021-04-20 20:36:13.701783');INSERT INTO "django_migrations" VALUES(17,'content','0003_auto_20170607_1212','2021-04-20 20:36:13.745548');INSERT INTO "django_migrations" VALUES(18,'content','0004_auto_20170825_1038','2021-04-20 20:36:23.255392');INSERT INTO "django_migrations" VALUES(19,'content','0005_auto_20171009_0903','2021-04-20 20:36:26.613092');INSERT INTO "django_migrations" VALUES(20,'content','0006_auto_20171128_1703','2021-04-20 20:36:27.282707');INSERT INTO "django_migrations" VALUES(21,'content','0007_auto_20180212_1155','2021-04-20 20:36:28.125022');INSERT INTO "django_migrations" VALUES(22,'content','0008_contentnode_coach_content','2021-04-20 20:36:29.186861');INSERT INTO "django_migrations" VALUES(23,'content','0009_auto_20180410_1139','2021-04-20 20:36:32.182512');INSERT INTO "django_migrations" VALUES(24,'content','0008_auto_20180429_1709','2021-04-20 20:36:34.418890');INSERT INTO "django_migrations" VALUES(25,'content','0010_merge_20180504_1540','2021-04-20 20:36:34.455421');INSERT INTO "django_migrations" VALUES(26,'content','0011_auto_20180907_1017','2021-04-20 20:36:37.282538');INSERT INTO "django_migrations" VALUES(27,'content','0012_auto_20180910_1702','2021-04-20 20:36:38.989670');INSERT INTO "django_migrations" VALUES(28,'content','0013_auto_20180919_1142','2021-04-20 20:36:40.763396');INSERT INTO "django_migrations" VALUES(29,'content','0014_auto_20181218_1132','2021-04-20 20:36:41.763557');INSERT INTO "django_migrations" VALUES(30,'content','0015_auto_20190125_1715','2021-04-20 20:36:43.652435');INSERT INTO "django_migrations" VALUES(31,'content','0016_auto_20190124_1639','2021-04-20 20:36:45.116486');INSERT INTO "django_migrations" VALUES(32,'content','0017_auto_20190415_1855','2021-04-20 20:36:46.312236');INSERT INTO "django_migrations" VALUES(33,'content','0018_contentnode_num_coach_contents','2021-04-20 20:36:47.523708');INSERT INTO "django_migrations" VALUES(34,'content','0019_contentnode_slideshow_options','2021-04-20 20:36:49.913567');INSERT INTO "django_migrations" VALUES(35,'content','0020_le_utils_0_20_upgrade_migration','2021-04-20 20:36:51.622726');INSERT INTO "django_migrations" VALUES(36,'content','0021_remove_contentnode_stemmed_metaphone','2021-04-20 20:36:52.772742');INSERT INTO "django_migrations" VALUES(37,'content','0022_remove_file_available','2021-04-20 20:36:54.013135');INSERT INTO "django_migrations" VALUES(38,'content','0023_contentnode_on_device_resources','2021-04-20 20:36:55.092688');INSERT INTO "django_migrations" VALUES(39,'content','0024_channelmetadata_public','2021-04-20 20:36:56.285088');INSERT INTO "django_migrations" VALUES(40,'content','0025_add_h5p_kind','2021-04-20 20:36:57.436216');INSERT INTO "django_migrations" VALUES(41,'content','0026_contentnode_options','2021-04-20 20:36:58.843182');INSERT INTO "django_migrations" VALUES(42,'content','0027_channelmetadata_tagline','2021-04-20 20:36:59.803899');INSERT INTO "django_migrations" VALUES(43,'kolibriauth','0002_auto_20170608_2125','2021-04-20 20:37:00.624137');INSERT INTO "django_migrations" VALUES(44,'kolibriauth','0003_auto_20170621_0958','2021-04-20 20:37:05.182477');INSERT INTO "django_migrations" VALUES(45,'device','0001_initial','2021-04-20 20:37:06.171872');INSERT INTO "django_migrations" VALUES(46,'kolibriauth','0004_auto_20170816_1607','2021-04-20 20:37:07.823983');INSERT INTO "django_migrations" VALUES(47,'kolibriauth','0005_auto_20170818_1203','2021-04-20 20:37:08.802774');INSERT INTO "django_migrations" VALUES(48,'kolibriauth','0006_auto_20171206_1207','2021-04-20 20:37:12.113114');INSERT INTO "django_migrations" VALUES(49,'kolibriauth','0007_auto_20171226_1125','2021-04-20 20:37:13.633302');INSERT INTO "django_migrations" VALUES(50,'kolibriauth','0008_auto_20180222_1244','2021-04-20 20:37:14.167958');INSERT INTO "django_migrations" VALUES(51,'kolibriauth','0009_auto_20180301_1123','2021-04-20 20:37:15.045038');INSERT INTO "django_migrations" VALUES(52,'kolibriauth','0010_auto_20180320_1320','2021-04-20 20:37:16.102893');INSERT INTO "django_migrations" VALUES(53,'kolibriauth','0011_facilitydataset_show_download_button_in_learn','2021-04-20 20:37:16.855767');INSERT INTO "django_migrations" VALUES(54,'kolibriauth','0012_facilitydataset_allow_guest_access','2021-04-20 20:37:17.594257');INSERT INTO "django_migrations" VALUES(55,'device','0002_devicesettings_default_facility','2021-04-20 20:37:18.715237');INSERT INTO "django_migrations" VALUES(56,'device','0003_contentcachekey','2021-04-20 20:37:22.366836');INSERT INTO "django_migrations" VALUES(57,'device','0004_auto_20190306_0553','2021-04-20 20:37:23.384638');INSERT INTO "django_migrations" VALUES(58,'device','0005_auto_20191203_0951','2021-04-20 20:37:26.843130');INSERT INTO "django_migrations" VALUES(59,'device','0006_migrate_guest_access','2021-04-20 20:37:28.706151');INSERT INTO "django_migrations" VALUES(60,'device','0007_devicesettings_name','2021-04-20 20:37:29.546778');INSERT INTO "django_migrations" VALUES(61,'device','0007_deviceappkey','2021-04-20 20:37:29.752702');INSERT INTO "django_migrations" VALUES(62,'device','0008_merge_20200531_1829','2021-04-20 20:37:29.786307');INSERT INTO "django_migrations" VALUES(63,'device','0008_devicesettings_allow_other_browsers_to_connect','2021-04-20 20:37:30.802917');INSERT INTO "django_migrations" VALUES(64,'device','0009_merge_20200608_1716','2021-04-20 20:37:30.874898');INSERT INTO "django_migrations" VALUES(65,'device','0010_sqlitelock','2021-04-20 20:37:31.198428');INSERT INTO "django_migrations" VALUES(66,'discovery','0001_initial','2021-04-20 20:37:31.432108');INSERT INTO "django_migrations" VALUES(67,'discovery','0002_general_network_location_data_structure','2021-04-20 20:37:34.273875');INSERT INTO "django_migrations" VALUES(68,'exams','0001_initial','2021-04-20 20:37:36.083529');INSERT INTO "django_migrations" VALUES(69,'exams','0002_update_exam_data_model','2021-04-20 20:37:39.556384');INSERT INTO "django_migrations" VALUES(70,'exams','0003_auto_20190426_1015','2021-04-20 20:37:40.825343');INSERT INTO "django_migrations" VALUES(71,'exams','0004_exam_add_dates_opened_created_and_archived','2021-04-20 20:37:46.484166');INSERT INTO "django_migrations" VALUES(72,'kolibriauth','0013_auto_20180917_1213','2021-04-20 20:37:47.558215');INSERT INTO "django_migrations" VALUES(73,'kolibriauth','0014_auto_20190815_1421','2021-04-20 20:37:51.295482');INSERT INTO "django_migrations" VALUES(74,'kolibriauth','0015_facilitydataset_registered','2021-04-20 20:37:52.264596');INSERT INTO "django_migrations" VALUES(75,'kolibriauth','0016_add_adhoclearnersgroup_collection_kind','2021-04-20 20:37:53.744471');INSERT INTO "django_migrations" VALUES(76,'kolibriauth','0017_remove_facilitydataset_allow_guest_access','2021-04-20 20:37:54.734858');INSERT INTO "django_migrations" VALUES(77,'kolibriauth','0018_no_i18n_collection_kinds','2021-04-20 20:37:55.833638');INSERT INTO "django_migrations" VALUES(78,'lessons','0001_initial','2021-04-20 20:37:58.034434');INSERT INTO "django_migrations" VALUES(79,'lessons','0002_auto_20180221_1115','2021-04-20 20:38:03.625058');INSERT INTO "django_migrations" VALUES(80,'logger','0001_initial','2021-04-20 20:38:25.903355');INSERT INTO "django_migrations" VALUES(81,'logger','0002_auto_20170518_1031','2021-04-20 20:39:22.384665');INSERT INTO "django_migrations" VALUES(82,'logger','0003_auto_20170531_1140','2021-04-20 20:39:24.523504');INSERT INTO "django_migrations" VALUES(83,'logger','0004_tidy_progress_range','2021-04-20 20:39:27.382178');INSERT INTO "django_migrations" VALUES(84,'logger','0005_auto_20180514_1419','2021-04-20 20:39:31.306879');INSERT INTO "django_migrations" VALUES(85,'logger','0006_remove_examattemptlog_channel_id','2021-04-20 20:39:33.436931');INSERT INTO "django_migrations" VALUES(86,'logger','0007_contentsessionlog_visitor_id','2021-04-20 20:39:35.526100');INSERT INTO "django_migrations" VALUES(87,'morango','0001_initial','2021-04-20 20:39:46.265419');INSERT INTO "django_migrations" VALUES(88,'morango','0002_auto_20170511_0400','2021-04-20 20:39:54.713303');INSERT INTO "django_migrations" VALUES(89,'morango','0003_auto_20170519_0543','2021-04-20 20:39:56.800781');INSERT INTO "django_migrations" VALUES(90,'morango','0004_auto_20170520_2112','2021-04-20 20:39:59.726011');INSERT INTO "django_migrations" VALUES(91,'morango','0005_auto_20170629_2139','2021-04-20 20:40:01.415033');INSERT INTO "django_migrations" VALUES(92,'morango','0006_instanceidmodel_system_id','2021-04-20 20:40:02.425323');INSERT INTO "django_migrations" VALUES(93,'morango','0007_auto_20171018_1615','2021-04-20 20:40:34.375543');INSERT INTO "django_migrations" VALUES(94,'morango','0008_auto_20171114_2217','2021-04-20 20:40:44.753181');INSERT INTO "django_migrations" VALUES(95,'morango','0009_auto_20171205_0252','2021-04-20 20:40:45.636574');INSERT INTO "django_migrations" VALUES(96,'morango','0010_auto_20171206_1615','2021-04-20 20:40:48.294406');INSERT INTO "django_migrations" VALUES(97,'morango','0011_sharedkey','2021-04-20 20:40:48.564645');INSERT INTO "django_migrations" VALUES(98,'morango','0012_auto_20180927_1658','2021-04-20 20:40:50.746151');INSERT INTO "django_migrations" VALUES(99,'morango','0013_auto_20190627_1513','2021-04-20 20:40:51.685229');INSERT INTO "django_migrations" VALUES(100,'morango','0014_syncsession_extra_fields','2021-04-20 20:40:53.005787');INSERT INTO "django_migrations" VALUES(101,'morango','0015_auto_20200508_2104','2021-04-20 20:40:54.985549');INSERT INTO "django_migrations" VALUES(102,'morango','0016_store_deserialization_error','2021-04-20 20:40:55.892042');INSERT INTO "django_migrations" VALUES(103,'notifications','0001_initial','2021-04-20 20:40:56.156700');INSERT INTO "django_migrations" VALUES(104,'notifications','0002_notificationslog','2021-04-20 20:40:56.413516');INSERT INTO "django_migrations" VALUES(105,'notifications','0003_learnerprogressnotification_quiz_num_correct','2021-04-20 20:40:56.757826');INSERT INTO "django_migrations" VALUES(106,'notifications','0004_learnerprogressnotification_quiz_num_answered','2021-04-20 20:40:57.621882');INSERT INTO "django_migrations" VALUES(107,'notifications','0005_learnerprogressnotification_assignment_collections','2021-04-20 20:40:58.154847');INSERT INTO "django_migrations" VALUES(108,'sessions','0001_initial','2021-04-20 20:40:58.426319');CREATE TABLE "django_session" ("session_key" varchar(40) NOT NULL PRIMARY KEY, "session_data" text NOT NULL, "expire_date" datetime NOT NULL);CREATE TABLE "exams_exam" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "title" varchar(200) NOT NULL, "question_count" integer NOT NULL, "question_sources" text NOT NULL, "seed" integer NOT NULL, "active" bool NOT NULL, "archive" bool NOT NULL, "collection_id" char(32) NOT NULL REFERENCES "kolibriauth_collection" ("id"), "creator_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"), "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "data_model_version" smallint NOT NULL, "learners_see_fixed_order" bool NOT NULL, "date_created" datetime NULL, "date_archived" datetime NULL, "date_activated" datetime NULL);CREATE TABLE "exams_examassignment" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "assigned_by_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"), "collection_id" char(32) NOT NULL REFERENCES "kolibriauth_collection" ("id"), "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "exam_id" char(32) NOT NULL REFERENCES "exams_exam" ("id"));CREATE TABLE "kolibriauth_collection" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "name" varchar(100) NOT NULL, "lft" integer unsigned NOT NULL, "rght" integer unsigned NOT NULL, "tree_id" integer unsigned NOT NULL, "level" integer unsigned NOT NULL, "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "kind" varchar(20) NOT NULL, "parent_id" char(32) NULL REFERENCES "kolibriauth_collection" ("id"));INSERT INTO "kolibriauth_collection" VALUES('f122768d86e4aa9c5649cf4fb920ecf7',1,'c99cab58133a47e092d6e2e9d82cfcd0','0922fe4c01655735cdd57097f52ee837:allusers-ro','Home Facility Nick',1,2,1,0,'0922fe4c01655735cdd57097f52ee837','facility',NULL);CREATE TABLE "kolibriauth_facilitydataset" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "description" text NOT NULL, "location" varchar(200) NOT NULL, "learner_can_edit_username" bool NOT NULL, "learner_can_edit_name" bool NOT NULL, "learner_can_edit_password" bool NOT NULL, "learner_can_sign_up" bool NOT NULL, "learner_can_delete_account" bool NOT NULL, "learner_can_login_with_no_password" bool NOT NULL, "preset" varchar(50) NOT NULL, "show_download_button_in_learn" bool NOT NULL, "registered" bool NOT NULL);INSERT INTO "kolibriauth_facilitydataset" VALUES('0922fe4c01655735cdd57097f52ee837',1,'0922fe4c01655735cdd57097f52ee837','0922fe4c01655735cdd57097f52ee837:allusers-ro','','',1,1,1,1,1,0,'informal',1,0);CREATE TABLE "kolibriauth_facilityuser" ("password" varchar(128) NOT NULL, "last_login" datetime NULL, "id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "username" varchar(30) NOT NULL, "full_name" varchar(120) NOT NULL, "date_joined" varchar NOT NULL, "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "facility_id" char(32) NOT NULL REFERENCES "kolibriauth_collection" ("id"), "birth_year" varchar(16) NOT NULL, "gender" varchar(16) NOT NULL, "id_number" varchar(64) NOT NULL);INSERT INTO "kolibriauth_facilityuser" VALUES('pbkdf2_sha256$36000$kuPBFTxnJ4tX$oNxlxT7zo6QSbX1WGPU258URVausKgOlZzT2VMGRibs=','2021-04-20 21:56:28.992403','5153602b5a84aa3ed3df788ff77dae8f',1,'6f856519c53f4d93b4e68448fe9ac577','0922fe4c01655735cdd57097f52ee837:user-ro:5153602b5a84aa3ed3df788ff77dae8f','nick','Nick','2021-04-20 21:56:26.705383(Europe/London)','0922fe4c01655735cdd57097f52ee837','f122768d86e4aa9c5649cf4fb920ecf7','DEFERRED','DEFERRED','');CREATE TABLE "kolibriauth_membership" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "collection_id" char(32) NOT NULL REFERENCES "kolibriauth_collection" ("id"), "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "user_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"));CREATE TABLE "kolibriauth_role" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "collection_id" char(32) NOT NULL REFERENCES "kolibriauth_collection" ("id"), "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "user_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"), "kind" varchar(26) NOT NULL);INSERT INTO "kolibriauth_role" VALUES('568e20006c5dfb59f1378fe070d7c5f0',1,'f122768d86e4aa9c5649cf4fb920ecf7:admin','0922fe4c01655735cdd57097f52ee837:user-ro:5153602b5a84aa3ed3df788ff77dae8f','f122768d86e4aa9c5649cf4fb920ecf7','0922fe4c01655735cdd57097f52ee837','5153602b5a84aa3ed3df788ff77dae8f','admin');CREATE TABLE "lessons_lesson" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "title" varchar(50) NOT NULL, "description" varchar(200) NOT NULL, "resources" text NOT NULL, "is_active" bool NOT NULL, "collection_id" char(32) NOT NULL REFERENCES "kolibriauth_collection" ("id"), "created_by_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"), "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "date_created" varchar NOT NULL);CREATE TABLE "lessons_lessonassignment" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "assigned_by_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"), "collection_id" char(32) NOT NULL REFERENCES "kolibriauth_collection" ("id"), "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "lesson_id" char(32) NOT NULL REFERENCES "lessons_lesson" ("id"));CREATE TABLE "logger_attemptlog" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "item" varchar(200) NOT NULL, "start_timestamp" varchar NOT NULL, "end_timestamp" varchar NOT NULL, "completion_timestamp" varchar NULL, "time_spent" real NOT NULL, "complete" bool NOT NULL, "correct" real NOT NULL, "hinted" bool NOT NULL, "answer" text NULL, "simple_answer" varchar(200) NOT NULL, "interaction_history" text NOT NULL, "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "masterylog_id" char(32) NULL REFERENCES "logger_masterylog" ("id"), "sessionlog_id" char(32) NOT NULL REFERENCES "logger_contentsessionlog" ("id"), "user_id" char(32) NULL REFERENCES "kolibriauth_facilityuser" ("id"), "error" bool NOT NULL);CREATE TABLE "logger_contentsessionlog" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "content_id" char(32) NOT NULL, "channel_id" char(32) NOT NULL, "start_timestamp" varchar NOT NULL, "end_timestamp" varchar NULL, "time_spent" real NOT NULL, "progress" real NOT NULL, "kind" varchar(200) NOT NULL, "extra_fields" text NOT NULL, "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "user_id" char(32) NULL REFERENCES "kolibriauth_facilityuser" ("id"), "visitor_id" char(32) NULL);CREATE TABLE "logger_contentsummarylog" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "content_id" char(32) NOT NULL, "channel_id" char(32) NOT NULL, "end_timestamp" varchar NULL, "completion_timestamp" varchar NULL, "time_spent" real NOT NULL, "progress" real NOT NULL, "kind" varchar(200) NOT NULL, "extra_fields" text NOT NULL, "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "user_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"), "start_timestamp" varchar NOT NULL);CREATE TABLE "logger_examattemptlog" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "item" varchar(200) NOT NULL, "start_timestamp" varchar NOT NULL, "end_timestamp" varchar NOT NULL, "completion_timestamp" varchar NULL, "time_spent" real NOT NULL, "complete" bool NOT NULL, "correct" real NOT NULL, "hinted" bool NOT NULL, "answer" text NULL, "simple_answer" varchar(200) NOT NULL, "interaction_history" text NOT NULL, "content_id" char(32) NOT NULL, "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "examlog_id" char(32) NOT NULL REFERENCES "logger_examlog" ("id"), "user_id" char(32) NULL REFERENCES "kolibriauth_facilityuser" ("id"), "error" bool NOT NULL);CREATE TABLE "logger_examlog" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "closed" bool NOT NULL, "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "exam_id" char(32) NOT NULL REFERENCES "exams_exam" ("id"), "user_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"), "completion_timestamp" varchar NULL);CREATE TABLE "logger_masterylog" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "mastery_criterion" text NOT NULL, "end_timestamp" varchar NULL, "completion_timestamp" varchar NULL, "mastery_level" integer NOT NULL, "complete" bool NOT NULL, "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "summarylog_id" char(32) NOT NULL REFERENCES "logger_contentsummarylog" ("id"), "user_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"), "start_timestamp" varchar NOT NULL);CREATE TABLE "logger_usersessionlog" ("id" char(32) NOT NULL PRIMARY KEY, "_morango_dirty_bit" bool NOT NULL, "_morango_source_id" varchar(96) NOT NULL, "_morango_partition" varchar(128) NOT NULL, "channels" text NOT NULL, "start_timestamp" varchar NOT NULL, "pages" text NOT NULL, "dataset_id" char(32) NOT NULL REFERENCES "kolibriauth_facilitydataset" ("id"), "user_id" char(32) NOT NULL REFERENCES "kolibriauth_facilityuser" ("id"), "last_interaction_timestamp" varchar NULL);INSERT INTO "logger_usersessionlog" VALUES('ebed9f860e1adebbe6254383a4820f4f',1,'1b3a08f385614f1f922fbff470a08ce6','0922fe4c01655735cdd57097f52ee837:user-rw:5153602b5a84aa3ed3df788ff77dae8f','','2021-04-20 21:56:29.278062(Europe/London)','','0922fe4c01655735cdd57097f52ee837','5153602b5a84aa3ed3df788ff77dae8f','2021-04-20 21:56:29.279664(Europe/London)');CREATE TABLE "morango_buffer" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "serialized" text NOT NULL, "deleted" bool NOT NULL, "last_saved_instance" char(32) NOT NULL, "last_saved_counter" integer NOT NULL, "model_name" varchar(40) NOT NULL, "profile" varchar(40) NOT NULL, "partition" text NOT NULL, "model_uuid" char(32) NOT NULL, "transfer_session_id" char(32) NOT NULL REFERENCES "morango_transfersession" ("id"), "conflicting_serialized_data" text NOT NULL, "_self_ref_fk" varchar(32) NOT NULL, "source_id" varchar(96) NOT NULL, "hard_deleted" bool NOT NULL);CREATE TABLE "morango_certificate" ("id" char(32) NOT NULL PRIMARY KEY, "profile" varchar(20) NOT NULL, "scope_version" integer NOT NULL, "scope_params" text NOT NULL, "public_key" text NOT NULL, "serialized" text NOT NULL, "signature" text NOT NULL, "private_key" text NULL, "lft" integer unsigned NOT NULL, "rght" integer unsigned NOT NULL, "tree_id" integer unsigned NOT NULL, "level" integer unsigned NOT NULL, "scope_definition_id" varchar(20) NOT NULL REFERENCES "morango_scopedefinition" ("id"), "salt" varchar(32) NOT NULL, "parent_id" char(32) NULL REFERENCES "morango_certificate" ("id"));INSERT INTO "morango_certificate" VALUES('0922fe4c01655735cdd57097f52ee837','facilitydata',1,'{"dataset_id": "0922fe4c01655735cdd57097f52ee837"}','MIIBCgKCAQEArngTglJgOqlllj40+y9nasMOKNdGT+iEkasGy+huyzJOZFaK7Y56QeylKLgoaaF5t8H0Ib9WGuXRyPDInwWcQDhclea8ec9EE1JwBIZB1B8HTqi1OSkWkfOTR65nmPPrr/DWKzBNZSdMOHA1WvISXl1wjW7Qoyf83zCGbtFMp823jzRll/rwiCgEoHyx9qsVPTl2LVeabpemiVYH5MUKCU0ZG2UvvJe/HzGDzvg3d2U3OY9R/RTKav4qgG9vRu8EsHYKHlobBK3WSXL6V0Ot9Bb6p77HNZDI1Gc09RcN1Sl1pbn2RYAR81Vd2l50l116OOmymgIGMzBsgacjz2k7vQIDAQAB','{"id": "0922fe4c01655735cdd57097f52ee837", "parent_id": null, "profile": "facilitydata", "salt": "", "scope_definition_id": "full-facility", "scope_version": 1, "scope_params": "{\"dataset_id\": \"0922fe4c01655735cdd57097f52ee837\"}", "public_key_string": "MIIBCgKCAQEArngTglJgOqlllj40+y9nasMOKNdGT+iEkasGy+huyzJOZFaK7Y56QeylKLgoaaF5t8H0Ib9WGuXRyPDInwWcQDhclea8ec9EE1JwBIZB1B8HTqi1OSkWkfOTR65nmPPrr/DWKzBNZSdMOHA1WvISXl1wjW7Qoyf83zCGbtFMp823jzRll/rwiCgEoHyx9qsVPTl2LVeabpemiVYH5MUKCU0ZG2UvvJe/HzGDzvg3d2U3OY9R/RTKav4qgG9vRu8EsHYKHlobBK3WSXL6V0Ot9Bb6p77HNZDI1Gc09RcN1Sl1pbn2RYAR81Vd2l50l116OOmymgIGMzBsgacjz2k7vQIDAQAB"}','emX0J5yn1ZE0vCz9oZ0urZm1i6GS8UwLP10Qhe6GMKYOtMWrQ0CrWjeZr7boXXGMeAaYI9ClCsLKCg05Rhinyhz/hE0zuY+dEIdbuBQL14clCv8c1pPKO9mc1Y7CaBHUedrt2SO+XbE0j7QTxa3hEF8r7H933FI+svUqwbs7hjsWgIzRrDsMSY5fiT30+rX3BBvcGrGaYQgG0fT3yf+wcLjrBPsJnsfpKEthXIYbtAGyGFVOkfEvWCfaasa1QoiV6vYjlDWYG3Q3HYzLh2LtBLMpgdRurKRwAnQ0Gfok7fFWb9JwPbmnZfXZoPAKxUWz8eD2CGbRJ2odD0ZSZc1rxg==','-----BEGIN RSA PRIVATE KEY-----
MIIEpAIBAAKCAQEArngTglJgOqlllj40+y9nasMOKNdGT+iEkasGy+huyzJOZFaK
7Y56QeylKLgoaaF5t8H0Ib9WGuXRyPDInwWcQDhclea8ec9EE1JwBIZB1B8HTqi1
OSkWkfOTR65nmPPrr/DWKzBNZSdMOHA1WvISXl1wjW7Qoyf83zCGbtFMp823jzRl
l/rwiCgEoHyx9qsVPTl2LVeabpemiVYH5MUKCU0ZG2UvvJe/HzGDzvg3d2U3OY9R
/RTKav4qgG9vRu8EsHYKHlobBK3WSXL6V0Ot9Bb6p77HNZDI1Gc09RcN1Sl1pbn2
RYAR81Vd2l50l116OOmymgIGMzBsgacjz2k7vQIDAQABAoIBAQCtRAiz6xUwDN0b
aWn6buh4qX/dZXWplBRcCgp05L9rQumBUkUkiNO3tsmK9+ECjl+v84l9HmTnz4cY
1K+Y5dx4FsE0CXLyUbmcqskeZSro+2upXXikbL7CcbC5hmXSC6PsFfTL7WtfYria
cC08xZ0iZA+MFhpTfjnueWV4lplXJxy+BjGVhrQ+ZaR+KX5zzSeSLtk9BixdBn1i
XmkgZS+lNlSYzffB+fOMUBhxvVpzY1V+xI0Tgt1HINWuXOWFGgQw87+CeUIWGNKx
Zy7JgZSdRi/W1y4YU5YfU++SKEkgDq5Jd6PaDxtsRb50F/CKpOGmrWvoYtXib7mJ
XwKt/9sNAoGBAN2wm2AOpenZaSg5qOAt8Ra7TfJLATElARlPHm4uJDXf/B6vjJHX
Bi7nc8CznfMBkk62m5K6LMfaVkRP543IlMfP9cAtCw+tVRQa3tevUjr01EsobePl
Laefwi1Vl7+Bw2urcPNOm8cMnxR2vHm2vLJWw60puhWzAKeV65VACgPfAoGBAMl4
klgqLhtZDQEt0GQhQFfR7QsnxlQRAQNff3vbOPwtajkWHAIPFP06hgUl3PyPajUs
6R6x+Lw9xcUA3lXrdu0gCEYMObIr5k7DA8Me8rwkRBPWDq6+RAX0uVyLAlrqO/aB
1eLTkx1oLzaz3/Nq5vU4dgHEALC1iCOhfTatidPjAoGBAMCPzQaM8rTDskHMg9Hm
VgnmvHf/ipODjwbK4KXX0oAxhK+q0LFFUwue4764xjP0Y3+Xwl6a9JbMIi7IMVvI
pONC0jYRahA+AS6rgHFcylKHo3d9MKbJxPRbIrF6LYudTX/StRPCbjFh1zRRRrl6
b0GBeAqLuiVrDOCEqtNDgu+FAoGAU87CIca6E0pB7KGgNGbYmy+KSb+r8sB4CW0q
XN1eoRhLPaAC2qBnfMdhhLaxbKZD6gbampgx/iw8Hq0zz835VL6kcm8XeRRl45Gf
+QTguH7litLanLotFcUtbl+tBSC2/N4ZmRel9O+n5DuDB4EKvitUe3uLRfbdwOSm
b55U3T0CgYAjeSa6jSD5YGIg6RLrqp2F2ZsfiKxjjOrgpEmN1OPflgDplq6QMgJU
bCxbl26tBbyFCz1lZSixr0ddXg5uUhO+93NtJUOp2tM4y+iHU6wUfuDH5Dj74h9o
0B9GvN1PltYlkrqzSiXuPl0+Iw6QsMlhVvQ+TxREz2Z+mYJdEID30w==
-----END RSA PRIVATE KEY-----
',1,2,1,0,'full-facility','',NULL);CREATE TABLE "morango_databaseidmodel" ("current" bool NOT NULL, "date_generated" datetime NOT NULL, "initial_instance_id" varchar(32) NOT NULL, "id" char(32) NOT NULL PRIMARY KEY);INSERT INTO "morango_databaseidmodel" VALUES(1,'2021-04-20 20:44:30.876177','','fa99180412164ffca641401e7b44ed29');CREATE TABLE "morango_databasemaxcounter" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "instance_id" char(32) NOT NULL, "counter" integer NOT NULL, "partition" varchar(128) NOT NULL);CREATE TABLE "morango_deletedmodels" ("id" char(32) NOT NULL PRIMARY KEY, "profile" varchar(40) NOT NULL);CREATE TABLE "morango_harddeletedmodels" ("id" char(32) NOT NULL PRIMARY KEY, "profile" varchar(40) NOT NULL);CREATE TABLE "morango_instanceidmodel" ("id" char(32) NOT NULL PRIMARY KEY, "platform" text NOT NULL, "hostname" text NOT NULL, "sysversion" text NOT NULL, "counter" integer NOT NULL, "current" bool NOT NULL, "db_path" varchar(1000) NOT NULL, "database_id" char(32) NOT NULL REFERENCES "morango_databaseidmodel" ("id"), "system_id" varchar(100) NOT NULL, "node_id" varchar(20) NOT NULL);INSERT INTO "morango_instanceidmodel" VALUES('92dbec25eb986ce497f858f2b3c67130','Linux-5.10.17+-armv6l-with-debian-10.9','kolibri','3.7.3 (default, Jan 22 2021, 20:04:44) 
[GCC 8.3.0]',0,1,'/home/pi/.kolibri/db.sqlite3','fa99180412164ffca641401e7b44ed29','d8d457b4a57f72218c9e','46b9e5c5e51410aad2bb');CREATE TABLE "morango_nonce" ("id" char(32) NOT NULL PRIMARY KEY, "timestamp" datetime NOT NULL, "ip" varchar(100) NOT NULL);CREATE TABLE "morango_recordmaxcounter" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "instance_id" char(32) NOT NULL, "counter" integer NOT NULL, "store_model_id" char(32) NOT NULL REFERENCES "morango_store" ("id"));CREATE TABLE "morango_recordmaxcounterbuffer" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "instance_id" char(32) NOT NULL, "counter" integer NOT NULL, "transfer_session_id" char(32) NOT NULL REFERENCES "morango_transfersession" ("id"), "model_uuid" char(32) NOT NULL);CREATE TABLE "morango_scopedefinition" ("profile" varchar(20) NOT NULL, "version" integer NOT NULL, "id" varchar(20) NOT NULL PRIMARY KEY, "description" text NOT NULL, "read_filter_template" text NOT NULL, "read_write_filter_template" text NOT NULL, "primary_scope_param_key" varchar(20) NOT NULL, "write_filter_template" text NOT NULL);INSERT INTO "morango_scopedefinition" VALUES('facilitydata',1,'full-facility','Allows full syncing for data under the Facility with FacilityDataset ID ${dataset_id}.','','${dataset_id}','dataset_id','');INSERT INTO "morango_scopedefinition" VALUES('facilitydata',1,'single-user','Allows syncing data for FacilityUser ${user_id} under Facility with FacilityDataset ID ${dataset_id}.','${dataset_id}:allusers-ro
${dataset_id}:user-ro:${user_id}','${dataset_id}:user-rw:${user_id}','','${dataset_id}:anonymous');CREATE TABLE "morango_sharedkey" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "public_key" text NOT NULL, "private_key" text NOT NULL, "current" bool NOT NULL);CREATE TABLE "morango_store" ("serialized" text NOT NULL, "deleted" bool NOT NULL, "last_saved_instance" char(32) NOT NULL, "last_saved_counter" integer NOT NULL, "model_name" varchar(40) NOT NULL, "profile" varchar(40) NOT NULL, "partition" text NOT NULL, "id" char(32) NOT NULL PRIMARY KEY, "conflicting_serialized_data" text NOT NULL, "_self_ref_fk" varchar(32) NOT NULL, "dirty_bit" bool NOT NULL, "source_id" varchar(96) NOT NULL, "hard_deleted" bool NOT NULL, "deserialization_error" text NOT NULL);CREATE TABLE "morango_syncsession" ("id" char(32) NOT NULL PRIMARY KEY, "start_timestamp" datetime NOT NULL, "last_activity_timestamp" datetime NOT NULL, "active" bool NOT NULL, "connection_kind" varchar(10) NOT NULL, "connection_path" varchar(1000) NOT NULL, "is_server" bool NOT NULL, "client_instance" text NOT NULL, "client_ip" varchar(100) NOT NULL, "profile" varchar(40) NOT NULL, "server_instance" text NOT NULL, "server_ip" varchar(100) NOT NULL, "client_certificate_id" char(32) NULL REFERENCES "morango_certificate" ("id"), "server_certificate_id" char(32) NULL REFERENCES "morango_certificate" ("id"), "extra_fields" text NOT NULL);CREATE TABLE "morango_transfersession" ("id" char(32) NOT NULL PRIMARY KEY, "filter" text NOT NULL, "push" bool NOT NULL, "active" bool NOT NULL, "records_total" integer NULL, "sync_session_id" char(32) NOT NULL REFERENCES "morango_syncsession" ("id"), "last_activity_timestamp" datetime NOT NULL, "client_fsic" text NOT NULL, "records_transferred" integer NOT NULL, "server_fsic" text NOT NULL, "start_timestamp" datetime NOT NULL, "bytes_received" bigint NULL, "bytes_sent" bigint NULL);DELETE FROM "sqlite_sequence";INSERT INTO "sqlite_sequence" VALUES('django_migrations',108);INSERT INTO "sqlite_sequence" VALUES('django_admin_log',0);INSERT INTO "sqlite_sequence" VALUES('django_content_type',59);INSERT INTO "sqlite_sequence" VALUES('auth_permission',177);INSERT INTO "sqlite_sequence" VALUES('device_contentcachekey',1);INSERT INTO "sqlite_sequence" VALUES('device_devicesettings',1);INSERT INTO "sqlite_sequence" VALUES('morango_recordmaxcounter',0);INSERT INTO "sqlite_sequence" VALUES('morango_databasemaxcounter',0);INSERT INTO "sqlite_sequence" VALUES('morango_buffer',0);INSERT INTO "sqlite_sequence" VALUES('morango_recordmaxcounterbuffer',0);CREATE INDEX "django_admin_log_content_type_id_c4bce8eb" ON "django_admin_log" ("content_type_id");CREATE INDEX "django_admin_log_user_id_c564eba6" ON "django_admin_log" ("user_id");CREATE UNIQUE INDEX "analytics_pingbacknotificationdismissed_user_id_notification_id_8d56aefc_uniq" ON "analytics_pingbacknotificationdismissed" ("user_id", "notification_id");CREATE INDEX "analytics_pingbacknotificationdismissed_notification_id_01d1ee67" ON "analytics_pingbacknotificationdismissed" ("notification_id");CREATE INDEX "analytics_pingbacknotificationdismissed_user_id_99b20e1e" ON "analytics_pingbacknotificationdismissed" ("user_id");CREATE UNIQUE INDEX "django_content_type_app_label_model_76bd3d3b_uniq" ON "django_content_type" ("app_label", "model");CREATE UNIQUE INDEX "auth_group_permissions_group_id_permission_id_0cd325b0_uniq" ON "auth_group_permissions" ("group_id", "permission_id");CREATE INDEX "auth_group_permissions_group_id_b120cbf9" ON "auth_group_permissions" ("group_id");CREATE INDEX "auth_group_permissions_permission_id_84c5c92e" ON "auth_group_permissions" ("permission_id");CREATE UNIQUE INDEX "auth_permission_content_type_id_codename_01ab375a_uniq" ON "auth_permission" ("content_type_id", "codename");CREATE INDEX "auth_permission_content_type_id_2f476e4b" ON "auth_permission" ("content_type_id");CREATE UNIQUE INDEX "content_contentnode_has_prerequisite_from_contentnode_id_to_contentnode_id_c9e1d527_uniq" ON "content_contentnode_has_prerequisite" ("from_contentnode_id", "to_contentnode_id");CREATE INDEX "content_contentnode_has_prerequisite_from_contentnode_id_1085c145" ON "content_contentnode_has_prerequisite" ("from_contentnode_id");CREATE INDEX "content_contentnode_has_prerequisite_to_contentnode_id_5561f92c" ON "content_contentnode_has_prerequisite" ("to_contentnode_id");CREATE INDEX "content_language_lang_code_7a423afe" ON "content_language" ("lang_code");CREATE INDEX "content_language_lang_subcode_6ca3c58e" ON "content_language" ("lang_subcode");CREATE UNIQUE INDEX "content_contentnode_related_from_contentnode_id_to_contentnode_id_fc2ed20c_uniq" ON "content_contentnode_related" ("from_contentnode_id", "to_contentnode_id");CREATE INDEX "content_contentnode_related_from_contentnode_id_f56e3999" ON "content_contentnode_related" ("from_contentnode_id");CREATE INDEX "content_contentnode_related_to_contentnode_id_42e82421" ON "content_contentnode_related" ("to_contentnode_id");CREATE UNIQUE INDEX "content_contentnode_tags_contentnode_id_contenttag_id_64a4ac15_uniq" ON "content_contentnode_tags" ("contentnode_id", "contenttag_id");CREATE INDEX "content_contentnode_tags_contentnode_id_4ea196dd" ON "content_contentnode_tags" ("contentnode_id");CREATE INDEX "content_contentnode_tags_contenttag_id_9518e093" ON "content_contentnode_tags" ("contenttag_id");CREATE INDEX "content_assessmentmetadata_contentnode_id_19cbc70a" ON "content_assessmentmetadata" ("contentnode_id");CREATE INDEX "content_file_priority_073dafe4" ON "content_file" ("priority");CREATE INDEX "content_file_contentnode_id_d4089e6e" ON "content_file" ("contentnode_id");CREATE INDEX "content_file_lang_id_364540cd" ON "content_file" ("lang_id");CREATE INDEX "content_file_local_file_id_9780c2ab" ON "content_file" ("local_file_id");CREATE INDEX "content_contentnode_content_id_790eac82" ON "content_contentnode" ("content_id");CREATE INDEX "content_contentnode_channel_id_77d3faec" ON "content_contentnode" ("channel_id");CREATE INDEX "content_contentnode_lft_4253d420" ON "content_contentnode" ("lft");CREATE INDEX "content_contentnode_rght_33f2973d" ON "content_contentnode" ("rght");CREATE INDEX "content_contentnode_tree_id_d115ca94" ON "content_contentnode" ("tree_id");CREATE INDEX "content_contentnode_level_9ffc3b01" ON "content_contentnode" ("level");CREATE INDEX "content_contentnode_lang_id_600d594b" ON "content_contentnode" ("lang_id");CREATE INDEX "content_contentnode_parent_id_47178783" ON "content_contentnode" ("parent_id");CREATE INDEX "content_contentnode_level_channel_id_kind_fd732cc4_idx" ON "content_contentnode" ("level", "channel_id", "kind");CREATE INDEX "content_contentnode_level_channel_id_available_29f0bb18_idx" ON "content_contentnode" ("level", "channel_id", "available");CREATE INDEX "content_channelmetadata_root_id_ba963469" ON "content_channelmetadata" ("root_id");CREATE UNIQUE INDEX "kolibriauth_membership_user_id_collection_id_48b95423_uniq" ON "kolibriauth_membership" ("user_id", "collection_id");CREATE INDEX "kolibriauth_membership_collection_id_c955dbd2" ON "kolibriauth_membership" ("collection_id");CREATE INDEX "kolibriauth_membership_dataset_id_13e29803" ON "kolibriauth_membership" ("dataset_id");CREATE INDEX "kolibriauth_membership_user_id_79317fa1" ON "kolibriauth_membership" ("user_id");CREATE UNIQUE INDEX "kolibriauth_role_user_id_collection_id_kind_9c51e8a2_uniq" ON "kolibriauth_role" ("user_id", "collection_id", "kind");CREATE INDEX "kolibriauth_role_collection_id_1fa9ce6f" ON "kolibriauth_role" ("collection_id");CREATE INDEX "kolibriauth_role_dataset_id_70eb0469" ON "kolibriauth_role" ("dataset_id");CREATE INDEX "kolibriauth_role_user_id_d4014967" ON "kolibriauth_role" ("user_id");CREATE INDEX "device_devicesettings_default_facility_id_8937e0b7" ON "device_devicesettings" ("default_facility_id");CREATE INDEX "discovery_networklocation_added_5a6610e3" ON "discovery_networklocation" ("added");CREATE INDEX "exams_examassignment_assigned_by_id_53aa193a" ON "exams_examassignment" ("assigned_by_id");CREATE INDEX "exams_examassignment_collection_id_90ec6a7a" ON "exams_examassignment" ("collection_id");CREATE INDEX "exams_examassignment_dataset_id_3200aa09" ON "exams_examassignment" ("dataset_id");CREATE INDEX "exams_examassignment_exam_id_d7c499da" ON "exams_examassignment" ("exam_id");CREATE INDEX "exams_exam_collection_id_9dc0b187" ON "exams_exam" ("collection_id");CREATE INDEX "exams_exam_creator_id_37d1b2e5" ON "exams_exam" ("creator_id");CREATE INDEX "exams_exam_dataset_id_7dff1bad" ON "exams_exam" ("dataset_id");CREATE INDEX "kolibriauth_facilityuser_dataset_id_0dab63f9" ON "kolibriauth_facilityuser" ("dataset_id");CREATE INDEX "kolibriauth_facilityuser_facility_id_f602d621" ON "kolibriauth_facilityuser" ("facility_id");CREATE INDEX "kolibriauth_collection_lft_ee90bb3a" ON "kolibriauth_collection" ("lft");CREATE INDEX "kolibriauth_collection_rght_54dc9abb" ON "kolibriauth_collection" ("rght");CREATE INDEX "kolibriauth_collection_tree_id_07cebdf6" ON "kolibriauth_collection" ("tree_id");CREATE INDEX "kolibriauth_collection_level_4af376dc" ON "kolibriauth_collection" ("level");CREATE INDEX "kolibriauth_collection_dataset_id_5689c7d8" ON "kolibriauth_collection" ("dataset_id");CREATE INDEX "kolibriauth_collection_parent_id_1561ec4a" ON "kolibriauth_collection" ("parent_id");CREATE INDEX "lessons_lesson_collection_id_13b7d040" ON "lessons_lesson" ("collection_id");CREATE INDEX "lessons_lesson_created_by_id_441dbacf" ON "lessons_lesson" ("created_by_id");CREATE INDEX "lessons_lesson_dataset_id_da71bead" ON "lessons_lesson" ("dataset_id");CREATE INDEX "lessons_lessonassignment_assigned_by_id_ed8b2358" ON "lessons_lessonassignment" ("assigned_by_id");CREATE INDEX "lessons_lessonassignment_collection_id_d30ca20a" ON "lessons_lessonassignment" ("collection_id");CREATE INDEX "lessons_lessonassignment_dataset_id_07c252d8" ON "lessons_lessonassignment" ("dataset_id");CREATE INDEX "lessons_lessonassignment_lesson_id_52b19e73" ON "lessons_lessonassignment" ("lesson_id");CREATE INDEX "logger_contentsummarylog_content_id_2e21d8cf" ON "logger_contentsummarylog" ("content_id");CREATE INDEX "logger_contentsummarylog_dataset_id_f9a1ad8e" ON "logger_contentsummarylog" ("dataset_id");CREATE INDEX "logger_contentsummarylog_user_id_16aa2b2c" ON "logger_contentsummarylog" ("user_id");CREATE INDEX "logger_examlog_dataset_id_13109aa7" ON "logger_examlog" ("dataset_id");CREATE INDEX "logger_examlog_exam_id_41856b8c" ON "logger_examlog" ("exam_id");CREATE INDEX "logger_examlog_user_id_05397f8b" ON "logger_examlog" ("user_id");CREATE INDEX "logger_masterylog_dataset_id_f5b54331" ON "logger_masterylog" ("dataset_id");CREATE INDEX "logger_masterylog_summarylog_id_f2816f59" ON "logger_masterylog" ("summarylog_id");CREATE INDEX "logger_masterylog_user_id_3f58a1cb" ON "logger_masterylog" ("user_id");CREATE INDEX "logger_usersessionlog_dataset_id_1a2bbb5f" ON "logger_usersessionlog" ("dataset_id");CREATE INDEX "logger_usersessionlog_user_id_a755b0c2" ON "logger_usersessionlog" ("user_id");CREATE INDEX "logger_attemptlog_dataset_id_3017c88e" ON "logger_attemptlog" ("dataset_id");CREATE INDEX "logger_attemptlog_masterylog_id_d65af27c" ON "logger_attemptlog" ("masterylog_id");CREATE INDEX "logger_attemptlog_sessionlog_id_0a239a1a" ON "logger_attemptlog" ("sessionlog_id");CREATE INDEX "logger_attemptlog_user_id_cd57843f" ON "logger_attemptlog" ("user_id");CREATE INDEX "logger_examattemptlog_dataset_id_9f9d1b24" ON "logger_examattemptlog" ("dataset_id");CREATE INDEX "logger_examattemptlog_examlog_id_ad0f674d" ON "logger_examattemptlog" ("examlog_id");CREATE INDEX "logger_examattemptlog_user_id_5442dc41" ON "logger_examattemptlog" ("user_id");CREATE INDEX "logger_contentsessionlog_content_id_12ef7b71" ON "logger_contentsessionlog" ("content_id");CREATE INDEX "logger_contentsessionlog_dataset_id_9b53cdba" ON "logger_contentsessionlog" ("dataset_id");CREATE INDEX "logger_contentsessionlog_user_id_173ee284" ON "logger_contentsessionlog" ("user_id");CREATE INDEX "morango_recordmaxcounter_store_model_id_2a91327d" ON "morango_recordmaxcounter" ("store_model_id");CREATE UNIQUE INDEX "morango_recordmaxcounter_store_model_id_instance_id_d478818f_uniq" ON "morango_recordmaxcounter" ("store_model_id", "instance_id");CREATE INDEX "morango_certificate_lft_7686107b" ON "morango_certificate" ("lft");CREATE INDEX "morango_certificate_rght_fc1fe114" ON "morango_certificate" ("rght");CREATE INDEX "morango_certificate_tree_id_88a9f83c" ON "morango_certificate" ("tree_id");CREATE INDEX "morango_certificate_level_bb83c8bf" ON "morango_certificate" ("level");CREATE INDEX "morango_certificate_scope_definition_id_1f75587b" ON "morango_certificate" ("scope_definition_id");CREATE INDEX "morango_certificate_parent_id_60dedc2b" ON "morango_certificate" ("parent_id");CREATE INDEX "morango_instanceidmodel_database_id_3d1b7c0a" ON "morango_instanceidmodel" ("database_id");CREATE UNIQUE INDEX "morango_databasemaxcounter_instance_id_partition_99e4f1fb_uniq" ON "morango_databasemaxcounter" ("instance_id", "partition");CREATE UNIQUE INDEX "morango_buffer_transfer_session_id_model_uuid_2a7288db_uniq" ON "morango_buffer" ("transfer_session_id", "model_uuid");CREATE INDEX "morango_buffer_transfer_session_id_8e70af5a" ON "morango_buffer" ("transfer_session_id");CREATE INDEX "morango_recordmaxcounterbuffer_transfer_session_id_1e48e3dd" ON "morango_recordmaxcounterbuffer" ("transfer_session_id");CREATE INDEX "morango_recordmaxcounterbuffer_model_uuid_27589dbd" ON "morango_recordmaxcounterbuffer" ("model_uuid");CREATE INDEX "morango_syncsession_client_certificate_id_507e0d5d" ON "morango_syncsession" ("client_certificate_id");CREATE INDEX "morango_syncsession_server_certificate_id_52bf728f" ON "morango_syncsession" ("server_certificate_id");CREATE INDEX "morango_transfersession_sync_session_id_0455b5bd" ON "morango_transfersession" ("sync_session_id");CREATE INDEX "django_session_expire_date_a5c62663" ON "django_session" ("expire_date");COMMIT;