37 lines
1.1 KiB
SQL
37 lines
1.1 KiB
SQL
-- SQL Schema for Ayris Apart Blog and Suites
|
|
-- This is generated as a reference for the Prisma Schema
|
|
|
|
-- Create Post table for Blog
|
|
CREATE TABLE IF NOT EXISTS "Post" (
|
|
"id" TEXT NOT NULL,
|
|
"title" TEXT NOT NULL,
|
|
"slug" TEXT NOT NULL,
|
|
"excerpt" TEXT NOT NULL,
|
|
"content" TEXT,
|
|
"image" TEXT,
|
|
"author" TEXT NOT NULL DEFAULT 'Ayris Apart',
|
|
"lang" TEXT NOT NULL DEFAULT 'tr',
|
|
"published" BOOLEAN NOT NULL DEFAULT false,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "Post_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- Create Suite table (if moved to DB)
|
|
CREATE TABLE IF NOT EXISTS "Suite" (
|
|
"id" TEXT NOT NULL,
|
|
"name" TEXT NOT NULL,
|
|
"description" TEXT NOT NULL,
|
|
"price" TEXT NOT NULL,
|
|
"image" TEXT NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "Suite_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- Unique index for slug and lang
|
|
CREATE UNIQUE INDEX IF NOT EXISTS "Post_slug_key" ON "Post"("slug");
|
|
CREATE INDEX IF NOT EXISTS "Post_slug_lang_idx" ON "Post"("slug", "lang");
|