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','9'); | 5 INSERT INTO "meta" VALUES('version','9'); |
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 37 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... | |
48 0, /* date_synced */ | 48 0, /* date_synced */ |
49 '', /* display_name */ | 49 '', /* display_name */ |
50 '', /* avatar_url */ | 50 '', /* avatar_url */ |
51 '', /* federation_url */ | 51 '', /* federation_url */ |
52 0 /* is_zero_click */ | 52 0 /* is_zero_click */ |
53 ); | 53 ); |
54 INSERT INTO "logins" VALUES( | 54 INSERT INTO "logins" VALUES( |
55 'https://accounts.google.com/ServiceLogin', /* origin_url */ | 55 'https://accounts.google.com/ServiceLogin', /* origin_url */ |
56 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ | 56 'https://accounts.google.com/ServiceLoginAuth', /* action_url */ |
57 'Email', /* username_element */ | 57 'Email', /* username_element */ |
58 'theerikchen2', /* username_value */ | 58 'theerikchen', /* username_value */ |
Mike West
2015/02/03 14:15:41
Why this change?
vasilii
2015/02/03 19:49:18
I can leave it as it was before. But the test won'
| |
59 'Passwd', /* password_element */ | 59 'Passwd', /* password_element */ |
60 X'', /* password_value */ | 60 X'', /* password_value */ |
61 '', /* submit_element */ | 61 'non-empty', /* submit_element */ |
Mike West
2015/02/03 14:15:41
And this one?
vasilii
2015/02/03 19:49:17
The 2 forms here have the same (origin_url, userna
| |
62 'https://accounts.google.com/', /* signon_realm */ | 62 'https://accounts.google.com/', /* signon_realm */ |
63 1, /* ssl_valid */ | 63 1, /* ssl_valid */ |
64 1, /* preferred */ | 64 1, /* preferred */ |
65 13047423600000000, /* date_created */ | 65 13047423600000000, /* date_created */ |
66 0, /* blacklisted_by_user */ | 66 0, /* blacklisted_by_user */ |
67 0, /* scheme */ | 67 0, /* scheme */ |
68 0, /* password_type */ | 68 0, /* password_type */ |
69 X'00000000', /* possible_usernames */ | 69 X'00000000', /* possible_usernames */ |
70 1, /* times_used */ | 70 1, /* times_used */ |
71 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ | 71 X'18000000020000000000000000000000000000000000000000000000', /* form_data */ |
72 0, /* date_synced */ | 72 0, /* date_synced */ |
73 '', /* display_name */ | 73 '', /* display_name */ |
74 '', /* avatar_url */ | 74 '', /* avatar_url */ |
75 '', /* federation_url */ | 75 '', /* federation_url */ |
76 0 /* is_zero_click */ | 76 0 /* is_zero_click */ |
77 ); | 77 ); |
78 CREATE INDEX logins_signon ON logins (signon_realm); | 78 CREATE INDEX logins_signon ON logins (signon_realm); |
79 COMMIT; | 79 COMMIT; |
OLD | NEW |