OLD | NEW |
| 1 PRAGMA foreign_keys=OFF; |
1 BEGIN TRANSACTION; | 2 BEGIN TRANSACTION; |
2 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,value LONGVARCHAR)
; | 3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR
); |
3 INSERT INTO "meta" VALUES('version','19'); | |
4 INSERT INTO "meta" VALUES('last_compatible_version','16'); | 4 INSERT INTO "meta" VALUES('last_compatible_version','16'); |
| 5 INSERT INTO "meta" VALUES('version','22'); |
| 6 INSERT INTO "meta" VALUES('next_download_id','2'); |
| 7 INSERT INTO "meta" VALUES('early_expiration_threshold','12995946566765618'); |
5 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 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); |
6 INSERT INTO "urls" VALUES(1,'http://google.com/','Google',1,1,$1,0,1); | 9 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); |
7 INSERT INTO "urls" VALUES(2,'http://www.google.com/','Google',1,0,$1,0,1); | |
8 INSERT INTO "urls" VALUES(3,'http://www.google.com/blank.html','',1,0,$1,1,0); | |
9 INSERT INTO "urls" VALUES(4,'http://yahoo.com/','Yahoo!',1,1,$1,0,2); | |
10 INSERT INTO "urls" VALUES(5,'http://www.yahoo.com/','Yahoo!',1,0,$1,0,2); | |
11 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); | |
12 INSERT INTO "visits" VALUES(1,1,$2,0,268435457,1,0); | |
13 INSERT INTO "visits" VALUES(2,2,$2,1,2684354561,0,1); | |
14 INSERT INTO "visits" VALUES(3,3,$2,0,805306371,0,0); | |
15 INSERT INTO "visits" VALUES(4,4,$2,0,268435457,2,0); | |
16 INSERT INTO "visits" VALUES(5,5,$2,4,2684354561,0,1); | |
17 CREATE TABLE visit_source(id INTEGER PRIMARY KEY,source INTEGER NOT NULL); | 10 CREATE TABLE visit_source(id INTEGER PRIMARY KEY,source INTEGER NOT NULL); |
18 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 keyword_search_terms (keyword_id INTEGER NOT NULL,url_id INTEGER NO
T NULL,lower_term LONGVARCHAR NOT NULL,term LONGVARCHAR NOT NULL); |
19 CREATE TABLE downloads (id INTEGER PRIMARY KEY,full_path LONGVARCHAR NOT NULL,ur
l LONGVARCHAR NOT NULL,start_time INTEGER NOT NULL,received_bytes INTEGER NOT NU
LL,total_bytes INTEGER NOT NULL,state INTEGER NOT NULL); | 12 CREATE TABLE downloads (id INTEGER PRIMARY KEY,full_path LONGVARCHAR NOT NULL,ur
l LONGVARCHAR NOT NULL,start_time INTEGER NOT NULL,received_bytes INTEGER NOT NU
LL,total_bytes INTEGER NOT NULL,state INTEGER NOT NULL,end_time INTEGER NOT NULL
,opened INTEGER NOT NULL); |
20 CREATE TABLE segments (id INTEGER PRIMARY KEY,name VARCHAR,url_id INTEGER NON NU
LL,pres_index INTEGER DEFAULT -1 NOT NULL); | 13 CREATE TABLE segments (id INTEGER PRIMARY KEY,name VARCHAR,url_id INTEGER NON NU
LL,pres_index INTEGER DEFAULT -1 NOT NULL); |
21 INSERT INTO "segments" VALUES(1,'http://google.com/',1,-1); | |
22 INSERT INTO "segments" VALUES(2,'http://yahoo.com/',4,-1); | |
23 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); | 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); |
24 INSERT INTO "segment_usage" VALUES(1,1,$3,1); | |
25 INSERT INTO "segment_usage" VALUES(2,2,$3,1); | |
26 CREATE TABLE presentation(url_id INTEGER PRIMARY KEY,pres_index INTEGER NOT NULL
); | 15 CREATE TABLE presentation(url_id INTEGER PRIMARY KEY,pres_index INTEGER NOT NULL
); |
27 CREATE INDEX visits_url_index ON visits (url); | 16 CREATE INDEX visits_url_index ON visits (url); |
28 CREATE INDEX visits_from_index ON visits (from_visit); | 17 CREATE INDEX visits_from_index ON visits (from_visit); |
29 CREATE INDEX visits_time_index ON visits (visit_time); | 18 CREATE INDEX visits_time_index ON visits (visit_time); |
30 CREATE INDEX keyword_search_terms_index1 ON keyword_search_terms (keyword_id, lo
wer_term); | |
31 CREATE INDEX keyword_search_terms_index2 ON keyword_search_terms (url_id); | |
32 CREATE INDEX segments_name ON segments(name); | 19 CREATE INDEX segments_name ON segments(name); |
33 CREATE INDEX segments_url_id ON segments(url_id); | 20 CREATE INDEX segments_url_id ON segments(url_id); |
34 CREATE INDEX segment_usage_time_slot_segment_id ON segment_usage(time_slot, segm
ent_id); | 21 CREATE INDEX segment_usage_time_slot_segment_id ON segment_usage(time_slot, segm
ent_id); |
35 CREATE INDEX segments_usage_seg_id ON segment_usage(segment_id); | 22 CREATE INDEX segments_usage_seg_id ON segment_usage(segment_id); |
36 CREATE INDEX urls_url_index ON urls (url); | 23 CREATE INDEX urls_url_index ON urls (url); |
37 CREATE INDEX urls_favicon_id_INDEX ON urls (favicon_id); | 24 CREATE INDEX keyword_search_terms_index1 ON keyword_search_terms (keyword_id, lo
wer_term); |
| 25 CREATE INDEX keyword_search_terms_index2 ON keyword_search_terms (url_id); |
| 26 CREATE INDEX keyword_search_terms_index3 ON keyword_search_terms (term); |
38 COMMIT; | 27 COMMIT; |
OLD | NEW |