chrome/test/data/History/history.21.sql - Issue 10067030: Upgrade the history database to version 23

Side by Side Diff

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Keyboard Shortcuts

	File
u :	up to issue
j / k :	jump to file after / before current file
J / K :	jump to next file with a comment after / before current file
	Side-by-side diff
i :	toggle intra-line diffs
e :	expand all comments
c :	collapse all comments
s :	toggle showing all comments
n / p :	next / previous diff chunk or comment
N / P :	next / previous comment
<Up> / <Down> :	next / previous line

	Issue
u :	up to list of issues
j / k :	jump to patch after / before current patch
o / <Enter> :	open current patch in side-by-side view
i :	open current patch in unified diff view

	Issue List
j / k :	jump to issue after / before current issue
o / <Enter> :	open current issue

Side by Side Diff: chrome/test/data/History/history.21.sql

Issue 10067030: Upgrade the history database to version 23 (Closed) Base URL: http://git.chromium.org/chromium/src.git@master

Patch Set: Sync and update test data Created 8 years, 8 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:

OLD	NEW
(Empty)
	1 BEGIN TRANSACTION;

	2 CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,value LONGVARCHAR) ;

	3 INSERT INTO "meta" VALUES('version','21');

	4 INSERT INTO "meta" VALUES('last_compatible_version','16');

	5 CREATE TABLE android_urls(id INTEGER PRIMARY KEY, raw_url LONGVARCHAR, created_t ime INTEGER NOT NULL, last_visit_time INTEGER NOT NULL, url_id INTEGER NOT NULL, favicon_id INTEGER DEFAULT NULL, bookmark INTEGER DEFAULT 0);

	6 INSERT INTO "android_urls" VALUES(1,'http://google.com/',1,1,1,1,0);

	7 INSERT INTO "android_urls" VALUES(4,'www.google.com/',1,1,3,1,1);

	8 COMMIT;

	9

	10

OLD	NEW