56 lines
2.8 KiB
SQL
56 lines
2.8 KiB
SQL
-- CreateTable
|
|
CREATE TABLE "board_view_types" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"key" TEXT NOT NULL,
|
|
"name" TEXT NOT NULL,
|
|
"scope" TEXT NOT NULL,
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" DATETIME NOT NULL
|
|
);
|
|
|
|
-- RedefineTables
|
|
PRAGMA defer_foreign_keys=ON;
|
|
PRAGMA foreign_keys=OFF;
|
|
CREATE TABLE "new_boards" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"name" TEXT NOT NULL,
|
|
"slug" TEXT NOT NULL,
|
|
"description" TEXT,
|
|
"sortOrder" INTEGER NOT NULL DEFAULT 0,
|
|
"status" TEXT NOT NULL DEFAULT 'active',
|
|
"type" TEXT NOT NULL DEFAULT 'general',
|
|
"requiresApproval" BOOLEAN NOT NULL DEFAULT false,
|
|
"allowAnonymousPost" BOOLEAN NOT NULL DEFAULT false,
|
|
"allowSecretComment" BOOLEAN NOT NULL DEFAULT false,
|
|
"isAdultOnly" BOOLEAN NOT NULL DEFAULT false,
|
|
"requiredTags" JSONB,
|
|
"requiredFields" JSONB,
|
|
"readLevel" TEXT NOT NULL DEFAULT 'public',
|
|
"writeLevel" TEXT NOT NULL DEFAULT 'member',
|
|
"categoryId" TEXT,
|
|
"mainPageViewTypeId" TEXT,
|
|
"listViewTypeId" TEXT,
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" DATETIME NOT NULL,
|
|
CONSTRAINT "boards_categoryId_fkey" FOREIGN KEY ("categoryId") REFERENCES "board_categories" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
|
|
CONSTRAINT "boards_mainPageViewTypeId_fkey" FOREIGN KEY ("mainPageViewTypeId") REFERENCES "board_view_types" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
|
|
CONSTRAINT "boards_listViewTypeId_fkey" FOREIGN KEY ("listViewTypeId") REFERENCES "board_view_types" ("id") ON DELETE SET NULL ON UPDATE CASCADE
|
|
);
|
|
INSERT INTO "new_boards" ("allowAnonymousPost", "allowSecretComment", "categoryId", "createdAt", "description", "id", "isAdultOnly", "name", "readLevel", "requiredFields", "requiredTags", "requiresApproval", "slug", "sortOrder", "status", "type", "updatedAt", "writeLevel") SELECT "allowAnonymousPost", "allowSecretComment", "categoryId", "createdAt", "description", "id", "isAdultOnly", "name", "readLevel", "requiredFields", "requiredTags", "requiresApproval", "slug", "sortOrder", "status", "type", "updatedAt", "writeLevel" FROM "boards";
|
|
DROP TABLE "boards";
|
|
ALTER TABLE "new_boards" RENAME TO "boards";
|
|
CREATE UNIQUE INDEX "boards_slug_key" ON "boards"("slug");
|
|
CREATE INDEX "boards_status_sortOrder_idx" ON "boards"("status", "sortOrder");
|
|
CREATE INDEX "boards_type_requiresApproval_idx" ON "boards"("type", "requiresApproval");
|
|
CREATE INDEX "boards_categoryId_idx" ON "boards"("categoryId");
|
|
CREATE INDEX "boards_mainPageViewTypeId_idx" ON "boards"("mainPageViewTypeId");
|
|
CREATE INDEX "boards_listViewTypeId_idx" ON "boards"("listViewTypeId");
|
|
PRAGMA foreign_keys=ON;
|
|
PRAGMA defer_foreign_keys=OFF;
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "board_view_types_key_key" ON "board_view_types"("key");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "board_view_types_scope_idx" ON "board_view_types"("scope");
|