21 lines
925 B
Plaintext
21 lines
925 B
Plaintext
moz_icons
|
|
moz_pages_w_icons
|
|
moz_icons_to_pages
|
|
sqlite_stat1
|
|
Table: moz_icons
|
|
Create Statement:
|
|
CREATE TABLE moz_icons ( id INTEGER PRIMARY KEY, icon_url TEXT NOT NULL, fixed_icon_url_hash INTEGER NOT NULL, width INTEGER NOT NULL DEFAULT 0, root INTEGER NOT NULL DEFAULT 0, color INTEGER, expire_ms INTEGER NOT NULL DEFAULT 0, data BLOB )
|
|
|
|
Table: moz_pages_w_icons
|
|
Create Statement:
|
|
CREATE TABLE moz_pages_w_icons ( id INTEGER PRIMARY KEY, page_url TEXT NOT NULL, page_url_hash INTEGER NOT NULL )
|
|
|
|
Table: moz_icons_to_pages
|
|
Create Statement:
|
|
CREATE TABLE moz_icons_to_pages ( page_id INTEGER NOT NULL, icon_id INTEGER NOT NULL, expire_ms INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (page_id, icon_id), FOREIGN KEY (page_id) REFERENCES moz_pages_w_icons ON DELETE CASCADE, FOREIGN KEY (icon_id) REFERENCES moz_icons ON DELETE CASCADE ) WITHOUT ROWID
|
|
|
|
Table: sqlite_stat1
|
|
Create Statement:
|
|
CREATE TABLE sqlite_stat1(tbl,idx,stat)
|
|
|