blob: 44055b2254ac303f589aec82047a876874fb619b [file] [log] [blame]
INSERT OR REPLACE INTO meta (key, value)
VALUES ("version", 2), ("last_compatible_version", 1);
CREATE TABLE IF NOT EXISTS categories (
category_id INTEGER PRIMARY KEY AUTOINCREMENT,
version_token TEXT NOT NULL,
type INTEGER NOT NULL,
label TEXT NOT NULL,
image BLOB,
ntp_click_count INTEGER NOT NULL DEFAULT 0,
esp_site_click_count INTEGER NOT NULL DEFAULT 0,
ntp_shown_count INTEGER NOT NULL DEFAULT 0);
INSERT INTO categories
(version_token,
type,
label,
ntp_shown_count)
VALUES ('versionToken', 3, 'category1', 3);
CREATE TABLE IF NOT EXISTS sites (
site_id INTEGER PRIMARY KEY AUTOINCREMENT,
url TEXT NOT NULL,
category_id INTEGER NOT NULL,
title TEXT NOT NULL,
favicon BLOB,
click_count INTEGER NOT NULL DEFAULT 0,
removed BOOLEAN NOT NULL default FALSE);
INSERT INTO sites
(url, category_id, title)
VALUES ('http://www.google.com', 1, 'site1');
CREATE TABLE IF NOT EXISTS activity (
time INTEGER NOT NULL,
category_type INTEGER NOT NULL,
url TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS site_blacklist (
url TEXT NOT NULL UNIQUE,
date_removed INTEGER NOT NULL);