| OLD | NEW |
| (Empty) |
| 1 PRAGMA foreign_keys=OFF; | |
| 2 BEGIN TRANSACTION; | |
| 3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR
); | |
| 4 INSERT INTO "meta" VALUES('last_compatible_version','16'); | |
| 5 INSERT INTO "meta" VALUES('version','26'); | |
| 6 INSERT INTO "meta" VALUES('early_expiration_threshold','12995946566765618'); | |
| 7 CREATE TABLE urls(id INTEGER PRIMARY KEY,url LONGVARCHAR,title LONGVARCHAR,visit
_count INTEGER DEFAULT 0 NOT NULL,typed_count INTEGER DEFAULT 0 NOT NULL,last_vi
sit_time INTEGER NOT NULL,hidden INTEGER DEFAULT 0 NOT NULL,favicon_id INTEGER D
EFAULT 0 NOT NULL); | |
| 8 CREATE TABLE visits(id INTEGER PRIMARY KEY,url INTEGER NOT NULL,visit_time INTEG
ER NOT NULL,from_visit INTEGER,transition INTEGER DEFAULT 0 NOT NULL,segment_id
INTEGER,is_indexed BOOLEAN,visit_duration INTEGER DEFAULT 0 NOT NULL); | |
| 9 CREATE TABLE visit_source(id INTEGER PRIMARY KEY,source INTEGER NOT NULL); | |
| 10 CREATE TABLE keyword_search_terms (keyword_id INTEGER NOT NULL,url_id INTEGER NO
T NULL,lower_term LONGVARCHAR NOT NULL,term LONGVARCHAR NOT NULL); | |
| 11 CREATE TABLE downloads (id INTEGER PRIMARY KEY,current_path LONGVARCHAR NOT NULL
,target_path LONGVARCHAR NOT NULL,start_time INTEGER NOT NULL,received_bytes INT
EGER NOT NULL,total_bytes INTEGER NOT NULL,state INTEGER NOT NULL,danger_type IN
TEGER NOT NULL,interrupt_reason INTEGER NOT NULL,end_time INTEGER NOT NULL,opene
d INTEGER NOT NULL,referrer VARCHAR NOT NULL); | |
| 12 CREATE TABLE downloads_url_chains (id INTEGER NOT NULL,chain_index INTEGER NOT N
ULL,url LONGVARCHAR NOT NULL,PRIMARY KEY (id, chain_index) ); | |
| 13 CREATE TABLE segments (id INTEGER PRIMARY KEY,name VARCHAR,url_id INTEGER NON NU
LL); | |
| 14 CREATE TABLE segment_usage (id INTEGER PRIMARY KEY,segment_id INTEGER NOT NULL,t
ime_slot INTEGER NOT NULL,visit_count INTEGER DEFAULT 0 NOT NULL); | |
| 15 CREATE INDEX visits_url_index ON visits (url); | |
| 16 CREATE INDEX visits_from_index ON visits (from_visit); | |
| 17 CREATE INDEX visits_time_index ON visits (visit_time); | |
| 18 CREATE INDEX segments_name ON segments(name); | |
| 19 CREATE INDEX segments_url_id ON segments(url_id); | |
| 20 CREATE INDEX segment_usage_time_slot_segment_id ON segment_usage(time_slot, segm
ent_id); | |
| 21 CREATE INDEX segments_usage_seg_id ON segment_usage(segment_id); | |
| 22 CREATE INDEX urls_url_index ON urls (url); | |
| 23 CREATE INDEX keyword_search_terms_index1 ON keyword_search_terms (keyword_id, lo
wer_term); | |
| 24 CREATE INDEX keyword_search_terms_index2 ON keyword_search_terms (url_id); | |
| 25 CREATE INDEX keyword_search_terms_index3 ON keyword_search_terms (term); | |
| 26 COMMIT; | |
| OLD | NEW |