components/test/data/password_manager/login_db_v11.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','11');
   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 date_synced INTEGER,
  25 display_name VARCHAR,
  26 avatar_url VARCHAR,
  27 federation_url VARCHAR,
  28 skip_zero_click INTEGER,
  29 UNIQUE (origin_url, username_element, username_value, password_element, signon_realm));
  30 INSERT INTO "logins" VALUES(
  31 'https://accounts.google.com/ServiceLogin', /* origin_url */
  32 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
  33 'Email', /* username_element */
  34 'theerikchen', /* username_value */
  35 'Passwd', /* password_element */
  36 X'', /* password_value */
  37 '', /* submit_element */
  38 'https://accounts.google.com/', /* signon_realm */
  39 1, /* ssl_valid */
  40 1, /* preferred */
  41 13047429345000000, /* date_created */
  42 0, /* blacklisted_by_user */
  43 0, /* scheme */
  44 0, /* password_type */
  45 X'00000000', /* possible_usernames */
  46 1, /* times_used */
  47 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
  48 0, /* date_synced */
  49 '', /* display_name */
  50 '', /* avatar_url */
  51 '', /* federation_url */
  52 0  /* skip_zero_click */
  53 );
  54 INSERT INTO "logins" VALUES(
  55 'https://accounts.google.com/ServiceLogin', /* origin_url */
  56 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
  57 'Email', /* username_element */
  58 'theerikchen2', /* username_value */
  59 'Passwd', /* password_element */
  60 X'', /* password_value */
  61 'non-empty', /* submit_element */
  62 'https://accounts.google.com/', /* signon_realm */
  63 1, /* ssl_valid */
  64 1, /* preferred */
  65 13047423600000000, /* date_created */
  66 0, /* blacklisted_by_user */
  67 0, /* scheme */
  68 0, /* password_type */
  69 X'00000000', /* possible_usernames */
  70 1, /* times_used */
  71 X'18000000020000000000000000000000000000000000000000000000', /* form_data */
  72 0, /* date_synced */
  73 '', /* display_name */
  74 'https://www.google.com/icon', /* avatar_url */
  75 '', /* federation_url */
  76 0  /* skip_zero_click */
  77 );
  78 CREATE INDEX logins_signon ON logins (signon_realm);
  79 COMMIT;