From 0fad493706f21f8d82594590d59900d714b3c4b4 Mon Sep 17 00:00:00 2001
From: Rafi Zadanly <zadanlyr@gmail.com>
Date: Mon, 20 Nov 2023 14:32:18 +0700
Subject: Change database from mysql to postgresql

---
 .../20231120072134_initial/migration.sql           | 83 ++++++++++++++++++++++
 1 file changed, 83 insertions(+)
 create mode 100644 prisma/migrations/20231120072134_initial/migration.sql

(limited to 'prisma/migrations/20231120072134_initial/migration.sql')

diff --git a/prisma/migrations/20231120072134_initial/migration.sql b/prisma/migrations/20231120072134_initial/migration.sql
new file mode 100644
index 0000000..c55fda9
--- /dev/null
+++ b/prisma/migrations/20231120072134_initial/migration.sql
@@ -0,0 +1,83 @@
+-- CreateEnum
+CREATE TYPE "Team" AS ENUM ('COUNT1', 'COUNT2', 'COUNT3', 'VERIFICATION');
+
+-- CreateTable
+CREATE TABLE "Company" (
+    "id" SERIAL NOT NULL,
+    "name" TEXT NOT NULL,
+
+    CONSTRAINT "Company_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateTable
+CREATE TABLE "User" (
+    "id" SERIAL NOT NULL,
+    "name" TEXT NOT NULL,
+    "companyId" INTEGER NOT NULL,
+    "username" TEXT NOT NULL,
+    "password" TEXT NOT NULL,
+    "team" "Team" NOT NULL,
+
+    CONSTRAINT "User_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateTable
+CREATE TABLE "Location" (
+    "id" SERIAL NOT NULL,
+    "name" TEXT NOT NULL,
+    "companyId" INTEGER NOT NULL,
+
+    CONSTRAINT "Location_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateTable
+CREATE TABLE "Product" (
+    "id" SERIAL NOT NULL,
+    "barcode" TEXT NOT NULL,
+    "itemCode" TEXT NOT NULL,
+    "name" TEXT NOT NULL,
+    "onhandQty" INTEGER NOT NULL,
+    "differenceQty" INTEGER NOT NULL,
+    "isDifferent" BOOLEAN NOT NULL,
+    "companyId" INTEGER NOT NULL,
+
+    CONSTRAINT "Product_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateTable
+CREATE TABLE "StockOpname" (
+    "id" SERIAL NOT NULL,
+    "productId" INTEGER NOT NULL,
+    "locationId" INTEGER NOT NULL,
+    "companyId" INTEGER NOT NULL,
+    "userId" INTEGER NOT NULL,
+    "team" "Team" NOT NULL,
+    "quantity" INTEGER NOT NULL,
+    "isDifferent" BOOLEAN NOT NULL,
+
+    CONSTRAINT "StockOpname_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateIndex
+CREATE UNIQUE INDEX "User_username_key" ON "User"("username");
+
+-- AddForeignKey
+ALTER TABLE "User" ADD CONSTRAINT "User_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES "Company"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "Location" ADD CONSTRAINT "Location_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES "Company"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "Product" ADD CONSTRAINT "Product_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES "Company"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "StockOpname" ADD CONSTRAINT "StockOpname_productId_fkey" FOREIGN KEY ("productId") REFERENCES "Product"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "StockOpname" ADD CONSTRAINT "StockOpname_locationId_fkey" FOREIGN KEY ("locationId") REFERENCES "Location"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "StockOpname" ADD CONSTRAINT "StockOpname_companyId_fkey" FOREIGN KEY ("companyId") REFERENCES "Company"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "StockOpname" ADD CONSTRAINT "StockOpname_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
-- 
cgit v1.2.3