From 2af2659018d08cd8685a6e727994ab76f0735189 Mon Sep 17 00:00:00 2001
From: Mqdd <ahmadmiqdad27@gmail.com>
Date: Sun, 15 Feb 2026 11:18:35 +0700
Subject: <Miqdad> Locator

---
 prisma/migrations/20260215035919_test/migration.sql | 5 +++++
 prisma/schema.prisma                                | 3 +++
 2 files changed, 8 insertions(+)
 create mode 100644 prisma/migrations/20260215035919_test/migration.sql

(limited to 'prisma')

diff --git a/prisma/migrations/20260215035919_test/migration.sql b/prisma/migrations/20260215035919_test/migration.sql
new file mode 100644
index 0000000..8b85792
--- /dev/null
+++ b/prisma/migrations/20260215035919_test/migration.sql
@@ -0,0 +1,5 @@
+-- AlterTable
+ALTER TABLE "Product" ADD COLUMN     "locationId" INTEGER;
+
+-- AddForeignKey
+ALTER TABLE "Product" ADD CONSTRAINT "Product_locationId_fkey" FOREIGN KEY ("locationId") REFERENCES "Location"("id") ON DELETE SET NULL ON UPDATE CASCADE;
diff --git a/prisma/schema.prisma b/prisma/schema.prisma
index 68bc387..bcbc9a2 100644
--- a/prisma/schema.prisma
+++ b/prisma/schema.prisma
@@ -33,6 +33,7 @@ model Location {
     name         String
     company      Company       @relation(fields: [companyId], references: [id])
     companyId    Int
+    products     Product[]
     stockOpnames StockOpname[]
 }
 
@@ -48,6 +49,8 @@ model Product {
     isDifferent   Boolean
     company       Company       @relation(fields: [companyId], references: [id])
     companyId     Int
+    location      Location?     @relation(fields: [locationId], references: [id])
+    locationId    Int?
     stockOpnames  StockOpname[]
 }
 
-- 
cgit v1.2.3