PageRenderTime 53ms CodeModel.GetById 24ms app.highlight 19ms RepoModel.GetById 6ms app.codeStats 0ms

/components/test/data/web_database/version_59.sql

http://github.com/chromium/chromium
SQL | 28 lines | 28 code | 0 blank | 0 comment | 0 complexity | 6befa18b7320c3ede1d377780cbb0253 MD5 | raw file
 1PRAGMA foreign_keys=OFF;
 2BEGIN TRANSACTION;
 3CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);
 4INSERT INTO "meta" VALUES('version','58');
 5INSERT INTO "meta" VALUES('last_compatible_version','58');
 6INSERT INTO "meta" VALUES('Builtin Keyword Version','79');
 7CREATE TABLE token_service (service VARCHAR PRIMARY KEY NOT NULL,encrypted_token BLOB);
 8CREATE TABLE autofill (name VARCHAR, value VARCHAR, value_lower VARCHAR, date_created INTEGER DEFAULT 0, date_last_used INTEGER DEFAULT 0, count INTEGER DEFAULT 1, PRIMARY KEY (name, value));
 9CREATE TABLE credit_cards ( guid VARCHAR PRIMARY KEY, name_on_card VARCHAR, expiration_month INTEGER, expiration_year INTEGER, card_number_encrypted BLOB, date_modified INTEGER NOT NULL DEFAULT 0, origin VARCHAR DEFAULT '');
10CREATE TABLE autofill_profiles ( guid VARCHAR PRIMARY KEY, company_name VARCHAR, street_address VARCHAR, dependent_locality VARCHAR, city VARCHAR, state VARCHAR, zipcode VARCHAR, sorting_code VARCHAR, country_code VARCHAR, date_modified INTEGER NOT NULL DEFAULT 0, origin VARCHAR DEFAULT '', language_code VARCHAR);
11CREATE TABLE autofill_profile_names ( guid VARCHAR, first_name VARCHAR, middle_name VARCHAR, last_name VARCHAR, full_name VARCHAR);
12CREATE TABLE autofill_profile_emails ( guid VARCHAR, email VARCHAR);
13CREATE TABLE autofill_profile_phones ( guid VARCHAR, number VARCHAR);
14CREATE TABLE autofill_profiles_trash ( guid VARCHAR);
15CREATE TABLE keywords (id INTEGER PRIMARY KEY,short_name VARCHAR NOT NULL,keyword VARCHAR NOT NULL,favicon_url VARCHAR NOT NULL,url VARCHAR NOT NULL,safe_for_autoreplace INTEGER,originating_url VARCHAR,date_created INTEGER DEFAULT 0,usage_count INTEGER DEFAULT 0,input_encodings VARCHAR,show_in_default_list INTEGER,suggest_url VARCHAR,prepopulate_id INTEGER DEFAULT 0,created_by_policy INTEGER DEFAULT 0,instant_url VARCHAR,last_modified INTEGER DEFAULT 0,sync_guid VARCHAR,alternate_urls VARCHAR,search_terms_replacement_key VARCHAR,image_url VARCHAR,search_url_post_params VARCHAR,suggest_url_post_params VARCHAR,instant_url_post_params VARCHAR,image_url_post_params VARCHAR,new_tab_url VARCHAR);
16INSERT INTO "keywords" VALUES(2,'Google','google.com','http://www.google.com/favicon.ico','{google:baseURL}search?q={searchTerms}&{google:RLZ}{google:originalQueryForSuggestion}{google:assistedQueryStats}{google:searchFieldtrialParameter}{google:bookmarkBarPinned}{google:searchClient}{google:sourceId}{google:instantExtendedEnabledParameter}{google:omniboxStartMarginParameter}{google:contextualSearchVersion}ie={inputEncoding}',1,'',0,0,'UTF-8',1,'{google:baseSuggestURL}search?{google:searchFieldtrialParameter}client={google:suggestClient}&gs_ri={google:suggestRid}&xssi=t&q={searchTerms}&{google:inputType}{google:cursorPosition}{google:currentPageUrl}{google:pageClassification}{google:searchVersion}{google:sessionToken}{google:prefetchQuery}sugkey={google:suggestAPIKeyParameter}',1,0,'{google:baseURL}webhp?sourceid=chrome-instant&{google:RLZ}{google:forceInstantResults}{google:instantExtendedEnabledParameter}{google:ntpIsThemedParameter}{google:omniboxStartMarginParameter}ie={inputEncoding}',0,'6C67B7D4-77D0-4149-B7F1-6AF0244036E7','["{google:baseURL}#q={searchTerms}","{google:baseURL}search#q={searchTerms}","{google:baseURL}webhp#q={searchTerms}","{google:baseURL}s?q={searchTerms}"]','espv','{google:baseURL}searchbyimage/upload','','','','encoded_image={google:imageThumbnail},image_url={google:imageURL},sbisrc={google:imageSearchSource},original_width={google:imageOriginalWidth},original_height={google:imageOriginalHeight}','{google:baseURL}_/chrome/newtab?{google:RLZ}{google:instantExtendedEnabledParameter}{google:ntpIsThemedParameter}ie={inputEncoding}');
17INSERT INTO "keywords" VALUES(3,'Bing','bing.com','https://www.bing.com/s/a/bing_p.ico','https://www.bing.com/search?setmkt=en-US&q={searchTerms}',1,'',0,0,'UTF-8',1,'http://api.bing.com/osjson.aspx?query={searchTerms}&language={language}',3,0,'',0,'F1E052CB-13DC-416A-AD21-7209EA583B8E','[]','','','','','','','https://www.bing.com/chrome/newtab?setmkt=en-US');
18INSERT INTO "keywords" VALUES(4,'Yahoo!','yahoo.com','https://search.yahoo.com/favicon.ico','https://search.yahoo.com/search?ei={inputEncoding}&fr=crmas&p={searchTerms}',1,'',0,0,'UTF-8',1,'https://search.yahoo.com/sugg/chrome?output=fxjson&appid=crmas&command={searchTerms}',2,0,'',0,'DDB12711-B938-4B5D-A6D5-19B654363D26','[]','','','','','','','');
19INSERT INTO "keywords" VALUES(5,'AOL','aol.com','http://search.aol.com/favicon.ico','http://search.aol.com/aol/search?q={searchTerms}',1,'',0,0,'UTF-8',1,'http://autocomplete.search.aol.com/autocomplete/get?output=json&it=&q={searchTerms}',35,0,'',0,'706DAF64-B881-449A-B743-ADA5E6D5A611','[]','','','','','','','');
20INSERT INTO "keywords" VALUES(6,'Ask','ask.com','http://sp.ask.com/sh/i/a16/favicon/favicon.ico','http://www.ask.com/web?q={searchTerms}',1,'',0,0,'UTF-8',1,'http://ss.ask.com/query?q={searchTerms}&li=ff',4,0,'',0,'585358DB-C0D8-4C18-8929-72F4F17C90A6','[]','','','','','','','');
21INSERT INTO "keywords" VALUES(7,'Wikipedia (en)','en.wikipedia.org','http://en.wikipedia.org/favicon.ico','http://en.wikipedia.org/wiki/Special:Search?search={searchTerms}',0,'',1417547030,0,'UTF-8',1,'http://en.wikipedia.org/w/api.php?action=opensearch&search={searchTerms}',0,0,'',1417547030,'50B3053A-70B8-4750-9DB2-09F9F3DD238E','[]','','','','','','','');
22INSERT INTO "keywords" VALUES(8,'eBay','rover.ebay.com','http://rover.ebay.com/favicon.ico','http://rover.ebay.com/rover/1/711-47294-18009-3/4?mfe=search&mpre=http://www.ebay.com/sch/i.html?_nkw={searchTerms}',0,'',1417547030,0,'ISO-8859-1',1,'http://autosug.ebay.com/autosug?sId=0&kwd={searchTerms}&fmt=osr',0,0,'',1417547030,'94DDDF4A-607A-4BB6-A307-487B563332F0','[]','','','','','','','');
23INSERT INTO "keywords" VALUES(9,'Amazon.com','amazon.com','http://www.amazon.com/favicon.ico','http://www.amazon.com/exec/obidos/external-search/?field-keywords={searchTerms}&mode=blended&tag=wwwcanoniccom-20',0,'',1417547030,0,'ISO-8859-1',1,'',0,0,'',1417547030,'CF1F692F-39A3-4B76-AC99-D6401CE3CA8B','[]','','','','','','','');
24INSERT INTO "keywords" VALUES(10,'DuckDuckGo','duckduckgo.com','https://duckduckgo.com/favicon.ico','https://duckduckgo.com/?q={searchTerms}&t=canonical',0,'',1417547030,0,'UTF-8',1,'',0,0,'',1417547030,'630C20C5-2240-4D67-91FA-5E7971191594','[]','','','','','','','');
25INSERT INTO "keywords" VALUES(11,'Twitter','twitter.com','https://twitter.com/favicon.ico','https://twitter.com/search?q={searchTerms}&source=desktop-search',0,'',1417547030,0,'UTF-8',1,'',0,0,'',1417547030,'5D5A4D78-1202-41C1-9778-57964E3F86DE','[]','','','','','','','');
26CREATE INDEX autofill_name ON autofill (name);
27CREATE INDEX autofill_name_value_lower ON autofill (name, value_lower);
28COMMIT;