| 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','5'); |
| 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 UNIQUE (origin_url, username_element, username_value, password_element, submit_e
lement, signon_realm)); |
| 26 INSERT INTO "logins" VALUES( |
| 27 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
| 28 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
| 29 'Email', /* username_element */ |
| 30 'theerikchen', /* username_value */ |
| 31 'Passwd', /* password_element */ |
| 32 X'', /* password_value */ |
| 33 '', /* submit_element */ |
| 34 'https://accounts.google.com/', /* signon_realm */ |
| 35 1, /* ssl_valid */ |
| 36 1, /* preferred */ |
| 37 1402955745, /* date_created */ |
| 38 0, /* blacklisted_by_user */ |
| 39 0, /* scheme */ |
| 40 0, /* password_type */ |
| 41 X'00000000', /* possible_usernames */ |
| 42 1, /* times_used */ |
| 43 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 44 NULL /* use_additional_auth */ |
| 45 ); |
| 46 INSERT INTO "logins" VALUES( |
| 47 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
| 48 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
| 49 'Email', /* username_element */ |
| 50 'theerikchen2', /* username_value */ |
| 51 'Passwd', /* password_element */ |
| 52 X'', /* password_value */ |
| 53 '', /* submit_element */ |
| 54 'https://accounts.google.com/', /* signon_realm */ |
| 55 1, /* ssl_valid */ |
| 56 1, /* preferred */ |
| 57 1402950000, /* date_created */ |
| 58 0, /* blacklisted_by_user */ |
| 59 0, /* scheme */ |
| 60 0, /* password_type */ |
| 61 X'00000000', /* possible_usernames */ |
| 62 1, /* times_used */ |
| 63 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 64 NULL /* use_additional_auth */ |
| 65 ); |
| 66 CREATE INDEX logins_signon ON logins (signon_realm); |
| 67 COMMIT; |
| 68 |
| 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