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