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','1'); |
| 6 CREATE TABLE logins ( |
| 7 origin_url VARCHAR NOT NULL, |
| 8 action_url VARCHAR, |
| 9 username_element VARCHAR, |
| 10 username_value VARCHAR, |
| 11 password_element VARCHAR, |
| 12 password_value BLOB, |
| 13 submit_element VARCHAR, |
| 14 signon_realm VARCHAR NOT NULL, |
| 15 ssl_valid INTEGER NOT NULL, |
| 16 preferred INTEGER NOT NULL, |
| 17 date_created INTEGER NOT NULL, |
| 18 blacklisted_by_user INTEGER NOT NULL, |
| 19 scheme INTEGER NOT NULL, |
| 20 UNIQUE (origin_url, username_element, username_value, password_element, submit_e
lement, signon_realm)); |
| 21 INSERT INTO "logins" VALUES( |
| 22 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
| 23 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
| 24 'Email', /* username_element */ |
| 25 'theerikchen', /* username_value */ |
| 26 'Passwd', /* password_element */ |
| 27 X'', /* password_value */ |
| 28 '', /* submit_element */ |
| 29 'https://accounts.google.com/', /* signon_realm */ |
| 30 1, /* ssl_valid */ |
| 31 1, /* preferred */ |
| 32 1402955745, /* date_created */ |
| 33 0, /* blacklisted_by_user */ |
| 34 0 /* scheme */ |
| 35 ); |
| 36 INSERT INTO "logins" VALUES( |
| 37 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
| 38 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
| 39 'Email', /* username_element */ |
| 40 'theerikchen2', /* username_value */ |
| 41 'Passwd', /* password_element */ |
| 42 X'', /* password_value */ |
| 43 '', /* submit_element */ |
| 44 'https://accounts.google.com/', /* signon_realm */ |
| 45 1, /* ssl_valid */ |
| 46 1, /* preferred */ |
| 47 1402950000, /* date_created */ |
| 48 0, /* blacklisted_by_user */ |
| 49 0 /* scheme */ |
| 50 ); |
| 51 CREATE INDEX logins_signon ON logins (signon_realm); |
| 52 COMMIT; |
| 53 |
OLD | NEW |