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