diff options
| author | Rafi Zadanly <zadanlyr@gmail.com> | 2023-11-17 15:15:31 +0700 |
|---|---|---|
| committer | Rafi Zadanly <zadanlyr@gmail.com> | 2023-11-17 15:15:31 +0700 |
| commit | 10ce1ad59969576244ba786d7d17da2da3fe6f61 (patch) | |
| tree | 5b1960e3472c5a56b90db31cae770f0bb9848fd1 | |
| parent | 57da8e77153d6f83705e63db3d6d93b3e246ada2 (diff) | |
Update migration prisma
| -rw-r--r-- | prisma/migrations/20231113070209_initial/migration.sql (renamed from prisma/migrations/20231101073315_initial/migration.sql) | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/prisma/migrations/20231101073315_initial/migration.sql b/prisma/migrations/20231113070209_initial/migration.sql index e559eb2..cf99541 100644 --- a/prisma/migrations/20231101073315_initial/migration.sql +++ b/prisma/migrations/20231113070209_initial/migration.sql @@ -13,7 +13,7 @@ CREATE TABLE `User` ( `companyId` INTEGER NOT NULL, `username` VARCHAR(191) NOT NULL, `password` VARCHAR(191) NOT NULL, - `team` ENUM('COUNT1', 'COUNT2', 'VERIFICATION') NOT NULL, + `team` ENUM('COUNT1', 'COUNT2', 'COUNT3', 'VERIFICATION') NOT NULL, UNIQUE INDEX `User_username_key`(`username`), PRIMARY KEY (`id`) @@ -38,8 +38,6 @@ CREATE TABLE `Product` ( `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; @@ -51,7 +49,7 @@ CREATE TABLE `StockOpname` ( `locationId` INTEGER NOT NULL, `companyId` INTEGER NOT NULL, `userId` INTEGER NOT NULL, - `team` ENUM('COUNT1', 'COUNT2', 'VERIFICATION') NOT NULL, + `team` ENUM('COUNT1', 'COUNT2', 'COUNT3', 'VERIFICATION') NOT NULL, `quantity` INTEGER NOT NULL, `isDifferent` BOOLEAN NOT NULL, |