Unified Diff: sitescripts/filterhits/schema.sql
Issue 4615801646612480:
Issue 395 - Filter hits statistics backend (Closed)
Patch Set: Addressed Sebastian's and Wladimir's comments.
Created March 27, 2015, 3:08 p.m.
Use n/p to move between diff chunks;
N/P to move between comments.
« sitescripts/filterhits/common.py ('K')
|
« sitescripts/filterhits/geometrical_mean.py ('k')
|
sitescripts/filterhits/static/datatables/jquery.js » ('j')
|
sitescripts/filterhits/static/query.html » ('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..4bc565fc23e8dc54cdaa59bb73ca87db8782f03c |
| --- /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, |
| + `hits` 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 */; |
