iOS Cache.db

cache.db.sql

CREATE TABLE cfurl_cache_blob_data(
  entry_ID INTEGER PRIMARY KEY,
  response_object BLOB,
  request_object BLOB,
  proto_props BLOB,
  user_info BLOB
);
CREATE INDEX proto_props_index ON cfurl_cache_blob_data(entry_ID);

CREATE TABLE cfurl_cache_receiver_data(
  entry_ID INTEGER PRIMARY KEY,
  receiver_data BLOB
);
CREATE INDEX receiver_data_index ON cfurl_cache_receiver_data(entry_ID);

CREATE TABLE cfurl_cache_response(
  entry_ID INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE,
  version INTEGER,
  hash_value INTEGER,
  storage_policy INTEGER,
  request_key TEXT UNIQUE,
  time_stamp NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE INDEX request_key_index ON cfurl_cache_response(request_key);
CREATE INDEX time_stamp_index ON cfurl_cache_response(time_stamp);

CREATE TABLE cfurl_cache_schema_version(schema_version INTEGER);