From 10ce1ad59969576244ba786d7d17da2da3fe6f61 Mon Sep 17 00:00:00 2001 From: Rafi Zadanly Date: Fri, 17 Nov 2023 15:15:31 +0700 Subject: Update migration prisma --- .../20231101073315_initial/migration.sql | 80 ---------------------- .../20231113070209_initial/migration.sql | 78 +++++++++++++++++++++ 2 files changed, 78 insertions(+), 80 deletions(-) delete mode 100644 prisma/migrations/20231101073315_initial/migration.sql create mode 100644 prisma/migrations/20231113070209_initial/migration.sql diff --git a/prisma/migrations/20231101073315_initial/migration.sql b/prisma/migrations/20231101073315_initial/migration.sql deleted file mode 100644 index e559eb2..0000000 --- a/prisma/migrations/20231101073315_initial/migration.sql +++ /dev/null @@ -1,80 +0,0 @@ --- CreateTable -CREATE TABLE `Company` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `name` VARCHAR(191) NOT NULL, - - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- CreateTable -CREATE TABLE `User` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `name` VARCHAR(191) NOT NULL, - `companyId` INTEGER NOT NULL, - `username` VARCHAR(191) NOT NULL, - `password` VARCHAR(191) NOT NULL, - `team` ENUM('COUNT1', 'COUNT2', 'VERIFICATION') NOT NULL, - - UNIQUE INDEX `User_username_key`(`username`), - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- CreateTable -CREATE TABLE `Location` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `name` VARCHAR(191) NOT NULL, - `companyId` INTEGER NOT NULL, - - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- CreateTable -CREATE TABLE `Product` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `barcode` VARCHAR(191) NOT NULL, - `itemCode` VARCHAR(191) NOT NULL, - `name` VARCHAR(191) NOT NULL, - `onhandQty` INTEGER NOT NULL, - `differenceQty` INTEGER NOT NULL, - `isDifferent` BOOLEAN NOT NULL, - `companyId` INTEGER NOT NULL, - `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), - `updatedAt` DATETIME(3) NULL, - - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- CreateTable -CREATE TABLE `StockOpname` ( - `id` INTEGER NOT NULL AUTO_INCREMENT, - `productId` INTEGER NOT NULL, - `locationId` INTEGER NOT NULL, - `companyId` INTEGER NOT NULL, - `userId` INTEGER NOT NULL, - `team` ENUM('COUNT1', 'COUNT2', 'VERIFICATION') NOT NULL, - `quantity` INTEGER NOT NULL, - `isDifferent` BOOLEAN NOT NULL, - - PRIMARY KEY (`id`) -) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; - --- 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; diff --git a/prisma/migrations/20231113070209_initial/migration.sql b/prisma/migrations/20231113070209_initial/migration.sql new file mode 100644 index 0000000..cf99541 --- /dev/null +++ b/prisma/migrations/20231113070209_initial/migration.sql @@ -0,0 +1,78 @@ +-- CreateTable +CREATE TABLE `Company` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `name` VARCHAR(191) NOT NULL, + + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- CreateTable +CREATE TABLE `User` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `name` VARCHAR(191) NOT NULL, + `companyId` INTEGER NOT NULL, + `username` VARCHAR(191) NOT NULL, + `password` VARCHAR(191) NOT NULL, + `team` ENUM('COUNT1', 'COUNT2', 'COUNT3', 'VERIFICATION') NOT NULL, + + UNIQUE INDEX `User_username_key`(`username`), + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- CreateTable +CREATE TABLE `Location` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `name` VARCHAR(191) NOT NULL, + `companyId` INTEGER NOT NULL, + + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- CreateTable +CREATE TABLE `Product` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `barcode` VARCHAR(191) NOT NULL, + `itemCode` VARCHAR(191) NOT NULL, + `name` VARCHAR(191) NOT NULL, + `onhandQty` INTEGER NOT NULL, + `differenceQty` INTEGER NOT NULL, + `isDifferent` BOOLEAN NOT NULL, + `companyId` INTEGER NOT NULL, + + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- CreateTable +CREATE TABLE `StockOpname` ( + `id` INTEGER NOT NULL AUTO_INCREMENT, + `productId` INTEGER NOT NULL, + `locationId` INTEGER NOT NULL, + `companyId` INTEGER NOT NULL, + `userId` INTEGER NOT NULL, + `team` ENUM('COUNT1', 'COUNT2', 'COUNT3', 'VERIFICATION') NOT NULL, + `quantity` INTEGER NOT NULL, + `isDifferent` BOOLEAN NOT NULL, + + PRIMARY KEY (`id`) +) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +-- 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