14 lines
434 B
SQL
14 lines
434 B
SQL
CREATE TABLE IF NOT EXISTS "TutorialVideos" (
|
|
"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
|
|
"title" varchar(128) NOT NULL,
|
|
"videoUrl" text NOT NULL,
|
|
"coverUrl" text,
|
|
"description" text,
|
|
"order" integer NOT NULL DEFAULT 0,
|
|
"isEnabled" boolean NOT NULL DEFAULT true,
|
|
"createdAt" timestamp DEFAULT now() NOT NULL,
|
|
"updatedAt" timestamp DEFAULT now() NOT NULL,
|
|
"createdBy" uuid REFERENCES "User"("id")
|
|
);
|
|
|