19 lines
1 KiB
SQL
19 lines
1 KiB
SQL
/*
|
|
Warnings:
|
|
|
|
- Added the required column `permitExpireDate` to the `Branch` table without a default value. This is not possible if the table is not empty.
|
|
- Added the required column `permitIssueDate` to the `Branch` table without a default value. This is not possible if the table is not empty.
|
|
- Added the required column `permitNo` to the `Branch` table without a default value. This is not possible if the table is not empty.
|
|
- Added the required column `citizenId` to the `User` table without a default value. This is not possible if the table is not empty.
|
|
- Added the required column `citizenIssue` to the `User` table without a default value. This is not possible if the table is not empty.
|
|
|
|
*/
|
|
-- AlterTable
|
|
ALTER TABLE "Branch" ADD COLUMN "permitExpireDate" DATE NOT NULL,
|
|
ADD COLUMN "permitIssueDate" DATE NOT NULL,
|
|
ADD COLUMN "permitNo" TEXT NOT NULL;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "User" ADD COLUMN "citizenExpire" DATE,
|
|
ADD COLUMN "citizenId" TEXT NOT NULL,
|
|
ADD COLUMN "citizenIssue" DATE NOT NULL;
|