,'mil.ve'),(1378,'mil.za'),(1199,'mincom.tn'),(1247,'mk.ua'),(474,'mob.ki'),(457,'mobi.ke'),(688,'mobi.ng'),(899,'mobi.tt'),(1289,'mod.uk'),(1035,'mordovia.ru'),(1036,'mosreg.ru'),(1379,'mpm.school.za'),(504,'ms.kr'),(1037,'msk.ru'),(395,'muni.il'),(1038,'murmansk.ru'),(139,'mus.br'),(643,'museum.mv'),(655,'museum.mw'),(722,'museum.om'),(901,'museum.tt'),(1129,'n.se'),(1039,'nalchik.ru'),(14,'name.ae'),(253,'name.cy'),(294,'name.eg'),(318,'name.et'),(325,'name.fj'),(439,'name.jo'),(613,'name.mk'),(644,'name.mv'),(670,'name.my'),(687,'name.ng'),(791,'name.pr'),(1183,'name.tj'),(883,'name.tr'),(905,'name.tt'),(1340,'name.vn'),(1200,'nat.tn'),(1291,'national-library-scotland.uk'),(175,'nb.ca'),(1380,'ncape.school.za'),(448,'ne.jp'),(452,'ne.ke'),(496,'ne.kr'),(806,'ne.pw'),(1211,'ne.tz'),(1272,'ne.ug'),(1292,'nel.uk'),(2,'net.ac'),(7,'net.ae'),(18,'net.af'),(24,'net.al'),(39,'net.ar'),(47,'net.au'),(55,'net.ba'),(69,'net.bb'),(82,'net.bh'),(88,'net.bn'),(91,'net.bo'),(140,'net.br'),(163,'net.bs'),(170,'net.bz'),(190,'net.ck'),(199,'net.cn'),(237,'net.co'),(249,'net.cy'),(267,'net.do'),(273,'net.dz'),(281,'net.ec'),(295,'net.eg'),(302,'net.er'),(316,'net.et'),(326,'net.fj'),(334,'net.fk'),(344,'net.gg'),(355,'net.gn'),(358,'net.gr'),(364,'net.gt'),(370,'net.gu'),(378,'net.hk'),(382,'net.id'),(392,'net.il'),(400,'net.in'),(418,'net.iq'),(424,'net.ir'),(431,'net.je'),(434,'net.jo'),(464,'net.kh'),(469,'net.ki'),(490,'net.kn'),(526,'net.kw'),(531,'net.ky'),(538,'net.kz'),(543,'net.lb'),(547,'net.lk'),(563,'net.lr'),(570,'net.lv'),(574,'net.ly'),(583,'net.ma'),(592,'net.me'),(609,'net.mk'),(616,'net.ml'),(627,'net.mo'),(6g.lb'),(550,'org.lk'),(562,'org.lr'),(567,'org.lv'),(580,'org.ly'),(585,'org.ma'),(593,'org.me'),(599,'org.mg'),(608,'org.mk'),(617,'org.ml'),(623,'org.mn'),(628,'org.mo'),(630,'org.mt'),(922,'org.mu'),(646,'org.mv'),(657,'org.mw'),(660,'org.mx'),(665,'org.my'),(929,'org.mz'),(682,'org.ng'),(696,'org.ni'),(703,'org.np'),(711,'org.nr'),(944,'org.nz'),(720,'org.om'),(956,'org.pa'),(731,'org.pe'),(736,'org.ph'),(745,'org.pk'),(761,'org.pl'),(793,'org.pr'),(800,'org.ps'),(964,'org.pt'),(971,'org.py'),(977,'org.qa'),(817,'org.ro'),(823,'org.rs'),(1047,'org.ru'),(1104,'org.sa'),(831,'org.sb'),(837,'org.sc'),(1113,'org.sd'),(1131,'org.se'),(1150,'org.sg'),(840,'org.sh'),(847,'org.sl'),(1156,'org.sn'),(855,'org.st'),(865,'org.sv'),(1165,'org.sy'),(869,'org.sz'),(1186,'org.tj'),(1202,'org.tn'),(872,'org.tr'),(891,'org.tt'),(914,'org.tw'),(1252,'org.ua'),(1274,'org.ug'),(1298,'org.uk'),(1317,'org.uy'),(1325,'org.ve'),(1331,'org.vi'),(1342,'org.vn'),(1350,'org.ye'),(1356,'org.yu'),(1387,'org.za'),(1399,'org.zm'),(1299,'orgn.uk'),(1048,'oryol.ru'),(678,'other.nf'),(1132,'p.se'),(259,'parliament.cy'),(945,'parliament.nz'),(1300,'parliament.uk'),(1133,'parti.se'),(30,'pb.ao'),(182,'pe.ca'),(499,'pe.kr'),(1049,'penza.ru'),(459,'per.kh'),(679,'per.nf'),(1151,'per.sg'),(1050,'perm.ru'),(1157,'perso.sn'),(1203,'perso.tn'),(485,'pharmaciens.km'),(1388,'pix.za'),(1253,'pl.ua'),(576,'plc.ly'),(1302,'plc.uk'),(1351,'plc.ye'),(803,'plo.ps'),(277,'pol.dz'),(877,'pol.tr'),(1303,'police.uk'),(1254,'poltava.ua'),(772,'poznan.pl'),(1051,'pp.ru'),(1134,'pp.se'),(1255,'pp.ua'),(146,'ppg.br'),(339,'prd.fr'),(602,'prd.mg'),(258,'press.cy'),(587,'press.ma'),(1135,'press.se'),(340,'presse.fr'),(481,'presse.km'),(620,'presse.ml'),(852,'principe.st'),(598,'priv.me'),(13,'pro.ae'),(147,'pro.br'),(252,'pro.cy'),(284,'pro.ec'),(328,'pro.fj'),(614,'pro.mk'),(647,'pro.mv'),(724,'pro.om'),(794,'pro.pr'),(895,'pro.tt'),(1343,'pro.vn'),(796,'prof.pr'),(148,'psc.br'),(149,'psi.br'),(1052,'pskov.ru'),(1053,'ptz.ru'),(1105,'pub.sa'),(965,'publ.pt'),(755,'pwr.pl'),(183,'qc.ca'),(221,'qh.cn'),(150,'qsl.br'),(1136,'r.se'),(777,'radom.pl'),(498,'re.kr'),(151,'rec.br'),(680,'rec.nf'),(818,'rec.ro'),(866,'red.sv'),(406,'res.in'),(1054,'rnd.ru'),(1204,'rnrt.tn'),(1205,'rns.tn'),(1206,'rnu.tn'),(305,'rochest.er'),(1256,'rovno.ua'),(66,'rs.ba'),(1257,'rv.ua'),(1055,'ryazan.ru'),(1137,'s.se'),(246,'sa.cr'),(1056,'sakhalin.ru'),(1057,'samara.ru'),(851,'saotome.st'),(1058,'saratov.ru'),(222,'sc.cn'),(455,'sc.ke'),(506,'sc.kr'),(1275,'sc.ug'),(10,'sch.ae'),(385,'sch.id'),(426,'sch.ir'),(440,'sch.jo'),(546,'sch.lk'),(578,'sch.ly'),(668,'sch.my'),(686,'sch.ng'),(717,'sch.om'),(1106,'sch.sa'),(1304,'sch.uk'),(1400,'sch.zm'),(946,'school.nz'),(1389,'school.za'),(297,'sci.eg'),(1305,'scot.uk'),(223,'sd.cn'),(1258,'sebastopol.ua'),(804,'sec.ps'),(508,'seoul.kr'),(224,'sh.cn'),(1059,'simbirsk.ru'),(184,'sk.ca'),(265,'sld.do'),(957,'sld.pa'),(730,'sld.pe'),(152,'slg.br'),(776,'slupsk.pl'),(1060,'smolensk.ru'),(225,'sn.cn'),(553,'soc.lk'),(1306,'soc.uk'),(1061,'spb.ru'),(153,'srv.br'),(1062,'stavropol.ru'),(74,'store.bb'),(674,'store.nf'),(819,'store.ro'),(859,'store.st'),(1063,'stv.ru'),(1259,'sumy.ua'),(1064,'surgut.ru'),(226,'sx.cn'),(778,'szczecin.pl'),(1138,'t.se'),(1065,'tambov.ru'),(1066,'tatarstan.ru'),(1260,'te.ua'),(475,'tel.ki'),(887,'tel.tr'),(904,'tel.tt'),(1261,'ternopil.ua'),(1187,'test.tj'),(227,'tj.cn'),(255,'tm.cy'),(336,'tm.fr'),(482,'tm.km'),(589,'tm.mc'),(603,'tm.mg'),(820,'tm.ro'),(1139,'tm.se'),(1390,'tm.za'),(154,'tmp.br'),(1067,'tom.ru'),(1068,'tomsk.ru'),(782,'torun.pl'),(1207,'tourism.tn'),(900,'travel.tt'),(155,'trd.br'),(1069,'tsaritsyn.ru'),(1070,'tsk.ru'),(879,'tsk.tr'),(1071,'tula.ru'),(41,'tur.ar'),(156,'tur.br'),(1072,'tuva.ru'),(75,'tv.bb'),(93,'tv.bo'),(157,'tv.br'),(1114,'tv.sd'),(888,'tv.tr'),(1073,'tver.ru'),(228,'tw.cn'),(1074,'tyumen.ru'),(1140,'u.se'),(1075,'udm.ru'),(1076,'udmurtia.ru'),(1077,'ulan-ude.ru'),(514,'ulsan.kr'),(62,'unbi.ba'),(1158,'univ.sn'),(61,'unmo.ba'),(59,'unsa.ba'),(60,'untz.ba'),(63,'unze.ba'),(1262,'uzhgorod.ua'),(158,'vet.br'),(486,'veterinaire.km'),(1263,'vinnica.ua'),(1078,'vladikavkaz.ru'),(1079,'vladimir.ru'),(1080,'vladivostok.ru'),(159,'vlog.br'),(1264,'vn.ua'),(1081,'volgograd.ru'),(1082,'vologda.ru'),(1083,'voronezh.ru'),(1084,'vrn.ru'),(1085,'vyatka.ru'),(306,'w.er'),(1141,'w.se'),(388,'war.net.id'),(767,'warszawa.pl'),(766,'waw.pl'),(1391,'wcape.school.za'),(268,'web.do'),(384,'web.id'),(554,'web.lk'),(675,'web.nf'),(748,'web.pk'),(1188,'web.tj'),(886,'web.tr'),(1326,'web.ve'),(1392,'web.za'),(160,'wiki.br'),(768,'wroc.pl'),(769,'wroclaw.pl'),(821,'www.ro'),(1142,'x.se'),(229,'xj.cn'),(230,'xz.cn'),(1143,'y.se'),(1086,'yakutia.ru'),(1087,'yamal.ru'),(1088,'yekaterinburg.ru'),(185,'yk.ca'),(231,'yn.cn'),(1089,'yuzhno-sakhalinsk.ru'),(1144,'z.se'),(1265,'zaporizhzhe.ua'),(784,'zgora.pl'),(1266,'zhitomir.ua'),(232,'zj.cn'),(161,'zlg.br'),(1267,'zp.ua'),(1268,'zt.ua'); /*!40000 ALTER TABLE `core_blacklist` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_dnssec_banner` -- DROP TABLE IF EXISTS `core_dnssec_banner`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_dnssec_banner` ( `id` int NOT NULL, `core_dnssec_domain` int NOT NULL, `banner` varchar(255) NOT NULL, `datetime` bigint DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `core_dnssec_domain_1` (`core_dnssec_domain`,`banner`), CONSTRAINT `core_dnssec_banner_ibfk_1` FOREIGN KEY (`core_dnssec_domain`) REFERENCES `core_dnssec_domain` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_dnssec_banner` -- LOCK TABLES `core_dnssec_banner` WRITE; /*!40000 ALTER TABLE `core_dnssec_banner` DISABLE KEYS */; /*!40000 ALTER TABLE `core_dnssec_banner` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_dnssec_domain` -- DROP TABLE IF EXISTS `core_dnssec_domain`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_dnssec_domain` ( `id` int NOT NULL, `user` varchar(64) DEFAULT NULL, `domain` varchar(255) NOT NULL, `view` varchar(255) NOT NULL, `type` varchar(8) DEFAULT NULL, `status` varchar(16) DEFAULT NULL, `has_default_view` char(3) NOT NULL DEFAULT 'off', `has_nsec3` char(3) NOT NULL DEFAULT 'off', `published` char(3) NOT NULL DEFAULT 'on', `maxttl` int DEFAULT NULL, `update_time` bigint DEFAULT NULL, `original_file` varchar(255) DEFAULT NULL, `signed_file` varchar(255) DEFAULT NULL, `rollback` char(3) NOT NULL DEFAULT 'off', `skip` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `domain_1` (`domain`,`view`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_dnssec_domain` -- LOCK TABLES `core_dnssec_domain` WRITE; /*!40000 ALTER TABLE `core_dnssec_domain` DISABLE KEYS */; /*!40000 ALTER TABLE `core_dnssec_domain` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_dnssec_key` -- DROP TABLE IF EXISTS `core_dnssec_key`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_dnssec_key` ( `id` int NOT NULL, `core_dnssec_domain` int NOT NULL, `identifier` varchar(255) DEFAULT NULL, `type` char(3) DEFAULT NULL, `active` char(3) NOT NULL DEFAULT 'off', `next_key` char(3) NOT NULL DEFAULT 'off', `published` char(3) NOT NULL DEFAULT 'off', `key_tag` int DEFAULT NULL, `algorithm` int DEFAULT NULL, `size` int DEFAULT NULL, `period` int DEFAULT NULL, `publish_time` bigint DEFAULT NULL, `activate_time` bigint DEFAULT NULL, `revoke_time` bigint DEFAULT NULL, `inactive_time` bigint DEFAULT NULL, `delete_time` bigint DEFAULT NULL, PRIMARY KEY (`id`), KEY `core_dnssec_domain` (`core_dnssec_domain`), CONSTRAINT `core_dnssec_key_ibfk_1` FOREIGN KEY (`core_dnssec_domain`) REFERENCES `core_dnssec_domain` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_dnssec_key` -- LOCK TABLES `core_dnssec_key` WRITE; /*!40000 ALTER TABLE `core_dnssec_key` DISABLE KEYS */; /*!40000 ALTER TABLE `core_dnssec_key` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_dnssec_param` -- DROP TABLE IF EXISTS `core_dnssec_param`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_dnssec_param` ( `id` int NOT NULL, `user` varchar(64) NOT NULL, `type` char(3) NOT NULL, `algorithm` int DEFAULT NULL, `size` int DEFAULT NULL, `months` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_1` (`user`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_dnssec_param` -- LOCK TABLES `core_dnssec_param` WRITE; /*!40000 ALTER TABLE `core_dnssec_param` DISABLE KEYS */; /*!40000 ALTER TABLE `core_dnssec_param` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_dnssec_record` -- DROP TABLE IF EXISTS `core_dnssec_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_dnssec_record` ( `id` int NOT NULL, `core_dnssec_domain` int NOT NULL, `core_dnssec_key` int NOT NULL, `record_name` varchar(10) DEFAULT NULL, `key_tag` int DEFAULT NULL, `flags` int DEFAULT NULL, `protocol` int DEFAULT NULL, `algorithm` int DEFAULT NULL, `digest_type` int DEFAULT NULL, `data` mediumtext, PRIMARY KEY (`id`), KEY `core_dnssec_domain` (`core_dnssec_domain`), KEY `core_dnssec_key` (`core_dnssec_key`), CONSTRAINT `core_dnssec_record_ibfk_1` FOREIGN KEY (`core_dnssec_domain`) REFERENCES `core_dnssec_domain` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `core_dnssec_record_ibfk_2` FOREIGN KEY (`core_dnssec_key`) REFERENCES `core_dnssec_key` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_dnssec_record` -- LOCK TABLES `core_dnssec_record` WRITE; /*!40000 ALTER TABLE `core_dnssec_record` DISABLE KEYS */; /*!40000 ALTER TABLE `core_dnssec_record` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_funcs` -- DROP TABLE IF EXISTS `core_funcs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_funcs` ( `users` int NOT NULL, `name` varchar(255) NOT NULL, `access` int NOT NULL, PRIMARY KEY (`users`,`name`), CONSTRAINT `core_funcs_ibfk_1` FOREIGN KEY (`users`) REFERENCES `core_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_funcs` -- LOCK TABLES `core_funcs` WRITE; /*!40000 ALTER TABLE `core_funcs` DISABLE KEYS */; /*!40000 ALTER TABLE `core_funcs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_gdpr_doc` -- DROP TABLE IF EXISTS `core_gdpr_doc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_gdpr_doc` ( `id` int NOT NULL, `name` varchar(255) DEFAULT NULL, `type` int NOT NULL, `url` varchar(128) DEFAULT NULL, `desc_condition` varchar(256) DEFAULT NULL, `entry_date` date DEFAULT NULL, `change_date` date DEFAULT NULL, `locale` varchar(64) DEFAULT NULL, `need_agree` char(3) NOT NULL DEFAULT 'off', `show_after_auth` char(3) NOT NULL DEFAULT 'off', `show_in_warnings` char(3) NOT NULL DEFAULT 'off', `status` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `type` (`type`), CONSTRAINT `core_gdpr_doc_ibfk_1` FOREIGN KEY (`type`) REFERENCES `core_gdpr_doc_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_gdpr_doc` -- LOCK TABLES `core_gdpr_doc` WRITE; /*!40000 ALTER TABLE `core_gdpr_doc` DISABLE KEYS */; /*!40000 ALTER TABLE `core_gdpr_doc` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_gdpr_doc_type` -- DROP TABLE IF EXISTS `core_gdpr_doc_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_gdpr_doc_type` ( `id` int NOT NULL, `name` varchar(64) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `core_gdpr_doc_type` -- LOCK TABLES `core_gdpr_doc_type` WRITE; /*!40000 ALTER TABLE `core_gdpr_doc_type` DISABLE KEYS */; INSERT INTO `core_gdpr_doc_type` VALUES (1,'msg_doc_type_privacy_policy'),(2,'msg_doc_type_terms_of_use'); /*!40000 ALTER TABLE `core_gdpr_doc_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `core_gdpr_journal` -- DROP TABLE IF EXISTS `core_gdpr_journal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `core_gdpr_journal` ( `id` int NOT NULL, `action_object` int DEFAULT NULL, `username` varchar(128) DEFAULT NULL, `action_type` int DEFAULT NULL, `ip` varchar(64) DEFAULT NULL, `action_date` datetime DEFAULT NULL, `deleted_user` char(3) NOT NULL DEFAULT 'off', `delete_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `username_1` (`username`), KEY `action_object` (`action_object`), CONSTRAINT `core_gdpr_journal_ibfk_1` FOREIGN KEY (`action_object`) REFERENCES `core_gdpr_doc` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client