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','18'); |
| 5 INSERT INTO "meta" VALUES('version','18'); |
| 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 preferred INTEGER NOT NULL, |
| 16 date_created INTEGER NOT NULL, |
| 17 blacklisted_by_user INTEGER NOT NULL, |
| 18 scheme INTEGER NOT NULL, |
| 19 password_type INTEGER, |
| 20 times_used INTEGER, |
| 21 form_data BLOB, |
| 22 date_synced INTEGER, |
| 23 display_name VARCHAR, |
| 24 icon_url VARCHAR, |
| 25 federation_url VARCHAR, |
| 26 skip_zero_click INTEGER, |
| 27 generation_upload_status INTEGER, |
| 28 possible_username_pairs BLOB, |
| 29 UNIQUE (origin_url, username_element, username_value, password_element, signon_r
ealm)); |
| 30 INSERT INTO "logins" VALUES( |
| 31 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
| 32 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
| 33 'Email', /* username_element */ |
| 34 'theerikchen', /* username_value */ |
| 35 'Passwd', /* password_element */ |
| 36 X'', /* password_value */ |
| 37 '', /* submit_element */ |
| 38 'https://accounts.google.com/', /* signon_realm */ |
| 39 1, /* preferred */ |
| 40 13047429345000000, /* date_created */ |
| 41 0, /* blacklisted_by_user */ |
| 42 0, /* scheme */ |
| 43 0, /* password_type */ |
| 44 1, /* times_used */ |
| 45 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 46 0, /* date_synced */ |
| 47 '', /* display_name */ |
| 48 '', /* icon_url */ |
| 49 '', /* federation_url */ |
| 50 1, /* skip_zero_click */ |
| 51 0, /* generation_upload_status */ |
| 52 X'00000000' /* possible_username_pairs */ |
| 53 ); |
| 54 INSERT INTO "logins" VALUES( |
| 55 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
| 56 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
| 57 'Email', /* username_element */ |
| 58 'theerikchen2', /* username_value */ |
| 59 'Passwd', /* password_element */ |
| 60 X'', /* password_value */ |
| 61 'non-empty', /* submit_element */ |
| 62 'https://accounts.google.com/', /* signon_realm */ |
| 63 1, /* preferred */ |
| 64 13047423600000000, /* date_created */ |
| 65 0, /* blacklisted_by_user */ |
| 66 0, /* scheme */ |
| 67 0, /* password_type */ |
| 68 1, /* times_used */ |
| 69 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 70 0, /* date_synced */ |
| 71 '', /* display_name */ |
| 72 'https://www.google.com/icon', /* icon_url */ |
| 73 '', /* federation_url */ |
| 74 1, /* skip_zero_click */ |
| 75 0, /* generation_upload_status */ |
| 76 X'00000000' /* possible_username_pairs */ |
| 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 1, /* times_used */ |
| 93 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
| 94 0, /* date_synced */ |
| 95 '', /* display_name */ |
| 96 'https://www.google.com/icon', /* icon_url */ |
| 97 '', /* federation_url */ |
| 98 1, /* skip_zero_click */ |
| 99 0, /* generation_upload_status */ |
| 100 X'00000000' /* possible_username_pairs */ |
| 101 ); |
| 102 CREATE INDEX logins_signon ON logins (signon_realm); |
| 103 CREATE TABLE stats ( |
| 104 origin_domain VARCHAR NOT NULL, |
| 105 username_value VARCHAR, |
| 106 dismissal_count INTEGER, |
| 107 update_time INTEGER NOT NULL, |
| 108 UNIQUE(origin_domain, username_value)); |
| 109 CREATE INDEX stats_origin ON stats(origin_domain); |
| 110 COMMIT; |
OLD | NEW |