sitescripts/filterhits/schema.sql - Issue 29344572: Noissue - Removed obsolete sitescripts.filterhits package

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 29344572: Noissue - Removed obsolete sitescripts.filterhits package (Closed)

Patch Set: Created May 26, 2016, 12:05 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 `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 /;

OLD	NEW