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);