sqlite3 /Users/dgerman/Library/Caches/com.apple.Safari/Cache.db .schema CREATE TABLE cfurl_cache_blob_data (entry_ID INTEGER PRIMARY KEY, response_object BLOB, request_object BLOB, proto_props BLOB, user_info BLOB); CREATE TABLE cfurl_cache_receiver_data (entry_ID INTEGER PRIMARY KEY, isDataOnFS INTEGER, receiver_data BLOB); 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, partition TEXT); entry_ID|version|hash_value |storage_policy|request_key| 1195993 |0 |4600284380998084695|0 |https://mts0.googleapis.com/vt?pb=!1m4!1m3!1i17!2i63262!3i42492!2m3!1e0!2sm!3i298101555!3m9!2sen!3sUS!5e18!12m1!1e47!12m3!1e37!2m1!1ssmartmaps!4e0[google.com] time_stamp |partition |2015-04-28 21:36:12|google.com 1198807|0 |-927245206 |0 |http://real-world-systems.com/docs/safariCache.html |2015-04-29 15:57:11|real-world-systems.com CREATE TABLE cfurl_cache_schema_version(schema_version INTEGER); 25 CREATE INDEX proto_props_index ON cfurl_cache_blob_data(entry_ID); CREATE INDEX receiver_data_index ON cfurl_cache_receiver_data(entry_ID); CREATE INDEX request_key_index ON cfurl_cache_response(request_key); CREATE INDEX time_stamp_index ON cfurl_cache_response(time_stamp);