-- Tables

-- Alters

ALTER TABLE RDS.T_ELECTRONIC_CERTIFICATE_STATUS ALTER COLUMN "statusdatetime" SET DATA TYPE timestamp;

UPDATE RDS.T_ELECTRONIC_CERTIFICATE_STATUS SET "statusdatetime" = coalesce(StartDate, now()) WHERE "statusdatetime" IS NULL;

ALTER TABLE RDS.T_ELECTRONIC_CERTIFICATE_STATUS ALTER COLUMN "statusdatetime" SET NOT NULL;

