1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
content / test / data / first_party_sets / v1.sql [blame]
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS public_sets(
site TEXT NOT NULL,
primary_site TEXT NOT NULL,
site_type INTEGER NOT NULL,
PRIMARY KEY(site)
) WITHOUT ROWID;
CREATE TABLE IF NOT EXISTS policy_modifications (
browser_context_id TEXT NOT NULL,
site TEXT NOT NULL,
site_owner TEXT, -- May be NULL if this row represents a deletion.
PRIMARY KEY (browser_context_id, site)
) WITHOUT ROWID;
CREATE TABLE IF NOT EXISTS browser_context_sites_to_clear (
browser_context_id TEXT NOT NULL,
site TEXT NOT NULL,
marked_at_run Integer NOT NULL,
PRIMARY KEY (browser_context_id, site)
) WITHOUT ROWID;
CREATE INDEX idx_marked_at_run_sites ON browser_context_sites_to_clear (marked_at_run);
CREATE TABLE IF NOT EXISTS browser_contexts_cleared (
browser_context_id TEXT PRIMARY KEY NOT NULL,
cleared_at_run Integer NOT NULL
) WITHOUT ROWID;
CREATE INDEX idx_cleared_at_run_browser_contexts ON browser_contexts_cleared (cleared_at_run);
CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);
INSERT INTO meta VALUES('version','1');
INSERT INTO meta VALUES('last_compatible_version','1');
INSERT INTO meta VALUES('run_count','1');
INSERT INTO public_sets VALUES('https://aaa.test', 'https://bbb.test', 1),
('https://bbb.test', 'https://bbb.test', 0);
COMMIT;