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

Issues Search
    My Issues | Starred     Open | Closed | All

Side by Side Diff: components/test/data/password_manager/login_db_v8.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
« no previous file with comments | « components/test/data/password_manager/login_db_v7.sql ('k') | no next file » | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
1 PRAGMA foreign_keys=OFF; 1 PRAGMA foreign_keys=OFF;
2 BEGIN TRANSACTION; 2 BEGIN TRANSACTION;
3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR ); 3 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR );
4 INSERT INTO "meta" VALUES('last_compatible_version','1'); 4 INSERT INTO "meta" VALUES('last_compatible_version','1');
5 INSERT INTO "meta" VALUES('version','8'); 5 INSERT INTO "meta" VALUES('version','8');
6 CREATE TABLE logins (origin_url VARCHAR NOT NULL, action_url VARCHAR, username_e lement VARCHAR, username_value VARCHAR, password_element VARCHAR, password_value BLOB, submit_element VARCHAR, signon_realm VARCHAR NOT NULL,ssl_valid INTEGER N OT NULL,preferred INTEGER NOT NULL,date_created INTEGER NOT NULL,blacklisted_by_ user INTEGER NOT NULL,scheme INTEGER NOT NULL,password_type INTEGER,possible_use rnames BLOB,times_used INTEGER,form_data BLOB,use_additional_auth INTEGER,date_s ynced INTEGER, display_name VARCHAR, avatar_url VARCHAR, federation_url VARCHAR, is_zero_click INTEGER,UNIQUE (origin_url, username_element, username_value, pas sword_element, submit_element, signon_realm)); 6 CREATE TABLE logins (
7 INSERT INTO "logins" VALUES('https://accounts.google.com/ServiceLogin','https:// accounts.google.com/ServiceLoginAuth','Email','theerikchen','Passwd',X'','','htt ps://accounts.google.com/',1,1,1402955745,0,0,0,X'00000000',1,X'1800000002000000 0000000000000000000000000000000000000000',NULL,0,'','','',0); 7 origin_url VARCHAR NOT NULL,
8 INSERT INTO "logins" VALUES('https://accounts.google.com/ServiceLogin','https:// accounts.google.com/ServiceLoginAuth','Email','theerikchen2','Passwd',X'','','ht tps://accounts.google.com/',1,1,1402950000,0,0,0,X'00000000',1,X'180000000200000 00000000000000000000000000000000000000000',NULL,0,'','','',0); 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_e lement, 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 1402955745, /* 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 1402950000, /* 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 '', /* avatar_url */
78 '', /* federation_url */
79 0 /* is_zero_click */
80 );
9 CREATE INDEX logins_signon ON logins (signon_realm); 81 CREATE INDEX logins_signon ON logins (signon_realm);
10 COMMIT; 82 COMMIT;
11 83
OLDNEW
« no previous file with comments | « components/test/data/password_manager/login_db_v7.sql ('k') | no next file » | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698