28 lines
1.3 KiB
SQL
28 lines
1.3 KiB
SQL
-- AlterTable
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "brandName" TEXT;
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "seriesName" TEXT;
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "skuCode" TEXT;
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "materialTexture" TEXT;
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "renderTime" TEXT;
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "imageResolution" TEXT;
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "colorMode" TEXT;
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "displayImages" TEXT NOT NULL DEFAULT '';
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "platformName" TEXT NOT NULL DEFAULT '';
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "previewUrls" TEXT;
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "metadata" TEXT;
|
|
ALTER TABLE "materials" ADD COLUMN IF NOT EXISTS "templateId" TEXT;
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX IF NOT EXISTS "materials_platformName_idx" ON "materials"("platformName");
|
|
|
|
-- AddForeignKey
|
|
DO $$
|
|
BEGIN
|
|
IF NOT EXISTS (
|
|
SELECT 1 FROM pg_constraint
|
|
WHERE conname = 'materials_templateId_fkey'
|
|
) THEN
|
|
ALTER TABLE "materials" ADD CONSTRAINT "materials_templateId_fkey" FOREIGN KEY ("templateId") REFERENCES "UploadTemplate"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
|
END IF;
|
|
END $$;
|