| OLD | NEW |
| 1 /*!40101 SET @saved_cs_client = @@character_set_client */; | 1 /*!40101 SET @saved_cs_client = @@character_set_client */; |
| 2 /*!40101 SET character_set_client = utf8 */; | 2 /*!40101 SET character_set_client = utf8 */; |
| 3 CREATE TABLE `subscriptions` ( | 3 CREATE TABLE `subscriptions` ( |
| 4 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | 4 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
| 5 `url` varchar(255) NOT NULL, | 5 `url` varchar(255) NOT NULL, |
| 6 PRIMARY KEY (`id`) | 6 PRIMARY KEY (`id`) |
| 7 ) DEFAULT CHARSET=utf8; | 7 ) DEFAULT CHARSET=utf8mb4; |
| 8 /*!40101 SET character_set_client = @saved_cs_client */; | 8 /*!40101 SET character_set_client = @saved_cs_client */; |
| 9 /*!40101 SET @saved_cs_client = @@character_set_client */; | 9 /*!40101 SET @saved_cs_client = @@character_set_client */; |
| 10 /*!40101 SET character_set_client = utf8 */; | 10 /*!40101 SET character_set_client = utf8 */; |
| 11 CREATE TABLE `users` ( | 11 CREATE TABLE `users` ( |
| 12 `id` varchar(40) NOT NULL, | 12 `id` varchar(40) NOT NULL, |
| 13 `reports` int(10) unsigned NOT NULL DEFAULT '0', | 13 `reports` int(10) unsigned NOT NULL DEFAULT '0', |
| 14 `positive` int(10) unsigned NOT NULL DEFAULT '0', | 14 `positive` int(10) unsigned NOT NULL DEFAULT '0', |
| 15 `negative` int(10) unsigned NOT NULL DEFAULT '0', | 15 `negative` int(10) unsigned NOT NULL DEFAULT '0', |
| 16 `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTA
MP, | 16 `mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTA
MP, |
| 17 PRIMARY KEY (`id`) | 17 PRIMARY KEY (`id`) |
| 18 ) DEFAULT CHARSET=utf8; | 18 ) DEFAULT CHARSET=utf8mb4; |
| 19 /*!40101 SET character_set_client = @saved_cs_client */; | 19 /*!40101 SET character_set_client = @saved_cs_client */; |
| 20 /*!40101 SET @saved_cs_client = @@character_set_client */; | 20 /*!40101 SET @saved_cs_client = @@character_set_client */; |
| 21 /*!40101 SET character_set_client = utf8 */; | 21 /*!40101 SET character_set_client = utf8 */; |
| 22 CREATE TABLE `reports` ( | 22 CREATE TABLE `reports` ( |
| 23 `guid` varchar(40) NOT NULL, | 23 `guid` varchar(40) NOT NULL, |
| 24 `type` varchar(30) DEFAULT NULL, | 24 `type` varchar(30) DEFAULT NULL, |
| 25 `ctime` datetime NOT NULL, | 25 `ctime` datetime NOT NULL, |
| 26 `site` varchar(150) DEFAULT NULL, | 26 `site` varchar(150) DEFAULT NULL, |
| 27 `status` text, | 27 `status` text, |
| 28 `comment` text, | 28 `comment` text, |
| 29 `contact` varchar(40) DEFAULT NULL, | 29 `contact` varchar(40) DEFAULT NULL, |
| 30 `hasscreenshot` tinyint(1) NOT NULL DEFAULT '0', | 30 `hasscreenshot` tinyint(1) NOT NULL DEFAULT '0', |
| 31 `knownissues` int(10) unsigned NOT NULL DEFAULT '0', | 31 `knownissues` int(10) unsigned NOT NULL DEFAULT '0', |
| 32 `dump` mediumblob, | 32 `dump` mediumblob, |
| 33 PRIMARY KEY (`guid`), | 33 PRIMARY KEY (`guid`), |
| 34 KEY `reports_ctime` (`ctime`), | 34 KEY `reports_ctime` (`ctime`), |
| 35 KEY `reports_contract` (`contact`), | 35 KEY `reports_contract` (`contact`), |
| 36 CONSTRAINT `reports_contract` FOREIGN KEY (`contact`) REFERENCES `users` (`id`
) ON DELETE SET NULL ON UPDATE CASCADE | 36 CONSTRAINT `reports_contract` FOREIGN KEY (`contact`) REFERENCES `users` (`id`
) ON DELETE SET NULL ON UPDATE CASCADE |
| 37 ) DEFAULT CHARSET=utf8; | 37 ) DEFAULT CHARSET=utf8mb4; |
| 38 /*!40101 SET character_set_client = @saved_cs_client */; | 38 /*!40101 SET character_set_client = @saved_cs_client */; |
| 39 /*!40101 SET @saved_cs_client = @@character_set_client */; | 39 /*!40101 SET @saved_cs_client = @@character_set_client */; |
| 40 /*!40101 SET character_set_client = utf8 */; | 40 /*!40101 SET character_set_client = utf8 */; |
| 41 CREATE TABLE `sublists` ( | 41 CREATE TABLE `sublists` ( |
| 42 `report` varchar(40) NOT NULL, | 42 `report` varchar(40) NOT NULL, |
| 43 `list` int(10) unsigned NOT NULL, | 43 `list` int(10) unsigned NOT NULL, |
| 44 `hasmatches` tinyint(1) NOT NULL DEFAULT '0', | 44 `hasmatches` tinyint(1) NOT NULL DEFAULT '0', |
| 45 UNIQUE KEY `report_list` (`list`,`report`), | 45 UNIQUE KEY `report_list` (`list`,`report`), |
| 46 KEY `sublists_report` (`report`), | 46 KEY `sublists_report` (`report`), |
| 47 CONSTRAINT `sublists_report` FOREIGN KEY (`report`) REFERENCES `reports` (`gui
d`) ON DELETE CASCADE ON UPDATE CASCADE, | 47 CONSTRAINT `sublists_report` FOREIGN KEY (`report`) REFERENCES `reports` (`gui
d`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 48 CONSTRAINT `sublists_list` FOREIGN KEY (`list`) REFERENCES `subscriptions` (`i
d`) ON DELETE CASCADE ON UPDATE CASCADE | 48 CONSTRAINT `sublists_list` FOREIGN KEY (`list`) REFERENCES `subscriptions` (`i
d`) ON DELETE CASCADE ON UPDATE CASCADE |
| 49 ) DEFAULT CHARSET=utf8; | 49 ) DEFAULT CHARSET=utf8mb4; |
| 50 /*!40101 SET character_set_client = @saved_cs_client */; | 50 /*!40101 SET character_set_client = @saved_cs_client */; |
| OLD | NEW |