Side by Side Diff: sitescripts/filterhits/schema.sql
Issue 4615801646612480:
Issue 395 - Filter hits statistics backend (Closed)
Patch Set: Improvements regarding comments
Created Feb. 17, 2015, 10:50 a.m.
| Left: | ||
| Right: |
Use n/p to move between diff chunks;
N/P to move between comments.
« sitescripts/filterhits/geometrical_mean.py ('K')
|
« sitescripts/filterhits/geometrical_mean.py ('k')
|
sitescripts/filterhits/test/common_tests.py » ('j')
|
sitescripts/filterhits/web/query.py » ('J')
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 `filters` ( | 3 CREATE TABLE `filters` ( |
| 4 `md5` BINARY(16) NOT NULL, | 4 `sha1` BINARY(20) NOT NULL, |
| 5 `filter` TEXT CHARACTER SET utf8 NOT NULL, | 5 `filter` TEXT CHARACTER SET utf8 NOT NULL, |
| 6 PRIMARY KEY(md5) | 6 PRIMARY KEY(sha1) |
| 7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; | 7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 8 /*!40101 SET character_set_client = @saved_cs_client */; | |
| 9 | 8 |
| 10 /*!40101 SET @saved_cs_client = @@character_set_client */; | |
| 11 /*!40101 SET character_set_client = utf8 */; | |
| 12 CREATE TABLE `geometrical_mean` ( | 9 CREATE TABLE `geometrical_mean` ( |
| 13 `filter_md5` BINARY(16) NOT NULL, | 10 `filter_sha1` BINARY(20) NOT NULL, |
| 14 `domain` varchar(255) CHARACTER SET utf8 NOT NULL, | 11 `domain` varchar(255) CHARACTER SET utf8 NOT NULL, |
| 15 `hits` int(10) unsigned DEFAULT 0 NOT NULL, | 12 `hits` int(10) unsigned DEFAULT 0 NOT NULL, |
| 16 `timestamp` timestamp NOT NULL, | 13 `timestamp` timestamp NOT NULL, |
| 17 PRIMARY KEY(domain, filter_md5) | 14 PRIMARY KEY(domain, filter_sha1) |
| 18 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; | 15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 19 /*!40101 SET character_set_client = @saved_cs_client */; | 16 /*!40101 SET character_set_client = @saved_cs_client */; |
| OLD | NEW |
