9 lines
334 B
SQL
9 lines
334 B
SQL
CREATE TABLE IF NOT EXISTS "card_cache" (
|
|
"id" serial PRIMARY KEY NOT NULL,
|
|
"movie_id" integer NOT NULL,
|
|
"card_type" varchar(50) NOT NULL,
|
|
"payload" jsonb NOT NULL,
|
|
"created_at" timestamptz DEFAULT now() NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS "card_cache_movie_card_unique" ON "card_cache" ("movie_id", "card_type"); |