Tables
urls
CREATE TABLE urls(
id INTEGER PRIMARY KEY AUTOINCREMENT,
url LONGVARCHAR,
title LONGVARCHAR,
visit_count INTEGER DEFAULT 0 NOT NULL,
typed_count INTEGER DEFAULT 0 NOT NULL,
last_visit_time INTEGER NOT NULL,
hidden INTEGER DEFAULT 0 NOT NULL
);
CREATE INDEX urls_url_index ON urls (url)
visits
CREATE TABLE visits(
id INTEGER PRIMARY KEY,
url INTEGER NOT NULL,
visit_time INTEGER NOT NULL,
from_visit INTEGER,
transition INTEGER DEFAULT 0 NOT NULL,
segment_id INTEGER,
visit_duration INTEGER DEFAULT 0 NOT NULL,
incremented_omnibox_typed_score BOOLEAN DEFAULT FALSE NOT NULL,
publicly_routable BOOLEAN DEFAULT FALSE NOT NULL
);
CREATE INDEX visits_url_index ON visits (url)
CREATE INDEX visits_from_index ON visits (from_visit)
CREATE INDEX visits_time_index ON visits (visit_time)
content_annotations
CREATE TABLE content_annotations (
visit_id INTEGER PRIMARY KEY,
floc_protected_score DECIMAL(3, 2),
categories VARCHAR,
page_topics_model_version INTEGER,
annotation_flags INTEGER DEFAULT 0 NOT NULL
);
segments
CREATE TABLE segments (
id INTEGER PRIMARY KEY,
name VARCHAR,
url_id INTEGER NON NULL
);
CREATE INDEX segments_name ON segments(name );
CREATE INDEX segments_url_id ON segments(url_id);
meta
CREATE TABLE meta(
key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY,
value LONGVARCHAR
);
-- sqlite_autoindex_meta_1 (index)
PS> select-winSQLiteDB ( get-chromeHistoryFile ) "select * from meta limit 10"
key value
--- -----
mmap_status -1
last_compatible_version 16
version 44
early_expiration_threshold 13264157229637931
visit_source
CREATE TABLE visit_source(
id INTEGER PRIMARY KEY,
source INTEGER NOT NULL
);
keyword_search_terms
CREATE TABLE keyword_search_terms (
keyword_id INTEGER NOT NULL,
url_id INTEGER NOT NULL,
term LONGVARCHAR NOT NULL,
normalized_term LONGVARCHAR NOT NULL
);
CREATE INDEX keyword_search_terms_index1 ON keyword_search_terms (keyword_id, normalized_term)
CREATE INDEX keyword_search_terms_index2 ON keyword_search_terms (url_id)
CREATE INDEX keyword_search_terms_index3 ON keyword_search_terms (term)
downloads
CREATE TABLE downloads (
id INTEGER PRIMARY KEY,
guid VARCHAR NOT NULL,
current_path LONGVARCHAR NOT NULL,
target_path LONGVARCHAR NOT NULL,
start_time INTEGER NOT NULL,
received_bytes INTEGER NOT NULL,
total_bytes INTEGER NOT NULL,
state INTEGER NOT NULL,
danger_type INTEGER NOT NULL,
interrupt_reason INTEGER NOT NULL,
hash BLOB NOT NULL,
end_time INTEGER NOT NULL,
opened INTEGER NOT NULL,
last_access_time INTEGER NOT NULL,
transient INTEGER NOT NULL,
referrer VARCHAR NOT NULL,
site_url VARCHAR NOT NULL,
tab_url VARCHAR NOT NULL,
tab_referrer_url VARCHAR NOT NULL,
http_method VARCHAR NOT NULL,
by_ext_id VARCHAR NOT NULL,
by_ext_name VARCHAR NOT NULL,
etag VARCHAR NOT NULL,
last_modified VARCHAR NOT NULL,
mime_type VARCHAR(255) NOT NULL,
original_mime_type VARCHAR(255) NOT NULL
);
downloads_url_chains
CREATE TABLE downloads_url_chains (
id INTEGER NOT NULL,
chain_index INTEGER NOT NULL,
url LONGVARCHAR NOT NULL,
PRIMARY KEY (id, chain_index)
);
-- sqlite_autoindex_downloads_url_chains_1 (index)
downloads_slices
CREATE TABLE downloads_slices (
download_id INTEGER NOT NULL,
offset INTEGER NOT NULL,
received_bytes INTEGER NOT NULL,
finished INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY (download_id, offset)
)
-- sqlite_autoindex_downloads_slices_1 (index)
segment_usage
CREATE TABLE segment_usage (
id INTEGER PRIMARY KEY,
segment_id INTEGER NOT NULL,
time_slot INTEGER NOT NULL,
visit_count INTEGER DEFAULT 0 NOT NULL
);
CREATE INDEX segment_usage_time_slot_segment_id ON segment_usage(time_slot, segment_id)
CREATE INDEX segments_usage_seg_id ON segment_usage(segment_id)
typed_url_sync_metadata
CREATE TABLE typed_url_sync_metadata (storage_key INTEGER PRIMARY KEY NOT NULL,value BLOB)