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 |