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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
PRAGMA foreign_keys = OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS bounces(
site TEXT PRIMARY KEY NOT NULL,
first_site_storage_time INTEGER DEFAULT NULL,
last_site_storage_time INTEGER DEFAULT NULL,
first_user_interaction_time INTEGER DEFAULT NULL,
last_user_interaction_time INTEGER DEFAULT NULL,
first_stateful_bounce_time INTEGER DEFAULT NULL,
last_stateful_bounce_time INTEGER DEFAULT NULL,
first_bounce_time INTEGER DEFAULT NULL,
last_bounce_time INTEGER DEFAULT NULL,
first_web_authn_assertion_time INTEGER DEFAULT NULL,
last_web_authn_assertion_time INTEGER DEFAULT NULL
);
CREATE TABLE IF NOT EXISTS popups(
opener_site TEXT NOT NULL,
popup_site TEXT NOT NULL,
access_id INTEGER DEFAULT NULL,
last_popup_time INTEGER DEFAULT NULL,
PRIMARY KEY (opener_site, popup_site)
);
CREATE TABLE meta(
key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,
value LONGVARCHAR
);
INSERT INTO
meta
VALUES
('version', '4');
INSERT INTO
meta
VALUES
('last_compatible_version', '4');
INSERT INTO
meta
VALUES
('prepopulated', '1');
INSERT INTO
bounces
VALUES
('storage.test', 1, 1, 4, 4, NULL, NULL, NULL, NULL, NULL, NULL),
('stateful-bounce.test', NULL, NULL, 4, 4, 1, 1, NULL, NULL, NULL, NULL),
('stateless-bounce.test', NULL, NULL, 4, 4, NULL, NULL, 1, 1, NULL, NULL),
('both-bounce-kinds.test', NULL, NULL, 4, 4, 1, 4, 2, 6, NULL, NULL);
INSERT INTO
popups
VALUES
('site1.com', '3p-site.com', 123, '2023-10-01 12:00:00'),
('site2.com', '3p-site.com', 456, '2023-10-02 12:00:00');
COMMIT;
|
