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