| 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','18'); | 4 INSERT INTO "meta" VALUES('last_compatible_version','18'); |
| 5 INSERT INTO "meta" VALUES('version','18'); | 5 INSERT INTO "meta" VALUES('version','18'); |
| 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, |
| (...skipping 57 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 68 X'00000000', /* possible_usernames */ | 68 X'00000000', /* possible_usernames */ |
| 69 1, /* times_used */ | 69 1, /* times_used */ |
| 70 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ | 70 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 71 0, /* date_synced */ | 71 0, /* date_synced */ |
| 72 '', /* display_name */ | 72 '', /* display_name */ |
| 73 'https://www.google.com/icon', /* icon_url */ | 73 'https://www.google.com/icon', /* icon_url */ |
| 74 '', /* federation_url */ | 74 '', /* federation_url */ |
| 75 1, /* skip_zero_click */ | 75 1, /* skip_zero_click */ |
| 76 0 /* generation_upload_status */ | 76 0 /* generation_upload_status */ |
| 77 ); | 77 ); |
| 78 INSERT INTO "logins" VALUES( |
| 79 'http://example.com', /* origin_url */ |
| 80 'http://example.com/landing', /* action_url */ |
| 81 '', /* username_element */ |
| 82 'user', /* username_value */ |
| 83 '', /* password_element */ |
| 84 X'', /* password_value */ |
| 85 'non-empty', /* submit_element */ |
| 86 'http://example.com', /* signon_realm */ |
| 87 1, /* preferred */ |
| 88 13047423600000000, /* date_created */ |
| 89 0, /* blacklisted_by_user */ |
| 90 1, /* scheme */ |
| 91 0, /* password_type */ |
| 92 X'00000000', /* possible_usernames */ |
| 93 1, /* times_used */ |
| 94 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 95 0, /* date_synced */ |
| 96 '', /* display_name */ |
| 97 'https://www.google.com/icon', /* icon_url */ |
| 98 '', /* federation_url */ |
| 99 1, /* skip_zero_click */ |
| 100 0 /* generation_upload_status */ |
| 101 ); |
| 78 CREATE INDEX logins_signon ON logins (signon_realm); | 102 CREATE INDEX logins_signon ON logins (signon_realm); |
| 79 CREATE TABLE stats ( | 103 CREATE TABLE stats ( |
| 80 origin_domain VARCHAR NOT NULL, | 104 origin_domain VARCHAR NOT NULL, |
| 81 username_value VARCHAR, | 105 username_value VARCHAR, |
| 82 dismissal_count INTEGER, | 106 dismissal_count INTEGER, |
| 83 update_time INTEGER NOT NULL, | 107 update_time INTEGER NOT NULL, |
| 84 UNIQUE(origin_domain, username_value)); | 108 UNIQUE(origin_domain, username_value)); |
| 85 CREATE INDEX stats_origin ON stats(origin_domain); | 109 CREATE INDEX stats_origin ON stats(origin_domain); |
| 86 COMMIT; | 110 COMMIT; |
| OLD | NEW |