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

Delta Between Two Patch Sets: sitescripts/filterhits/schema.sql

Issue 4615801646612480: Issue 395 - Filter hits statistics backend (Closed)
Left Patch Set: Simplified geometrical_mean code and reduced filter inserts. Created March 16, 2015, 4:24 p.m.
Right 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:
Left: Side by side diff | Download
Right: Side by side diff | Download
« no previous file with change/comment | « sitescripts/filterhits/geometrical_mean.py ('k') | sitescripts/filterhits/static/datatables/jquery.js » ('j') | no next file with change/comment »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
LEFTRIGHT
1 /*!40101 SET @saved_cs_client = @@character_set_client */; 1 /*!40101 SET @saved_cs_client = @@character_set_client */;
2 /*!40101 SET character_set_client = utf8 */; 2 /*!40101 SET character_set_client = utf8 */;
3 CREATE TABLE `filters` ( 3 CREATE TABLE `filters` (
4 `sha1` BINARY(20) NOT NULL, 4 `sha1` BINARY(20) NOT NULL,
5 `filter` TEXT CHARACTER SET utf8 NOT NULL, 5 `filter` TEXT CHARACTER SET utf8 NOT NULL,
6 PRIMARY KEY(sha1) 6 PRIMARY KEY(sha1)
7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
8 8
9 CREATE TABLE `geometrical_mean` ( 9 CREATE TABLE `frequencies` (
10 `filter_sha1` BINARY(20) NOT NULL, 10 `filter_sha1` BINARY(20) NOT NULL,
11 `domain` varchar(255) CHARACTER SET utf8 NOT NULL, 11 `domain` varchar(255) CHARACTER SET utf8 NOT NULL,
12 `hits` int(10) unsigned DEFAULT 0 NOT NULL, 12 `frequency` int(10) unsigned DEFAULT 0 NOT NULL,
13 `timestamp` timestamp NOT NULL, 13 `timestamp` timestamp NOT NULL,
14 PRIMARY KEY(domain, filter_sha1) 14 PRIMARY KEY(domain, filter_sha1)
15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
16 /*!40101 SET character_set_client = @saved_cs_client */; 16 /*!40101 SET character_set_client = @saved_cs_client */;
LEFTRIGHT

Powered by Google App Engine
This is Rietveld