Rietveld Code Review Tool
Help | Bug tracker | Discussion group | Source code

Side by Side Diff: sitescripts/reports/schema.sql

Issue 29977625: Issue 7196 - Delegate to centralized flake8 configuration (sitescripts/abpssembly)
Patch Set: Created Jan. 10, 2019, 12:55 a.m.
Left:
Right:
Use n/p to move between diff chunks; N/P to move between comments.
Jump to:
View unified diff | Download patch
« no previous file with comments | « no previous file | sitescripts/reports/utils.py » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
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 */;
OLDNEW
« no previous file with comments | « no previous file | sitescripts/reports/utils.py » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld