| 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','14'); | 4 INSERT INTO "meta" VALUES('last_compatible_version','14'); |
| 5 INSERT INTO "meta" VALUES('version','15'); | 5 INSERT INTO "meta" VALUES('version','17'); |
| 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 64 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 80 ); | 80 ); |
| 81 CREATE INDEX logins_signon ON logins (signon_realm); | 81 CREATE INDEX logins_signon ON logins (signon_realm); |
| 82 CREATE TABLE stats ( | 82 CREATE TABLE stats ( |
| 83 origin_domain VARCHAR NOT NULL, | 83 origin_domain VARCHAR NOT NULL, |
| 84 username_value VARCHAR, | 84 username_value VARCHAR, |
| 85 dismissal_count INTEGER, | 85 dismissal_count INTEGER, |
| 86 update_time INTEGER NOT NULL, | 86 update_time INTEGER NOT NULL, |
| 87 UNIQUE(origin_domain, username_value)); | 87 UNIQUE(origin_domain, username_value)); |
| 88 CREATE INDEX stats_origin ON stats(origin_domain); | 88 CREATE INDEX stats_origin ON stats(origin_domain); |
| 89 COMMIT; | 89 COMMIT; |
| OLD | NEW |