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

Side by Side Diff: components/test/data/history/history.31.sql

Issue 1924473003: [Downloads] Use the initiating StoragePartition for resumption. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: Fix typo in comment Created 4 years, 7 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
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('version','30'); 4 INSERT INTO "meta" VALUES('version','31');
5 INSERT INTO "meta" VALUES('last_compatible_version','16'); 5 INSERT INTO "meta" VALUES('last_compatible_version','16');
6 CREATE TABLE urls(id INTEGER PRIMARY KEY,url LONGVARCHAR,title LONGVARCHAR,visit _count INTEGER DEFAULT 0 NOT NULL,typed_count INTEGER DEFAULT 0 NOT NULL,last_vi sit_time INTEGER NOT NULL,hidden INTEGER DEFAULT 0 NOT NULL,favicon_id INTEGER D EFAULT 0 NOT NULL); 6 CREATE TABLE urls(id INTEGER PRIMARY KEY,url LONGVARCHAR,title LONGVARCHAR,visit _count INTEGER DEFAULT 0 NOT NULL,typed_count INTEGER DEFAULT 0 NOT NULL,last_vi sit_time INTEGER NOT NULL,hidden INTEGER DEFAULT 0 NOT NULL,favicon_id INTEGER D EFAULT 0 NOT NULL);
7 CREATE TABLE visits(id INTEGER PRIMARY KEY,url INTEGER NOT NULL,visit_time INTEG ER NOT NULL,from_visit INTEGER,transition INTEGER DEFAULT 0 NOT NULL,segment_id INTEGER,visit_duration INTEGER DEFAULT 0 NOT NULL); 7 CREATE TABLE visits(id INTEGER PRIMARY KEY,url INTEGER NOT NULL,visit_time INTEG ER NOT NULL,from_visit INTEGER,transition INTEGER DEFAULT 0 NOT NULL,segment_id INTEGER,visit_duration INTEGER DEFAULT 0 NOT NULL);
8 CREATE TABLE visit_source(id INTEGER PRIMARY KEY,source INTEGER NOT NULL); 8 CREATE TABLE visit_source(id INTEGER PRIMARY KEY,source INTEGER NOT NULL);
9 CREATE TABLE keyword_search_terms (keyword_id INTEGER NOT NULL,url_id INTEGER NO T NULL,lower_term LONGVARCHAR NOT NULL,term LONGVARCHAR NOT NULL); 9 CREATE TABLE keyword_search_terms (keyword_id INTEGER NOT NULL,url_id INTEGER NO T NULL,lower_term LONGVARCHAR NOT NULL,term LONGVARCHAR NOT NULL);
10 CREATE TABLE downloads (id INTEGER PRIMARY KEY,guid VARCHAR NOT NULL,current_pat h LONGVARCHAR NOT NULL,target_path LONGVARCHAR NOT NULL,start_time INTEGER NOT N ULL,received_bytes INTEGER NOT NULL,total_bytes INTEGER NOT NULL,state INTEGER N OT NULL,danger_type INTEGER NOT NULL,interrupt_reason INTEGER NOT NULL,hash BLOB NOT NULL,end_time INTEGER NOT NULL,opened INTEGER NOT NULL,referrer VARCHAR NOT NULL,http_method VARCHAR NOT NULL,by_ext_id VARCHAR NOT NULL,by_ext_name VARCHA R NOT NULL,etag VARCHAR NOT NULL,last_modified VARCHAR NOT NULL,mime_type VARCHA R(255) NOT NULL,original_mime_type VARCHAR(255) NOT NULL); 10 CREATE TABLE downloads (id INTEGER PRIMARY KEY,guid VARCHAR NOT NULL,current_pat h LONGVARCHAR NOT NULL,target_path LONGVARCHAR NOT NULL,start_time INTEGER NOT N ULL,received_bytes INTEGER NOT NULL,total_bytes INTEGER NOT NULL,state INTEGER N OT NULL,danger_type INTEGER NOT NULL,interrupt_reason INTEGER NOT NULL,hash BLOB NOT NULL,end_time INTEGER NOT NULL,opened INTEGER NOT NULL,referrer VARCHAR NOT NULL,tab_url VARCHAR NOT NULL,tab_referrer_url VARCHAR NOT NULL,http_method VAR CHAR NOT NULL,by_ext_id VARCHAR NOT NULL,by_ext_name VARCHAR NOT NULL,etag VARCH AR NOT NULL,last_modified VARCHAR NOT NULL,mime_type VARCHAR(255) NOT NULL,origi nal_mime_type VARCHAR(255) NOT NULL);
11 CREATE TABLE downloads_url_chains (id INTEGER NOT NULL,chain_index INTEGER NOT N ULL,url LONGVARCHAR NOT NULL, PRIMARY KEY (id, chain_index) ); 11 CREATE TABLE downloads_url_chains (id INTEGER NOT NULL,chain_index INTEGER NOT N ULL,url LONGVARCHAR NOT NULL, PRIMARY KEY (id, chain_index) );
12 CREATE TABLE segments (id INTEGER PRIMARY KEY,name VARCHAR,url_id INTEGER NON NU LL); 12 CREATE TABLE segments (id INTEGER PRIMARY KEY,name VARCHAR,url_id INTEGER NON NU LL);
13 CREATE TABLE segment_usage (id INTEGER PRIMARY KEY,segment_id INTEGER NOT NULL,t ime_slot INTEGER NOT NULL,visit_count INTEGER DEFAULT 0 NOT NULL); 13 CREATE TABLE segment_usage (id INTEGER PRIMARY KEY,segment_id INTEGER NOT NULL,t ime_slot INTEGER NOT NULL,visit_count INTEGER DEFAULT 0 NOT NULL);
14 CREATE INDEX visits_url_index ON visits (url); 14 CREATE INDEX visits_url_index ON visits (url);
15 CREATE INDEX visits_from_index ON visits (from_visit); 15 CREATE INDEX visits_from_index ON visits (from_visit);
16 CREATE INDEX visits_time_index ON visits (visit_time); 16 CREATE INDEX visits_time_index ON visits (visit_time);
17 CREATE INDEX segments_name ON segments(name); 17 CREATE INDEX segments_name ON segments(name);
18 CREATE INDEX segments_url_id ON segments(url_id); 18 CREATE INDEX segments_url_id ON segments(url_id);
19 CREATE INDEX segment_usage_time_slot_segment_id ON segment_usage(time_slot, segm ent_id); 19 CREATE INDEX segment_usage_time_slot_segment_id ON segment_usage(time_slot, segm ent_id);
20 CREATE INDEX segments_usage_seg_id ON segment_usage(segment_id); 20 CREATE INDEX segments_usage_seg_id ON segment_usage(segment_id);
21 CREATE INDEX urls_url_index ON urls (url); 21 CREATE INDEX urls_url_index ON urls (url);
22 CREATE INDEX keyword_search_terms_index1 ON keyword_search_terms (keyword_id, lo wer_term); 22 CREATE INDEX keyword_search_terms_index1 ON keyword_search_terms (keyword_id, lo wer_term);
23 CREATE INDEX keyword_search_terms_index2 ON keyword_search_terms (url_id); 23 CREATE INDEX keyword_search_terms_index2 ON keyword_search_terms (url_id);
24 CREATE INDEX keyword_search_terms_index3 ON keyword_search_terms (term); 24 CREATE INDEX keyword_search_terms_index3 ON keyword_search_terms (term);
25 COMMIT; 25 COMMIT;
OLDNEW
« no previous file with comments | « components/history/core/test/history_backend_db_base_test.cc ('k') | content/browser/download/download_browsertest.cc » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698