components/test/data/password_manager/login_db_v9.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','9');
   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 display_name VARCHAR,
  27 avatar_url VARCHAR,
  28 federation_url VARCHAR,
  29 is_zero_click INTEGER,
  30 UNIQUE (origin_url, username_element, username_value, password_element, submit_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 */
  40 1, /* ssl_valid */
  41 1, /* preferred */
  42 13047429345000000, /* date_created */
  43 0, /* blacklisted_by_user */
  44 0, /* scheme */
  45 0, /* password_type */
  46 X'00000000', /* possible_usernames */
  47 1, /* times_used */
  48 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
  49 NULL, /* use_additional_auth */
  50 0, /* date_synced */
  51 '', /* display_name */
  52 '', /* avatar_url */
  53 '', /* federation_url */
  54 0  /* is_zero_click */
  55 );
  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 '', /* submit_element */
  64 'https://accounts.google.com/', /* signon_realm */
  65 1, /* ssl_valid */
  66 1, /* preferred */
  67 13047423600000000, /* date_created */
  68 0, /* blacklisted_by_user */
  69 0, /* scheme */
  70 0, /* password_type */
  71 X'00000000', /* possible_usernames */
  72 1, /* times_used */
  73 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
  74 NULL, /* use_additional_auth */
  75 0, /* date_synced */
  76 '', /* display_name */
  77 'https://www.google.com/icon', /* avatar_url */
  78 '', /* federation_url */
  79 0  /* is_zero_click */
  80 );
  81 CREATE INDEX logins_signon ON logins (signon_realm);
  82 COMMIT;
  83