Index: sitescripts/reports/schema.sql |
=================================================================== |
--- a/sitescripts/reports/schema.sql |
+++ b/sitescripts/reports/schema.sql |
@@ -4,7 +4,7 @@ |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
`url` varchar(255) NOT NULL, |
PRIMARY KEY (`id`) |
-) DEFAULT CHARSET=utf8; |
+) DEFAULT CHARSET=utf8mb4; |
/*!40101 SET character_set_client = @saved_cs_client */; |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
/*!40101 SET character_set_client = utf8 */; |
@@ -15,7 +15,7 @@ |
`negative` int(10) unsigned NOT NULL DEFAULT '0', |
`mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
PRIMARY KEY (`id`) |
-) DEFAULT CHARSET=utf8; |
+) DEFAULT CHARSET=utf8mb4; |
/*!40101 SET character_set_client = @saved_cs_client */; |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
/*!40101 SET character_set_client = utf8 */; |
@@ -34,7 +34,7 @@ |
KEY `reports_ctime` (`ctime`), |
KEY `reports_contract` (`contact`), |
CONSTRAINT `reports_contract` FOREIGN KEY (`contact`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE |
-) DEFAULT CHARSET=utf8; |
+) DEFAULT CHARSET=utf8mb4; |
/*!40101 SET character_set_client = @saved_cs_client */; |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
/*!40101 SET character_set_client = utf8 */; |
@@ -46,5 +46,5 @@ |
KEY `sublists_report` (`report`), |
CONSTRAINT `sublists_report` FOREIGN KEY (`report`) REFERENCES `reports` (`guid`) ON DELETE CASCADE ON UPDATE CASCADE, |
CONSTRAINT `sublists_list` FOREIGN KEY (`list`) REFERENCES `subscriptions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
-) DEFAULT CHARSET=utf8; |
+) DEFAULT CHARSET=utf8mb4; |
/*!40101 SET character_set_client = @saved_cs_client */; |