OLD | NEW |
---|---|
1 PRAGMA foreign_keys=OFF; | 1 PRAGMA foreign_keys=OFF; |
2 BEGIN TRANSACTION; | 2 BEGIN TRANSACTION; |
3 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 ); |
4 INSERT INTO "meta" VALUES('version','27'); | 4 INSERT INTO "meta" VALUES('version','28'); |
5 INSERT INTO "meta" VALUES('last_compatible_version','16'); | 5 INSERT INTO "meta" VALUES('last_compatible_version','16'); |
6 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 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); |
7 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,visit_duration INTEGER DEFAULT 0 NOT NULL); | 7 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,visit_duration INTEGER DEFAULT 0 NOT NULL); |
8 CREATE TABLE visit_source(id INTEGER PRIMARY KEY,source INTEGER NOT NULL); | 8 CREATE TABLE visit_source(id INTEGER PRIMARY KEY,source INTEGER NOT NULL); |
9 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); | 9 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); |
10 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,open ed INTEGER NOT NULL,referrer VARCHAR NOT NULL,by_ext_id VARCHAR NOT NULL,by_ext_ name VARCHAR NOT NULL); | 10 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,open ed INTEGER NOT NULL,referrer VARCHAR NOT NULL,by_ext_id VARCHAR NOT NULL,by_ext_ name VARCHAR NOT NULL,etag VARCHAR NOT NULL,last_modified VARCHAR NOT NULL); |
11 CREATE TABLE downloads_url_chains (id INTEGER NOT NULL,chain_index INTEGER NOT N ULL,url LONGVARCHAR NOT NULL, PRIMARY KEY (id, chain_index) ); | 11 CREATE TABLE downloads_url_chains (id INTEGER NOT NULL,chain_index INTEGER NOT N ULL,url LONGVARCHAR NOT NULL, PRIMARY KEY (id, chain_index) ); |
12 CREATE TABLE segments (id INTEGER PRIMARY KEY,name VARCHAR,url_id INTEGER NON NU LL); | 12 CREATE TABLE segments (id INTEGER PRIMARY KEY,name VARCHAR,url_id INTEGER NON NU LL); |
13 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); | 13 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 INDEX visits_url_index ON visits (url); | 14 CREATE INDEX visits_url_index ON visits (url); |
15 CREATE INDEX visits_from_index ON visits (from_visit); | 15 CREATE INDEX visits_from_index ON visits (from_visit); |
16 CREATE INDEX visits_time_index ON visits (visit_time); | 16 CREATE INDEX visits_time_index ON visits (visit_time); |
17 CREATE INDEX segments_name ON segments(name); | 17 CREATE INDEX segments_name ON segments(name); |
18 CREATE INDEX segments_url_id ON segments(url_id); | 18 CREATE INDEX segments_url_id ON segments(url_id); |
19 CREATE INDEX segment_usage_time_slot_segment_id ON segment_usage(time_slot, segm ent_id); | 19 CREATE INDEX segment_usage_time_slot_segment_id ON segment_usage(time_slot, segm ent_id); |
20 CREATE INDEX segments_usage_seg_id ON segment_usage(segment_id); | 20 CREATE INDEX segments_usage_seg_id ON segment_usage(segment_id); |
21 CREATE INDEX urls_url_index ON urls (url); | 21 CREATE INDEX urls_url_index ON urls (url); |
22 CREATE INDEX keyword_search_terms_index1 ON keyword_search_terms (keyword_id, lo wer_term); | 22 CREATE INDEX keyword_search_terms_index1 ON keyword_search_terms (keyword_id, lo wer_term); |
23 CREATE INDEX keyword_search_terms_index2 ON keyword_search_terms (url_id); | 23 CREATE INDEX keyword_search_terms_index2 ON keyword_search_terms (url_id); |
24 CREATE INDEX keyword_search_terms_index3 ON keyword_search_terms (term); | 24 CREATE INDEX keyword_search_terms_index3 ON keyword_search_terms (term); |
25 COMMIT; | 25 COMMIT; |
26 | |
Randy Smith (Not in Mondays)
2013/12/17 18:48:58
nit: No need for ending blank line.
| |
OLD | NEW |