Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PRAGMA foreign_keys=OFF;
- BEGIN TRANSACTION;
- CREATE TABLE cfurl_cache_schema_version(schema_version INTEGER);
- 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 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, receiver_data BLOB);
- DELETE FROM sqlite_sequence;
- CREATE INDEX request_key_index ON cfurl_cache_response(request_key);
- CREATE INDEX time_stamp_index ON cfurl_cache_response(time_stamp);
- CREATE INDEX proto_props_index ON cfurl_cache_blob_data(entry_ID);
- CREATE INDEX receiver_data_index ON cfurl_cache_receiver_data(entry_ID);
- COMMIT;
Add Comment
Please, Sign In to add comment