cache_table.sql 416 B

12345678910111213141516
  1. CREATE TABLE cache_table (
  2. cache_key character varying(255) NOT NULL,
  3. value text NOT NULL,
  4. expires timestamp with time zone NOT NULL
  5. );
  6. ALTER TABLE cache_table OWNER TO postgres;
  7. COPY cache_table (cache_key, value, expires) FROM stdin;
  8. \.
  9. ALTER TABLE ONLY cache_table
  10. ADD CONSTRAINT cache_table_pkey PRIMARY KEY (cache_key);
  11. CREATE INDEX cache_table_expires ON cache_table USING btree (expires);