1 PRAGMA foreign_keys=OFF;
3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);
4 INSERT INTO "meta" VALUES('last_compatible_version','1');
5 INSERT INTO "meta" VALUES('version','12');
7 origin_url VARCHAR NOT NULL,
9 username_element VARCHAR,
10 username_value VARCHAR,
11 password_element VARCHAR,
13 submit_element VARCHAR,
14 signon_realm VARCHAR NOT NULL,
15 ssl_valid INTEGER NOT NULL,
16 preferred INTEGER NOT NULL,
17 date_created INTEGER NOT NULL,
18 blacklisted_by_user INTEGER NOT NULL,
19 scheme INTEGER NOT NULL,
20 password_type INTEGER,
21 possible_usernames BLOB,
27 federation_url VARCHAR,
28 skip_zero_click INTEGER,
29 generation_upload_status INTEGER,
30 UNIQUE (origin_url, username_element, username_value, password_element, signon_realm));
31 INSERT INTO "logins" VALUES(
32 'https://accounts.google.com/ServiceLogin', /* origin_url */
33 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
34 'Email', /* username_element */
35 'theerikchen', /* username_value */
36 'Passwd', /* password_element */
37 X'', /* password_value */
38 '', /* submit_element */
39 'https://accounts.google.com/', /* signon_realm */
42 13047429345000000, /* date_created */
43 0, /* blacklisted_by_user */
45 0, /* password_type */
46 X'00000000', /* possible_usernames */
48 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
50 '', /* display_name */
52 '', /* federation_url */
53 0, /* skip_zero_click */
54 0 /* generation_upload_status */
56 INSERT INTO "logins" VALUES(
57 'https://accounts.google.com/ServiceLogin', /* origin_url */
58 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
59 'Email', /* username_element */
60 'theerikchen2', /* username_value */
61 'Passwd', /* password_element */
62 X'', /* password_value */
63 'non-empty', /* submit_element */
64 'https://accounts.google.com/', /* signon_realm */
67 13047423600000000, /* date_created */
68 0, /* blacklisted_by_user */
70 0, /* password_type */
71 X'00000000', /* possible_usernames */
73 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
75 '', /* display_name */
76 'https://www.google.com/icon', /* avatar_url */
77 '', /* federation_url */
78 0, /* skip_zero_click */
79 0 /* generation_upload_status */
81 CREATE INDEX logins_signon ON logins (signon_realm);