OLD | NEW |
1 PRAGMA foreign_keys=OFF; | 1 PRAGMA foreign_keys=OFF; |
2 BEGIN TRANSACTION; | 2 BEGIN TRANSACTION; |
3 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)
; |
4 INSERT INTO "meta" VALUES('version','33'); | 4 INSERT INTO "meta" VALUES('version','33'); |
5 INSERT INTO "meta" VALUES('last_compatible_version','33'); | 5 INSERT INTO "meta" VALUES('last_compatible_version','33'); |
6 INSERT INTO "meta" VALUES('Default Search Provider ID','2'); | 6 INSERT INTO "meta" VALUES('Default Search Provider ID','2'); |
7 INSERT INTO "meta" VALUES('Builtin Keyword Version','33'); | 7 INSERT INTO "meta" VALUES('Builtin Keyword Version','33'); |
8 CREATE TABLE keywords (id INTEGER PRIMARY KEY,short_name VARCHAR NOT NULL,keywor
d VARCHAR NOT NULL,favicon_url VARCHAR NOT NULL,url VARCHAR NOT NULL,show_in_def
ault_list INTEGER,safe_for_autoreplace INTEGER,originating_url VARCHAR,date_crea
ted INTEGER DEFAULT 0,usage_count INTEGER DEFAULT 0,input_encodings VARCHAR,sugg
est_url VARCHAR,prepopulate_id INTEGER DEFAULT 0,autogenerate_keyword INTEGER DE
FAULT 0,logo_id INTEGER DEFAULT 0,created_by_policy INTEGER DEFAULT 0,instant_ur
l VARCHAR); | 8 CREATE TABLE keywords (id INTEGER PRIMARY KEY,short_name VARCHAR NOT NULL,keywor
d VARCHAR NOT NULL,favicon_url VARCHAR NOT NULL,url VARCHAR NOT NULL,show_in_def
ault_list INTEGER,safe_for_autoreplace INTEGER,originating_url VARCHAR,date_crea
ted INTEGER DEFAULT 0,usage_count INTEGER DEFAULT 0,input_encodings VARCHAR,sugg
est_url VARCHAR,prepopulate_id INTEGER DEFAULT 0,autogenerate_keyword INTEGER DE
FAULT 0,logo_id INTEGER DEFAULT 0,created_by_policy INTEGER DEFAULT 0,instant_ur
l VARCHAR); |
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,1,6256,0,'{google:baseURL}webhp?{google:RLZ}sourceid=chrome-ins
tant&ie={inputEncoding}&ion=1{searchTerms}&nord=1'); | 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,1,6256,0,'{google:baseURL}webhp?{google:RLZ}sourceid=chrome-ins
tant&ie={inputEncoding}&ion=1{searchTerms}&nord=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,0,6273,0,''); | 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,0,6273,0,''); |
(...skipping 12 matching lines...) Expand all Loading... |
23 CREATE TABLE autofill_profile_phones ( guid VARCHAR, type INTEGER DEFAULT 0, num
ber VARCHAR); | 23 CREATE TABLE autofill_profile_phones ( guid VARCHAR, type INTEGER DEFAULT 0, num
ber VARCHAR); |
24 INSERT INTO "autofill_profile_phones" VALUES('45285F35-4A04-5F47-DBCC-CA8C2F2A59
44',0,'9013323322'); | 24 INSERT INTO "autofill_profile_phones" VALUES('45285F35-4A04-5F47-DBCC-CA8C2F2A59
44',0,'9013323322'); |
25 CREATE TABLE credit_cards ( guid VARCHAR PRIMARY KEY, name_on_card VARCHAR, expi
ration_month INTEGER, expiration_year INTEGER, card_number_encrypted BLOB, date_
modified INTEGER NOT NULL DEFAULT 0); | 25 CREATE TABLE credit_cards ( guid VARCHAR PRIMARY KEY, name_on_card VARCHAR, expi
ration_month INTEGER, expiration_year INTEGER, card_number_encrypted BLOB, date_
modified INTEGER NOT NULL DEFAULT 0); |
26 CREATE TABLE token_service (service VARCHAR PRIMARY KEY NOT NULL,encrypted_token
BLOB); | 26 CREATE TABLE token_service (service VARCHAR PRIMARY KEY NOT NULL,encrypted_token
BLOB); |
27 CREATE INDEX logins_signon ON logins (signon_realm); | 27 CREATE INDEX logins_signon ON logins (signon_realm); |
28 CREATE INDEX web_apps_url_index ON web_apps (url); | 28 CREATE INDEX web_apps_url_index ON web_apps (url); |
29 CREATE INDEX autofill_name ON autofill (name); | 29 CREATE INDEX autofill_name ON autofill (name); |
30 CREATE INDEX autofill_name_value_lower ON autofill (name, value_lower); | 30 CREATE INDEX autofill_name_value_lower ON autofill (name, value_lower); |
31 CREATE INDEX autofill_dates_pair_id ON autofill_dates (pair_id); | 31 CREATE INDEX autofill_dates_pair_id ON autofill_dates (pair_id); |
32 COMMIT; | 32 COMMIT; |
OLD | NEW |