Index: chrome/test/data/top_sites/history.19.sql |
=================================================================== |
--- chrome/test/data/top_sites/history.19.sql (revision 71581) |
+++ chrome/test/data/top_sites/history.19.sql (working copy) |
@@ -3,17 +3,17 @@ |
INSERT INTO "meta" VALUES('version','19'); |
INSERT INTO "meta" VALUES('last_compatible_version','16'); |
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_visit_time INTEGER NOT NULL,hidden INTEGER DEFAULT 0 NOT NULL,favicon_id INTEGER DEFAULT 0 NOT NULL); |
-INSERT INTO "urls" VALUES(1,'http://google.com/','Google',1,1,12931898015280853,0,1); |
-INSERT INTO "urls" VALUES(2,'http://www.google.com/','Google',1,0,12931898015280853,0,1); |
-INSERT INTO "urls" VALUES(3,'http://www.google.com/blank.html','',1,0,12931898015572853,1,0); |
-INSERT INTO "urls" VALUES(4,'http://yahoo.com/','Yahoo!',1,1,12931898025843853,0,2); |
-INSERT INTO "urls" VALUES(5,'http://www.yahoo.com/','Yahoo!',1,0,12931898025843853,0,2); |
+INSERT INTO "urls" VALUES(1,'http://google.com/','Google',1,1,$1,0,1); |
+INSERT INTO "urls" VALUES(2,'http://www.google.com/','Google',1,0,$1,0,1); |
+INSERT INTO "urls" VALUES(3,'http://www.google.com/blank.html','',1,0,$1,1,0); |
+INSERT INTO "urls" VALUES(4,'http://yahoo.com/','Yahoo!',1,1,$1,0,2); |
+INSERT INTO "urls" VALUES(5,'http://www.yahoo.com/','Yahoo!',1,0,$1,0,2); |
CREATE TABLE visits(id INTEGER PRIMARY KEY,url INTEGER NOT NULL,visit_time INTEGER NOT NULL,from_visit INTEGER,transition INTEGER DEFAULT 0 NOT NULL,segment_id INTEGER,is_indexed BOOLEAN); |
-INSERT INTO "visits" VALUES(1,1,12931898015280853,0,268435457,1,0); |
-INSERT INTO "visits" VALUES(2,2,12931898015280853,1,2684354561,0,1); |
-INSERT INTO "visits" VALUES(3,3,12931898015572853,0,805306371,0,0); |
-INSERT INTO "visits" VALUES(4,4,12931898025843853,0,268435457,2,0); |
-INSERT INTO "visits" VALUES(5,5,12931898025843853,4,2684354561,0,1); |
+INSERT INTO "visits" VALUES(1,1,$2,0,268435457,1,0); |
+INSERT INTO "visits" VALUES(2,2,$2,1,2684354561,0,1); |
+INSERT INTO "visits" VALUES(3,3,$2,0,805306371,0,0); |
+INSERT INTO "visits" VALUES(4,4,$2,0,268435457,2,0); |
+INSERT INTO "visits" VALUES(5,5,$2,4,2684354561,0,1); |
CREATE TABLE visit_source(id INTEGER PRIMARY KEY,source INTEGER NOT NULL); |
CREATE TABLE keyword_search_terms (keyword_id INTEGER NOT NULL,url_id INTEGER NOT NULL,lower_term LONGVARCHAR NOT NULL,term LONGVARCHAR NOT NULL); |
CREATE TABLE downloads (id INTEGER PRIMARY KEY,full_path LONGVARCHAR NOT NULL,url LONGVARCHAR NOT NULL,start_time INTEGER NOT NULL,received_bytes INTEGER NOT NULL,total_bytes INTEGER NOT NULL,state INTEGER NOT NULL); |
@@ -21,8 +21,8 @@ |
INSERT INTO "segments" VALUES(1,'http://google.com/',1,-1); |
INSERT INTO "segments" VALUES(2,'http://yahoo.com/',4,-1); |
CREATE TABLE segment_usage (id INTEGER PRIMARY KEY,segment_id INTEGER NOT NULL,time_slot INTEGER NOT NULL,visit_count INTEGER DEFAULT 0 NOT NULL); |
-INSERT INTO "segment_usage" VALUES(1,1,12931858800000000,1); |
-INSERT INTO "segment_usage" VALUES(2,2,12931858800000000,1); |
+INSERT INTO "segment_usage" VALUES(1,1,$3,1); |
+INSERT INTO "segment_usage" VALUES(2,2,$3,1); |
CREATE TABLE presentation(url_id INTEGER PRIMARY KEY,pres_index INTEGER NOT NULL); |
CREATE INDEX visits_url_index ON visits (url); |
CREATE INDEX visits_from_index ON visits (from_visit); |