Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(682)

Side by Side Diff: chrome/test/data/top_sites/history.19.sql

Issue 6371001: A quick fix for TopSitesMigrationTest.Migrate... (Closed) Base URL: svn://chrome-svn/chrome/trunk/src/
Patch Set: '' Created 9 years, 11 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch | Annotate | Revision Log
« no previous file with comments | « chrome/browser/history/top_sites_unittest.cc ('k') | no next file » | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
1 BEGIN TRANSACTION; 1 BEGIN TRANSACTION;
2 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,value LONGVARCHAR) ; 2 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,value LONGVARCHAR) ;
3 INSERT INTO "meta" VALUES('version','19'); 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 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); 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);
6 INSERT INTO "urls" VALUES(1,'http://google.com/','Google',1,1,12931898015280853, 0,1); 6 INSERT INTO "urls" VALUES(1,'http://google.com/','Google',1,1,$1,0,1);
7 INSERT INTO "urls" VALUES(2,'http://www.google.com/','Google',1,0,12931898015280 853,0,1); 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,1293189801 5572853,1,0); 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,12931898025843853,0 ,2); 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,129318980258438 53,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); 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,12931898015280853,0,268435457,1,0); 12 INSERT INTO "visits" VALUES(1,1,$2,0,268435457,1,0);
13 INSERT INTO "visits" VALUES(2,2,12931898015280853,1,2684354561,0,1); 13 INSERT INTO "visits" VALUES(2,2,$2,1,2684354561,0,1);
14 INSERT INTO "visits" VALUES(3,3,12931898015572853,0,805306371,0,0); 14 INSERT INTO "visits" VALUES(3,3,$2,0,805306371,0,0);
15 INSERT INTO "visits" VALUES(4,4,12931898025843853,0,268435457,2,0); 15 INSERT INTO "visits" VALUES(4,4,$2,0,268435457,2,0);
16 INSERT INTO "visits" VALUES(5,5,12931898025843853,4,2684354561,0,1); 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); 17 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); 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);
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); 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);
20 CREATE TABLE segments (id INTEGER PRIMARY KEY,name VARCHAR,url_id INTEGER NON NU LL,pres_index INTEGER DEFAULT -1 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);
21 INSERT INTO "segments" VALUES(1,'http://google.com/',1,-1); 21 INSERT INTO "segments" VALUES(1,'http://google.com/',1,-1);
22 INSERT INTO "segments" VALUES(2,'http://yahoo.com/',4,-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); 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);
24 INSERT INTO "segment_usage" VALUES(1,1,12931858800000000,1); 24 INSERT INTO "segment_usage" VALUES(1,1,$3,1);
25 INSERT INTO "segment_usage" VALUES(2,2,12931858800000000,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 ); 26 CREATE TABLE presentation(url_id INTEGER PRIMARY KEY,pres_index INTEGER NOT NULL );
27 CREATE INDEX visits_url_index ON visits (url); 27 CREATE INDEX visits_url_index ON visits (url);
28 CREATE INDEX visits_from_index ON visits (from_visit); 28 CREATE INDEX visits_from_index ON visits (from_visit);
29 CREATE INDEX visits_time_index ON visits (visit_time); 29 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); 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); 31 CREATE INDEX keyword_search_terms_index2 ON keyword_search_terms (url_id);
32 CREATE INDEX segments_name ON segments(name); 32 CREATE INDEX segments_name ON segments(name);
33 CREATE INDEX segments_url_id ON segments(url_id); 33 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); 34 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); 35 CREATE INDEX segments_usage_seg_id ON segment_usage(segment_id);
36 CREATE INDEX urls_url_index ON urls (url); 36 CREATE INDEX urls_url_index ON urls (url);
37 CREATE INDEX urls_favicon_id_INDEX ON urls (favicon_id); 37 CREATE INDEX urls_favicon_id_INDEX ON urls (favicon_id);
38 COMMIT; 38 COMMIT;
OLDNEW
« no previous file with comments | « chrome/browser/history/top_sites_unittest.cc ('k') | no next file » | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698