components/test/data/password_manager/login_db_v6.sql

   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','1');
   5 INSERT INTO "meta" VALUES('version','6');
   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 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,
  22 times_used INTEGER,
  23 form_data BLOB,
  24 use_additional_auth INTEGER,
  25 date_synced INTEGER,
  26 UNIQUE (origin_url, username_element, username_value, password_element, submit_element, signon_realm));
  27 INSERT INTO "logins" VALUES(
  28 'https://accounts.google.com/ServiceLogin', /* origin_url */
  29 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
  30 'Email', /* username_element */
  31 'theerikchen', /* username_value */
  32 'Passwd', /* password_element */
  33 X'', /* password_value */
  34 '', /* submit_element */
  35 'https://accounts.google.com/', /* signon_realm */
  36 1, /* ssl_valid */
  37 1, /* preferred */
  38 1402955745, /* date_created */
  39 0, /* blacklisted_by_user */
  40 0, /* scheme */
  41 0, /* password_type */
  42 X'00000000', /* possible_usernames */
  43 1, /* times_used */
  44 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
  45 NULL, /* use_additional_auth */
  46 0 /* date_synced */
  47 );
  48 INSERT INTO "logins" VALUES(
  49 'https://accounts.google.com/ServiceLogin', /* origin_url */
  50 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
  51 'Email', /* username_element */
  52 'theerikchen2', /* username_value */
  53 'Passwd', /* password_element */
  54 X'', /* password_value */
  55 '', /* submit_element */
  56 'https://accounts.google.com/', /* signon_realm */
  57 1, /* ssl_valid */
  58 1, /* preferred */
  59 1402950000, /* date_created */
  60 0, /* blacklisted_by_user */
  61 0, /* scheme */
  62 0, /* password_type */
  63 X'00000000', /* possible_usernames */
  64 1, /* times_used */
  65 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
  66 NULL, /* use_additional_auth */
  67 0 /* date_synced */
  68 );
  69 CREATE INDEX logins_signon ON logins (signon_realm);
  70 COMMIT;
  71