83 lines
2.5 KiB
SQL
83 lines
2.5 KiB
SQL
-- CreateEnum
|
|
CREATE TYPE "App" AS ENUM ('desa_plus', 'hipmi');
|
|
|
|
-- CreateEnum
|
|
CREATE TYPE "BugSource" AS ENUM ('QC', 'SYSTEM', 'USER');
|
|
|
|
-- CreateEnum
|
|
CREATE TYPE "BugStatus" AS ENUM ('OPEN', 'ON_HOLD', 'IN_PROGRESS', 'RESOLVED', 'RELEASED', 'CLOSED');
|
|
|
|
-- AlterEnum
|
|
ALTER TYPE "Role" ADD VALUE 'DEVELOPER';
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "user" ADD COLUMN "active" BOOLEAN NOT NULL DEFAULT true;
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "log" (
|
|
"id" TEXT NOT NULL,
|
|
"userId" TEXT NOT NULL,
|
|
"type" TEXT NOT NULL,
|
|
"message" TEXT NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
CONSTRAINT "log_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "bug" (
|
|
"id" TEXT NOT NULL,
|
|
"userId" TEXT,
|
|
"app" "App" NOT NULL,
|
|
"affectedVersion" TEXT NOT NULL,
|
|
"device" TEXT NOT NULL,
|
|
"os" TEXT NOT NULL,
|
|
"status" "BugStatus" NOT NULL,
|
|
"source" "BugSource" NOT NULL,
|
|
"description" TEXT NOT NULL,
|
|
"stackTrace" TEXT,
|
|
"fixedVersion" TEXT,
|
|
"feedBack" TEXT,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "bug_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "bug_image" (
|
|
"id" TEXT NOT NULL,
|
|
"bugId" TEXT NOT NULL,
|
|
"imageUrl" TEXT NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
CONSTRAINT "bug_image_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "bug_log" (
|
|
"id" TEXT NOT NULL,
|
|
"bugId" TEXT NOT NULL,
|
|
"userId" TEXT NOT NULL,
|
|
"status" "BugStatus" NOT NULL,
|
|
"description" TEXT NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
CONSTRAINT "bug_log_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "log" ADD CONSTRAINT "log_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "bug" ADD CONSTRAINT "bug_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "bug_image" ADD CONSTRAINT "bug_image_bugId_fkey" FOREIGN KEY ("bugId") REFERENCES "bug"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "bug_log" ADD CONSTRAINT "bug_log_bugId_fkey" FOREIGN KEY ("bugId") REFERENCES "bug"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "bug_log" ADD CONSTRAINT "bug_log_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|