18 lines
890 B
MySQL
18 lines
890 B
MySQL
|
-- DropForeignKey
|
||
|
|
ALTER TABLE "EmployeeInCountryNotice" DROP CONSTRAINT "EmployeeInCountryNotice_employeeId_fkey";
|
||
|
|
|
||
|
|
-- DropForeignKey
|
||
|
|
ALTER TABLE "EmployeePassport" DROP CONSTRAINT "EmployeePassport_employeeId_fkey";
|
||
|
|
|
||
|
|
-- DropForeignKey
|
||
|
|
ALTER TABLE "EmployeeVisa" DROP CONSTRAINT "EmployeeVisa_employeeId_fkey";
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "EmployeePassport" ADD CONSTRAINT "EmployeePassport_employeeId_fkey" FOREIGN KEY ("employeeId") REFERENCES "Employee"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "EmployeeVisa" ADD CONSTRAINT "EmployeeVisa_employeeId_fkey" FOREIGN KEY ("employeeId") REFERENCES "Employee"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "EmployeeInCountryNotice" ADD CONSTRAINT "EmployeeInCountryNotice_employeeId_fkey" FOREIGN KEY ("employeeId") REFERENCES "Employee"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|