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','11'); |
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, |
(...skipping 54 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
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 |