<Miqdad> Locatorlocator

2 files changed, 8 insertions, 0 deletions

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[]
 }