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

Delta Between Two Patch Sets: sitescripts/reports/schema.sql

Issue 8625042: Reports - user usefullness (Closed)
Left Patch Set: Reports - report update UI Created Oct. 18, 2012, 1:35 p.m.
Right Patch Set: Reports - user usefulness Created Oct. 29, 2012, 12:35 p.m.
Left:
Right:
Use n/p to move between diff chunks; N/P to move between comments.
Jump to:
Right: Side by side diff | Download
« no previous file with change/comment | « sitescripts/reports/bin/updateDigests.py ('k') | sitescripts/reports/static/lib/reportsview.js » ('j') | no next file with change/comment »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
LEFTRIGHT
(no file at all)
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=utf8;
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 `rating` int(11) NOT NULL DEFAULT '0', 14 `positive` int(10) unsigned NOT NULL DEFAULT '0',
15 `negative` int(10) unsigned NOT NULL DEFAULT '0',
15 PRIMARY KEY (`id`) 16 PRIMARY KEY (`id`)
16 ) DEFAULT CHARSET=utf8; 17 ) DEFAULT CHARSET=utf8;
17 /*!40101 SET character_set_client = @saved_cs_client */; 18 /*!40101 SET character_set_client = @saved_cs_client */;
18 /*!40101 SET @saved_cs_client = @@character_set_client */; 19 /*!40101 SET @saved_cs_client = @@character_set_client */;
19 /*!40101 SET character_set_client = utf8 */; 20 /*!40101 SET character_set_client = utf8 */;
20 CREATE TABLE `reports` ( 21 CREATE TABLE `reports` (
21 `guid` varchar(40) NOT NULL, 22 `guid` varchar(40) NOT NULL,
22 `type` varchar(30) DEFAULT NULL, 23 `type` varchar(30) DEFAULT NULL,
23 `ctime` datetime NOT NULL, 24 `ctime` datetime NOT NULL,
24 `site` varchar(150) DEFAULT NULL, 25 `site` varchar(150) DEFAULT NULL,
(...skipping 14 matching lines...) Expand all
39 CREATE TABLE `sublists` ( 40 CREATE TABLE `sublists` (
40 `report` varchar(40) NOT NULL, 41 `report` varchar(40) NOT NULL,
41 `list` int(10) unsigned NOT NULL, 42 `list` int(10) unsigned NOT NULL,
42 `hasmatches` tinyint(1) NOT NULL DEFAULT '0', 43 `hasmatches` tinyint(1) NOT NULL DEFAULT '0',
43 UNIQUE KEY `report_list` (`list`,`report`), 44 UNIQUE KEY `report_list` (`list`,`report`),
44 KEY `sublists_report` (`report`), 45 KEY `sublists_report` (`report`),
45 CONSTRAINT `sublists_report` FOREIGN KEY (`report`) REFERENCES `reports` (`gui d`) ON DELETE CASCADE ON UPDATE CASCADE, 46 CONSTRAINT `sublists_report` FOREIGN KEY (`report`) REFERENCES `reports` (`gui d`) ON DELETE CASCADE ON UPDATE CASCADE,
46 CONSTRAINT `sublists_list` FOREIGN KEY (`list`) REFERENCES `subscriptions` (`i d`) ON DELETE CASCADE ON UPDATE CASCADE 47 CONSTRAINT `sublists_list` FOREIGN KEY (`list`) REFERENCES `subscriptions` (`i d`) ON DELETE CASCADE ON UPDATE CASCADE
47 ) DEFAULT CHARSET=utf8; 48 ) DEFAULT CHARSET=utf8;
48 /*!40101 SET character_set_client = @saved_cs_client */; 49 /*!40101 SET character_set_client = @saved_cs_client */;
LEFTRIGHT

Powered by Google App Engine
This is Rietveld