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