38 lines
1.4 KiB
MySQL
38 lines
1.4 KiB
MySQL
|
-- AlterTable
|
||
|
|
ALTER TABLE "Customer" ALTER COLUMN "birthDate" SET DATA TYPE DATE;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "CustomerBranch" ALTER COLUMN "registerDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "payDate" SET DATA TYPE DATE;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "Employee" ALTER COLUMN "dateOfBirth" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "passportIssueDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "passportExpiryDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "visaIssueDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "visaExpiryDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "visaStayUntilDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "entryDate" SET DATA TYPE DATE;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "EmployeeCheckup" ALTER COLUMN "coverageStartDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "coverageExpireDate" SET DATA TYPE DATE;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "EmployeeWork" ALTER COLUMN "workPermitIssuDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "workPermitExpireDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "workEndDate" SET DATA TYPE DATE;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "Quotation" ALTER COLUMN "payBillDate" SET DATA TYPE DATE;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "QuotationPaySplit" ALTER COLUMN "date" SET DATA TYPE DATE;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "User" ALTER COLUMN "startDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "retireDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "licenseIssueDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "licenseExpireDate" SET DATA TYPE DATE,
|
||
|
|
ALTER COLUMN "birthDate" SET DATA TYPE DATE;
|