db-v0.14.7_2021-12-19_05-26-43.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);INSERT INTO "content_channelmetadata" VALUES('0418cc231e9c5513af0fff9f227f7172','Free English with Hello Channel','This YouTube channel teaches conversational English, English for social life
and grammar by using Hello Channel’s TV educational shows with ESL learners.','',5,'data:image/jpg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCABoAJMDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+kLBQSTgDvS1y/xGvzpvw9165V9jCzdVYdmb5R+poA3JNW06E4lv7WM/7Uyj+tUJ/GXhi1OJ/EOlxn0a7TP86+SLHQjeQmZfKRc7csuScd6vp4ZC8tOoP+xGBWUq9OLs2elRyjG1oqcIaP0PpqX4keDIc7/Eum/8BnDfyqi3xb8CqT/xUMBx/dikP/stfPS+HbcYzcSk/gKkGgWY6mZvYyVn9apnXHh3GvdJfM96k+MvgZBkau7/AO5ayH/2Wqsnxu8GJ92e9k/3bVv64rxIaHYD/lm5+shpw0XTx/y7g/ViaX1un2NVwzi/5o/e/wDI9hf48eFEPy2uqP8ASBR/Nqj/AOF+eGP+gdrH/fqP/wCLryP+x7D/AJ9k/Wl/siw/59k/Wl9bgV/qxiv5o/j/AJHrqfHnwsx+ay1ZB6mFD/J6tR/HDwc+N0l/Fn+/ak/yJrxY6Lp5/wCXYfgx/wAab/Ydh2iYfRzT+twJfDOL6Sj+P+R7tF8ZfA8nXVnT/ftZB/7LVqP4teBZCAPEVspP99HX+a18+NoFkennL9JKY3h63P3Z5l+pBprFUzKXDuNWyT+Z9LRfELwfMBs8TaV/wK5Vf5mtSDXtHugDb6rYyg9Nlwh/rXye/hsEYW6P/AkFUrrw8baB5iYHVBkjZg4q1XpvZnNVybG0ouUoaLs0z7NVldQykFT0IOQaWuG+EN4br4Y6Pn70SvCef7rkV3ANbHli0UUUAFec/G66Nt8NrpB/y8XEMX4b9x/9Br0avJP2gLgp4R023B4mvxn/AIDG5oGldnlelx+VpluuMEruP1PNW6WCCRolWOKRwoAOxC2OPYU54JoxmSGVB6tGwH6ivGndybP1PDqFOnCkmtEl07DKKKKk6AooopAFFFPSKWUExxSOB1KIWx+QoE5JK7GUU94ZowC8MqZOBujYZP4infZbn/n1uP8Avy3+FOzF7SHdfeiKilIIJBBBHUEYIpKCtxG3bTtODUEiPLaTRygZZSOPpVijGeKaepnUhzJ+jPQ/hGdQvvhFqlnp1ysN+s9zFbSn/lmzKCp/Nqk+Enhvxrouq30uvSTw2Dpt8i4n85pJM/fU5OABnnvnpWR8G47678F+LtO0+5+z3jSkW8p/5Zu0WAfzFa/wj8IeL/D2qX0+tyNBZPHt+zPP5xlkzneDk4wM89817S2PyiSs2j12iiigQV4v+0DIGtvDlv8A3rmRz+Cgf1r2ivCfj3MTr/h6DPCo7/m6j+lJ7F0lecfVfmdN8HlBt9YyP+WkX/oJrW+KoH/CHg4/5eY/51lfB7iDWf8ArpF/6Ca1viqP+KOGOT9qi4H1rlj/ALv8j6DEf8jtf4l+SPFKK6KDwJ4muLX7QmkyBMZCvIqOf+Ak/wA6w7u0uLG5e2u4JIJ0+9HIuCP/AK3vXA4SirtH2VPFUKsnGnNNrsyGinxRSTyrFDG8srHCoilix9AB1rfTwH4oePzBo8gGM4aRA35ZoUZPZDq4mjR0qTS9Wc7XrfwgAOj6lkf8vQ/9AFeWXtheabcfZ761ltpR/BIuCfceteqfCD/kD6l/19D/ANAFb4a6qpPzPIz+UZYByi7q6/Mv/EkAWuhcf8xWH+ddtgZ6VxPxJ/49NC/7C0H867fofxruj8cvkfG1/wDdaX/b35o+cPEf/Iy6p/19yf8AoRrMrT8Rn/iptVzx/pcn/oVWtK8G69rUQmtLBhCwysszeWrfTPJ/KvMcXKTSR+iQrU6OHhKrJJWW78kYVHeuqufhz4ntYjIbGKbHVYZwzfkcVy8kckMrxSxvHIh2sjrgqfQjtSlCUfiRpRxVCun7Kal6HY/AWQrq3ii3/h3QuB77pB/SvcAB6V4P8Cnx4t8SR+sSN+Ujf417yOlevH4Ufl9f+LL1f5hRRRVGQV4B8ejjxboR9LY/+jRXv9eCftBRbdX0O46ZhkXP0YH+tJ7FQdpJnV/B7/j31n/rpF/6Ca9A1NrKK0+1agY1gtT5xeTomO/61598HDutdXPrJEf/AB01tfFORk8GMoPD3ESn6Zz/AErnpPlo37HtY+l7fNnTvbmaX4I6DRfEGl+IIpJNNulmEZw42lSuemQea5n4oaNDd+G21IIBcWTBg46lCcMPp3/CuX+EkjDxJepnhrXkfRv/AK9ej+MofP8ACGpxYHzxbfzIojL21JtkVqKy3MYxpvRNP5Mxfh34Yh0nRItQmhBv7xd7OeqIfuqPQY5NXdT8e6FpOsf2Xcyy+cpCu6R5SMnpuP8AnFdLEgiiSNRhVUKPwrzrUPhQuoX91dtrUga4leRgYAcbjnHWqkpwglTRnSqYfFYidXGzave1r/JeiR1viTQLXxJo0trKFMhXdBKOSj44IPpXLfCNHi0zVYpV2yJebHX0YKARXdadatY6bb2rymVoY1QyEY3YGM4rC8K2y2uteJkUYBvw/wD31GppuPvxkZ0sQ1hKuHveN019/wCqKXxJ/wCPLRP+wrB/Ou0I5ri/iT/x5aJ/2FYP512vf8aqPxy+X6mdb/daX/b35o8l8N+GYtb8d6ze3kYktLO8fCMMh5CcjPqAOfyr0bXtas/DulPf3Yby1IVUQfM7Hooql4RtlhtdRkA+abUbhz7/ADY/pXK/GCYjTtKg/he4dj/wFf8A69ZL91Sckdzvj8fCjN+6rL5Ja/edN4W8YWHikTi3ilgmhwXilxkg9CMdRWF8TvDcF1pLa1BEFu7UDzWUcyR55z6461y3wqcr4wdQfle0k3D1wy4/rXrevQpceHtRhcAq1tID/wB8miEva0m5FYqmsszJewemj+T3R4n8Cif+E38Qen2Yf+jTXv1eA/AEeZ4j16b1to/1dj/Svfq6I7WPGrPmqSfdsKKKKZmFeK/tDQ5sNBmA586aP80B/pXtVeS/H+2MnhDTbkdIdQUH/gSMKAHfBCTzdJ1Bx/F5P/oJre+K3/Inr/19R/zrzf4QeONB8Nadf2utX4tJJJFMRZGIZQD3AOOtdR8QPG/hjXPCgi03XLO4k+0xt5ayYbAPJwcGsJR5aTXqexRrKpmVOrfS8fyS/Qo/Cb/kabr/AK9D/wChCvS/GEvk+EtSl/uRbvyIryz4UX9mnia4Z7uBVNqQC0gAPzD3r0rxrcQTeB9Y8uaN82zfdcGooXVF/M6M4camZxs9HynQxuJI1dTwwBB9c15NefFTWLO/ubZtOsj5ErxklmB+Ukf0rrPh/wCIYtZ8PwW8kg+22iiORM8sBwrD2IxTdX+HGkavrD6jI9zE0rbpooyNkh9eRkZ74qpuc4p02c+FWFwuIqU8bC6W33+q3RmReLvG9zBHND4TjeKRQyMJT8wI4PWtTwLd3t7c67cahai1umu08yEHO3EajrXRX15aaJpUl1OVhtrdOnTgdAK5H4ZX0mpxa5fTAh7i+8wj+7lRgfgMUWcZxTdxSlGrhqtSFJRSsrq/fbVk/wASP+PLRP8AsLQfzrts8/jXE/En/jy0XH/QVg/nXbd+9aR+OXyOWt/utL/t780c74RuVmttTjBy0GpXCMP+BZH865r4vWzSaRpt0AdsNwysfQMuOfxFY2h+LIfDvjvWYL1wljd3bhnPSNw2Ax9ux9K9I1G+8P3lg8Go3unyW0i5ZZZ0wR69azS9pScTsqc2Ax0K9rrR+t0rnmPwntZJPE91dAHy4LYq3H8TMMD9DXpHjTUl0zwbq10xAItnVfdmGB+prKtPE/gDw1ZtDaazpFtDncyxXCsSffGSa8w+JvxKsPEVvJpmlXBks48nzApAmfGBj/ZGfxNOEPZw5dycTiY4/Gut8MV38l+bZe/Z5hb7R4gnx8oS3jB9/nP9RXuw6V43+z7Ay6Frc5X5XvEQH12xj/GvZK3PIbu7hRRRQAV578a7QXPwzvpOc200M4/BwD+jV6FWH4x0mTXfB+r6XCFM1zavHGG6b8fL+oFAHyp4Z0P/AISDWTZtdfZYIoJbmeYLvZY41y21e56YqDVrfR4mt5dG1SW9hlRi6XFv5UsJB4DYJVgRyCD9a6Sy8B/ELQ9Qjv7PQ72C6hOVlhaJ+owRjccgjggjmoNc0vxzqhgj1Dw5fxxWoYRQ2umeVEm45YgIMEk9TQMxNB8P3HiO+msrTyxLFay3OGQtuCAEqABkk5wKXUPD2o6Jpem3t5G9smoCTy4G3JImwgHepxjqMVd0hvEXhW9lvYdGvUkktpbYma0lUKrjBIIAIIxxUWr63qur6PpOn38Fy/8AZolC3EokaSXeQfmLDtjFAGXZG9e8hisZbgXUriKMQyMrMzHAUEHuTW3rTeLfC+qHTtR1bUYbgIJB5d+7IynoVYHnoR9RVLw7rZ8NawuqJZrcXUMbi283IWKUjAkIx82ATxxyat6/4r/4SLSNPtruxtor2xd1jntlESGFudhTthuc+9Gw229yKwfxL4r1G30m31C+vbiQkxRT3h25AyTljgcU9/8AhKdCsZJzeahY2/2t7ORUumQ+eigspUHPQjnpUHhbXU8OeIINTaA3AjSRPLVwpO9Cuc+2c1p+JPGx8SeGtM0+4sxHfW83nXV2rjFywjEYYjqG2hc/SlZXuPnlblvoZtpdeIPEeqWemJql5cXNxMFhSe7faH6g5J4+tWdW0jxPp1vezandXSrZXa2cwe8ct5jLuUgZ5UjnPvWd4f1YaD4j07V/J8/7HN5vlb9u/gjGe3WtjV/Hd1rXhKHQru1iaWKdJDfeb+8kVNwRGXHJAbG7PQUxNvY5+ws5tU1O1sYpP311MkKtIxIDMcAn861PE/g9vDDxR3FxFcSSSOhVbKWIAr1IaRQG5/u5rL0y8k07VbS+hj8yW1nSdEZSQSpyAcduK2Nf1u88TSiZtFEEplaRng+0yli3UfOSAM/3QKAbbKnhjQ18Qa/Dpfni2Ekcr+YqBsbI2fGPfGKx43EiBgRyATg+1dHoNl4r0vU4dT0jRtR+0xBgjf2e7rhlKngrg8E1o3Pg/wAeeILlbqfwzdBwoQBbWK1XaDnG0bR+NAj2D4E2rQfDwysB/pF7M4PqBhR/6DXptct8OdDufDvgPS9MvIvKuo4y0ybg212YsRkcHrXU0CCiiigAooooAMUYoooAMUmAaKKAI3toJPvwxv8A7yg1Wk0XS5c+Zptm/wDvQIf6UUUAVn8K+HpD8+g6W31s4z/Smf8ACH+Gf+hd0j/wCj/+JoooAcvhPw4nK+H9KU+1nGP6VYj0PSYv9Vpdkn+7boP6UUUAWo7WCL/Vwxp/uoBUuAKKKAFxRiiigAooooAKKKKAP//Z','2021-12-19 00:27:45.605651(Europe/London)','1','0418cc231e9c5513af0fff9f227f7172',15757388,1,1,1,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"));INSERT INTO "content_channelmetadata_included_languages" VALUES(1,'0418cc231e9c5513af0fff9f227f7172','en');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"));INSERT INTO "content_contentnode" VALUES('0418cc231e9c5513af0fff9f227f7172','Free English with Hello Channel','0418cc231e9c5513af0fff9f227f7172','0418cc231e9c5513af0fff9f227f7172','',3826.0,'','','topic',1,1,144,1,0,'en',NULL,NULL,0,0,1,'{}',NULL);INSERT INTO "content_contentnode" VALUES('10a3263f952654a1b68fe92070fd0445','English Grammar','0bf6f85b30fb50d4a3b8d86fdf2f2334','0418cc231e9c5513af0fff9f227f7172','',1.0,'','Free English with Hello Channel','topic',1,2,63,1,1,'en',NULL,NULL,0,0,1,'{}','0418cc231e9c5513af0fff9f227f7172');INSERT INTO "content_contentnode" VALUES('476e8755df025fb2a5c996caf79cb59e','Vocabulary and Conversational English','8bc6d5a4b46d5fb2afe00b0e8fee017e','0418cc231e9c5513af0fff9f227f7172','',2.0,'','Free English with Hello Channel','topic',0,64,143,1,1,'en',NULL,NULL,0,NULL,NULL,'{}','0418cc231e9c5513af0fff9f227f7172');INSERT INTO "content_contentnode" VALUES('8f8e1c8051555f589ec1f73b58e6adaf','Lesson 1','2ce0fd291c8d5e3cbd58ba04a4da1681','0418cc231e9c5513af0fff9f227f7172','',1.0,'Free English with Hello Channel','Free English with Hello Channel','video',1,3,4,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,1,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('383aec0144ac55aa9c86c2ca1e9a4241','Lesson 2','26ae74e725ba5329b06039684ca9dd59','0418cc231e9c5513af0fff9f227f7172','',2.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,5,6,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('a57d2d00605350e580541d54b6d0be08','Lesson 3','d72acab91a5b5416845201db9ff29223','0418cc231e9c5513af0fff9f227f7172','',3.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,7,8,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('5588c95fdaa15e808ebca5ba06156ae5','Lesson 4','80c1354eb9bd596aaf9c93b6848573df','0418cc231e9c5513af0fff9f227f7172','',4.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,9,10,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('497c96972d985bec9d02688a20126bb8','Lesson 5','af99e9d4111c539688ef278469191ed4','0418cc231e9c5513af0fff9f227f7172','',5.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,11,12,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('d0e10fb46b775f1b9d5e367c354c83b5','Lesson 6','d6d25682c2ec5df380653399fbf26c69','0418cc231e9c5513af0fff9f227f7172','',6.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,13,14,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('f6a00ac3db4c5b3bbb0f83691eb09060','Lesson 7','0e8b648d2bc958299aa230657ad07ca4','0418cc231e9c5513af0fff9f227f7172','',7.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,15,16,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('12084912e3b7515c96fb7619918f3215','Lesson 8','e6c8d64bd5475583a6cf63c1bcc1a189','0418cc231e9c5513af0fff9f227f7172','',8.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,17,18,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('df407485b38750649ce5949a4550ea70','Lesson 9','fe4fdb8de0125c448c9660d4860160fb','0418cc231e9c5513af0fff9f227f7172','',9.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,19,20,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('9db1b3a00df4523eb6de4d53e7f696a1','Lesson 10','b1e1c3a0821d595098717e7c412d656b','0418cc231e9c5513af0fff9f227f7172','',10.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,21,22,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('a09e9b7f1d1654d180db7574a7d5f585','Lesson 11','d6f230c9de9750d9aa49ac21b824d31d','0418cc231e9c5513af0fff9f227f7172','',11.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,23,24,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('9730a4ac12955cbb8e0913895519d1c2','Lesson 12','8c874c0b70915f28aecfc8dc4681e118','0418cc231e9c5513af0fff9f227f7172','',12.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,25,26,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('9dd5c2e796a9514d852ce1c37cbda33f','Lesson 13','5dc9aa5a1fa258289b2f98b0e8d861c6','0418cc231e9c5513af0fff9f227f7172','',13.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,27,28,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('a17025f3967e51bc870a59ff983f1ce6','Lesson 14','3fe9ca2f55f2581f817e7423d4aaab7e','0418cc231e9c5513af0fff9f227f7172','',14.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,29,30,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('8f93fedbc07151b39504e7ded6301851','Lesson 15','229b3805ea8959eea692eee58fa92b70','0418cc231e9c5513af0fff9f227f7172','',15.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,31,32,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('ab2b46614ee9551096289cdd06e828fa','Lesson 16','c3971fc6552c5d6483cdcfa9588b056b','0418cc231e9c5513af0fff9f227f7172','',16.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,33,34,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('d7f9999fdf88586abdd9c7f544ec1b67','Lesson 17','d5eb1f7d51855e09a0c79ed43f4c1779','0418cc231e9c5513af0fff9f227f7172','',17.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,35,36,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('fbb063844a825920a1002fdcb0273dff','Lesson 18','4d51011cc5275ec58b4c2de06b03f799','0418cc231e9c5513af0fff9f227f7172','',18.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,37,38,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('4d4dd207635c59cbb5b3d7f7771002c2','Lesson 19','348cc53dc7f657daa84f624082d22a92','0418cc231e9c5513af0fff9f227f7172','',19.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,39,40,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('6d0be50eb82752cb8d4fb6cfe89d9194','Lesson 20','865d6b8fd1d451b6a1eaa06380efb674','0418cc231e9c5513af0fff9f227f7172','',20.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,41,42,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('f530451e29b454cfb9524f8f272adefd','Lesson 21','4c4b9605acd25490a77892addfe3bbb0','0418cc231e9c5513af0fff9f227f7172','',21.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,43,44,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('443cd862582453e8bb25280ea4134e54','Lesson 22','d06162f2ecb458efb35eca78131bc8a7','0418cc231e9c5513af0fff9f227f7172','',22.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,45,46,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('4943679baaab57a28850fe3b959b0184','Lesson 23','217792972fb45814952377f651fabc19','0418cc231e9c5513af0fff9f227f7172','',23.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,47,48,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('40c01e859b265734a8519e78a0d66215','Lesson 24','16f1797ae9565660a2a551a22d5aa7f7','0418cc231e9c5513af0fff9f227f7172','',24.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,49,50,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('cc5bf195c8715e3498e8bed4c477a9f1','Lesson 25','73833a23c5d152618614afb4656b76f2','0418cc231e9c5513af0fff9f227f7172','',25.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,51,52,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('4fac585aab835eeea230386186b872d7','Lesson 26','3ce3ee27eea6544b85bf6f5fc9482cbb','0418cc231e9c5513af0fff9f227f7172','',26.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,53,54,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('09e9555b6a3d5c5598927809199c6124','Lesson 27','912addc5ea45536bba1e1ea722e091ad','0418cc231e9c5513af0fff9f227f7172','',27.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,55,56,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('5634f0826a305f26a79088e3e98220f9','Lesson 28','aa70eb2c7834537fbcff9739ac60850c','0418cc231e9c5513af0fff9f227f7172','',28.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,57,58,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('b50e77e4623c57448373b152f8a230c2','Lesson 29','116213f27ea253c2b0bbc372e5e15dd0','0418cc231e9c5513af0fff9f227f7172','',29.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,59,60,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('a439bdc1fb9a5f9294160c449a0b3ae5','Lesson 30','2baa0d90311f5105adf502e54383ce17','0418cc231e9c5513af0fff9f227f7172','',30.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,61,62,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','10a3263f952654a1b68fe92070fd0445');INSERT INTO "content_contentnode" VALUES('b1095132839c5a83b94ae5caa795ed38','Are you Married ','675468afc33b5e888665e06a224deb2d','0418cc231e9c5513af0fff9f227f7172','',1.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,65,66,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('ea56e8c48e60594db22ee8faa35f44af','Big and Small ','1258c16e8a685bd49710b1785757df60','0418cc231e9c5513af0fff9f227f7172','',2.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,67,68,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('8298fa60c56a513c8288c5c10d5175d2','Breakfast Song ','c445b8900b8f5932b879fa8b57a7d483','0418cc231e9c5513af0fff9f227f7172','',3.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,69,70,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('82ef5d84b68d5838b5bf03ee8237e709','Breakfast and Food ','9ad2db846be55fcfa6d73b508855cbc8','0418cc231e9c5513af0fff9f227f7172','',4.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,71,72,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('8fcb975954c75202879ea720b344c306','Breakfast and Foods ','3706b20f3089568fba653bf54b228655','0418cc231e9c5513af0fff9f227f7172','',5.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,73,74,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('9810aa3c9b6d5a659bb008006e96ef4b','Clothes Part 1 ','61ac64403cef5a2eb6952150a2d898fd','0418cc231e9c5513af0fff9f227f7172','',6.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,75,76,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('b7732a57402c5e23b2ab16972bcf582d','Clothes Part 2 ','8216786d2b0659a994c18de2fdb3b12e','0418cc231e9c5513af0fff9f227f7172','',7.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,77,78,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('66612629c66c51b3beb542d8f4e7c378','Colors Part 1 ','fd52794f8976547ab1470173e79daf46','0418cc231e9c5513af0fff9f227f7172','',8.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,79,80,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('9b536fc5aceb511d9291c9f033cf382a','Colors Part 2 ','dc1e39a70deb5d269c9fd51405a490bf','0418cc231e9c5513af0fff9f227f7172','',9.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,81,82,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('0a9ba01e878d5c48a9b8589a54028702','Come with me ','fa1c979e83ab564fa99dc8c147f75d0c','0418cc231e9c5513af0fff9f227f7172','',10.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,83,84,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('00b0f1992dda58778c719b65543d1f6f','Contractions ','8db65d5e001b5fec845458ff67df0ef2','0418cc231e9c5513af0fff9f227f7172','',11.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,85,86,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('8303cb6576c15aacb9588ed335f61f44','Countries','ffadd7d2a8215bab90f2099111ca8b90','0418cc231e9c5513af0fff9f227f7172','',12.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,87,88,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('dec4da8096715557a079ef1b35256a5a','Dessert ','d352a7955bdc5aa58715c942aad13b08','0418cc231e9c5513af0fff9f227f7172','',13.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,89,90,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('abfae014ac2752408adee8c2a153793b','Directions ','d663195c648e548684aa3bb53731b21d','0418cc231e9c5513af0fff9f227f7172','',14.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,91,92,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('9044a94b74cb569ab96bcad141654a91','Doctor ','88a0bb8b1621521a9685dd2a477bd4ad','0418cc231e9c5513af0fff9f227f7172','',15.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,93,94,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('97e61e2c4c9551fe937c5fdb29fc9d27','Head, Shoulder, Knees and Toes ','a11219add95a5cd8a9a22a5701a09ba5','0418cc231e9c5513af0fff9f227f7172','',16.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,95,96,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('7da9b4abdac35ef3a5cc34cc4503e074','How Are You ','72b1ad5fece55fc9a9c9faf7d84ff6e8','0418cc231e9c5513af0fff9f227f7172','',17.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,97,98,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('3de27b7918ce5519900af3568bc2968e','How Are You  1','63d508c4fba65863862641c985434b10','0418cc231e9c5513af0fff9f227f7172','',18.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,99,100,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('ab0e378e5f965f628ee4921a32c2089b','I Have ','5afd2d28b2c258419a7e616b7567432f','0418cc231e9c5513af0fff9f227f7172','',19.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,101,102,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('80c3acc50279512ca4a551852ad33085','Jobs ','db46fe1391b75956b8360bb81650bba1','0418cc231e9c5513af0fff9f227f7172','',20.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,103,104,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('ea34f78ec66450be88816a990927d65f','Lunch ','3969bf1753095f989126e3fd4ad74173','0418cc231e9c5513af0fff9f227f7172','',21.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,105,106,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('26225a49ff085eaabfd99ee6a46df236','Money ','6a09fc911d775cf8b14e955bfec86331','0418cc231e9c5513af0fff9f227f7172','',22.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,107,108,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('0a5ed177c27d59f4a74c92b27b9900e1','Near and Far ','4ed1c16049fc5410a47794ccb8389dbd','0418cc231e9c5513af0fff9f227f7172','',23.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,109,110,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('a0bb52afa46e57a8a2b3882d27a4e6a5','No Thank You ','72f868a662fd5ca095d73c115451dc47','0418cc231e9c5513af0fff9f227f7172','',24.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,111,112,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('c09c6d0b69bb57d2aa233a09cfd2eeb9','Object ','ef471577d1eb57c498dae62458d465ed','0418cc231e9c5513af0fff9f227f7172','',25.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,113,114,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('f44ff796457d58a5a4d18e622bed41c2','Occupations Part 1 ','f1bda7c0d1315015997d08fa1e31839f','0418cc231e9c5513af0fff9f227f7172','',26.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,115,116,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('fdaa4626807355db8c85dd1dabd9a143','Occupations Part 2 ','1344757d0b285bb0a6a8cf2aa4867b43','0418cc231e9c5513af0fff9f227f7172','',27.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,117,118,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('9486407106d953fb8776be1180184fdc','People and Things ','70e93af51ede57908ec56a51ce5acadf','0418cc231e9c5513af0fff9f227f7172','',28.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,119,120,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('7725ff767b16568da10ff91f9981b854','Perpositions Part 1 ','e3c06aff9ede5822b7aeb7c80a820703','0418cc231e9c5513af0fff9f227f7172','',29.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,121,122,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('8a1bab9a242850949154e43cac93e255','Perpositions Part 2 ','14f22d68943f561da5433ac8e14975ce','0418cc231e9c5513af0fff9f227f7172','',30.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,123,124,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('f3d506a075ca5dcab3194850cde233e8','Pets ','7fbd879dad955b52ad07cfadcc567b20','0418cc231e9c5513af0fff9f227f7172','',31.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,125,126,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('611df051ccf35a57bc9f1b5875ef54da','Post Office ','ec07686710f35960b9c9cd990331b441','0418cc231e9c5513af0fff9f227f7172','',32.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,127,128,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('166661fb7aeb56008f503eeecf2ad0e6','Soup and Salad ','89546fd819395b8aad5c489adf21dcd3','0418cc231e9c5513af0fff9f227f7172','',33.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,129,130,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('1003650202f75729b93a6da2a527c475','Things during the day ','0c4daccdc4085067b7980d59526a11df','0418cc231e9c5513af0fff9f227f7172','',34.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,131,132,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('1501650315505010b15d98da5f30b48a','Verbs Part 1 ','9c5f3bd685265a6bb174e6283914d268','0418cc231e9c5513af0fff9f227f7172','',35.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,133,134,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('4367c6db58375a2e8930375a6619ffcd','Verbs Part 2 ','8e9d44320c3e5d32b839a4f7b0b0f704','0418cc231e9c5513af0fff9f227f7172','',36.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,135,136,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('79b50d90b0a251eead7ec480bb6d13ce','What time is it ','ed31d2c5c98e5b9a8a37f30af27f9950','0418cc231e9c5513af0fff9f227f7172','',37.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,137,138,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('114842df193e5ee2bcf8d48598066748','Names ','76675deedaff5bc09feea9545c36bc2f','0418cc231e9c5513af0fff9f227f7172','',38.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,139,140,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');INSERT INTO "content_contentnode" VALUES('758c6316625f5b449b3ae3cdefdafedc','Animals Learn ','6fbcf843bd175701a8cf2a16b1573984','0418cc231e9c5513af0fff9f227f7172','',39.0,'Free English with Hello Channel','Free English with Hello Channel','video',0,141,142,1,2,'en','The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.','CC BY',0,0,0,'{}','476e8755df025fb2a5c996caf79cb59e');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"));INSERT INTO "content_file" VALUES('193e719bcdcb47eeae0f340a93e4ff7b','video_thumbnail',1,1,3,'8f8e1c8051555f589ec1f73b58e6adaf',NULL,'19e435f5e7c74f470139e2797c38cf32');INSERT INTO "content_file" VALUES('08db740db9274f4289e9f632d3daa9f7','low_res_video',0,0,2,'8f8e1c8051555f589ec1f73b58e6adaf',NULL,'8e327b2fc702894e4cc8a22fab01378b');INSERT INTO "content_file" VALUES('9713d2451dcb4911a68a44c6d76a94a3','video_thumbnail',1,1,3,'383aec0144ac55aa9c86c2ca1e9a4241',NULL,'f77f3e3a622c66b395c87ef574c083c1');INSERT INTO "content_file" VALUES('d9c4f220964d4a9b83f70c0f88f6cc18','low_res_video',0,0,2,'383aec0144ac55aa9c86c2ca1e9a4241',NULL,'11e1c2c83b9dd46e584d75f484386021');INSERT INTO "content_file" VALUES('bd8a0a47e38646cf9a08099e2de9b6a6','video_thumbnail',1,1,3,'a57d2d00605350e580541d54b6d0be08',NULL,'f4a57dc6cbc50b4ba99ffa51e0976a92');INSERT INTO "content_file" VALUES('0061577f9f65490ba0e82aa65fda6182','low_res_video',0,0,2,'a57d2d00605350e580541d54b6d0be08',NULL,'9fd63b12e223f69b4a6d202da677e163');INSERT INTO "content_file" VALUES('64b962766cfb4dedb0c90f54f6349731','video_thumbnail',1,1,3,'5588c95fdaa15e808ebca5ba06156ae5',NULL,'9f54c953b113557e40003dd69d8d8f68');INSERT INTO "content_file" VALUES('32aa8f06f69f4db9a688d6b9ad1669a1','low_res_video',0,0,2,'5588c95fdaa15e808ebca5ba06156ae5',NULL,'6d0d8cef3d028b349736791e9762cd26');INSERT INTO "content_file" VALUES('d1ba43656fcf44abab6c09fd4a32274d','video_thumbnail',1,1,3,'497c96972d985bec9d02688a20126bb8',NULL,'ffef661089b1a31cc37b1d8c13959871');INSERT INTO "content_file" VALUES('5b2bafd0cd984733bfc1c6ac9524f898','low_res_video',0,0,2,'497c96972d985bec9d02688a20126bb8',NULL,'d742094b0921008cc3693fa101bec907');INSERT INTO "content_file" VALUES('3da71b15b91a494b8d75af73ef4b7bca','video_thumbnail',1,1,3,'d0e10fb46b775f1b9d5e367c354c83b5',NULL,'676e5c675500b3f7a1556392948fdb18');INSERT INTO "content_file" VALUES('d5b4336df0b3444f8b8348b3f580d4a3','low_res_video',0,0,2,'d0e10fb46b775f1b9d5e367c354c83b5',NULL,'14475d6376e30410a7af0ac729ae1ab1');INSERT INTO "content_file" VALUES('6872848c657c442ab5e9534d8c664430','video_thumbnail',1,1,3,'f6a00ac3db4c5b3bbb0f83691eb09060',NULL,'9f1139876ba1e5177b52d9e0792982f4');INSERT INTO "content_file" VALUES('cd771f02191d4a4ab569fada7c056b68','low_res_video',0,0,2,'f6a00ac3db4c5b3bbb0f83691eb09060',NULL,'47b2d6d9f7d35128352b984f72fc5ae1');INSERT INTO "content_file" VALUES('f62c99330a9b446d8d96d51c1ac0ae8c','video_thumbnail',1,1,3,'12084912e3b7515c96fb7619918f3215',NULL,'76f5e7848768115e6a9d2e3f15961d46');INSERT INTO "content_file" VALUES('46cc149939584b88b98fe87817f4ac73','low_res_video',0,0,2,'12084912e3b7515c96fb7619918f3215',NULL,'f26561b81ec45b61d1c95c1f7272d1eb');INSERT INTO "content_file" VALUES('18115b47268641b8a384ec96c8992edb','video_thumbnail',1,1,3,'df407485b38750649ce5949a4550ea70',NULL,'27230d0cdf5e819fa73cd4334a71ad4f');INSERT INTO "content_file" VALUES('4f66c254aada49bcb8d27638852debd2','low_res_video',0,0,2,'df407485b38750649ce5949a4550ea70',NULL,'2b36860cbeafd6063ceb746e436a7076');INSERT INTO "content_file" VALUES('ffca750763a84744ad1b4e3e4f5f5ecd','video_thumbnail',1,1,3,'9db1b3a00df4523eb6de4d53e7f696a1',NULL,'bfa6e65472ef43288483acd53553dc25');INSERT INTO "content_file" VALUES('75ca4cd2f64c4f9ba130559e8db48c25','low_res_video',0,0,2,'9db1b3a00df4523eb6de4d53e7f696a1',NULL,'833462f99c228f7f41dd453dfadb0f41');INSERT INTO "content_file" VALUES('4aa4ed8738b84cd0bd578ba0f2303c9b','video_thumbnail',1,1,3,'a09e9b7f1d1654d180db7574a7d5f585',NULL,'411574f3b885cdd8939943780cd2590d');INSERT INTO "content_file" VALUES('c4598767fbaf4e9994411be42ec6fce8','low_res_video',0,0,2,'a09e9b7f1d1654d180db7574a7d5f585',NULL,'ecbe67a046a0a1e1d9e0e137d862893f');INSERT INTO "content_file" VALUES('4242ad03d8da49f18b8a905b11e3574d','video_thumbnail',1,1,3,'9730a4ac12955cbb8e0913895519d1c2',NULL,'a2ea9b100f11639ee642764abad492cd');INSERT INTO "content_file" VALUES('f70a3da6b49e45d1a5be9ab9385e79ad','low_res_video',0,0,2,'9730a4ac12955cbb8e0913895519d1c2',NULL,'14e78a4100dcf7b532aff77c9dd66e02');INSERT INTO "content_file" VALUES('89ec045fb7e64a6785ace4ff2a12b372','video_thumbnail',1,1,3,'9dd5c2e796a9514d852ce1c37cbda33f',NULL,'2cfb0fd48c41ce549664115b512c5969');INSERT INTO "content_file" VALUES('d265da8e747146e49a23068c329defe1','low_res_video',0,0,2,'9dd5c2e796a9514d852ce1c37cbda33f',NULL,'1aa0ec382579b4f4fedba920f54e5b7a');INSERT INTO "content_file" VALUES('a892852739404f81b60c4f2b6fce3ea9','video_thumbnail',1,1,3,'a17025f3967e51bc870a59ff983f1ce6',NULL,'f25dcda208e4204cffbb632f03fffdb5');INSERT INTO "content_file" VALUES('0f8d177a9e2d462e823491e185ec83eb','low_res_video',0,0,2,'a17025f3967e51bc870a59ff983f1ce6',NULL,'648c1f074dd69b6a8be63eef06aebb07');INSERT INTO "content_file" VALUES('18c173566f8a47ef8445e2244b304016','video_thumbnail',1,1,3,'8f93fedbc07151b39504e7ded6301851',NULL,'36f3545c69fdc14eb4e7afb811d0505d');INSERT INTO "content_file" VALUES('0fa53215c0684e488052d78750235505','low_res_video',0,0,2,'8f93fedbc07151b39504e7ded6301851',NULL,'96895bf6f6f8171cc50230a5deda1d34');INSERT INTO "content_file" VALUES('3b3bcd70d076417bb0fe61859331cfd2','video_thumbnail',1,1,3,'ab2b46614ee9551096289cdd06e828fa',NULL,'2b9949019dcfd62187fa873dc6355da6');INSERT INTO "content_file" VALUES('c5f5393b9cef4581970aead8575c260b','low_res_video',0,0,2,'ab2b46614ee9551096289cdd06e828fa',NULL,'f28abd9f73ff0f39458b0fad5a8f07eb');INSERT INTO "content_file" VALUES('e58e35b16c0643c180341d9e8c50f6df','video_thumbnail',1,1,3,'d7f9999fdf88586abdd9c7f544ec1b67',NULL,'9dc4b5be36238a77a9aac55c0e420618');INSERT INTO "content_file" VALUES('58d7c828eeb94b26853d2a1585f5b26d','low_res_video',0,0,2,'d7f9999fdf88586abdd9c7f544ec1b67',NULL,'15ddceec6b7ec50ab59bde98f48c90fb');INSERT INTO "content_file" VALUES('eb68aa5e483b448f8710a416b795395c','video_thumbnail',1,1,3,'fbb063844a825920a1002fdcb0273dff',NULL,'f1fb7d407fb8e5faf250cd6ec252498d');INSERT INTO "content_file" VALUES('f469acb1a7624c699fd2068d53e6b329','low_res_video',0,0,2,'fbb063844a825920a1002fdcb0273dff',NULL,'491a8c42658a5704692177771021a96d');INSERT INTO "content_file" VALUES('3f40d90b28ac497ea6b12adbdc2e42f4','video_thumbnail',1,1,3,'4d4dd207635c59cbb5b3d7f7771002c2',NULL,'dc4c7584a1904f9abe585b8a218b64d8');INSERT INTO "content_file" VALUES('012b7f980cbd48e68274d0c2936f8e06','low_res_video',0,0,2,'4d4dd207635c59cbb5b3d7f7771002c2',NULL,'275219e4b6f81908edb1e58bec9a1c7d');INSERT INTO "content_file" VALUES('b9077a4c77964c2081e6e47106406572','video_thumbnail',1,1,3,'6d0be50eb82752cb8d4fb6cfe89d9194',NULL,'013e6d90625d6eeeb8f82665194adc90');INSERT INTO "content_file" VALUES('704a8cb035d04c9f97602682d61db18b','low_res_video',0,0,2,'6d0be50eb82752cb8d4fb6cfe89d9194',NULL,'8f10ec3795a151b872600ae1f98ed9f9');INSERT INTO "content_file" VALUES('7327de629e0f4d39a3d6d5b66b9357dd','video_thumbnail',1,1,3,'f530451e29b454cfb9524f8f272adefd',NULL,'4a427a58aa797b29a9eed2fad56c8b68');INSERT INTO "content_file" VALUES('a86d293db471485d8344b315c731ccbd','low_res_video',0,0,2,'f530451e29b454cfb9524f8f272adefd',NULL,'9124f0ca5678499b2e664442be55b473');INSERT INTO "content_file" VALUES('a0b6bcc62bf448ee97d40940073aed87','video_thumbnail',1,1,3,'443cd862582453e8bb25280ea4134e54',NULL,'d171e084143243dd17a4648fbce3a255');INSERT INTO "content_file" VALUES('7d09c46b042e4d8d9f377024320d5d8f','low_res_video',0,0,2,'443cd862582453e8bb25280ea4134e54',NULL,'73fa98d385e869e09158ac857373cb53');INSERT INTO "content_file" VALUES('1b6213bc381e4a21becf40efbb51dcbb','video_thumbnail',1,1,3,'4943679baaab57a28850fe3b959b0184',NULL,'82b4ae8dede08df1a4bed2d4b21cbbc9');INSERT INTO "content_file" VALUES('85b285789e764489b96d4f0956005f02','low_res_video',0,0,2,'4943679baaab57a28850fe3b959b0184',NULL,'4788c09ea760b29871bad66deac20439');INSERT INTO "content_file" VALUES('861358d506f542659eaa778279a5bdee','video_thumbnail',1,1,3,'40c01e859b265734a8519e78a0d66215',NULL,'fc5abdfc4e90e33a18efc7edf68ca1dd');INSERT INTO "content_file" VALUES('4e04242e51c1411b9db6d1fc55041480','low_res_video',0,0,2,'40c01e859b265734a8519e78a0d66215',NULL,'015356a56cf09e04fa748c9550738246');INSERT INTO "content_file" VALUES('224576193eaf4dd19657c3cca21850b0','video_thumbnail',1,1,3,'cc5bf195c8715e3498e8bed4c477a9f1',NULL,'73e06cb5e77f6e127b8335d7172bc6f1');INSERT INTO "content_file" VALUES('9a2277dce2c04924af60f93436c3ff26','low_res_video',0,0,2,'cc5bf195c8715e3498e8bed4c477a9f1',NULL,'3414589566193fe1e5b19fad12211b31');INSERT INTO "content_file" VALUES('26215736712b48bfafbe5b31ebdbdae7','video_thumbnail',1,1,3,'4fac585aab835eeea230386186b872d7',NULL,'5b37affd69ba3561d6fa8097a0b943cd');INSERT INTO "content_file" VALUES('1bfc8633774e4870958e3df3fb00201e','low_res_video',0,0,2,'4fac585aab835eeea230386186b872d7',NULL,'093074fb9725852396102d9b110f5ea9');INSERT INTO "content_file" VALUES('f37e344bca6a4e289ba525a074cc6c98','video_thumbnail',1,1,3,'09e9555b6a3d5c5598927809199c6124',NULL,'4cec4c553c7d383d9866d8cd1fe0a717');INSERT INTO "content_file" VALUES('1eb941533a73486ba721f60ff70b10ef','low_res_video',0,0,2,'09e9555b6a3d5c5598927809199c6124',NULL,'5d39aaea241907769883307b7008014b');INSERT INTO "content_file" VALUES('6bd761bb4fd749fc850e7b43927544ab','video_thumbnail',1,1,3,'5634f0826a305f26a79088e3e98220f9',NULL,'5e82f50f33b3d3893494064bb6c5370c');INSERT INTO "content_file" VALUES('24062d4e8e3e499480339a67e4148b4d','low_res_video',0,0,2,'5634f0826a305f26a79088e3e98220f9',NULL,'46826a155b01ba2ed840a816b21ed4f0');INSERT INTO "content_file" VALUES('dc99680e3ef342d79b29eee04807c3ac','video_thumbnail',1,1,3,'b50e77e4623c57448373b152f8a230c2',NULL,'bed12d1c75319888722ca6038682c566');INSERT INTO "content_file" VALUES('eef8102ac20247df9ef955de7c5f8696','low_res_video',0,0,2,'b50e77e4623c57448373b152f8a230c2',NULL,'8c72a22b440c7eaf81d107b51795cdf9');INSERT INTO "content_file" VALUES('2644f7ab0b9f4daa83bbd1fada4c3634','video_thumbnail',1,1,3,'a439bdc1fb9a5f9294160c449a0b3ae5',NULL,'5ab0196ce2619d8b8d74197491f1f966');INSERT INTO "content_file" VALUES('75d80961f6094031b38546797b358248','low_res_video',0,0,2,'a439bdc1fb9a5f9294160c449a0b3ae5',NULL,'1175a098cdf2afb5fde204006e035520');INSERT INTO "content_file" VALUES('0141c59e42704f088e26189ce785e861','video_thumbnail',1,1,3,'b1095132839c5a83b94ae5caa795ed38',NULL,'f95555621101c0973a5e6e135709e589');INSERT INTO "content_file" VALUES('aa99cde54e204b15882b2aae3e5bdb6f','low_res_video',0,0,2,'b1095132839c5a83b94ae5caa795ed38',NULL,'645a452fa3818badf77657f0ca7d71f6');INSERT INTO "content_file" VALUES('c7beef9babf64ed4acde2a54fa50db84','video_thumbnail',1,1,3,'ea56e8c48e60594db22ee8faa35f44af',NULL,'440926a1076e2736ae38d998c2a482be');INSERT INTO "content_file" VALUES('6fb781638fab474392c86b6bc10159eb','low_res_video',0,0,2,'ea56e8c48e60594db22ee8faa35f44af',NULL,'7031f67b1931d7ea751cd079d2299cdf');INSERT INTO "content_file" VALUES('4cbdbc8199b14412bdea61a829179ba5','video_thumbnail',1,1,3,'8298fa60c56a513c8288c5c10d5175d2',NULL,'ce0fd246a5eaac1486ab0bf729591928');INSERT INTO "content_file" VALUES('cbc26d917999475c9e8840bb2138caa7','low_res_video',0,0,2,'8298fa60c56a513c8288c5c10d5175d2',NULL,'06c59c3c222140c7711ac28505891618');INSERT INTO "content_file" VALUES('14d6e04d87b34f279cc38abfa900d095','video_thumbnail',1,1,3,'82ef5d84b68d5838b5bf03ee8237e709',NULL,'59ee839471e313165e3fede87fa0a952');INSERT INTO "content_file" VALUES('afbdcf8314e5481cb2430fa91891381d','low_res_video',0,0,2,'82ef5d84b68d5838b5bf03ee8237e709',NULL,'d9bd3c3fbb409820d7377c5e40932ab3');INSERT INTO "content_file" VALUES('8ed4c41a2c8e423a94d7505c580a2d41','video_thumbnail',1,1,3,'8fcb975954c75202879ea720b344c306',NULL,'c8dc287264442dea68124dc8c180e198');INSERT INTO "content_file" VALUES('70621ddd674b48e1a02c1c55c6198a75','low_res_video',0,0,2,'8fcb975954c75202879ea720b344c306',NULL,'8e14aa04f1b31be32b88e6d0a57c66b8');INSERT INTO "content_file" VALUES('4ba430917570463a9c56d8fe75c6f661','video_thumbnail',1,1,3,'9810aa3c9b6d5a659bb008006e96ef4b',NULL,'17fc53addaef8293283079d9c456b6f1');INSERT INTO "content_file" VALUES('220b8a90bde64d198c5a278732058171','low_res_video',0,0,2,'9810aa3c9b6d5a659bb008006e96ef4b',NULL,'f762f27594632fe84e1c6e9e369025be');INSERT INTO "content_file" VALUES('fab6e071910345c0a18cf9cd6fde20d8','video_thumbnail',1,1,3,'b7732a57402c5e23b2ab16972bcf582d',NULL,'1a05109bc09be7e48781886324f906fc');INSERT INTO "content_file" VALUES('8dd638ba8a9d44c086932b673a926c38','low_res_video',0,0,2,'b7732a57402c5e23b2ab16972bcf582d',NULL,'079579507c32767c0fd75047469357f4');INSERT INTO "content_file" VALUES('703ba44289b743408275c93d561c4891','video_thumbnail',1,1,3,'66612629c66c51b3beb542d8f4e7c378',NULL,'a16a26bd73073b5688b846ee84c8398c');INSERT INTO "content_file" VALUES('e3fa082019a24b418cf45dd4343d2c30','low_res_video',0,0,2,'66612629c66c51b3beb542d8f4e7c378',NULL,'90a54ce708761074481573afaee11754');INSERT INTO "content_file" VALUES('9f7bf6f1af9a478ab10a532ed2d18ab9','video_thumbnail',1,1,3,'9b536fc5aceb511d9291c9f033cf382a',NULL,'c6e1e436f23f890185ebb6a21187bb20');INSERT INTO "content_file" VALUES('43c2d8fb1c794d829ac8f22bdd957855','low_res_video',0,0,2,'9b536fc5aceb511d9291c9f033cf382a',NULL,'e71c21d5c915e4b1be31314895a88d86');INSERT INTO "content_file" VALUES('524b694e83594c02a8c521c5c596e248','video_thumbnail',1,1,3,'0a9ba01e878d5c48a9b8589a54028702',NULL,'fa84bef83ae09ff1dbc1ea8e35d12db2');INSERT INTO "content_file" VALUES('cef5e9f9bc044fd394add30d3a6c15d0','low_res_video',0,0,2,'0a9ba01e878d5c48a9b8589a54028702',NULL,'38a4f3431e1a28275db412cdfdca6004');INSERT INTO "content_file" VALUES('ef13ab41b99b4aac90df30c80eb70511','video_thumbnail',1,1,3,'00b0f1992dda58778c719b65543d1f6f',NULL,'78b6f267fe2575d0bec16ead60b1ac0c');INSERT INTO "content_file" VALUES('430fe7788c5d44ebb74bb48d04a33da3','low_res_video',0,0,2,'00b0f1992dda58778c719b65543d1f6f',NULL,'ac9644bd921d3a397796e2787350577b');INSERT INTO "content_file" VALUES('07b716fa978647e9956eb7d9fee569ec','video_thumbnail',1,1,3,'8303cb6576c15aacb9588ed335f61f44',NULL,'fbfd11304122fc2322874d13aecfbe96');INSERT INTO "content_file" VALUES('6174e6231ca54c2bb7280b6f2d18d639','low_res_video',0,0,2,'8303cb6576c15aacb9588ed335f61f44',NULL,'aec165d8b74f35405eb969c1b76d494d');INSERT INTO "content_file" VALUES('ccc4dc27a5ff4209a481cc8f2b37b82a','video_thumbnail',1,1,3,'dec4da8096715557a079ef1b35256a5a',NULL,'9816ff2c369c0dd0b89144a1815a2217');INSERT INTO "content_file" VALUES('95396cc0188847c8a25701ec424a8000','low_res_video',0,0,2,'dec4da8096715557a079ef1b35256a5a',NULL,'e7339619f018375197ba90bc45489143');INSERT INTO "content_file" VALUES('f7664a6742f2442ebb441c881d6f1b2d','video_thumbnail',1,1,3,'abfae014ac2752408adee8c2a153793b',NULL,'10590c10275288c29c6dfe1d8343012e');INSERT INTO "content_file" VALUES('f117334b342844628b4b78e91e03eb07','low_res_video',0,0,2,'abfae014ac2752408adee8c2a153793b',NULL,'94b8f7ff68fc48c04b55f68416118ae3');INSERT INTO "content_file" VALUES('cf037ef0c4a74295810b550609845cfd','video_thumbnail',1,1,3,'9044a94b74cb569ab96bcad141654a91',NULL,'56dd804beb339287b435af397e957473');INSERT INTO "content_file" VALUES('39043058055b4042a140847d0932e408','low_res_video',0,0,2,'9044a94b74cb569ab96bcad141654a91',NULL,'1931ad1c13753dae91ae95092beece8d');INSERT INTO "content_file" VALUES('074c598b446a49b78a052580c40fb360','video_thumbnail',1,1,3,'97e61e2c4c9551fe937c5fdb29fc9d27',NULL,'1ae3a7456be1a56ac959a83c3ad644c4');INSERT INTO "content_file" VALUES('d0f6e78a5b0a4f599a4e70e47321a7ec','low_res_video',0,0,2,'97e61e2c4c9551fe937c5fdb29fc9d27',NULL,'7f63baef038a88c891aa12f587a41ddd');INSERT INTO "content_file" VALUES('f2d21ca6c4ff4705ab7a62257efa082b','video_thumbnail',1,1,3,'7da9b4abdac35ef3a5cc34cc4503e074',NULL,'626d266f8a5dcca9cb79ec2d4f731544');INSERT INTO "content_file" VALUES('c6f22fef430648bab6185227ada4dfdb','low_res_video',0,0,2,'7da9b4abdac35ef3a5cc34cc4503e074',NULL,'e49cb90a46b343239ab0e303b429e5b2');INSERT INTO "content_file" VALUES('02e6050072724502bab677ecc09b57f7','video_thumbnail',1,1,3,'3de27b7918ce5519900af3568bc2968e',NULL,'3708567e8b5c7c4c6d11df55ca72015c');INSERT INTO "content_file" VALUES('800213da18e74f9eb0ecaaa551db0b6b','low_res_video',0,0,2,'3de27b7918ce5519900af3568bc2968e',NULL,'2de2f9ae1d48c550445dc849945f3398');INSERT INTO "content_file" VALUES('6ad836f1be144bbd809f52f31b02ff08','video_thumbnail',1,1,3,'ab0e378e5f965f628ee4921a32c2089b',NULL,'0a60d117e28c0c1aee8fcb3274a0cf45');INSERT INTO "content_file" VALUES('13b39a8dc3734196b54b6b1223efc11b','low_res_video',0,0,2,'ab0e378e5f965f628ee4921a32c2089b',NULL,'75b530a71922538c7f69aa80b525a162');INSERT INTO "content_file" VALUES('278e43c2242b44b5b438329ad48fe92f','video_thumbnail',1,1,3,'80c3acc50279512ca4a551852ad33085',NULL,'1f63ac1153eea0022af00b0cb7789286');INSERT INTO "content_file" VALUES('0d1022fb199b435da4e852684f97a94f','low_res_video',0,0,2,'80c3acc50279512ca4a551852ad33085',NULL,'28f5e43b58399d82de599d3d743b7ceb');INSERT INTO "content_file" VALUES('822b1fe9d1c142d8839e40287970e226','video_thumbnail',1,1,3,'ea34f78ec66450be88816a990927d65f',NULL,'e72395cd601bac3647658f676bf45ca9');INSERT INTO "content_file" VALUES('5b94b633215945708338ff019dca821a','low_res_video',0,0,2,'ea34f78ec66450be88816a990927d65f',NULL,'06b305e850fa6c7f490a696039f57ec1');INSERT INTO "content_file" VALUES('9a5e3afba0b540718cc1b43ab394c9b8','video_thumbnail',1,1,3,'26225a49ff085eaabfd99ee6a46df236',NULL,'4268d03b6f1f4476a8ab2fd2639a734f');INSERT INTO "content_file" VALUES('e7317ac53b074a58bce4828c224c87fc','low_res_video',0,0,2,'26225a49ff085eaabfd99ee6a46df236',NULL,'5d4b542ff84c8d7aefdf715bdcca90c2');INSERT INTO "content_file" VALUES('4115c06df61b41b8a1500444893d8f44','video_thumbnail',1,1,3,'0a5ed177c27d59f4a74c92b27b9900e1',NULL,'bbc3b60328887e3b826f26d1c4eede6d');INSERT INTO "content_file" VALUES('57fdce3e145844908b2b02ab5ee93589','low_res_video',0,0,2,'0a5ed177c27d59f4a74c92b27b9900e1',NULL,'ea6c1f15935ccbc14caf3c5dd8aee338');INSERT INTO "content_file" VALUES('6dfc39ed6869425cb8d3873169dbb6cf','video_thumbnail',1,1,3,'a0bb52afa46e57a8a2b3882d27a4e6a5',NULL,'752cd8f5336c413715749b006750cc38');INSERT INTO "content_file" VALUES('4d44ceb96a844490ba961fa23d7bf211','low_res_video',0,0,2,'a0bb52afa46e57a8a2b3882d27a4e6a5',NULL,'4bb3a9fbfeb3ea9ed6c6f7dc1f027dc8');INSERT INTO "content_file" VALUES('98df1412b65e4ad0a9aeeb6ddce27739','video_thumbnail',1,1,3,'c09c6d0b69bb57d2aa233a09cfd2eeb9',NULL,'b0ae1f407347af77e332f22bdd7be2d2');INSERT INTO "content_file" VALUES('fe9cc51aaf5c4eea8ce89d0918867be9','low_res_video',0,0,2,'c09c6d0b69bb57d2aa233a09cfd2eeb9',NULL,'649f8e511258aa69634382056d1fee5b');INSERT INTO "content_file" VALUES('cb47f09d60c8446db43b0aa240ab292e','video_thumbnail',1,1,3,'f44ff796457d58a5a4d18e622bed41c2',NULL,'447216d138390197526274b216ea1c59');INSERT INTO "content_file" VALUES('7a631dab65104b9aa36f8e3def9ed26f','low_res_video',0,0,2,'f44ff796457d58a5a4d18e622bed41c2',NULL,'22f2a0b1c234322998e7c59382ada13f');INSERT INTO "content_file" VALUES('781aad9e0f964b008a8fe2b39cea3830','video_thumbnail',1,1,3,'fdaa4626807355db8c85dd1dabd9a143',NULL,'1300c47e8395e90eaea6c23cd678c207');INSERT INTO "content_file" VALUES('662134c8d6ef44aa8bb7bc795403c831','low_res_video',0,0,2,'fdaa4626807355db8c85dd1dabd9a143',NULL,'672630ba9c4100907ec5e4af594434c8');INSERT INTO "content_file" VALUES('46ef0d1306fc43e59b00fc15f048fb18','video_thumbnail',1,1,3,'9486407106d953fb8776be1180184fdc',NULL,'be9e5c8bb66f37fbcbdc1f67872e0749');INSERT INTO "content_file" VALUES('fec9829e17d947748d4836208057192f','low_res_video',0,0,2,'9486407106d953fb8776be1180184fdc',NULL,'27221605bb4bdfb6da48aa424961b22a');INSERT INTO "content_file" VALUES('c018950e13da45f6acadc3fb15cc3439','video_thumbnail',1,1,3,'7725ff767b16568da10ff91f9981b854',NULL,'34732f6fa3beb44d07341ddd5ca26221');INSERT INTO "content_file" VALUES('eaaafe97e65641f0b1b0cf9861e9c153','low_res_video',0,0,2,'7725ff767b16568da10ff91f9981b854',NULL,'d350065299c59042dc85c98d8b1a3524');INSERT INTO "content_file" VALUES('564910d8366344be8252cd42ffb0343c','video_thumbnail',1,1,3,'8a1bab9a242850949154e43cac93e255',NULL,'912336f986ae17fb9ab5e30d3214f175');INSERT INTO "content_file" VALUES('47f36cc779df44978a4f1c662ab6b524','low_res_video',0,0,2,'8a1bab9a242850949154e43cac93e255',NULL,'0f3f5bd21538d96eb2b80d693f0dd6d7');INSERT INTO "content_file" VALUES('46a652b2bea1419e8a1a435b2ebacd30','video_thumbnail',1,1,3,'f3d506a075ca5dcab3194850cde233e8',NULL,'858134fa3464935ab016a8a8779fe403');INSERT INTO "content_file" VALUES('4de8887924724801ae8865ab77918353','low_res_video',0,0,2,'f3d506a075ca5dcab3194850cde233e8',NULL,'5251a82988254cdf90b39dee71dce2ea');INSERT INTO "content_file" VALUES('6a2fc45278bb4f14b2e208048266873a','video_thumbnail',1,1,3,'611df051ccf35a57bc9f1b5875ef54da',NULL,'1b19d4a08418059aefbc7b0c45bdc465');INSERT INTO "content_file" VALUES('5e19c59b32f64405a9f415a306616b76','low_res_video',0,0,2,'611df051ccf35a57bc9f1b5875ef54da',NULL,'d1c1a0a38d1428548b396268f3e714b4');INSERT INTO "content_file" VALUES('70fe262fd4574830a5b96dc7ba861300','video_thumbnail',1,1,3,'166661fb7aeb56008f503eeecf2ad0e6',NULL,'725f982c00c77daa915bdf30c7e96260');INSERT INTO "content_file" VALUES('59e08432bfc4403cb80a68b0ab6ef157','low_res_video',0,0,2,'166661fb7aeb56008f503eeecf2ad0e6',NULL,'bb59b358bf69ff1f0731c6c1596f2687');INSERT INTO "content_file" VALUES('20d0dd313e37451ea337e00ed7e05f59','video_thumbnail',1,1,3,'1003650202f75729b93a6da2a527c475',NULL,'7e03db9d7bddb03c75f75d3b3ff8c68d');INSERT INTO "content_file" VALUES('0f2f304674c14a0f88e44df3aab4d9c3','low_res_video',0,0,2,'1003650202f75729b93a6da2a527c475',NULL,'ceb7e2c7660d25919fdee88c05fef670');INSERT INTO "content_file" VALUES('f31dc6a21d3443a0ad3e35b9db641433','video_thumbnail',1,1,3,'1501650315505010b15d98da5f30b48a',NULL,'86a5ae820358126a4558d65acd6577c2');INSERT INTO "content_file" VALUES('a1d070c0104d44e29858cc502b6c6dee','low_res_video',0,0,2,'1501650315505010b15d98da5f30b48a',NULL,'67797919d284349378c164d8774e912e');INSERT INTO "content_file" VALUES('7a47fa7613624a0580c2e9077733d13f','video_thumbnail',1,1,3,'4367c6db58375a2e8930375a6619ffcd',NULL,'18d4cd47acb508e480a4fbe36d1fbcf0');INSERT INTO "content_file" VALUES('92d8ff1d6d7f4f2d846c3a21dc80c02e','low_res_video',0,0,2,'4367c6db58375a2e8930375a6619ffcd',NULL,'fc729746c6818049785b9b8750b5b9c6');INSERT INTO "content_file" VALUES('f796b82bc3744723b61bb6846e6160fb','video_thumbnail',1,1,3,'79b50d90b0a251eead7ec480bb6d13ce',NULL,'341471bb518ebf829f249716a3a7cf53');INSERT INTO "content_file" VALUES('bbae8898d27a4a389d01063e4e5242ae','low_res_video',0,0,2,'79b50d90b0a251eead7ec480bb6d13ce',NULL,'4cc0754502915140e5d7f3fc3fdb5043');INSERT INTO "content_file" VALUES('402c95fd45404b7397aae5528d2ab246','video_thumbnail',1,1,3,'114842df193e5ee2bcf8d48598066748',NULL,'a13adbc1596136e2b4922725fa1d9a66');INSERT INTO "content_file" VALUES('e1dac36ad8ac48adb7b9f90a783a48bc','low_res_video',0,0,2,'114842df193e5ee2bcf8d48598066748',NULL,'a4220972ca8c96fe1331b5a4927f2da2');INSERT INTO "content_file" VALUES('4c313477c14f40739db1ea1a79c53e38','video_thumbnail',1,1,3,'758c6316625f5b449b3ae3cdefdafedc',NULL,'9ab4bf2f2da93acb95a0b30eba61bc3a');INSERT INTO "content_file" VALUES('ab77e4df67b54acc899be1f72d21402c','low_res_video',0,0,2,'758c6316625f5b449b3ae3cdefdafedc',NULL,'299b6e3e4cf63522563006e3f7451f3a');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);INSERT INTO "content_language" VALUES('en','en',NULL,'English','ltr');CREATE TABLE "content_localfile" ("id" varchar(32) NOT NULL PRIMARY KEY, "available" bool NOT NULL, "file_size" integer NULL, "extension" varchar(40) NOT NULL);INSERT INTO "content_localfile" VALUES('19e435f5e7c74f470139e2797c38cf32',1,92770,'png');INSERT INTO "content_localfile" VALUES('8e327b2fc702894e4cc8a22fab01378b',1,15664618,'mp4');INSERT INTO "content_localfile" VALUES('f77f3e3a622c66b395c87ef574c083c1',0,98593,'png');INSERT INTO "content_localfile" VALUES('11e1c2c83b9dd46e584d75f484386021',0,12719162,'mp4');INSERT INTO "content_localfile" VALUES('f4a57dc6cbc50b4ba99ffa51e0976a92',0,102959,'png');INSERT INTO "content_localfile" VALUES('9fd63b12e223f69b4a6d202da677e163',0,10530802,'mp4');INSERT INTO "content_localfile" VALUES('9f54c953b113557e40003dd69d8d8f68',0,106861,'png');INSERT INTO "content_localfile" VALUES('6d0d8cef3d028b349736791e9762cd26',0,9706380,'mp4');INSERT INTO "content_localfile" VALUES('ffef661089b1a31cc37b1d8c13959871',0,95708,'png');INSERT INTO "content_localfile" VALUES('d742094b0921008cc3693fa101bec907',0,12169191,'mp4');INSERT INTO "content_localfile" VALUES('676e5c675500b3f7a1556392948fdb18',0,106733,'png');INSERT INTO "content_localfile" VALUES('14475d6376e30410a7af0ac729ae1ab1',0,13970889,'mp4');INSERT INTO "content_localfile" VALUES('9f1139876ba1e5177b52d9e0792982f4',0,96197,'png');INSERT INTO "content_localfile" VALUES('47b2d6d9f7d35128352b984f72fc5ae1',0,13923063,'mp4');INSERT INTO "content_localfile" VALUES('76f5e7848768115e6a9d2e3f15961d46',0,103127,'png');INSERT INTO "content_localfile" VALUES('f26561b81ec45b61d1c95c1f7272d1eb',0,11206616,'mp4');INSERT INTO "content_localfile" VALUES('27230d0cdf5e819fa73cd4334a71ad4f',0,91446,'png');INSERT INTO "content_localfile" VALUES('2b36860cbeafd6063ceb746e436a7076',0,12351573,'mp4');INSERT INTO "content_localfile" VALUES('bfa6e65472ef43288483acd53553dc25',0,106865,'png');INSERT INTO "content_localfile" VALUES('833462f99c228f7f41dd453dfadb0f41',0,13059243,'mp4');INSERT INTO "content_localfile" VALUES('411574f3b885cdd8939943780cd2590d',0,104467,'png');INSERT INTO "content_localfile" VALUES('ecbe67a046a0a1e1d9e0e137d862893f',0,11202459,'mp4');INSERT INTO "content_localfile" VALUES('a2ea9b100f11639ee642764abad492cd',0,103172,'png');INSERT INTO "content_localfile" VALUES('14e78a4100dcf7b532aff77c9dd66e02',0,7822623,'mp4');INSERT INTO "content_localfile" VALUES('2cfb0fd48c41ce549664115b512c5969',0,101894,'png');INSERT INTO "content_localfile" VALUES('1aa0ec382579b4f4fedba920f54e5b7a',0,11156991,'mp4');INSERT INTO "content_localfile" VALUES('f25dcda208e4204cffbb632f03fffdb5',0,96670,'png');INSERT INTO "content_localfile" VALUES('648c1f074dd69b6a8be63eef06aebb07',0,11053789,'mp4');INSERT INTO "content_localfile" VALUES('36f3545c69fdc14eb4e7afb811d0505d',0,99017,'png');INSERT INTO "content_localfile" VALUES('96895bf6f6f8171cc50230a5deda1d34',0,11303426,'mp4');INSERT INTO "content_localfile" VALUES('2b9949019dcfd62187fa873dc6355da6',0,96680,'png');INSERT INTO "content_localfile" VALUES('f28abd9f73ff0f39458b0fad5a8f07eb',0,8800826,'mp4');INSERT INTO "content_localfile" VALUES('9dc4b5be36238a77a9aac55c0e420618',0,100157,'png');INSERT INTO "content_localfile" VALUES('15ddceec6b7ec50ab59bde98f48c90fb',0,10917731,'mp4');INSERT INTO "content_localfile" VALUES('f1fb7d407fb8e5faf250cd6ec252498d',0,105103,'png');INSERT INTO "content_localfile" VALUES('491a8c42658a5704692177771021a96d',0,9857365,'mp4');INSERT INTO "content_localfile" VALUES('dc4c7584a1904f9abe585b8a218b64d8',0,100358,'png');INSERT INTO "content_localfile" VALUES('275219e4b6f81908edb1e58bec9a1c7d',0,12506374,'mp4');INSERT INTO "content_localfile" VALUES('013e6d90625d6eeeb8f82665194adc90',0,101726,'png');INSERT INTO "content_localfile" VALUES('8f10ec3795a151b872600ae1f98ed9f9',0,8231355,'mp4');INSERT INTO "content_localfile" VALUES('4a427a58aa797b29a9eed2fad56c8b68',0,98725,'png');INSERT INTO "content_localfile" VALUES('9124f0ca5678499b2e664442be55b473',0,9880006,'mp4');INSERT INTO "content_localfile" VALUES('d171e084143243dd17a4648fbce3a255',0,99536,'png');INSERT INTO "content_localfile" VALUES('73fa98d385e869e09158ac857373cb53',0,11604903,'mp4');INSERT INTO "content_localfile" VALUES('82b4ae8dede08df1a4bed2d4b21cbbc9',0,94422,'png');INSERT INTO "content_localfile" VALUES('4788c09ea760b29871bad66deac20439',0,11109981,'mp4');INSERT INTO "content_localfile" VALUES('fc5abdfc4e90e33a18efc7edf68ca1dd',0,101659,'png');INSERT INTO "content_localfile" VALUES('015356a56cf09e04fa748c9550738246',0,12286752,'mp4');INSERT INTO "content_localfile" VALUES('73e06cb5e77f6e127b8335d7172bc6f1',0,101165,'png');INSERT INTO "content_localfile" VALUES('3414589566193fe1e5b19fad12211b31',0,10691016,'mp4');INSERT INTO "content_localfile" VALUES('5b37affd69ba3561d6fa8097a0b943cd',0,102299,'png');INSERT INTO "content_localfile" VALUES('093074fb9725852396102d9b110f5ea9',0,8192321,'mp4');INSERT INTO "content_localfile" VALUES('4cec4c553c7d383d9866d8cd1fe0a717',0,107232,'png');INSERT INTO "content_localfile" VALUES('5d39aaea241907769883307b7008014b',0,9073856,'mp4');INSERT INTO "content_localfile" VALUES('5e82f50f33b3d3893494064bb6c5370c',0,105712,'png');INSERT INTO "content_localfile" VALUES('46826a155b01ba2ed840a816b21ed4f0',0,11073554,'mp4');INSERT INTO "content_localfile" VALUES('bed12d1c75319888722ca6038682c566',0,111008,'png');INSERT INTO "content_localfile" VALUES('8c72a22b440c7eaf81d107b51795cdf9',0,11967288,'mp4');INSERT INTO "content_localfile" VALUES('5ab0196ce2619d8b8d74197491f1f966',0,107425,'png');INSERT INTO "content_localfile" VALUES('1175a098cdf2afb5fde204006e035520',0,11146146,'mp4');INSERT INTO "content_localfile" VALUES('f95555621101c0973a5e6e135709e589',0,127154,'png');INSERT INTO "content_localfile" VALUES('645a452fa3818badf77657f0ca7d71f6',0,92303317,'mp4');INSERT INTO "content_localfile" VALUES('440926a1076e2736ae38d998c2a482be',0,81708,'png');INSERT INTO "content_localfile" VALUES('7031f67b1931d7ea751cd079d2299cdf',0,50436633,'mp4');INSERT INTO "content_localfile" VALUES('ce0fd246a5eaac1486ab0bf729591928',0,120605,'png');INSERT INTO "content_localfile" VALUES('06c59c3c222140c7711ac28505891618',0,66242800,'mp4');INSERT INTO "content_localfile" VALUES('59ee839471e313165e3fede87fa0a952',0,127344,'png');INSERT INTO "content_localfile" VALUES('d9bd3c3fbb409820d7377c5e40932ab3',0,63300396,'mp4');INSERT INTO "content_localfile" VALUES('c8dc287264442dea68124dc8c180e198',0,104875,'png');INSERT INTO "content_localfile" VALUES('8e14aa04f1b31be32b88e6d0a57c66b8',0,43384920,'mp4');INSERT INTO "content_localfile" VALUES('17fc53addaef8293283079d9c456b6f1',0,71622,'png');INSERT INTO "content_localfile" VALUES('f762f27594632fe84e1c6e9e369025be',0,49848897,'mp4');INSERT INTO "content_localfile" VALUES('1a05109bc09be7e48781886324f906fc',0,26514,'png');INSERT INTO "content_localfile" VALUES('079579507c32767c0fd75047469357f4',0,36582625,'mp4');INSERT INTO "content_localfile" VALUES('a16a26bd73073b5688b846ee84c8398c',0,108880,'png');INSERT INTO "content_localfile" VALUES('90a54ce708761074481573afaee11754',0,81013121,'mp4');INSERT INTO "content_localfile" VALUES('c6e1e436f23f890185ebb6a21187bb20',0,116242,'png');INSERT INTO "content_localfile" VALUES('e71c21d5c915e4b1be31314895a88d86',0,72811288,'mp4');INSERT INTO "content_localfile" VALUES('fa84bef83ae09ff1dbc1ea8e35d12db2',0,94790,'png');INSERT INTO "content_localfile" VALUES('38a4f3431e1a28275db412cdfdca6004',0,99095500,'mp4');INSERT INTO "content_localfile" VALUES('78b6f267fe2575d0bec16ead60b1ac0c',0,129888,'png');INSERT INTO "content_localfile" VALUES('ac9644bd921d3a397796e2787350577b',0,60689718,'mp4');INSERT INTO "content_localfile" VALUES('fbfd11304122fc2322874d13aecfbe96',0,90911,'png');INSERT INTO "content_localfile" VALUES('aec165d8b74f35405eb969c1b76d494d',0,12117076,'mp4');INSERT INTO "content_localfile" VALUES('9816ff2c369c0dd0b89144a1815a2217',0,35509,'png');INSERT INTO "content_localfile" VALUES('e7339619f018375197ba90bc45489143',0,30889438,'mp4');INSERT INTO "content_localfile" VALUES('10590c10275288c29c6dfe1d8343012e',0,100422,'png');INSERT INTO "content_localfile" VALUES('94b8f7ff68fc48c04b55f68416118ae3',0,74807760,'mp4');INSERT INTO "content_localfile" VALUES('56dd804beb339287b435af397e957473',0,112973,'png');INSERT INTO "content_localfile" VALUES('1931ad1c13753dae91ae95092beece8d',0,107140216,'mp4');INSERT INTO "content_localfile" VALUES('1ae3a7456be1a56ac959a83c3ad644c4',0,105657,'png');INSERT INTO "content_localfile" VALUES('7f63baef038a88c891aa12f587a41ddd',0,65636159,'mp4');INSERT INTO "content_localfile" VALUES('626d266f8a5dcca9cb79ec2d4f731544',0,168276,'png');INSERT INTO "content_localfile" VALUES('e49cb90a46b343239ab0e303b429e5b2',0,135263042,'mp4');INSERT INTO "content_localfile" VALUES('3708567e8b5c7c4c6d11df55ca72015c',0,163280,'png');INSERT INTO "content_localfile" VALUES('2de2f9ae1d48c550445dc849945f3398',0,172824404,'mp4');INSERT INTO "content_localfile" VALUES('0a60d117e28c0c1aee8fcb3274a0cf45',0,84086,'png');INSERT INTO "content_localfile" VALUES('75b530a71922538c7f69aa80b525a162',0,46141699,'mp4');INSERT INTO "content_localfile" VALUES('1f63ac1153eea0022af00b0cb7789286',0,124569,'png');INSERT INTO "content_localfile" VALUES('28f5e43b58399d82de599d3d743b7ceb',0,61992371,'mp4');INSERT INTO "content_localfile" VALUES('e72395cd601bac3647658f676bf45ca9',0,86175,'png');INSERT INTO "content_localfile" VALUES('06b305e850fa6c7f490a696039f57ec1',0,29630168,'mp4');INSERT INTO "content_localfile" VALUES('4268d03b6f1f4476a8ab2fd2639a734f',0,124734,'png');INSERT INTO "content_localfile" VALUES('5d4b542ff84c8d7aefdf715bdcca90c2',0,78450464,'mp4');INSERT INTO "content_localfile" VALUES('bbc3b60328887e3b826f26d1c4eede6d',0,101639,'png');INSERT INTO "content_localfile" VALUES('ea6c1f15935ccbc14caf3c5dd8aee338',0,120500314,'mp4');INSERT INTO "content_localfile" VALUES('752cd8f5336c413715749b006750cc38',0,135644,'png');INSERT INTO "content_localfile" VALUES('4bb3a9fbfeb3ea9ed6c6f7dc1f027dc8',0,88052586,'mp4');INSERT INTO "content_localfile" VALUES('b0ae1f407347af77e332f22bdd7be2d2',0,156771,'png');INSERT INTO "content_localfile" VALUES('649f8e511258aa69634382056d1fee5b',0,63637985,'mp4');INSERT INTO "content_localfile" VALUES('447216d138390197526274b216ea1c59',0,137535,'png');INSERT INTO "content_localfile" VALUES('22f2a0b1c234322998e7c59382ada13f',0,104526178,'mp4');INSERT INTO "content_localfile" VALUES('1300c47e8395e90eaea6c23cd678c207',0,128327,'png');INSERT INTO "content_localfile" VALUES('672630ba9c4100907ec5e4af594434c8',0,119892100,'mp4');INSERT INTO "content_localfile" VALUES('be9e5c8bb66f37fbcbdc1f67872e0749',0,53785,'png');INSERT INTO "content_localfile" VALUES('27221605bb4bdfb6da48aa424961b22a',0,65319425,'mp4');INSERT INTO "content_localfile" VALUES('34732f6fa3beb44d07341ddd5ca26221',0,78003,'png');INSERT INTO "content_localfile" VALUES('d350065299c59042dc85c98d8b1a3524',0,92479204,'mp4');INSERT INTO "content_localfile" VALUES('912336f986ae17fb9ab5e30d3214f175',0,114596,'png');INSERT INTO "content_localfile" VALUES('0f3f5bd21538d96eb2b80d693f0dd6d7',0,40760583,'mp4');INSERT INTO "content_localfile" VALUES('858134fa3464935ab016a8a8779fe403',0,167139,'png');INSERT INTO "content_localfile" VALUES('5251a82988254cdf90b39dee71dce2ea',0,66484020,'mp4');INSERT INTO "content_localfile" VALUES('1b19d4a08418059aefbc7b0c45bdc465',0,160675,'png');INSERT INTO "content_localfile" VALUES('d1c1a0a38d1428548b396268f3e714b4',0,147086993,'mp4');INSERT INTO "content_localfile" VALUES('725f982c00c77daa915bdf30c7e96260',0,85997,'png');INSERT INTO "content_localfile" VALUES('bb59b358bf69ff1f0731c6c1596f2687',0,43513397,'mp4');INSERT INTO "content_localfile" VALUES('7e03db9d7bddb03c75f75d3b3ff8c68d',0,105868,'png');INSERT INTO "content_localfile" VALUES('ceb7e2c7660d25919fdee88c05fef670',0,94522301,'mp4');INSERT INTO "content_localfile" VALUES('86a5ae820358126a4558d65acd6577c2',0,117718,'png');INSERT INTO "content_localfile" VALUES('67797919d284349378c164d8774e912e',0,63152036,'mp4');INSERT INTO "content_localfile" VALUES('18d4cd47acb508e480a4fbe36d1fbcf0',0,153079,'png');INSERT INTO "content_localfile" VALUES('fc729746c6818049785b9b8750b5b9c6',0,39828121,'mp4');INSERT INTO "content_localfile" VALUES('341471bb518ebf829f249716a3a7cf53',0,122658,'png');INSERT INTO "content_localfile" VALUES('4cc0754502915140e5d7f3fc3fdb5043',0,144549845,'mp4');INSERT INTO "content_localfile" VALUES('a13adbc1596136e2b4922725fa1d9a66',0,113945,'png');INSERT INTO "content_localfile" VALUES('a4220972ca8c96fe1331b5a4927f2da2',0,54324465,'mp4');INSERT INTO "content_localfile" VALUES('9ab4bf2f2da93acb95a0b30eba61bc3a',0,88330,'png');INSERT INTO "content_localfile" VALUES('299b6e3e4cf63522563006e3f7451f3a',0,59272117,'mp4');CREATE TABLE "device_contentcachekey" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "key" integer NOT NULL);INSERT INTO "device_contentcachekey" VALUES(1,1639873774);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-12-19 00:18:23.540488','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)');INSERT INTO "logger_usersessionlog" VALUES('02fe927fc22355517a8863e58f7441cc',1,'1a6d339061a44096b96548fcbca2a5af','0922fe4c01655735cdd57097f52ee837:user-rw:5153602b5a84aa3ed3df788ff77dae8f','','2021-04-21 03:18:42.530824(Europe/London)','','0922fe4c01655735cdd57097f52ee837','5153602b5a84aa3ed3df788ff77dae8f','2021-04-21 03:18:42.532427(Europe/London)');INSERT INTO "logger_usersessionlog" VALUES('18ba839115c51399b01b9ef0e9c6d404',1,'58b7b368a74f4d10b2f89d1da648f521','0922fe4c01655735cdd57097f52ee837:user-rw:5153602b5a84aa3ed3df788ff77dae8f','','2021-04-21 03:59:01.557026(Europe/London)','','0922fe4c01655735cdd57097f52ee837','5153602b5a84aa3ed3df788ff77dae8f','2021-04-21 03:59:01.558571(Europe/London)');INSERT INTO "logger_usersessionlog" VALUES('b9cf092648f78ee2dafe531942a21c80',1,'6929b3fa07da45c1b4c6ca0b6282da9f','0922fe4c01655735cdd57097f52ee837:user-rw:5153602b5a84aa3ed3df788ff77dae8f','','2021-12-19 00:16:54.606698(Europe/London)','','0922fe4c01655735cdd57097f52ee837','5153602b5a84aa3ed3df788ff77dae8f','2021-12-19 00:18:25.108230(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,0,'/home/pi/.kolibri/db.sqlite3','fa99180412164ffca641401e7b44ed29','d8d457b4a57f72218c9e','46b9e5c5e51410aad2bb');INSERT INTO "morango_instanceidmodel" VALUES('1036e82c35215e54a1ab6884ac6b4a19','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','236673309da682a88c0f');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);INSERT INTO "sqlite_sequence" VALUES('device_sqlitelock',1);INSERT INTO "sqlite_sequence" VALUES('content_contentnode_has_prerequisite',0);INSERT INTO "sqlite_sequence" VALUES('content_contentnode_related',0);INSERT INTO "sqlite_sequence" VALUES('content_contentnode_tags',0);INSERT INTO "sqlite_sequence" VALUES('content_channelmetadata_included_languages',1);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;