Rietveld Code Review Tool
Help | Bug tracker | Discussion group | Source code

Side by Side Diff: sitescripts/filterhits/schema.sql

Issue 4615801646612480: Issue 395 - Filter hits statistics backend (Closed)
Patch Set: Addressed further comments from Sebastian. Created April 2, 2015, 10:13 a.m.
Left:
Right:
Use n/p to move between diff chunks; N/P to move between comments.
Jump to:
View unified diff | Download patch
OLDNEW
(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 */;
OLDNEW
« no previous file with comments | « sitescripts/filterhits/geometrical_mean.py ('k') | sitescripts/filterhits/static/datatables/jquery.js » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld