mirror of
https://github.com/BillyOutlast/stash-box.git
synced 2026-02-05 03:11:23 +01:00
9 lines
282 B
SQL
9 lines
282 B
SQL
CREATE TABLE "drafts" (
|
|
"id" UUID PRIMARY KEY,
|
|
"user_id" UUID NOT NULL,
|
|
"type" TEXT CHECK ("type" in ('SCENE', 'PERFORMER', 'STUDIO')) NOT NULL,
|
|
"data" JSONB NOT NULL,
|
|
"created_at" TIMESTAMP NOT NULL,
|
|
FOREIGN KEY("user_id") REFERENCES "users"("id") ON DELETE CASCADE
|
|
);
|