| | |
| | | CREATE TABLE "cache" ( |
| | | cache_id integer DEFAULT nextval('cache_ids'::text) PRIMARY KEY, |
| | | user_id integer NOT NULL REFERENCES users (user_id), |
| | | session_id character varying(40) REFERENCES "session" (session_id), |
| | | session_id character varying(40) REFERENCES "session" (sess_id), |
| | | cache_key character varying(128) DEFAULT ''::character varying NOT NULL, |
| | | created timestamp with time zone DEFAULT now() NOT NULL, |
| | | data text NOT NULL |
| | |
| | | date timestamp with time zone NOT NULL, |
| | | size integer DEFAULT 0 NOT NULL, |
| | | headers text NOT NULL, |
| | | body text |
| | | structure text |
| | | ); |
| | | |
| | | ALTER TABLE "messages" ADD UNIQUE (cache_key, uid); |