| OLD | NEW |
| 1 PRAGMA foreign_keys=OFF; | 1 PRAGMA foreign_keys=OFF; |
| 2 BEGIN TRANSACTION; | 2 BEGIN TRANSACTION; |
| 3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR
); | 3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR
); |
| 4 INSERT INTO "meta" VALUES('last_compatible_version','1'); | 4 INSERT INTO "meta" VALUES('last_compatible_version','1'); |
| 5 INSERT INTO "meta" VALUES('version','11'); | 5 INSERT INTO "meta" VALUES('version','12'); |
| 6 CREATE TABLE logins ( | 6 CREATE TABLE logins ( |
| 7 origin_url VARCHAR NOT NULL, | 7 origin_url VARCHAR NOT NULL, |
| 8 action_url VARCHAR, | 8 action_url VARCHAR, |
| 9 username_element VARCHAR, | 9 username_element VARCHAR, |
| 10 username_value VARCHAR, | 10 username_value VARCHAR, |
| 11 password_element VARCHAR, | 11 password_element VARCHAR, |
| 12 password_value BLOB, | 12 password_value BLOB, |
| 13 submit_element VARCHAR, | 13 submit_element VARCHAR, |
| 14 signon_realm VARCHAR NOT NULL, | 14 signon_realm VARCHAR NOT NULL, |
| 15 ssl_valid INTEGER NOT NULL, | 15 ssl_valid INTEGER NOT NULL, |
| 16 preferred INTEGER NOT NULL, | 16 preferred INTEGER NOT NULL, |
| 17 date_created INTEGER NOT NULL, | 17 date_created INTEGER NOT NULL, |
| 18 blacklisted_by_user INTEGER NOT NULL, | 18 blacklisted_by_user INTEGER NOT NULL, |
| 19 scheme INTEGER NOT NULL, | 19 scheme INTEGER NOT NULL, |
| 20 password_type INTEGER, | 20 password_type INTEGER, |
| 21 possible_usernames BLOB, | 21 possible_usernames BLOB, |
| 22 times_used INTEGER, | 22 times_used INTEGER, |
| 23 form_data BLOB, | 23 form_data BLOB, |
| 24 date_synced INTEGER, | 24 date_synced INTEGER, |
| 25 display_name VARCHAR, | 25 display_name VARCHAR, |
| 26 avatar_url VARCHAR, | 26 avatar_url VARCHAR, |
| 27 federation_url VARCHAR, | 27 federation_url VARCHAR, |
| 28 skip_zero_click INTEGER, | 28 skip_zero_click INTEGER, |
| 29 generation_upload_status INTEGER, |
| 29 UNIQUE (origin_url, username_element, username_value, password_element, signon_r
ealm)); | 30 UNIQUE (origin_url, username_element, username_value, password_element, signon_r
ealm)); |
| 30 INSERT INTO "logins" VALUES( | 31 INSERT INTO "logins" VALUES( |
| 31 'https://accounts.google.com/ServiceLogin', /* origin_url */ | 32 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
| 32 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ | 33 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
| 33 'Email', /* username_element */ | 34 'Email', /* username_element */ |
| 34 'theerikchen', /* username_value */ | 35 'theerikchen', /* username_value */ |
| 35 'Passwd', /* password_element */ | 36 'Passwd', /* password_element */ |
| 36 X'', /* password_value */ | 37 X'', /* password_value */ |
| 37 '', /* submit_element */ | 38 '', /* submit_element */ |
| 38 'https://accounts.google.com/', /* signon_realm */ | 39 'https://accounts.google.com/', /* signon_realm */ |
| 39 1, /* ssl_valid */ | 40 1, /* ssl_valid */ |
| 40 1, /* preferred */ | 41 1, /* preferred */ |
| 41 13047429345000000, /* date_created */ | 42 13047429345000000, /* date_created */ |
| 42 0, /* blacklisted_by_user */ | 43 0, /* blacklisted_by_user */ |
| 43 0, /* scheme */ | 44 0, /* scheme */ |
| 44 0, /* password_type */ | 45 0, /* password_type */ |
| 45 X'00000000', /* possible_usernames */ | 46 X'00000000', /* possible_usernames */ |
| 46 1, /* times_used */ | 47 1, /* times_used */ |
| 47 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ | 48 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 48 0, /* date_synced */ | 49 0, /* date_synced */ |
| 49 '', /* display_name */ | 50 '', /* display_name */ |
| 50 '', /* avatar_url */ | 51 '', /* avatar_url */ |
| 51 '', /* federation_url */ | 52 '', /* federation_url */ |
| 52 0 /* skip_zero_click */ | 53 0, /* skip_zero_click */ |
| 54 0 /* generation_upload_status */ |
| 53 ); | 55 ); |
| 54 INSERT INTO "logins" VALUES( | 56 INSERT INTO "logins" VALUES( |
| 55 'https://accounts.google.com/ServiceLogin', /* origin_url */ | 57 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
| 56 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ | 58 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
| 57 'Email', /* username_element */ | 59 'Email', /* username_element */ |
| 58 'theerikchen2', /* username_value */ | 60 'theerikchen2', /* username_value */ |
| 59 'Passwd', /* password_element */ | 61 'Passwd', /* password_element */ |
| 60 X'', /* password_value */ | 62 X'', /* password_value */ |
| 61 'non-empty', /* submit_element */ | 63 'non-empty', /* submit_element */ |
| 62 'https://accounts.google.com/', /* signon_realm */ | 64 'https://accounts.google.com/', /* signon_realm */ |
| 63 1, /* ssl_valid */ | 65 1, /* ssl_valid */ |
| 64 1, /* preferred */ | 66 1, /* preferred */ |
| 65 13047423600000000, /* date_created */ | 67 13047423600000000, /* date_created */ |
| 66 0, /* blacklisted_by_user */ | 68 0, /* blacklisted_by_user */ |
| 67 0, /* scheme */ | 69 0, /* scheme */ |
| 68 0, /* password_type */ | 70 0, /* password_type */ |
| 69 X'00000000', /* possible_usernames */ | 71 X'00000000', /* possible_usernames */ |
| 70 1, /* times_used */ | 72 1, /* times_used */ |
| 71 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ | 73 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 72 0, /* date_synced */ | 74 0, /* date_synced */ |
| 73 '', /* display_name */ | 75 '', /* display_name */ |
| 74 '', /* avatar_url */ | 76 '', /* avatar_url */ |
| 75 '', /* federation_url */ | 77 '', /* federation_url */ |
| 76 0 /* skip_zero_click */ | 78 0, /* skip_zero_click */ |
| 79 0 /* generation_upload_status */ |
| 77 ); | 80 ); |
| 78 CREATE INDEX logins_signon ON logins (signon_realm); | 81 CREATE INDEX logins_signon ON logins (signon_realm); |
| 79 COMMIT; | 82 COMMIT; |
| OLD | NEW |