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.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','1');
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;