Index: chrome/test/data/History/history.21.sql |
diff --git a/chrome/test/data/History/history.21.sql b/chrome/test/data/History/history.21.sql |
index 0e5322d9e7d0657c6562ad6a4f45c24ec4167ab4..782147c518a0961d0abe1f5a2f1b0d6928492c67 100644 |
--- a/chrome/test/data/History/history.21.sql |
+++ b/chrome/test/data/History/history.21.sql |
@@ -1,12 +1,28 @@ |
BEGIN TRANSACTION; |
+-- Version reset |
CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,value LONGVARCHAR); |
INSERT INTO "meta" VALUES('version','21'); |
INSERT INTO "meta" VALUES('last_compatible_version','16'); |
+ |
+-- Create old androi_urls table |
CREATE TABLE android_urls(id INTEGER PRIMARY KEY, raw_url LONGVARCHAR, created_time INTEGER NOT NULL, last_visit_time INTEGER NOT NULL, url_id INTEGER NOT NULL,favicon_id INTEGER DEFAULT NULL, bookmark INTEGER DEFAULT 0); |
CREATE INDEX android_urls_raw_url_idx ON android_urls(raw_url); |
CREATE INDEX android_urls_url_id_idx ON android_urls(url_id); |
INSERT INTO "android_urls" VALUES(1,'http://google.com/',1,1,1,1,0); |
INSERT INTO "android_urls" VALUES(4,'www.google.com/',1,1,3,1,1); |
+ |
+-- Create downloads table in proper (old) format. |
+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, |
+ end_time INTEGER NOT NULL, |
+ opened INTEGER NOT NULL); |
+ |
COMMIT; |