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

Side by Side Diff: chrome/test/data/History/Shortcuts.v2.sql

Issue 134853004: Migrate old Shortcuts DB data to conform to new type values (Closed) Base URL: svn://svn.chromium.org/chrome/trunk/src
Patch Set: Addressed Peter's comments - 2 Created 6 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 PRAGMA foreign_keys=OFF; 1 PRAGMA foreign_keys=OFF;
2 BEGIN TRANSACTION; 2 BEGIN TRANSACTION;
3 CREATE TABLE omni_box_shortcuts ( id VARCHAR PRIMARY KEY, text VARCHAR, url VARC HAR, contents VARCHAR, contents_class VARCHAR, description VARCHAR, description_ class VARCHAR, last_access_time INTEGER, number_of_hits INTEGER); 3 CREATE TABLE omni_box_shortcuts ( id VARCHAR PRIMARY KEY, text VARCHAR, url VARC HAR, contents VARCHAR, contents_class VARCHAR, description VARCHAR, description_ class VARCHAR, last_access_time INTEGER, number_of_hits INTEGER, fill_into_edit VARCHAR, transition INTEGER, type INTEGER, keyword VARCHAR);
4 INSERT INTO "omni_box_shortcuts" VALUES('34A7401D-0DC5-4A8F-A6B5-3FA4FF786C42',' sha','http://shacknews.com/','shacknews.com','0,1','Video Game News and Features - Video Game News, Videos, and File Downloads for PC and Console Games at Shack news.com','0,0',13024194201806179,3); 4 INSERT INTO "omni_box_shortcuts" VALUES('34A7401D-0DC5-4A8F-A6B5-3FA4FF786C42',' sha','http://shacknews.com/','shacknews.com','0,1','Video Game News and Features - Video Game News, Videos, and File Downloads for PC and Console Games at Shack news.com','0,0',13024194201806179,3,'http://shacknews.com/',1,2,NULL);
5 INSERT INTO "omni_box_shortcuts" VALUES('9EA31BB8-8528-4AE0-A6B1-FD06458DFC31',' shacknews','http://shacknews.com/','shacknews.com','0,1','Video Game News and Fe atures - Video Game News, Videos, and File Downloads for PC and Console Games at Shacknews.com','0,0',13024456716613368,4); 5 INSERT INTO "omni_box_shortcuts" VALUES('9EA31BB8-8528-4AE0-A6B1-FD06458DFC31',' shacknews','http://shacknews.com/','shacknews.com','0,1','Video Game News and Fe atures - Video Game News, Videos, and File Downloads for PC and Console Games at Shacknews.com','0,0',13024456716613368,4,'http://shacknews.com/',1,2,NULL);
6 INSERT INTO "omni_box_shortcuts" VALUES('CD853DC4-7C4E-4E64-903D-A4BBCAA410F9',' shacknews.com','http://shacknews.com/','shacknews.com','0,1','Video Game News an d Features - Video Game News, Videos, and File Downloads for PC and Console Game s at Shacknews.com','0,0',13024196901413541,1); 6 INSERT INTO "omni_box_shortcuts" VALUES('CD853DC4-7C4E-4E64-903D-A4BBCAA410F9',' shacknews.com','http://shacknews.com/','shacknews.com','0,1','Video Game News an d Features - Video Game News, Videos, and File Downloads for PC and Console Game s at Shacknews.com','0,0',13024196901413541,1,'http://shacknews.com/',1,2,NULL);
7 INSERT INTO "omni_box_shortcuts" VALUES('377314F7-E3AB-4264-8F3F-3404BE48DADB',' echo echo','chrome-extension://cedabbhfglmiikkmdgcpjdkocfcmbkee/?q=echo','Run Ec ho command: echo','0,0','Echo','0,4',13025401559133998,2); 7 -- SEARCH_OTHER_ENGINE (type = 9)
8 INSERT INTO "omni_box_shortcuts" VALUES('BCE200CA-01E9-4A2F-B5EC-2D561DDFBE41',' echo','chrome-extension://cedabbhfglmiikkmdgcpjdkocfcmbkee/?q=frobber','Run Echo command: frobber','0,0','Echo','0,4',13025413423801769,2); 8 INSERT INTO "omni_box_shortcuts" VALUES('B07F4744-F008-3C87-37E4-9D284AD9A697',' yahoo.com other keyword','yahoo.com other keyword','http://search.yahoo.com/sear ch?ei=UTF-8&fr=crmas&p=other+keyword','other keyword','0,0','Yahoo! Search','0,4 ',9,9,'yahoo.com',13036572535614255,1);
9 -- BOOKMARK_TITLE (type = 12)
Peter Kasting 2014/02/12 00:27:50 Do we need to test migrations for types 10 and 11?
Anuj 2014/02/12 23:54:40 10 and 11 are ExtensionApp and Contacts. I did not
10 INSERT INTO "omni_box_shortcuts" VALUES('9CBB669D-B7F0-5AFF-D808-EFFF7028B159',' rdt','www.reddit.com/','http://www.reddit.com/','www.reddit.com/','0,1','rdt','0 ,0',1,12,'',13036574229966419,1);
9 COMMIT; 11 COMMIT;
12
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698