Unified 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.
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')
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 |
| index f5a3222e952668251e60a387fb0c75ee83163ec8..48967ef8290372fcb9d8714b3860aa7f1e61f4fb 100644 |
| --- a/sitescripts/filterhits/schema.sql |
| +++ b/sitescripts/filterhits/schema.sql |
| @@ -1,19 +1,16 @@ |
| /*!40101 SET @saved_cs_client = @@character_set_client */; |
| /*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `filters` ( |
| - `md5` BINARY(16) NOT NULL, |
| + `sha1` BINARY(20) NOT NULL, |
| `filter` TEXT CHARACTER SET utf8 NOT NULL, |
| - PRIMARY KEY(md5) |
| + PRIMARY KEY(sha1) |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| -/*!40101 SET character_set_client = @saved_cs_client */; |
| -/*!40101 SET @saved_cs_client = @@character_set_client */; |
| -/*!40101 SET character_set_client = utf8 */; |
| CREATE TABLE `geometrical_mean` ( |
| - `filter_md5` BINARY(16) NOT NULL, |
| + `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_md5) |
| + PRIMARY KEY(domain, filter_sha1) |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| /*!40101 SET character_set_client = @saved_cs_client */; |
