Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(13)

Side by Side Diff: components/test/data/password_manager/login_db_v1.sql

Issue 808173002: Add tests for version migration tesing in for LoginDatabase. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: Created 5 years, 11 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
OLDNEW
(Empty)
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','1');
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 UNIQUE (origin_url, username_element, username_value, password_element, submit_e lement, signon_realm));
21 INSERT INTO "logins" VALUES(
22 'https://accounts.google.com/ServiceLogin', /* origin_url */
23 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
24 'Email', /* username_element */
25 'theerikchen', /* username_value */
26 'Passwd', /* password_element */
27 X'', /* password_value */
28 '', /* submit_element */
29 'https://accounts.google.com/', /* signon_realm */
30 1, /* ssl_valid */
31 1, /* preferred */
32 1402955745, /* date_created */
33 0, /* blacklisted_by_user */
34 0 /* scheme */
35 );
36 INSERT INTO "logins" VALUES(
37 'https://accounts.google.com/ServiceLogin', /* origin_url */
38 'https://accounts.google.com/ServiceLoginAuth', /* action_url */
39 'Email', /* username_element */
40 'theerikchen2', /* username_value */
41 'Passwd', /* password_element */
42 X'', /* password_value */
43 '', /* submit_element */
44 'https://accounts.google.com/', /* signon_realm */
45 1, /* ssl_valid */
46 1, /* preferred */
47 1402950000, /* date_created */
48 0, /* blacklisted_by_user */
49 0 /* scheme */
50 );
51 CREATE INDEX logins_signon ON logins (signon_realm);
52 COMMIT;
53
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698