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
content / test / data / browsing_topics / v1.init_too_new.sql [blame]
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE browsing_topics_api_usages (
hashed_context_domain INTEGER NOT NULL,
hashed_main_frame_host INTEGER NOT NULL,
last_usage_time INTEGER NOT NULL,
PRIMARY KEY (hashed_context_domain, hashed_main_frame_host));
CREATE INDEX last_usage_time_idx ON browsing_topics_api_usages(last_usage_time);
CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);
INSERT INTO meta VALUES('version','2');
INSERT INTO meta VALUES('last_compatible_version','1');
INSERT INTO browsing_topics_api_usages VALUES (111, 222, 333);
CREATE TABLE browsing_topics_api_hashed_to_unhashed_domain(
hashed_context_domain INTEGER NOT NULL,
context_domain TEXT NOT NULL,
PRIMARY KEY (hashed_context_domain));
INSERT INTO browsing_topics_api_hashed_to_unhashed_domain VALUES (111, '111.com');
COMMIT;