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

Side by Side Diff: chrome/test/data/History/history.21.sql

Issue 11363222: Persist download interrupt reason, both target and current paths, and url_chain. (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src
Patch Set: Merged to r180302 Created 7 years, 10 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
OLDNEW
1 BEGIN TRANSACTION; 1 BEGIN TRANSACTION;
2 -- Version reset
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','21'); 4 INSERT INTO "meta" VALUES('version','21');
4 INSERT INTO "meta" VALUES('last_compatible_version','16'); 5 INSERT INTO "meta" VALUES('last_compatible_version','16');
6
7 -- Create old androi_urls table
5 CREATE TABLE android_urls(id INTEGER PRIMARY KEY, raw_url LONGVARCHAR, created_t ime INTEGER NOT NULL, last_visit_time INTEGER NOT NULL, url_id INTEGER NOT NULL, favicon_id INTEGER DEFAULT NULL, bookmark INTEGER DEFAULT 0); 8 CREATE TABLE android_urls(id INTEGER PRIMARY KEY, raw_url LONGVARCHAR, created_t ime INTEGER NOT NULL, last_visit_time INTEGER NOT NULL, url_id INTEGER NOT NULL, favicon_id INTEGER DEFAULT NULL, bookmark INTEGER DEFAULT 0);
6 CREATE INDEX android_urls_raw_url_idx ON android_urls(raw_url); 9 CREATE INDEX android_urls_raw_url_idx ON android_urls(raw_url);
7 CREATE INDEX android_urls_url_id_idx ON android_urls(url_id); 10 CREATE INDEX android_urls_url_id_idx ON android_urls(url_id);
8 INSERT INTO "android_urls" VALUES(1,'http://google.com/',1,1,1,1,0); 11 INSERT INTO "android_urls" VALUES(1,'http://google.com/',1,1,1,1,0);
9 INSERT INTO "android_urls" VALUES(4,'www.google.com/',1,1,3,1,1); 12 INSERT INTO "android_urls" VALUES(4,'www.google.com/',1,1,3,1,1);
13
14 -- Create downloads table in proper (old) format.
15 CREATE TABLE downloads (
16 id INTEGER PRIMARY KEY,
17 full_path LONGVARCHAR NOT NULL,
18 url LONGVARCHAR NOT NULL,
19 start_time INTEGER NOT NULL,
20 received_bytes INTEGER NOT NULL,
21 total_bytes INTEGER NOT NULL,
22 state INTEGER NOT NULL,
23 end_time INTEGER NOT NULL,
24 opened INTEGER NOT NULL);
25
10 COMMIT; 26 COMMIT;
11 27
12 28
OLDNEW
« no previous file with comments | « chrome/browser/ui/webui/downloads_dom_handler_browsertest.cc ('k') | chrome/test/data/History/history.22.sql » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698