Side by Side Diff: sitescripts/reports/schema.sql
Issue 8625042:
Reports - user usefullness (Closed)
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.
« no previous file with comments
|
« sitescripts/reports/bin/updateDigests.py ('k')
|
sitescripts/reports/static/lib/reportsview.js » ('j')
|
no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
| 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=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 Loading... | |
| 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 */; |
| OLD | NEW |
« no previous file with comments
|
« sitescripts/reports/bin/updateDigests.py ('k')
|
sitescripts/reports/static/lib/reportsview.js » ('j')
|
no next file with comments »
