| 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','6'); |
| 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 password_type INTEGER, |
| 21 possible_usernames BLOB, |
| 22 times_used INTEGER, |
| 23 form_data BLOB, |
| 24 use_additional_auth INTEGER, |
| 25 date_synced INTEGER, |
| 26 UNIQUE (origin_url, username_element, username_value, password_element, submit_e
lement, signon_realm)); |
| 27 INSERT INTO "logins" VALUES( |
| 28 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
| 29 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
| 30 'Email', /* username_element */ |
| 31 'theerikchen', /* username_value */ |
| 32 'Passwd', /* password_element */ |
| 33 X'', /* password_value */ |
| 34 '', /* submit_element */ |
| 35 'https://accounts.google.com/', /* signon_realm */ |
| 36 1, /* ssl_valid */ |
| 37 1, /* preferred */ |
| 38 1402955745, /* date_created */ |
| 39 0, /* blacklisted_by_user */ |
| 40 0, /* scheme */ |
| 41 0, /* password_type */ |
| 42 X'00000000', /* possible_usernames */ |
| 43 1, /* times_used */ |
| 44 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 45 NULL, /* use_additional_auth */ |
| 46 0 /* date_synced */ |
| 47 ); |
| 48 INSERT INTO "logins" VALUES( |
| 49 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
| 50 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
| 51 'Email', /* username_element */ |
| 52 'theerikchen2', /* username_value */ |
| 53 'Passwd', /* password_element */ |
| 54 X'', /* password_value */ |
| 55 '', /* submit_element */ |
| 56 'https://accounts.google.com/', /* signon_realm */ |
| 57 1, /* ssl_valid */ |
| 58 1, /* preferred */ |
| 59 1402950000, /* date_created */ |
| 60 0, /* blacklisted_by_user */ |
| 61 0, /* scheme */ |
| 62 0, /* password_type */ |
| 63 X'00000000', /* possible_usernames */ |
| 64 1, /* times_used */ |
| 65 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 66 NULL, /* use_additional_auth */ |
| 67 0 /* date_synced */ |
| 68 ); |
| 69 CREATE INDEX logins_signon ON logins (signon_realm); |
| 70 COMMIT; |
| 71 |
| OLD | NEW |
|---|
Chromium Code Reviews
Issue 808173002:
Add tests for version migration tesing in for LoginDatabase. (Closed)
Base URL: https://chromium.googlesource.com/chromium/src.git@master