ALTER TABLE `vouchers` 
DROP COLUMN `order_no`,
ADD COLUMN `approved_comment` TEXT NULL AFTER `updated_at`,
ADD COLUMN `approved_by` BIGINT UNSIGNED NULL AFTER `approved_comment`,
ADD COLUMN `approved_at` DATE NULL AFTER `approved_by`,
ADD INDEX `approved_by_foreign_idx` (`approved_by` ASC);
;
ALTER TABLE `vouchers` 
ADD CONSTRAINT `vouchers_approved_by_foreign`
  FOREIGN KEY (`approved_by`)
  REFERENCES `users` (`id`)
  ON DELETE RESTRICT
  ON UPDATE RESTRICT;
;
ALTER TABLE `vouchers` 
ADD COLUMN `order_id` BIGINT UNSIGNED NULL AFTER `updated_at`,
ADD INDEX `vouchers_order_id_foreign_idx` (`order_id` ASC);
;
ALTER TABLE `vouchers` 
ADD CONSTRAINT `vouchers_order_id_foreign`
  FOREIGN KEY (`order_id`)
  REFERENCES `orders` (`id`)
  ON DELETE RESTRICT
  ON UPDATE RESTRICT;
;
ALTER TABLE `asset_types` 
ADD COLUMN `code` VARCHAR(20) NULL AFTER `name`,
ADD COLUMN `name_en` VARCHAR(255) NULL AFTER `code`;
;
ALTER TABLE `objectives` 
ADD COLUMN `code` VARCHAR(20) NULL AFTER `name`,
ADD COLUMN `name_en` VARCHAR(255) NULL AFTER `code`;
;
ALTER TABLE `orders` 
ADD COLUMN `payment_condition_other` VARCHAR(255) NULL AFTER `primary_assessor_name`,
ADD COLUMN `payment_status_other` VARCHAR(255) NULL AFTER `payment_condition_other`;
;
ALTER TABLE `vouchers` 
ADD COLUMN `approved_sec_comment` text NULL AFTER `approved_at`,
ADD COLUMN `approved_sec_at` date DEFAULT NULL AFTER `approved_sec_comment`,
ADD COLUMN `approved_sec_by` bigint(20) unsigned DEFAULT NULL AFTER `approved_sec_at`;
;
ALTER TABLE `orders` ADD COLUMN `usage_space` VARCHAR(255) NULL AFTER `usage_area`;