ALTER TABLE `PaymentBill`
  CHANGE COLUMN `date` `creationDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `amount`,
  ADD COLUMN `paymentDate` DATE NOT NULL AFTER `creationDate`,
  ADD COLUMN `submissionDate` TIMESTAMP NULL AFTER `paymentDate`,
  ADD COLUMN `note` VARCHAR(255) NULL AFTER `submissionDate`;

update PaymentBill set paymentDate = date(creationDate) where paymentDate is null;