components/test/data/web_database/version_20.sql - Issue 962583003: Raze old WebDatabases.

Side by Side Diff: components/test/data/web_database/version_20.sql

Issue 962583003: Raze old WebDatabases. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master

Patch Set: Created 5 years, 9 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

« components/search_engines/keyword_table.cc ('K') | « components/search_engines/keyword_table.cc ('k') | components/test/data/web_database/version_21.sql » ('j') | components/webdata/common/web_database.cc » ('J')
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Hide Comments ('s')

OLD	NEW
	(Empty)
1 PRAGMA foreign_keys=OFF;

2 BEGIN TRANSACTION;

3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR );

4 INSERT INTO "meta" VALUES('version','20');

5 INSERT INTO "meta" VALUES('last_compatible_version','20');

6 INSERT INTO "meta" VALUES('Builtin Keyword Version','27');

7 INSERT INTO "meta" VALUES('Default Search Provider ID','7');

8 CREATE TABLE keywords (id INTEGER PRIMARY KEY,short_name VARCHAR NOT NULL, keywo rd VARCHAR NOT NULL,favicon_url VARCHAR NOT NULL,url VARCHAR NOT NULL,show_in_de fault_list INTEGER,safe_for_autoreplace INTEGER,originating_url VARCHAR,date_cre ated INTEGER DEFAULT 0,usage_count INTEGER DEFAULT 0,input_encodings VARCHAR,sug gest_url VARCHAR,prepopulate_id INTEGER DEFAULT 0);

9 INSERT INTO "keywords" VALUES(2,'Google','google.com','http://www.google.com/fav icon.ico','{google:baseURL}search?{google:RLZ}{google:acceptedSuggestion}{google :originalQueryForSuggestion}sourceid=chrome&ie={inputEncoding}&q={searchTerms}', 1,1,'',0,0,'UTF-8','{google:baseSuggestURL}search?client=chrome&hl={language}&q= {searchTerms}',1);

10 INSERT INTO "keywords" VALUES(3,'Yahoo!','yahoo.com','http://search.yahoo.com/fa vicon.ico','http://search.yahoo.com/search?ei={inputEncoding}&fr=crmas&p={search Terms}',1,1,'',0,0,'UTF-8','http://ff.search.yahoo.com/gossip?output=fxjson&comm and={searchTerms}',2);

11 INSERT INTO "keywords" VALUES(4,'Bing','bing.com','http://www.bing.com/s/wlflag. ico','http://www.bing.com/search?setmkt=en-US&q={searchTerms}',1,1,'',0,0,'UTF-8 ','http://api.bing.com/osjson.aspx?query={searchTerms}&language={language}',3);

12 INSERT INTO "keywords" VALUES(5,'Wikipedia (en)','en.wikipedia.org','','http://e n.wikipedia.org/w/index.php?title=Special:Search&search={searchTerms}',1,0,'',12 83287335,0,'','',0);

13 INSERT INTO "keywords" VALUES(6,'NYTimes','query.nytimes.com','','http://query.n ytimes.com/gst/handler.html?query={searchTerms}&opensearch=1',1,0,'',1283287335, 0,'','',0);

14 INSERT INTO "keywords" VALUES(7,'eBay','rover.ebay.com','','http://rover.ebay.co m/rover/1/711-43047-14818-1/4?satitle={searchTerms}',1,0,'',1283287335,0,'','',0 );

15 INSERT INTO "keywords" VALUES(8,'ff','ff','','http://ff{searchTerms}',0,0,'',128 3287356,0,'','',0);

16 CREATE TABLE logins (origin_url VARCHAR NOT NULL, action_url VARCHAR, username_e lement VARCHAR, username_value VARCHAR, password_element VARCHAR, password_value BLOB, submit_element VARCHAR,signon_realm VARCHAR NOT NULL,ssl_valid INTEGER NO T NULL,preferred INTEGER NOT NULL,date_created INTEGER NOT NULL,blacklisted_by_u ser INTEGER NOT NULL,scheme INTEGER NOT NULL,UNIQUE (origin_url, username_elemen t, username_value, password_element, submit_element, signon_realm));

17 CREATE TABLE ie7_logins (url_hash VARCHAR NOT NULL, password_value BLOB, date_cr eated INTEGER NOT NULL,UNIQUE (url_hash));

18 CREATE TABLE web_app_icons (url LONGVARCHAR,width int,height int,image BLOB, UNI QUE (url, width, height));

19 CREATE TABLE web_apps (url LONGVARCHAR UNIQUE,has_all_images INTEGER NOT NULL);

20 CREATE INDEX logins_signon ON logins (signon_realm);

21 CREATE INDEX ie7_logins_hash ON ie7_logins (url_hash);

22 CREATE INDEX web_apps_url_index ON web_apps (url);

23 COMMIT;

OLD	NEW