ALTER TABLE `personnel_users` ADD `qualification_id` INT NOT NULL AFTER `role`;

ALTER TABLE `billing_bills` ADD `subtype_id` INT NOT NULL AFTER `subtype`;
ALTER TABLE `billing_bills` ADD INDEX(`subtype_id`);
ALTER TABLE `billing_bills` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;
ALTER TABLE `billing_bill_items` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;

ALTER TABLE `billing_invoices` ADD `subtype_id` INT NOT NULL AFTER `subtype`;
ALTER TABLE `billing_invoices` ADD INDEX(`subtype_id`);
ALTER TABLE `billing_invoices` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;
ALTER TABLE `billing_invoice_items` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;

ALTER TABLE `billing_returns` ADD `subtype_id` INT NOT NULL AFTER `subtype`;
ALTER TABLE `billing_returns` ADD INDEX(`subtype_id`);
ALTER TABLE `billing_returns` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;
ALTER TABLE `billing_return_items` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;

ALTER TABLE `inventory_adjustments` ADD `subtype_id` INT NOT NULL AFTER `subtype`;
ALTER TABLE `inventory_adjustments` ADD INDEX(`subtype_id`);
ALTER TABLE `inventory_adjustments` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;
ALTER TABLE `inventory_adjustment_items` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;

ALTER TABLE `inventory_requisitions` ADD `subtype_id` INT NOT NULL AFTER `subtype`;
ALTER TABLE `inventory_requisitions` ADD INDEX(`subtype_id`);
ALTER TABLE `inventory_requisitions` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;
ALTER TABLE `inventory_requisition_items` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;

ALTER TABLE `procurement_grns` ADD `subtype_id` INT NOT NULL AFTER `subtype`;
ALTER TABLE `procurement_grns` ADD INDEX(`subtype_id`);
ALTER TABLE `procurement_grns` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;
ALTER TABLE `procurement_grn_items` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;

ALTER TABLE `procurement_requisitions` ADD `subtype_id` INT NOT NULL AFTER `subtype`;
ALTER TABLE `procurement_requisitions` ADD INDEX(`subtype_id`);
ALTER TABLE `procurement_requisitions` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;
ALTER TABLE `procurement_requisition_items` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;

ALTER TABLE `procurement_requests` ADD `subtype_id` INT NOT NULL AFTER `subtype`;
ALTER TABLE `procurement_requests` ADD INDEX(`subtype_id`);
ALTER TABLE `procurement_requests` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;
ALTER TABLE `procurement_request_items` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;

ALTER TABLE `procurement_orders` ADD `subtype_id` INT NOT NULL AFTER `subtype`;
ALTER TABLE `procurement_orders` ADD INDEX(`subtype_id`);
ALTER TABLE `procurement_orders` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;
ALTER TABLE `procurement_order_items` ADD `progress_notes` TEXT NOT NULL AFTER `progress_code`, ADD `progress_user_id` INT NOT NULL AFTER `progress_notes`, ADD `progress_datetime` DATETIME NOT NULL AFTER `progress_user_id`;