1PRAGMA foreign_keys=OFF;
2BEGIN TRANSACTION;
3CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);
4INSERT INTO "meta" VALUES('last_compatible_version','19');
5INSERT INTO "meta" VALUES('version','22');
6CREATE TABLE logins (
7origin_url VARCHAR NOT NULL,
8action_url VARCHAR,
9username_element VARCHAR,
10username_value VARCHAR,
11password_element VARCHAR,
12password_value BLOB,
13submit_element VARCHAR,
14signon_realm VARCHAR NOT NULL,
15preferred INTEGER NOT NULL,
16date_created INTEGER NOT NULL,
17blacklisted_by_user INTEGER NOT NULL,
18scheme INTEGER NOT NULL,
19password_type INTEGER,
20times_used INTEGER,
21form_data BLOB,
22date_synced INTEGER,
23display_name VARCHAR,
24icon_url VARCHAR,
25federation_url VARCHAR,
26skip_zero_click INTEGER,
27generation_upload_status INTEGER,
28possible_username_pairs BLOB,
29id INTEGER,
30UNIQUE (origin_url, username_element, username_value, password_element, signon_realm),
31PRIMARY KEY (id));
32INSERT INTO "logins" (origin_url,action_url,username_element,username_value,password_element,password_value,submit_element,signon_realm,preferred,date_created,blacklisted_by_user,scheme,password_type,times_used,form_data,date_synced,display_name,icon_url,federation_url,skip_zero_click,generation_upload_status,possible_username_pairs) VALUES(
33'https://accounts.google.com/ServiceLogin', /* origin_url */
34'https://accounts.google.com/ServiceLoginAuth', /* action_url */
35'Email', /* username_element */
36'theerikchen', /* username_value */
37'Passwd', /* password_element */
38X'', /* password_value */
39'', /* submit_element */
40'https://accounts.google.com/', /* signon_realm */
411, /* preferred */
4213047429345000000, /* date_created */
430, /* blacklisted_by_user */
440, /* scheme */
450, /* password_type */
461, /* times_used */
47X'18000000020000000000000000000000000000000000000000000000', /* form_data */
480, /* date_synced */
49'', /* display_name */
50'', /* icon_url */
51'', /* federation_url */
521,  /* skip_zero_click */
530,  /* generation_upload_status */
54X'00000000' /* possible_username_pairs */
55);
56INSERT INTO "logins" (origin_url,action_url,username_element,username_value,password_element,password_value,submit_element,signon_realm,preferred,date_created,blacklisted_by_user,scheme,password_type,times_used,form_data,date_synced,display_name,icon_url,federation_url,skip_zero_click,generation_upload_status,possible_username_pairs) 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 */
62X'', /* password_value */
63'non-empty', /* submit_element */
64'https://accounts.google.com/', /* signon_realm */
651, /* preferred */
6613047423600000000, /* date_created */
670, /* blacklisted_by_user */
680, /* scheme */
690, /* password_type */
701, /* times_used */
71X'18000000020000000000000000000000000000000000000000000000', /* form_data */
720, /* date_synced */
73'', /* display_name */
74'https://www.google.com/icon', /* icon_url */
75'', /* federation_url */
761,  /* skip_zero_click */
770,  /* generation_upload_status */
78X'00000000' /* possible_username_pairs */
79);
80INSERT INTO "logins" (origin_url,action_url,username_element,username_value,password_element,password_value,submit_element,signon_realm,preferred,date_created,blacklisted_by_user,scheme,password_type,times_used,form_data,date_synced,display_name,icon_url,federation_url,skip_zero_click,generation_upload_status,possible_username_pairs) VALUES(
81'http://example.com', /* origin_url */
82'http://example.com/landing', /* action_url */
83'', /* username_element */
84'user', /* username_value */
85'', /* password_element */
86X'', /* password_value */
87'non-empty', /* submit_element */
88'http://example.com', /* signon_realm */
891, /* preferred */
9013047423600000000, /* date_created */
910, /* blacklisted_by_user */
921, /* scheme */
930, /* password_type */
941, /* times_used */
95X'18000000020000000000000000000000000000000000000000000000', /* form_data */
960, /* date_synced */
97'', /* display_name */
98'https://www.google.com/icon', /* icon_url */
99'', /* federation_url */
1001,  /* skip_zero_click */
1010,  /* generation_upload_status */
102X'00000000' /* possible_username_pairs */
103);
104CREATE INDEX logins_signon ON logins (signon_realm);
105CREATE TABLE stats (
106origin_domain VARCHAR NOT NULL,
107username_value VARCHAR,
108dismissal_count INTEGER,
109update_time INTEGER NOT NULL,
110UNIQUE(origin_domain, username_value));
111CREATE INDEX stats_origin ON stats(origin_domain);
112CREATE TABLE sync_entities_metadata (
113  storage_key INTEGER,
114  metadata VARCHAR NOT NULL,
115  PRIMARY KEY (storage_key)
116);
117CREATE TABLE sync_model_metadata (
118  id INTEGER,
119  metadata VARCHAR NOT NULL,
120  PRIMARY KEY (id)
121);
122COMMIT;
123