Static | ZeroBOX

SQLite format 3

tSQLite format 3

5tablepinned_tilespinned_tiles

CREATE TABLE pinned_tiles (hashed_tile_key BLOB NOT NULL, pin_id BLOB NOT NULL, create_time INTEGER NOT NULL, PRIMARY KEY (hashed_tile_key, pin_id))7

indexsqlite_autoindex_pinned_tiles_1pinned_tiles

indexix_tile_cache_expirationtiles

CREATE INDEX ix_tile_cache_expiration ON tiles(expiration_time)G

cindexix_prioritytiles

CREATE INDEX ix_priority ON tiles(priority)

5tabletilestiles

CREATE TABLE tiles (layer_id TEXT NOT NULL, hashed_tile_key BLOB NOT NULL, metadata_nonce BLOB NOT NULL, metadata BLOB NOT NULL, expiration_time BIGINT NOT NULL, priority BIGINT NOT NULL, data_nonce BLOB NOT NULL, data BLOB NOT NULL, PRIMARY KEY (layer_id, hashed_tile_key)))

indexsqlite_autoindex_tiles_1tiles

%indexix_resource_cache_expiration_timeresources

CREATE INDEX ix_resource_cache_expiration_time ON resources(expiration_time)n

indexix_resource_cache_priorityresources

CREATE INDEX ix_resource_cache_priority ON resources(priority)

mtableresourcesresources

CREATE TABLE resources (hashed_resource_key BLOB NOT NULL, metadata_nonce BLOB NOT NULL, metadata BLOB NULL, expiration_time BLOB NULL, priority BIGINT NOT NULL, data_nonce BLOB NULL, data BLOB NOT NULL, PRIMARY KEY (hashed_resource_key))1

indexsqlite_autoindex_resources_1resources

5tablesettingssettings

CREATE TABLE settings (server_version INTEGER NOT NULL, create_time BIGINT NOT NULL)