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
|
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
-- For the schemas to be identical, extra whitespace is needed to match the code
CREATE TABLE urls( url_id INTEGER PRIMARY KEY NOT NULL, url TEXT NOT NULL, fetch_time INTEGER NOT NULL, expiry_time INTEGER NOT NULL);
CREATE UNIQUE INDEX urls_by_url_idx ON urls(url);
CREATE INDEX fetch_time_idx ON urls(fetch_time);
CREATE INDEX expiry_time_idx ON urls(expiry_time);
CREATE TABLE keys( url_id INTEGER NOT NULL, key_id TEXT NOT NULL, key BLOB NOT NULL, PRIMARY KEY(url_id, key_id)) WITHOUT ROWID;
CREATE TABLE report_requests(request_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,report_time INTEGER NOT NULL,creation_time INTEGER NOT NULL,reporting_origin TEXT NOT NULL,request_proto BLOB NOT NULL);
CREATE INDEX report_time_idx ON report_requests(report_time);
CREATE INDEX creation_time_idx ON report_requests(creation_time);
CREATE INDEX reporting_origin_idx ON report_requests(reporting_origin);
CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);
INSERT INTO meta VALUES('mmap_status','-1');
INSERT INTO meta VALUES('version','3');
INSERT INTO meta VALUES('last_compatible_version','3');
INSERT INTO urls(url, fetch_time, expiry_time) VALUES ('https://url.example/path',13306020080123456,13306624880123456);
INSERT INTO keys(url_id, key_id, key) VALUES (1,'example-key-id',x'1632cfa71abbbc7f8784371967830757005b55c4400160618a07f28f0086bd05');
INSERT INTO report_requests(report_time,creation_time,reporting_origin,request_proto) VALUES(13306023680123456,13306020080123456,'https://reporting.example',x'1234');
COMMIT;
|
