| OLD | NEW |
| 1 -- Version 4 schema with meta.version==1. Tests http://crbug.com/295851 | 1 -- Version 4 schema with meta.version==1. Tests http://crbug.com/295851 |
| 2 PRAGMA foreign_keys=OFF; | 2 PRAGMA foreign_keys=OFF; |
| 3 BEGIN TRANSACTION; | 3 BEGIN TRANSACTION; |
| 4 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR
); | 4 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR
); |
| 5 INSERT INTO "meta" VALUES('last_compatible_version','1'); | 5 INSERT INTO "meta" VALUES('last_compatible_version','1'); |
| 6 INSERT INTO "meta" VALUES('version','1'); | 6 INSERT INTO "meta" VALUES('version','1'); |
| 7 CREATE TABLE logins ( | 7 CREATE TABLE logins ( |
| 8 origin_url VARCHAR NOT NULL, | 8 origin_url VARCHAR NOT NULL, |
| 9 action_url VARCHAR, | 9 action_url VARCHAR, |
| 10 username_element VARCHAR, | 10 username_element VARCHAR, |
| (...skipping 43 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 54 1, /* ssl_valid */ | 54 1, /* ssl_valid */ |
| 55 1, /* preferred */ | 55 1, /* preferred */ |
| 56 1402950000, /* date_created */ | 56 1402950000, /* date_created */ |
| 57 0, /* blacklisted_by_user */ | 57 0, /* blacklisted_by_user */ |
| 58 0, /* scheme */ | 58 0, /* scheme */ |
| 59 0, /* password_type */ | 59 0, /* password_type */ |
| 60 X'00000000', /* possible_usernames */ | 60 X'00000000', /* possible_usernames */ |
| 61 1, /* times_used */ | 61 1, /* times_used */ |
| 62 X'18000000020000000000000000000000000000000000000000000000' /* form_data */ | 62 X'18000000020000000000000000000000000000000000000000000000' /* form_data */ |
| 63 ); | 63 ); |
| 64 INSERT INTO "logins" VALUES( |
| 65 'http://example.com', /* origin_url */ |
| 66 'http://example.com/landing', /* action_url */ |
| 67 '', /* username_element */ |
| 68 'user', /* username_value */ |
| 69 '', /* password_element */ |
| 70 X'', /* password_value */ |
| 71 '', /* submit_element */ |
| 72 'http://example.com', /* signon_realm */ |
| 73 1, /* ssl_valid */ |
| 74 1, /* preferred */ |
| 75 1402950000, /* date_created */ |
| 76 0, /* blacklisted_by_user */ |
| 77 1, /* scheme */ |
| 78 0, /* password_type */ |
| 79 X'00000000', /* possible_usernames */ |
| 80 1, /* times_used */ |
| 81 X'18000000020000000000000000000000000000000000000000000000' /* form_data */ |
| 82 ); |
| 64 CREATE INDEX logins_signon ON logins (signon_realm); | 83 CREATE INDEX logins_signon ON logins (signon_realm); |
| 65 COMMIT; | 84 COMMIT; |
| 66 | 85 |
| OLD | NEW |