Unified 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.
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')
Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')
| Index: sitescripts/filterhits/schema.sql |
| diff --git a/sitescripts/filterhits/schema.sql b/sitescripts/filterhits/schema.sql |
| new file mode 100644 |
| index 0000000000000000000000000000000000000000..eba694440b3e0b9ef58293dc4423606234910d0c |
| --- /dev/null |
| +++ b/sitescripts/filterhits/schema.sql |
| @@ -0,0 +1,16 @@ |
| +/*!40101 SET @saved_cs_client = @@character_set_client */; |
| +/*!40101 SET character_set_client = utf8 */; |
| +CREATE TABLE `filters` ( |
| + `sha1` BINARY(20) NOT NULL, |
| + `filter` TEXT CHARACTER SET utf8 NOT NULL, |
| + PRIMARY KEY(sha1) |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| + |
| +CREATE TABLE `frequencies` ( |
| + `filter_sha1` BINARY(20) NOT NULL, |
| + `domain` varchar(255) CHARACTER SET utf8 NOT NULL, |
| + `frequency` int(10) unsigned DEFAULT 0 NOT NULL, |
| + `timestamp` timestamp NOT NULL, |
| + PRIMARY KEY(domain, filter_sha1) |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| +/*!40101 SET character_set_client = @saved_cs_client */; |
