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('last_compatible_version','1'); |
| 5 INSERT INTO "meta" VALUES('version','8'); |
| 6 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 N
OT NULL,preferred INTEGER NOT NULL,date_created INTEGER NOT NULL,blacklisted_by_
user INTEGER NOT NULL,scheme INTEGER NOT NULL,password_type INTEGER,possible_use
rnames BLOB,times_used INTEGER,form_data BLOB,use_additional_auth INTEGER,date_s
ynced INTEGER, display_name VARCHAR, avatar_url VARCHAR, federation_url VARCHAR,
is_zero_click INTEGER,UNIQUE (origin_url, username_element, username_value, pas
sword_element, submit_element, signon_realm)); |
| 7 INSERT INTO "logins" VALUES('https://accounts.google.com/ServiceLogin','https://
accounts.google.com/ServiceLoginAuth','Email','theerikchen','Passwd',X'','','htt
ps://accounts.google.com/',1,1,1402955745,0,0,0,X'00000000',1,X'1800000002000000
0000000000000000000000000000000000000000',NULL,0,'','','',0); |
| 8 INSERT INTO "logins" VALUES('https://accounts.google.com/ServiceLogin','https://
accounts.google.com/ServiceLoginAuth','Email','theerikchen2','Passwd',X'','','ht
tps://accounts.google.com/',1,1,1402950000,0,0,0,X'00000000',1,X'180000000200000
00000000000000000000000000000000000000000',NULL,0,'','','',0); |
| 9 CREATE INDEX logins_signon ON logins (signon_realm); |
| 10 COMMIT; |
| 11 |
OLD | NEW |