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','35'); | 4 INSERT INTO "meta" VALUES('version','35'); |
5 INSERT INTO "meta" VALUES('last_compatible_version','35'); | 5 INSERT INTO "meta" VALUES('last_compatible_version','35'); |
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,6262,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,6262,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,6279,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,6279,0,''); |
(...skipping 39 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
50 INSERT INTO "autofill_profile_names" VALUES('00000000-0000-0000-0000-00000000000
7','John','','Doe'); | 50 INSERT INTO "autofill_profile_names" VALUES('00000000-0000-0000-0000-00000000000
7','John','','Doe'); |
51 | 51 |
52 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); | 52 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); |
53 CREATE TABLE token_service (service VARCHAR PRIMARY KEY NOT NULL,encrypted_token
BLOB); | 53 CREATE TABLE token_service (service VARCHAR PRIMARY KEY NOT NULL,encrypted_token
BLOB); |
54 CREATE INDEX logins_signon ON logins (signon_realm); | 54 CREATE INDEX logins_signon ON logins (signon_realm); |
55 CREATE INDEX web_apps_url_index ON web_apps (url); | 55 CREATE INDEX web_apps_url_index ON web_apps (url); |
56 CREATE INDEX autofill_name ON autofill (name); | 56 CREATE INDEX autofill_name ON autofill (name); |
57 CREATE INDEX autofill_name_value_lower ON autofill (name, value_lower); | 57 CREATE INDEX autofill_name_value_lower ON autofill (name, value_lower); |
58 CREATE INDEX autofill_dates_pair_id ON autofill_dates (pair_id); | 58 CREATE INDEX autofill_dates_pair_id ON autofill_dates (pair_id); |
59 COMMIT; | 59 COMMIT; |
OLD | NEW |