Mercurial > hg > rc2
view SQL/oracle/2016112200.sql @ 8:bf99236cc5cd default tip
try to recover from upgrade fail
author | Charlie Root |
---|---|
date | Sat, 29 Dec 2018 07:07:34 -0500 |
parents | |
children |
line wrap: on
line source
DROP TABLE "cache"; DROP TABLE "cache_shared"; CREATE TABLE "cache" ( "user_id" integer NOT NULL REFERENCES "users" ("user_id") ON DELETE CASCADE, "cache_key" varchar(128) NOT NULL, "expires" timestamp with time zone DEFAULT NULL, "data" long 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, "expires" timestamp with time zone DEFAULT NULL, "data" long NOT NULL, PRIMARY KEY ("cache_key") ); CREATE INDEX "cache_shared_expires_idx" ON "cache_shared" ("expires");