diff options
| -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, |