Side by Side Diff: sitescripts/filterhits/schema.sql
Issue 4615801646612480:
Issue 395 - Filter hits statistics backend (Closed)
Patch Set: Make sure the temporary log directory is recreated for each test.
Created March 30, 2015, 7:26 p.m.
| Left: | ||
| Right: |
Use n/p to move between diff chunks;
N/P to move between comments.
« sitescripts/filterhits/db.py ('K')
|
« sitescripts/filterhits/geometrical_mean.py ('k')
|
sitescripts/filterhits/static/datatables/jquery.js » ('j')
|
sitescripts/filterhits/test/log_tests.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 |
|---|---|
| (Empty) | |
| 1 /*!40101 SET @saved_cs_client = @@character_set_client */; | |
| 2 /*!40101 SET character_set_client = utf8 */; | |
| 3 CREATE TABLE `filters` ( | |
| 4 `sha1` BINARY(20) NOT NULL, | |
| 5 `filter` TEXT CHARACTER SET utf8 NOT NULL, | |
| 6 PRIMARY KEY(sha1) | |
| 7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; | |
| 8 | |
| 9 CREATE TABLE `frequencies` ( | |
| 10 `filter_sha1` BINARY(20) NOT NULL, | |
| 11 `domain` varchar(255) CHARACTER SET utf8 NOT NULL, | |
| 12 `frequency` int(10) unsigned DEFAULT 0 NOT NULL, | |
| 13 `timestamp` timestamp NOT NULL, | |
| 14 PRIMARY KEY(domain, filter_sha1) | |
| 15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; | |
| 16 /*!40101 SET character_set_client = @saved_cs_client */; | |
| OLD | NEW |
