
ALTER TABLE `condo_unit_bill_payment` CHANGE `condo_unit_bill_id` `condo_unit_bill_id` INT( 11 ) NULL ;

ALTER TABLE `condo_unit_bill_payment` ADD `created_datetime` DATE NOT NULL ,
ADD `updated_datetime` DATE NOT NULL ,
ADD `created_by` INT NOT NULL ,
ADD `updated_by` INT NOT NULL ;

ALTER TABLE `condo_unit_bill_payment` ADD `month` VARCHAR( 2 ) NOT NULL AFTER `offline_receipt_file` ,
ADD `year` VARCHAR( 4 ) NOT NULL AFTER `month` ;