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

Side by Side Diff

Use n/p to move between diff chunks; N/P to move between comments.

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

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

Issue 4615801646612480: Issue 395 - Filter hits statistics backend (Closed)

Patch Set: Addressed comments. Created Feb. 24, 2015, 5:59 p.m.

Left:
Right:

Use n/p to move between diff chunks; N/P to move between comments.

Jump to:

OLD	NEW
(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 `geometrical_mean` (

	10 `filter_sha1` BINARY(20) NOT NULL,

	11 `domain` varchar(255) CHARACTER SET utf8 NOT NULL,

	12 `hits` 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 /;

OLD	NEW