sitescripts/filterhits/schema.sql - Issue 4615801646612480: Issue 395 - Filter hits statistics backend

Keyboard Shortcuts

	File
u :	up to issue
m :	publish + mail comments
M :	edit review message
j / k :	jump to file after / before current file
J / K :	jump to next file with a comment after / before current file
	Side-by-side diff
i :	toggle intra-line diffs
e :	expand all comments
c :	collapse all comments
s :	toggle showing all comments
n / p :	next / previous diff chunk or comment
N / P :	next / previous comment
<Up> / <Down> :	next / previous line
<Enter> :	respond to / edit current comment
d :	mark current comment as done

	Issue
u :	up to list of issues
m :	publish + mail comments
j / k :	jump to patch after / before current patch
o / <Enter> :	open current patch in side-by-side view
i :	open current patch in unified diff view

	Issue List
j / k :	jump to issue after / before current issue
o / <Enter> :	open current issue
# :	close issue

	Comment/message editing
<Ctrl> + s or <Ctrl> + Enter :	save comment
<Esc> :	cancel edit

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

LEFT	RIGHT
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 /;

LEFT	RIGHT