Merge Chromium + Blink git repositories
[chromium-blink-merge.git] / components / test / data / password_manager / login_db_v2.sql
blobd9776c5059ded8292148e99f67d276ef6fe0e0f9
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','2');
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 UNIQUE (origin_url, username_element, username_value, password_element, submit_element, signon_realm));
23 INSERT INTO "logins" VALUES(
24 'https://accounts.google.com/ServiceLogin', /* origin_url */
25 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
26 'Email', /* username_element */
27 'theerikchen', /* username_value */
28 'Passwd', /* password_element */
29 X'', /* password_value */
30 '', /* submit_element */
31 'https://accounts.google.com/', /* signon_realm */
32 1, /* ssl_valid */
33 1, /* preferred */
34 1402955745, /* date_created */
35 0, /* blacklisted_by_user */
36 0, /* scheme */
37 0, /* password_type */
38 X'00000000' /* possible_usernames */
40 INSERT INTO "logins" VALUES(
41 'https://accounts.google.com/ServiceLogin', /* origin_url */
42 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
43 'Email', /* username_element */
44 'theerikchen2', /* username_value */
45 'Passwd', /* password_element */
46 X'', /* password_value */
47 '', /* submit_element */
48 'https://accounts.google.com/', /* signon_realm */
49 1, /* ssl_valid */
50 1, /* preferred */
51 1402950000, /* date_created */
52 0, /* blacklisted_by_user */
53 0, /* scheme */
54 0, /* password_type */
55 X'00000000' /* possible_usernames */
57 CREATE INDEX logins_signon ON logins (signon_realm);
58 COMMIT;