ALTER TABLE `shahi_crm`.`operation_tracking` ADD COLUMN `colour_id` INT NOT NULL AFTER `sample_req_id`, ADD COLUMN `size_id` INT NOT NULL AFTER `colour_id`; 19/12/2023

ALTER TABLE `shahi_crm`.`operation_inventory` ADD COLUMN `colour_id` INT NOT NULL AFTER `sample_req_id`, ADD COLUMN `size_id` INT NOT NULL AFTER `colour_id`; 19/12/2023

ALTER TABLE `shahi_crm`.`operation_inventory` ADD COLUMN `sample_req_id` INT NOT NULL AFTER `rejected_uom_id`; 19/12/2023

ALTER TABLE `shahi_crm`.`operation_inventory` ADD COLUMN `reporter` INT NOT NULL AFTER `size_id`, ADD COLUMN `supervisor` INT NOT NULL AFTER `reporter`; 22/12/2023

ALTER TABLE `shahi_crm`.`operation_tracking` ADD COLUMN `reporter` INT NOT NULL AFTER `size_id`, ADD COLUMN `supervisor` INT NOT NULL AFTER `reporter`; ; 22/12/2023


ALTER TABLE `shahi_crm`.`purchase_order` ADD COLUMN `ref_no` INT NOT NULL AFTER `total_amount`;27/12/2023

ALTER TABLE `shahi_crm`.`purchase_order` CHANGE `grn_quantity` `grn_quantity` VARCHAR(255) CHARSET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' NULL; 28/12/2023

ALTER TABLE `shahi_crm`.`indent_trims` CHANGE `quantity_unit` `quantity_unit` INT(11) NULL;01/01/24
build alter queries
ALTER TABLE `shahi_crm`.`purchae_order_items` CHANGE `transportation` `transportation` INT(11) DEFAULT 0 NULL;19/01/2024  12:28