18 lines
678 B
SQL
18 lines
678 B
SQL
/*
|
|
Warnings:
|
|
|
|
- You are about to drop the column `remark` on the `EmployeeWork` table. All the data in the column will be lost.
|
|
- You are about to drop the column `workEndDate` on the `EmployeeWork` table. All the data in the column will be lost.
|
|
- You are about to drop the `EmployeeInCountryNotice` table. If the table is not empty, all the data it contains will be lost.
|
|
|
|
*/
|
|
-- DropForeignKey
|
|
ALTER TABLE "EmployeeInCountryNotice" DROP CONSTRAINT "EmployeeInCountryNotice_employeeId_fkey";
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "EmployeeWork" DROP COLUMN "remark",
|
|
DROP COLUMN "workEndDate",
|
|
ADD COLUMN "identityNo" TEXT;
|
|
|
|
-- DropTable
|
|
DROP TABLE "EmployeeInCountryNotice";
|