2016112200.sql
No OneTemporary
Actions

Size

614 B

Referenced Files

None

Subscribers

None

2016112200.sql
View Options

	DROP TABLE "cache";
	DROP TABLE "cache_shared";

	CREATE TABLE "cache" (
	user_id integer NOT NULL
	REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
	cache_key varchar(128) DEFAULT '' NOT NULL,
	expires timestamp with time zone DEFAULT NULL,
	data text NOT NULL,
	PRIMARY KEY (user_id, cache_key)
	);

	CREATE INDEX cache_expires_idx ON "cache" (expires);

	CREATE TABLE "cache_shared" (
	cache_key varchar(255) NOT NULL PRIMARY KEY,
	expires timestamp with time zone DEFAULT NULL,
	data text NOT NULL
	);

	CREATE INDEX cache_shared_expires_idx ON "cache_shared" (expires);