jws-backend/prisma/migrations/20240917034510_add_missing_meta/migration.sql
2024-09-17 10:45:21 +07:00

29 lines
1.6 KiB
SQL

/*
Warnings:
- Added the required column `updatedAt` to the `CustomerBranchCitizen` table without a default value. This is not possible if the table is not empty.
- Added the required column `updatedAt` to the `CustomerBranchCommercialRegis` table without a default value. This is not possible if the table is not empty.
- Added the required column `updatedAt` to the `CustomerBranchHouseRegis` table without a default value. This is not possible if the table is not empty.
- Added the required column `updatedAt` to the `CustomerBranchPoa` table without a default value. This is not possible if the table is not empty.
- Added the required column `updatedAt` to the `CustomerBranchVatRegis` table without a default value. This is not possible if the table is not empty.
*/
-- AlterTable
ALTER TABLE "CustomerBranchCitizen" ADD COLUMN "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN "updatedAt" TIMESTAMP(3) NOT NULL;
-- AlterTable
ALTER TABLE "CustomerBranchCommercialRegis" ADD COLUMN "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN "updatedAt" TIMESTAMP(3) NOT NULL;
-- AlterTable
ALTER TABLE "CustomerBranchHouseRegis" ADD COLUMN "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN "updatedAt" TIMESTAMP(3) NOT NULL;
-- AlterTable
ALTER TABLE "CustomerBranchPoa" ADD COLUMN "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN "updatedAt" TIMESTAMP(3) NOT NULL;
-- AlterTable
ALTER TABLE "CustomerBranchVatRegis" ADD COLUMN "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN "updatedAt" TIMESTAMP(3) NOT NULL;