02-04-2024 8.30 PM ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `reweighment_boxes` INT(11) NULL AFTER `inv_remarks`, ADD COLUMN `sample_quantity` INT(11) NULL AFTER `reweighment_boxes`, ADD COLUMN `sample_pieces` INT(11) NULL AFTER `sample_quantity`, ADD COLUMN `reweighment_count` INT(11) NULL AFTER `sample_pieces`; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `reweighment_status` TINYINT(4) DEFAULT FALSE NULL AFTER `reweighment_count`; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `approved_price` INT(11) NULL AFTER `reweighment_status`; 03-04-2024 1.24 PM ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` CHANGE `sample_quantity` `sample_quantity` DECIMAL(15,3) NULL, ADD COLUMN `reweighment_quantity` DECIMAL(15,3) NULL AFTER `approved_price`; 03-04-2024 9.40PM ALTER TABLE `erpx_dev_masters`.`product_price_list` CHANGE `category` `category` ENUM('LOCAL','EXPORT','UV') CHARSET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; ALTER TABLE `erpx_dev_enquiries`.`enquiry_products` ADD COLUMN `uv_price_category` VARCHAR(50) NULL AFTER `is_so_created`, ADD COLUMN `uv_type` VARCHAR(50) NULL AFTER `uv_price_category`, ADD COLUMN `uv_percent_or_cent` INT(11) NULL AFTER `uv_type`; ALTER TABLE `erpx_dev_enquiries`.`enquiry_products` CHANGE `unit_price` `unit_price` DECIMAL(10,3) NOT NULL; 04-04-2024 11.24AM ALTER TABLE `erpx_dev_masters`.`product_price_list` CHANGE `price` `min_price` DECIMAL(10,2) NOT NULL, ADD COLUMN `mid_price` DECIMAL(10,2) NOT NULL AFTER `category`, ADD COLUMN `high_price` DECIMAL(10,2) NOT NULL AFTER `mid_price`; ALTER TABLE erpx_dev_rm_procurement.indent ADD COLUMN vehicle_type ENUM('OWN','RENT') DEFAULT 'OWN' NULL AFTER harvest_type; ALTER TABLE erpx_dev_rm_procurement.indent CHANGE vehicle_type vehicle_type ENUM('OWN','RENT') CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE erpx_dev_rm_procurement.indent CHANGE assign_lead_1 assign_lead_1 INT(11) NULL; 04-04-2024 12.00PM ALTER TABLE `erpx_dev_rm_procurement`.`rm_re_weighing` CHANGE `expected_cnt_qty` `expected_cnt_qty` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `indent_item_id` `indent_item_id` INT(11) NULL; 05-04-2024 ALTER TABLE `erpx_dev_sales`.`so_invoice_details` ADD COLUMN `buyer_address` VARCHAR(250) NULL AFTER `bank_account_id`; ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `gross_weight` DECIMAL(10,3) NULL AFTER `addon_product`; ALTER TABLE `erpx_dev_enquiries`.`enquiry_products` ADD COLUMN `brand_type` VARCHAR(10) NULL AFTER `uv_percent_or_cent`; 06-04-2024 ALTER TABLE `erpx_dev_rm_procurement`.`grn` ADD COLUMN `batch_number` VARCHAR(50) NOT NULL AFTER `bill_to`; ALTER TABLE `erpx_dev_masters`.`product_price_list` CHANGE `category` `category` ENUM('LOCAL','EXPORT','UV','UB') CHARSET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; ALTER TABLE `erpx_dev_masters`.`product_price_list` CHANGE `category` `category` ENUM('LOCAL','EXPORT','UB') CHARSET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; 20-04-2024 ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `frozen_weight` DECIMAL(10,3) NULL AFTER `gross_weight`, ADD COLUMN `product_description` VARCHAR(250) NULL AFTER `frozen_weight`; 22-04-2024 ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `rm_rate` INT(11) NULL AFTER `reweighment_quantity`, ADD COLUMN `ice_rate` INT(11) NULL AFTER `rm_rate`; ALTER TABLE `erpx_dev_rm_procurement`.`indent_items` ADD COLUMN `rm_rate` INT(11) NULL AFTER `expected_price4`, ADD COLUMN `ice_rate` INT(11) NULL AFTER `rm_rate`; ALTER TABLE erpx_dev_rm_procurement.rm_rates ADD COLUMN type ENUM('Live Harvest','Re Weighment') NOT NULL AFTER category; ALTER TABLE erpx_dev_rm_procurement.indent ADD COLUMN farm_type ENUM('OWN','OTHERS') NULL AFTER vehicle_type; 24-04-2024 ALTER TABLE `erpx_dev_rm_procurement`.`grn_item_defects` ADD COLUMN `quantity` DECIMAL(5,3) NULL AFTER `version_flag`; ALTER TABLE `erpx_dev_rm_procurement`.`grn_item_defects` CHANGE `quantity` `quantity` DECIMAL(10,3) UNSIGNED NULL; 12-04-2024 ALTER TABLE erpx_dev_masters.unitcodes CHANGE company company ENUM('BMR INDUSTRIES PRIVATE LIMITED','BMR EXPORTS-AP','BMR EXPORTS-ODISHA') CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL; ALTER TABLE erpx_dev_masters.unitcodes CHANGE company company ENUM('BMR INDUSTRIES PRIVATE LIMITED','BMR EXPORTS-AP') CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL; ALTER TABLE erpx_dev_masters.bank_details CHANGE company company ENUM('BMR INDUSTRIES PRIVATE LIMITED','BMR EXPORTS-AP','BMR EXPORTS-ODISHA') CHARSET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; 22-04-2024 ALTER TABLE `erpx_dev_transport`.`vehicle_assignment` DROP COLUMN `ice_factory`, DROP COLUMN `vehicle_type`, DROP COLUMN `ice_type`, DROP COLUMN `ice_quantity`, ADD COLUMN `ice_quantity` INT(11) NOT NULL AFTER `driver_name`, ADD COLUMN `ice_type` ENUM('OWN','OTHERS') NOT NULL AFTER `ice_quantity`, ADD COLUMN `vehicle_type` ENUM('OWN','RENT') NOT NULL AFTER `ice_type`, ADD COLUMN `ice_factory` VARCHAR(50) NOT NULL AFTER `vehicle_type`; 23-04-2023 ALTER TABLE `erpx_dev_rm_procurement`.`grn` ADD COLUMN `reweighment_bill_to` ENUM('BMR INDUSTRIES PRIVATE LIMITED','BMR EXPORTS-AP','BMR EXPORTS-ODISHA') NULL AFTER `batch_number`; 17-04-2024 CREATE TABLE `erpx_dev_masters`.`stock_item_categories` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `category` VARCHAR(255) NOT NULL, `type` ENUM('Stock Items','End Customer','Vendor') NOT NULL, `created_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6), `created_user` VARCHAR(40), `updated_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP (6), `updated_user` VARCHAR(40), PRIMARY KEY (`id`) ) ENGINE=INNODB CHARSET=latin1 COLLATE=latin1_swedish_ci; 25-04-2024 02:31 AM ALTER TABLE `erpx_dev_masters`.`sku_codes` ADD COLUMN `vendor_category` VARCHAR(50) NOT NULL AFTER `hon_to_fg_yield`, ADD COLUMN `tax_name` VARCHAR(50) NOT NULL AFTER `vendor_category`, ADD COLUMN `type_of_supply` ENUM('Goods/services','Goods/capital') NOT NULL AFTER `tax_name`, ADD COLUMN `taxability_type` ENUM('Exempt/Nill','Rated/Non','GST/Taxable') NOT NULL AFTER `type_of_supply`; 25-04-2024 ALTER TABLE `erpx_dev_rm_procurement`.`grn` ADD COLUMN `ref_no` INT(11) NULL AFTER `reweighment_bill_to`, DROP PRIMARY KEY, ADD PRIMARY KEY (`grn_id`); ALTER TABLE `erpx_dev_sales`.`sale_order_items` DROP COLUMN `gross_weight`, DROP COLUMN `frozen_weight`; ALTER TABLE `erpx_dev_sales`.`so_invoice_details` ADD COLUMN `gross_weight` DECIMAL(10,3) NULL AFTER `buyer_address`, ADD COLUMN `frozen_weight` DECIMAL(10,3) NULL AFTER `gross_weight`; ALTER TABLE `erpx_dev_sales`.`so_invoice_details` ADD COLUMN `notify_party` INT(11) NULL AFTER `frozen_weight`, ADD COLUMN `port_of_discharge` INT(11) NULL AFTER `notify_party`; ALTER TABLE `erpx_dev_sales`.`so_po_details` CHANGE `brandType` `brandType` VARCHAR(30) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `is_brand_approved` `is_brand_approved` ENUM('YES','NO','Fresher','Experience') CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE `erpx_dev_sales`.`sale_order_log` CHANGE `is_brand_approved` `is_brand_approved` ENUM('YES','NO','Fresher','Experience') CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `brandType` `brandType` VARCHAR(30) CHARSET latin1 COLLATE latin1_swedish_ci NULL; 23-04-2024 CREATE TABLE `erpx_dev_masters`.`vendor_banks_log` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `bank_name` VARCHAR(255) NOT NULL, `created_at` DATETIME(6), `updated_at` DATETIME(6) ON UPDATE CURRENT_TIMESTAMP (6), `created_user` VARCHAR(55), `updated_user` VARCHAR(55), `vendor_bank_id` INT(11), PRIMARY KEY (`id`) ) ENGINE=INNODB CHARSET=latin1 COLLATE=latin1_swedish_ci; ALTER TABLE `erpx_dev_masters`.`vendors` ADD COLUMN `state_name` VARCHAR(55) NOT NULL AFTER `tds_deductble`; ALTER TABLE `erpx_dev_masters`.`vendors` ADD COLUMN `pan_number` VARCHAR(15) NOT NULL AFTER `state_name`; ALTER TABLE `erpx_dev_masters`.`vendors` ADD COLUMN `vendor_category` VARCHAR(55) NOT NULL AFTER `pan_number`; ALTER TABLE `erpx_dev_masters`.`vendors` ADD COLUMN `deductble_type` ENUM('Unknown','Artificial Juridical Person','Association of Persons','Body of Individuals','Company-Resident','Co-Operative Society - Non Resident','Co-Operative Society - Resident','Government','Individual/HUF - Non Resident','Individual/HUF - Resident','Local Authority','Partnership Firm') NULL AFTER `vendor_category`; ALTER TABLE `erpx_dev_masters`.`end_customers` ADD COLUMN `state_name` VARCHAR(50) NOT NULL AFTER `consignee_name`, ADD COLUMN `country_name` VARCHAR(50) NOT NULL AFTER `state_name`; ALTER TABLE `erpx_dev_masters`.`end_customers` ADD COLUMN `end_customer_type` ENUM('domestic','Export') NOT NULL AFTER `country_name`, ADD COLUMN `registration_type` ENUM('composition','regular','unregistered/consumer') NULL AFTER `end_customer_type`, ADD COLUMN `tcs_applicable` ENUM('Yes','No') NOT NULL AFTER `registration_type`; ALTER TABLE `erpx_dev_masters`.`end_customers` ADD COLUMN `fax_no` VARCHAR(20) NOT NULL AFTER `tcs_applicable`, ADD COLUMN `phone_no` VARCHAR(20) NOT NULL AFTER `fax_no`; ALTER TABLE `erpx_dev_masters`.`vendors` ADD COLUMN `registration_type` ENUM('Composition','Regular','Unregistererd/Consumer') NULL AFTER `tds_deductble`; ALTER TABLE `erpx_dev_masters`.`vendors` CHANGE `registration_type` `registration_type` ENUM('composition','regular','unregistered/consumer','Unregistererd/Consumer') CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL; ALTER TABLE `erpx_dev_masters`.`vendors` ADD COLUMN `registration_type` ENUM('composition','regular') NOT NULL AFTER `candidate_type`, ADD COLUMN `tds_deductble` ENUM('Yes','No') NOT NULL AFTER `registration_type`; 24-04-2024 ALTER TABLE `erpx_dev_masters`.`end_customers` CHANGE `country_name` `country_id` INT(11) NOT NULL; 22-04-2024 ALTER TABLE `erpx_dev_masters`.`states` CHANGE `id` `state_id` INT(11) NOT NULL AUTO_INCREMENT, DROP PRIMARY KEY, ADD PRIMARY KEY (`state_id`); 27-04-2024 ALTER TABLE `erpx_dev_sales`.`documents_approval` CHANGE `survey_report_uploaded` `survey_report_uploaded` TINYINT(4) DEFAULT 0 NULL AFTER `health_certificate_uploaded`; ALTER TABLE `erpx_dev_sales`.`documents_approval` CHANGE `health_certificate_uploaded` `health_certificate_uploaded` TINYINT(4) DEFAULT 0 NULL AFTER `declaration_of_shrimp_uploaded`; ALTER TABLE `erpx_dev_sales`.`documents_approval` ADD COLUMN `health_certificate_uploaded` TINYINT(4) DEFAULT 0 NULL AFTER `version_flag`, ADD COLUMN `survey_report_uploaded` TINYINT(4) DEFAULT 0 NULL AFTER `health_certificate_uploaded`; ALTER TABLE `erpx_dev_warehouse`.`domestic_sales` CHANGE `is_active` `is_active` TINYINT(4) DEFAULT 1 NOT NULL; ALTER TABLE `erpx_dev_logistics`.`loading_sheet` CHANGE `variety` `variety` INT(11) NULL; ALTER TABLE `erpx_dev_logistics`.`loading_sheet` CHANGE `variety` `variety` INT(11) NULL; ALTER TABLE `erpx_dev_logistics`.`container` ADD COLUMN `freight_after_shipment` VARCHAR(50) NULL AFTER `temp_indicator_no`; ALTER TABLE `erpx_dev_logistics`.`container` ADD COLUMN `freight_after_shipment` VARCHAR(50) NULL AFTER `temp_indicator_no`; ALTER TABLE `erpx_dev_logistics`.`container` ADD COLUMN `branch_code` VARCHAR(50) NULL AFTER `container_size`, ADD COLUMN `temp_indicator_no` VARCHAR(50) NULL AFTER `branch_code`; ALTER TABLE `erpx_dev_logistics`.`container` ADD COLUMN `container_size` VARCHAR(50) NULL AFTER `loadingSheet_number`; 27-04-2024 ALTER TABLE `erpx_dev_masters`.`end_customers` ADD COLUMN `category` VARCHAR(55) NOT NULL AFTER `phone_no`; ALTER TABLE `erpx_dev_masters`.`vendors` CHANGE `vendor_category` `category` VARCHAR(55) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL; ALTER TABLE `erpx_dev_masters`.`sku_codes` DROP COLUMN `type_of_supply`, DROP COLUMN `taxability_type`, ADD COLUMN `type_of_supply` ENUM('Capital Goods','Goods','Services') NULL AFTER `tax_name`, ADD COLUMN `taxability_type` ENUM('Exempt','Nill Rated','Non Gst','Taxable') NULL AFTER `type_of_supply`; 25-04-2024 ALTER TABLE `erpx_dev_rm_procurement`.`grn` ADD COLUMN `ref_no` INT(11) NULL AFTER `reweighment_bill_to`, DROP PRIMARY KEY, ADD PRIMARY KEY (`grn_id`); ALTER TABLE `erpx_dev_sales`.`sale_order_items` DROP COLUMN `gross_weight`, DROP COLUMN `frozen_weight`; ALTER TABLE `erpx_dev_sales`.`so_invoice_details` ADD COLUMN `gross_weight` DECIMAL(10,3) NULL AFTER `buyer_address`, ADD COLUMN `frozen_weight` DECIMAL(10,3) NULL AFTER `gross_weight`; ALTER TABLE `erpx_dev_sales`.`so_invoice_details` ADD COLUMN `notify_party` INT(11) NULL AFTER `frozen_weight`, ADD COLUMN `port_of_discharge` INT(11) NULL AFTER `notify_party`; ALTER TABLE `erpx_dev_sales`.`so_po_details` CHANGE `brandType` `brandType` VARCHAR(30) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `is_brand_approved` `is_brand_approved` ENUM('YES','NO','Fresher','Experience') CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE `erpx_dev_sales`.`sale_order_log` CHANGE `is_brand_approved` `is_brand_approved` ENUM('YES','NO','Fresher','Experience') CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `brandType` `brandType` VARCHAR(30) CHARSET latin1 COLLATE latin1_swedish_ci NULL; Queries executed 26-04-2024 ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `freezer` ENUM('IQF1','IQF2','IQF3','PF') NULL AFTER `pallet_status`; ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `transaction_type` `transaction_type` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','reworking') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'palleting' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `transaction_type` `transaction_type` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','reworking','stockIn') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'palleting' NOT NULL; --------------------------------------already executed -------------------------------------------------------------------- 29-04-2024 ALTER TABLE `erpx_dev_masters`.`items` ADD COLUMN `category` VARCHAR(55) NULL AFTER `hsn_code`, ADD COLUMN `taxability_type` ENUM('Exempt','Nill Rated','Non Gst','Taxable') NULL AFTER `category`, ADD COLUMN `tax_name` VARCHAR(55) NULL AFTER `taxability_type`, ADD COLUMN `rate_of_duty` VARCHAR(55) NULL AFTER `tax_name`; ALTER TABLE `erpx_dev_masters`.`items` ADD COLUMN `type_of_supply` ENUM('Capital Goods','Goods','Services') NULL AFTER `rate_of_duty`; ALTER TABLE `erpx_dev_rm_procurement`.`indent` ADD COLUMN `indent_status` ENUM('OPEN','IN PROGRESS','CLOSED','CANCELLED') DEFAULT 'OPEN' NOT NULL AFTER `farm_type`; ALTER TABLE `erpx_dev_masters`.`vendors` DROP COLUMN `vendor_category`, ADD COLUMN `category` VARCHAR(55) NOT NULL AFTER `deductble_type`; 29-04-2024 ALTER TABLE `erpx_dev_finance`.`purchases` ADD COLUMN `ref_no` INT(11) NULL AFTER `version_flag`; 30-04-2024 ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` CHANGE `count` `count` DECIMAL(5,2) NULL; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` CHANGE `quantity` `quantity` DECIMAL(10,3) NULL, CHANGE `price` `price` DECIMAL(10,2) NULL, CHANGE `actual_quantity` `actual_quantity` DECIMAL(10,3) NULL, CHANGE `actual_count` `actual_count` DECIMAL(5,2) NULL; ALTER TABLE `erpx_dev_masters`.`end_customers` DROP COLUMN `category`, ADD COLUMN `category_id` INT(11) NOT NULL AFTER `country_id`; ALTER TABLE `erpx_dev_masters`.`sku_codes` DROP COLUMN `vendor_category`, DROP COLUMN `tax_name`, ADD COLUMN `category_id` INT(11) NOT NULL AFTER `taxability_type`, ADD COLUMN `tax_id` INT(11) NOT NULL AFTER `category_id`; ALTER TABLE `erpx_dev_masters`.`vendors` DROP COLUMN `bank_name`, DROP COLUMN `category`, ADD COLUMN `bank_id` INT(11) NOT NULL AFTER `deductble_type`, ADD COLUMN `category_id` INT(11) NOT NULL AFTER `bank_id`; ALTER TABLE `erpx_dev_masters`.`items` DROP COLUMN `category`, DROP COLUMN `tax_name`, ADD COLUMN `tax_id` INT(11) NULL AFTER `type_of_supply`, ADD COLUMN `category_id` INT(11) NOT NULL AFTER `tax_id`; 2-05-2024 ALTER TABLE `erpx_dev_masters`.`items` CHANGE `category_id` `category_id` INT(11) NULL; 02-05-2024 ALTER TABLE `erpx_dev_sales`.`customer_invoice` ADD COLUMN `collection` DECIMAL(10,2) NULL AFTER `q_certificate_no`; 03-05-2024 (sunanda) ALTER TABLE `erpx_dev_sales`.`customer_invoice` CHANGE `collection` `collection` DECIMAL(10,2) DEFAULT 0 NULL; ALTER TABLE `erpx_dev_sales`.`customer_invoice` ADD COLUMN `ddb_amt` DECIMAL(10,2) DEFAULT 0.00 NULL AFTER `collection`; 04-05 (raji) ALTER TABLE `erpx_dev_rm_procurement`.`grn` CHANGE `batch_number` `batch_number` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NULL; 03-05-2024----------vi ALTER TABLE `erpx_dev_sales`.`domestic_sales` CHANGE `domestic_sale_order_no` `domestic_sale_order_no` VARCHAR(11) CHARSET latin1 COLLATE latin1_swedish_ci NULL AFTER `id`, CHANGE `sale_order_date` `sale_order_date` DATETIME NULL AFTER `unit_id`; 04-05-2024 (sunanda) ALTER TABLE `erpx_dev_sales`.`sale_order` ADD COLUMN `invoice_no` VARCHAR(50) NULL AFTER `enquiry_id`, ADD COLUMN `ref_no` VARCHAR(50) NULL AFTER `invoice_no`; ALTER TABLE `erpx_dev_rm_procurement`.`indent` ADD COLUMN `cance_reason` INT NULL AFTER `indent_status`; 06-05-2024(vineela) ALTER TABLE `erpx_dev_logistics`.`container` CHANGE `temp_indicator_no` `temp_indicator_no1` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NULL, ADD COLUMN `temp_indicator_no2` VARCHAR(50) NULL AFTER `freight_after_shipment`, ADD COLUMN `temp_indicator_no3` VARCHAR(50) NULL AFTER `temp_indicator_no2`, ADD COLUMN `eta` DATETIME NULL AFTER `temp_indicator_no3`, ADD COLUMN `shipping_liner` VARCHAR(50) NULL AFTER `eta`; 06-05-2024(raji) ALTER TABLE `erpx_dev_enquiries`.`enquiries` ADD COLUMN `is_regenerated` TINYINT(4) DEFAULT 0 NULL AFTER `uom_id`; 06-05-2024(sunanda) ALTER TABLE `erpx_dev_masters`.`items` DROP COLUMN `tax_id`, DROP COLUMN `category_id`, ADD COLUMN `tax_id` INT NULL AFTER `type_of_supply`, ADD COLUMN `category_id` INT NULL AFTER `tax_id`, ADD FOREIGN KEY (`tax_id`) REFERENCES `erpx_dev_masters`.`taxes`(`tax_id`), ADD FOREIGN KEY (`category_id`) REFERENCES `erpx_dev_masters`.`stock_item_categories`(`id`); 09-05-2024(Naveen) CREATE TABLE `erpx_dev_hrms`.`holidays_calendar_log` ( `holiday_id` INT(11) NOT NULL AUTO_INCREMENT, `holiday_name` CHAR(50) NOT NULL, `holiday_date` VARCHAR(255) NOT NULL, `is_active` TINYINT(4) NOT NULL DEFAULT 1, `created_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `created_user` VARCHAR(225) NOT NULL DEFAULT '1', `updated_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP (6), `updated_user` VARCHAR(255), `version_flag` INT(11) NOT NULL DEFAULT 1, `holidays-calendar_id` INT(11), PRIMARY KEY (`holiday_id`) ) ENGINE=INNODB CHARSET=latin1 COLLATE=latin1_swedish_ci; 07-05-2024(vineela) ALTER TABLE `erpx_dev_sales`.`customer_invoice` ADD COLUMN `gross_weight` DECIMAL(10,2) DEFAULT 0.00 NULL AFTER `file_path`, ADD COLUMN `frozen_weight` DECIMAL(10,2) DEFAULT 0.00 NULL AFTER `gross_weight`; ALTER TABLE `erpx_dev_sales`.`customer_invoice` ADD COLUMN `ref_no` INT NULL AFTER `frozen_weight`; ---------------------------------------------------------------------- already executed -------------------------------------------------------------------------------------------------------------- 09-05-2024(Naveen) ALTER TABLE `erpx_dev_sales`.`customer_invoice` ADD COLUMN `file_name` VARCHAR(255) NULL AFTER `ddb_amt`, ADD COLUMN `file_path` VARCHAR(255) NULL AFTER `file_name`; ALTER TABLE `erpx_dev_procurement`.`grn` ADD COLUMN `file_name` VARCHAR(255) NULL AFTER `inspection_status`, ADD COLUMN `file_path` VARCHAR(255) NULL AFTER `file_name`; LTER TABLE `erpx_dev_procurement`.`purchase_order` CHANGE `purchase_order_date` `purchase_order_date` DATETIME NOT NULL FIRST, CHANGE `purchase_order_id` `purchase_order_id` INT(11) NOT NULL AUTO_INCREMENT AFTER `purchase_order_date`, ADD COLUMN `file_name` VARCHAR(255) NULL AFTER `vendor_ack_date`, ADD COLUMN `file_path` VARCHAR(255) NULL AFTER `file_name`; 10-05-2024(Naveen) ALTER TABLE `erpx_dev_masters`.`sku_codes` ADD COLUMN `rate_of_duty` VARCHAR(255) NULL AFTER `tax_id`; 17-05-2024(Naveen) ALTER TABLE `erpx_dev_hrms`.`apply_for_leaves` CHANGE `leave_from_day` `leave_from_day` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `leave_to_day` `leave_to_day` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `leave_applied_date` `leave_applied_date` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL; CREATE TABLE `erpx_dev_hrms`.`apply_for_leaves_log` ( `apply_for_leaves_id` INT(11) NOT NULL AUTO_INCREMENT, `employee_id` VARCHAR(40) NOT NULL, `employee_code` VARCHAR(40) NOT NULL, `employee_name` VARCHAR(40), `type_of_leave` VARCHAR(255) NOT NULL, `from_date` DATETIME, `to_date` DATETIME NOT NULL, `leave_from_day` VARCHAR(255) NOT NULL, `leave_to_day` VARCHAR(255) NOT NULL, `no_of_days` DECIMAL(10,1), `leave_reason` VARCHAR(255) NOT NULL, `leave_applied_date` VARCHAR(255) NOT NULL, `leave_address` VARCHAR(255), `status` ENUM('OPEN','APPROVED','REJECTED','CANCEL') DEFAULT 'OPEN', `is_active` TINYINT(4) NOT NULL DEFAULT 1, `rejection_reason` VARCHAR(150), `created_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `created_user` VARCHAR(255), `updated_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `updated_user` VARCHAR(255), `version_flag` INT(11) NOT NULL DEFAULT 1, `apply_leave_log_id` INT(11), PRIMARY KEY (`apply_for_leaves_id`) ) ENGINE=INNODB CHARSET=latin1 COLLATE=latin1_swedish_ci; ALTER TABLE `erpx_dev_hrms`.`apply_for_leaves_log` CHANGE `leave_from_day` `leave_from_day` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `leave_to_day` `leave_to_day` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `leave_applied_date` `leave_applied_date` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL; 18-05-2024(Naveen) CREATE TABLE `erpx_dev_hrms`.`employee_week_off_uploads` ( `week_off_id` INT(11) NOT NULL AUTO_INCREMENT, `employee_id` VARCHAR(40) NOT NULL, `employee_code` VARCHAR(40) NOT NULL, `employee_type` VARCHAR(40) NOT NULL, `employee_category` VARCHAR(40) NULL, `week_off_day` VARCHAR(40) NOT NULL, `created_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `updated_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), `created_user` VARCHAR(55), `updated_user` VARCHAR(55), PRIMARY KEY (`week_off_id`) ) ENGINE=INNODB CHARSET=latin1 COLLATE=latin1_swedish_ci; CREATE TABLE `erpx_dev_hrms`.`employee_week_off_uploads_log` ( `week_off_id` INT(11) NOT NULL AUTO_INCREMENT, `employee_id` VARCHAR(40) NOT NULL, `employee_code` VARCHAR(40) NOT NULL, `employee_type` VARCHAR(40) NOT NULL, `employee_category` VARCHAR(40) NULL, `week_off_day` VARCHAR(40) NOT NULL, `created_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `updated_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), `created_user` VARCHAR(55), `updated_user` VARCHAR(55), `employee_week_off_uploads_log_id` INT(11), PRIMARY KEY (`week_off_id`) ) ENGINE=INNODB CHARSET=latin1 COLLATE=latin1_swedish_ci; 21-05-2024 (Raji) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `addon_count` TINYINT(4) DEFAULT 0 NULL AFTER `ice_rate`; ALTER TABLE `erpx_dev_enquiries`.`enquiry_products` CHANGE `style_weighment` `style_weighment` ENUM('FWNC','FWFC','NWNC','NWFC') CHARSET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `transaction_type` `transaction_type` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','rework') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'rm' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `transaction_type` `transaction_type` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','stockIn','rework') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'palleting' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_jobs` CHANGE `job_purpose` `job_purpose` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','rework') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'palleting' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `state` `state` ENUM('Allocated For Repacking','Allocated For Reprocessing','Assigned For Repacking','Partially Assigned For Repacking','Partially Assigned For Reprocessing','Assigned For Reprocessing','Stock','Allocated For Rework','Partially Assigned For Rework','Assigned For Rework') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'Stock' NOT NULL; 22-05-2024 (Raji) ALTER TABLE `erpx_dev_rm_procurement`.`grn` DROP COLUMN `batch_number`, DROP COLUMN `ref_no`; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` CHANGE `indent_item_id` `indent_item_id` INT(11) NULL, CHANGE `product` `product` INT(11) NULL; 22-05-2024(vineela) ALTER TABLE `erpx_dev_sales`.`customer_invoice` ADD COLUMN `bank_reached_date` DATE NULL AFTER `ref_no`; ALTER TABLE `erpx_dev_sales`.`customer_invoice` CHANGE `bank_reached_date` `bank_reached_date` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) NULL; ---------------------------------------------------------------------- already executed -------------------------------------------------------------------------------------------------------------- 23-05-2024(vineela) ALTER TABLE `erpx_dev_logistics`.`container` ADD COLUMN `leo_date` VARCHAR(30) NULL AFTER `shipping_liner`, ADD COLUMN `brc_rel_date` VARCHAR(30) NULL AFTER `leo_date`; CREATE TABLE `erpx_dev_logistics`.`post_shipment_details` ( `post_shipment_id` INT(11) NOT NULL AUTO_INCREMENT, `vessel_no` INT(11), `vessel_name` VARCHAR(50), `marks_no` VARCHAR(50), `date_of_issue` DATETIME, `lc_no` VARCHAR(50), `lc_name` VARCHAR(50), `lc_bank_address` VARCHAR(50), `lc_amount` INT(11), `is_active` TINYINT(4) NOT NULL DEFAULT 1, `created_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `created_user` VARCHAR(50), `updated_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `updated_user` VARCHAR(50), `version_flag` INT(11) NOT NULL DEFAULT 1, PRIMARY KEY (`post_shipment_id`) ); ALTER TABLE `erpx_dev_logistics`.`post_shipment_details` ADD COLUMN `sale_order_id` INT(11) NULL AFTER `post_shipment_id`; 24-05-2024 (Raji) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `inv_status` ENUM('OPEN','UNDER APPROVAL','APPROVED','IN PROGRESS','CLOSE') DEFAULT 'OPEN' NULL AFTER `addon_count`; ALTER TABLE `erpx_dev_rm_procurement`.`grn` DROP COLUMN `inv_no`, DROP COLUMN `inv_date`, DROP COLUMN `bill_to`, CHANGE `inv_status` `inv_status` ENUM('OPEN','UNDER APPROVAL','APPROVED','IN PROGRESS','CLOSE') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'OPEN' NULL; 23-05-2024(vineela) ALTER TABLE `erpx_dev_logistics`.`container` ADD COLUMN `leo_date` VARCHAR(30) NULL AFTER `shipping_liner`, ADD COLUMN `brc_rel_date` VARCHAR(30) NULL AFTER `leo_date`; CREATE TABLE `erpx_dev_logistics`.`post_shipment_details` ( `post_shipment_id` INT(11) NOT NULL AUTO_INCREMENT, `vessel_no` INT(11), `vessel_name` VARCHAR(50), `marks_no` VARCHAR(50), `date_of_issue` DATETIME, `lc_no` VARCHAR(50), `lc_name` VARCHAR(50), `lc_bank_address` VARCHAR(50), `lc_amount` INT(11), `is_active` TINYINT(4) NOT NULL DEFAULT 1, `created_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `created_user` VARCHAR(50), `updated_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `updated_user` VARCHAR(50), `version_flag` INT(11) NOT NULL DEFAULT 1, PRIMARY KEY (`post_shipment_id`) ); ALTER TABLE `erpx_dev_logistics`.`post_shipment_details` ADD COLUMN `sale_order_id` INT(11) NULL AFTER `post_shipment_id`; 24-05-2024 (Raji) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `inv_status` ENUM('OPEN','UNDER APPROVAL','APPROVED','IN PROGRESS','CLOSE') DEFAULT 'OPEN' NULL AFTER `addon_count`; ALTER TABLE `erpx_dev_rm_procurement`.`grn` DROP COLUMN `inv_no`, DROP COLUMN `inv_date`, DROP COLUMN `bill_to`, CHANGE `inv_status` `inv_status` ENUM('OPEN','UNDER APPROVAL','APPROVED','IN PROGRESS','CLOSE') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'OPEN' NULL; 25-05-2024 (Raji) ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `reporting_type` ENUM('PARTIAL','FULL') NULL AFTER `lot_number`; ALTER TABLE `erpx_dev_production`.`production_inventory` ADD COLUMN `prev_operation` ENUM('GRN','DEHEADING','GRADING','VALUE ADDITION','SOAKING','FREEZING','PACKING','NO OPERATION','TOFF','PD','RPDTON','COOKING','PEELING','PEELUNDEVEIN','REJECTION') NULL AFTER `inventory_type`; 05-05-2024(Naveen_hrms) ALTER TABLE `erpx_dev_hrms`.`attendance` ADD COLUMN `punch_status` VARBINARY(11) NULL AFTER `leave_status`; 25-05-2024(sunanda) ALTER TABLE `erpx_dev_masters`.`end_customers` ADD COLUMN `hts_code` VARCHAR(20) NULL AFTER `category_id`; 27-05-2024(vineela) CREATE TABLE `erpx_dev_logistics`.`expenses` ( `expenses_logistics_id` INT(11) NOT NULL AUTO_INCREMENT, `sale_order_id` INT(11), `cha_bill` INT(11), `ocean_frieght` INT(11), `domestic_frieght` INT(11), `sales_comission` INT(11), `anti_dumping_duty` INT(11), `cvd` INT(11), `clearing_forwarding` INT(11), `ddp_transport` INT(11), `marine_insurance` INT(11), `amc` INT(11), `duty_drawback` INT(11), `rodtep_amount` INT(11), `fda_due_date` VARCHAR(40), `remarks` VARCHAR(250), `is_active` TINYINT(4) NOT NULL DEFAULT 1, `created_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `created_user` VARCHAR(50), `updated_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `updated_user` VARCHAR(50), `version_flag` INT(11) NOT NULL DEFAULT 1, PRIMARY KEY (`expenses_logistics_id`) ); ALTER TABLE `erpx_dev_logistics`.`expenses` CHANGE `fda_due_date` `fda_due_date` DATETIME NULL; ALTER TABLE `erpx_dev_logistics`.`expenses` CHANGE `fda_due_date` `fda_due_date` VARCHAR(40) NULL; CREATE TABLE `erpx_dev_logistics`.`expenses_due_date` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `sale_order_id` INT(11), `fda_due_date` DATETIME, `remarks` VARCHAR(200), `is_active` TINYINT(4) NOT NULL DEFAULT 1, `created_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `created_user` VARCHAR(50), `updated_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `updated_user` VARCHAR(50), `version_flag` INT(11) NOT NULL DEFAULT 1, PRIMARY KEY (`id`) ); ALTER TABLE `erpx_dev_logistics`.`expenses_due_date` ADD COLUMN `expenses_logistics_id` INT(11) NULL AFTER `id`; ALTER TABLE `erpx_dev_logistics`.`expenses_due_date` CHANGE `fda_due_date` `fda_due_date` VARCHAR(200) NULL; ALTER TABLE `erpx_dev_logistics`.`expenses_due_date` DROP COLUMN `sale_order_id`; 28-05-2024(Raji) ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `product` VARCHAR(100) NULL AFTER `reporting_type`; ALTER TABLE `erpx_dev_production`.`production_inventory` ADD COLUMN `product` VARCHAR(100) NULL AFTER `prev_operation`; 28-05-2024(sunanda) ALTER TABLE `erpx_dev_masters`.`end_customers` ADD COLUMN `consignee_address` VARCHAR(255) NULL AFTER `hts_code`; 29-05-2024(Raji) ALTER TABLE `erpx_dev_production`.`grade_inventory_log` CHANGE `sub_plant_id` `sub_plant_id` INT(11) DEFAULT 0 NULL; ALTER TABLE `erpx_dev_production`.`grade_inventory` CHANGE `sub_plant_id` `sub_plant_id` INT(11) DEFAULT 0 NULL; ALTER TABLE `erpx_dev_production`.`grade_inventory` CHANGE `planned_so_number` `planned_so_number` VARCHAR(50) DEFAULT 0 NULL; 29-05 15:37 ALTER TABLE `erpx_dev_enquiries`.`cost_sheet` ADD COLUMN `adcvd_per_val` DECIMAL(10,2) DEFAULT 0 NULL AFTER `final_profit_loss`, ADD COLUMN `tot_cost_of_sales_usd_lb` DECIMAL(10,2) UNSIGNED NULL AFTER `adcvd_per_val` 30-05 12:25 ALTER TABLE `erpx_dev_enquiries`.`cost_sheet` ADD COLUMN `ad_per` INT NULL AFTER `total_sale_cost`, ADD COLUMN `cvd_per` INT NULL AFTER `ad_per`; 29-05-2024(sunanda) ALTER TABLE `erpx_dev_procurement`.`purchase_order` ADD COLUMN `ref_no` INT NULL AFTER `vendor_ack_date`; ALTER TABLE `erpx_dev_sales`.`sale_order` CHANGE `ref_no` `ref_no` INT(50) NULL; 30-05-2024(Naveen) ALTER TABLE `erpx_dev_masters`.`end_customers` CHANGE `fax_no` `fax_no` VARCHAR(20) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `phone_no` `phone_no` VARCHAR(20) CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE `erpx_dev_masters`.`vendors` CHANGE `registration_type` `registration_type` ENUM('composition','regular','unregistered/consumer','Unregistererd/Consumer') CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `tds_deductble` `tds_deductble` ENUM('Yes','No') CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `pan_number` `pan_number` VARCHAR(15) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `bank_id` `bank_id` INT(11) NULL, DROP PRIMARY KEY, ADD PRIMARY KEY (`vendor_id`, `is_active`); 06-06-2024 16:20 ALTER TABLE `erpx_dev_procurement`.`store_consumption` CHANGE `stock_type` `stock_type` ENUM('anticipated','SaleOrder','dummy','Super Dummy','generalItems') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'SaleOrder' NULL; 31-05-2024 (Raji) ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `item_code` VARCHAR(100) NULL AFTER `product_description`; ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `duplicate_grade` VARCHAR(50) NULL AFTER `item_code`; ALTER TABLE `erpx_dev_rm_procurement`.`grn` ADD COLUMN `vehicle_number` VARCHAR(50) NULL AFTER `reweighment_bill_to`; 04-06-2024(vineela) ALTER TABLE `erpx_dev_procurement`.`purchase_order` ADD COLUMN `indent_no` VARCHAR(255) NULL AFTER `ref_no`, ADD COLUMN `qtn_proforma_inv_no` VARCHAR(255) NULL AFTER `indent_no`, ADD COLUMN `proforma_date` VARCHAR(255) NULL AFTER `qtn_proforma_inv_no`, ADD COLUMN `price_basis` VARCHAR(255) NULL AFTER `proforma_date`, ADD COLUMN `dispatch_instructions` VARCHAR(255) NULL AFTER `price_basis`, ADD COLUMN `dispatched_through` VARCHAR(255) NULL AFTER `dispatch_instructions`; 07-06-2024(vineela) ALTER TABLE `erpx_dev_masters`.`freights_company` ADD COLUMN `liner_address` VARCHAR(255) NULL AFTER `code`; 10-06-2024(Raji) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `yield_per` INT(11) NULL AFTER `inv_status`; ALTER TABLE `erpx_dev_production`.`grade_inventory` ADD COLUMN `hon_count` INT(11) NULL AFTER `issued_boxes`, ADD COLUMN `hon_quantity` DECIMAL(10,3) NULL AFTER `hon_count`, ADD COLUMN `rm_rate` DECIMAL(10,2) NULL AFTER `hon_quantity`, ADD COLUMN `amount` DECIMAL(10,2) NULL AFTER `rm_rate`; 13-06-2024(vineela) ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `frozen_weight` DECIMAL(10,3) NULL AFTER `duplicate_grade`; ALTER TABLE `erpx_dev_masters`.`unitcodes` CHANGE `company` `company` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL, ADD COLUMN `company_id` INT(11) NULL AFTER `company`; 14-06-2024(uma) ALTER TABLE `erpx_dev_enquiries`.`cost_sheet` ADD COLUMN `frozen_yield` INT UNSIGNED NULL AFTER `cvd_per`, ADD COLUMN `containers` INT UNSIGNED NOT NULL AFTER `frozen_yield` 14-06-2024 (Raji) ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `hts_code` VARCHAR(50) NULL AFTER `frozen_weight`; 20-06-2024 (Raji) ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `shift` `shift` ENUM('shiftA','shiftB','shiftC','general','DAY','NIGHT') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'general' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `shift` `shift` ENUM('shiftA','shiftB','shiftC','general','DAY','NIGHT') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'general' NOT NULL; ALTER TABLE `erpx_dev_procurement`.`store_return` CHANGE `return_reason` `return_reason` VARCHAR(20) NOT NULL; 20-6-2024(Raji) ALTER TABLE `erpx_dev_production`.`production_log` CHANGE `input_grade` `input_grade` VARCHAR(20) NULL, CHANGE `planned_grade` `planned_grade` DECIMAL(10,2) DEFAULT 0.00 NULL, CHANGE `actual_grade` `actual_grade` VARCHAR(20) NULL; ALTER TABLE `erpx_dev_production`.`production_inventory` CHANGE `input_grade` `input_grade` VARCHAR(20) NULL, CHANGE `output_grade` `output_grade` VARCHAR(20) NULL; ALTER TABLE `erpx_dev_production`.`grade_inventory_log` CHANGE `grade` `grade` DECIMAL(10,2) DEFAULT 0.00 NOT NULL; ALTER TABLE `erpx_dev_production`.`grade_inventory` CHANGE `grade` `grade` DECIMAL(10,2) DEFAULT 0.00 NOT NULL; 21-06-2024(Raji) ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `stock_type` `stock_type` ENUM('anticipated','SaleOrder','dummy','Super Dummy') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'SaleOrder' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `stock_type` `stock_type` ENUM('Anticipated','SaleOrder','dummy','Super Dummy') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'SaleOrder' NOT NULL; 23-06-2024(Raji) ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `prev_operation` ENUM('GRN','DEHEADING','GRADING','VALUE ADDITION','SOAKING','FREEZING','PACKING','NO OPERATION','TOFF','PD','RPDTON','COOKING','PEELING','PEELUNDEVEIN','REJECTION') NULL AFTER `product`; 26-06-2024(lokesh) Alter table erpx_dev_masters.items add column item_uom int(11) NULL after category_id Alter table erpx_dev_masters.items change item_uom item_uom varchar(50) NULL; 03-07-2024(Raji) ALTER TABLE `erpx_dev_warehouse`.`stock` ADD COLUMN `total_loose_pouches` INT(11) NULL AFTER `version_flag`, ADD COLUMN `stockout_loose_pouches` INT(11) NULL AFTER `total_loose_pouches`; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_jobs` ADD COLUMN `total_job_loose_pouches` INT(11) NULL AFTER `version_flag`; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_items` ADD COLUMN `job_loose_pouches` INT(11) NULL AFTER `version_flag`; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_jobs` CHANGE `total_job_loose_pouches` `total_job_loose_pouches` INT(11) DEFAULT 0 NULL; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_items` CHANGE `job_loose_pouches` `job_loose_pouches` INT(11) DEFAULT 0 NULL; 05-07-2024(Raji) ALTER TABLE `erpx_dev_production`.`grade_inventory` CHANGE `hon_count` `hon_count` DECIMAL(10,2) NULL, ADD COLUMN `grn_hon_count` DECIMAL(10,2) NULL AFTER `grade_range`, ADD COLUMN `grn_hon_quantity` DECIMAL(10,3) NULL AFTER `grn_hon_count`, ADD COLUMN `grn_rm_rate` DECIMAL(10,2) NULL AFTER `grn_hon_quantity`; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_items` ADD COLUMN `variant_id` INT(11) NULL AFTER `job_loose_pouches`; 13-07-2024(sunanda) ALTER TABLE erpx_dev_rm_procurement.grn_items ADD COLUMN slot ENUM('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28-30','31','32','33-35','36-40','41','42','43-45','46-50','51','52','53-60','61','62','63-70','71','72','73-80','81','82','83-90','91','92','93-100','101-100','111-120','121-130','130 above') NULL AFTER `yield_per`; 22-07-2024(Naveen) ALTER TABLE `erpx_dev_finance`.`purchases` ADD COLUMN `company` VARCHAR(50) NOT NULL AFTER `ref_no`; 23-07-2024 (Raji) ALTER TABLE `erpx_dev_analytics`.`stock` CHANGE `transaction_type` `transaction_type` ENUM('palleting', 'repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','rework') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'rm' NOT NULL; ALTER TABLE `erpx_dev_analytics`.`stock` CHANGE `state` `state` ENUM('Allocated For Repacking','Allocated For Reprocessing','Assigned For Repacking', 'Partially Assigned For Repacking','Partially Assigned For Reprocessing','Assigned For Reprocessing','Stock','Allocated For Rework','Partially Assigned For Rework', 'Assigned For Rework') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'Stock' NOT NULL; ALTER TABLE `erpx_dev_analytics`.`stock` CHANGE `shift` `shift` ENUM('shiftA','shiftB','shiftC','general','DAY','NIGHT') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'general' NOT NULL; ALTER TABLE `erpx_dev_analytics`.`stock` CHANGE `stock_type` `stock_type` ENUM('Anticipated','SaleOrder','dummy','Super Dummy') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'SaleOrder' NOT NULL; ALTER TABLE `erpx_dev_analytics`.`stock` ADD COLUMN `total_loose_pouches` INT(11) NULL AFTER `version_flag`, ADD COLUMN `stockout_loose_pouches` INT(11) NULL AFTER `total_loose_pouches`; ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `flag` TINYINT(4) DEFAULT 0 NULL AFTER `freezer`; 25-07-2024 (Raji) ALTER TABLE `erpx_dev_production`.`grade_inventory` ADD COLUMN `flag` TINYINT(4) DEFAULT 0 NULL AFTER `grn_rm_rate`; 30-07-2024 (Raji) ALTER TABLE `erpx_dev_production`.`grade_inventory_log` ADD COLUMN `supervisor` INT(11) NULL AFTER `sub_plant_id`; ALTER TABLE `erpx_dev_production`.`grade_inventory` ADD COLUMN `supervisor` INT(11) NULL AFTER `flag`; 1-08-2024 (Raji) ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `contractor_id` INT(11) NULL AFTER `prev_operation`, ADD COLUMN `unit_price` DECIMAL(10,2) UNSIGNED NULL AFTER `contractor_id`, ADD COLUMN `amount` DECIMAL(10,2) UNSIGNED NULL AFTER `unit_price`; ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `bill_no` VARCHAR(30) NULL AFTER `amount`; 3-08-2024(Raji) ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `date` DATETIME(6) NULL AFTER `bill_no`; ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `bill_type` VARCHAR(20) NULL AFTER `date`; ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `no_of_persons` INT(11) NULL AFTER `bill_type`, ADD COLUMN `scope_of_work` VARCHAR(50) NULL AFTER `no_of_persons`, ADD COLUMN `average_qty` DECIMAL(10,3) NULL AFTER `scope_of_work`; ALTER TABLE `erpx_dev_production`.`production_log` CHANGE `no_of_persons` `no_of_persons` INT(11) NULL COMMENT 'For Peeling', CHANGE `scope_of_work` `scope_of_work` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NULL COMMENT 'For Peeling', CHANGE `average_qty` `average_qty` DECIMAL(10,3) NULL COMMENT 'For Peeling'; ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `transportation` VARCHAR(10) NULL AFTER `average_qty`; 6-08-2024 (Raji) ALTER TABLE `erpx_dev_analytics`.`production_cost_analysis` ADD COLUMN `soak_style` VARCHAR(50) NULL AFTER `reporting_id`; ALTER TABLE `erpx_dev_analytics`.`daywise_shrimp_analysis` ADD COLUMN `food_type_id` INT(11) NULL AFTER `domestic_sale_qty_kg`, ADD COLUMN `product_id` INT(11) NULL AFTER `food_type_id`, ADD COLUMN `soak_style` VARCHAR(50) NULL AFTER `product_id`; 21-08-2024(Raji) ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `reason` TEXT NULL AFTER `transportation`; ALTER TABLE `erpx_dev_production`.`production_workers` ADD COLUMN `operation` VARCHAR(20) NOT NULL COMMENT 'Working Operation (Peeling/Deheaing)' AFTER `production_log_id`; ALTER TABLE `erpx_dev_production`.`production_workers` ADD COLUMN `transportation` VARCHAR(20) NOT NULL AFTER `operation`; ALTER TABLE `erpx_dev_production`.`production_log` DROP COLUMN `transportation`; ALTER TABLE `erpx_dev_masters`.`village_transport_cost` CHANGE `village_Name` `village_name` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `Transport_cost` `transport_cost` INT(50) NOT NULL, DROP PRIMARY KEY, ADD PRIMARY KEY (`village_transport_id` , `transport_cost`); 23-08-2024(sunanda) ALTER TABLE `erpx_dev_logistics`.`container` ADD COLUMN `check_list_status` INT(11) DEFAULT 0 NULL AFTER `temperature_degree`; ALTER TABLE `erpx_dev_logistics`.`container` ADD COLUMN `shippment_details_status` INT(11) DEFAULT 0 NULL AFTER `check_list_status`; 21-09-2024(Raji) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `montly_mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `slot`; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` CHANGE `montly_mis_flag` `rewe_mis_flag` TINYINT(4) DEFAULT 0 NULL, ADD COLUMN `procure_mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `rewe_mis_flag`; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` CHANGE `rewe_mis_flag` `rewe_mis_flag` TINYINT(4) DEFAULT 0 NULL COMMENT 'Reweighment Qty Info Montly Mis Flag', CHANGE `procure_mis_flag` `procure_mis_flag` TINYINT(4) DEFAULT 0 NULL COMMENT 'Procured Qty Info Montly Mis Flag'; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` CHANGE `rewe_mis_flag` `reweigh_mis_flag` TINYINT(4) DEFAULT 0 NULL COMMENT 'Reweighment Qty Info Montly Mis Flag'; 21-09-2024(Raji) ALTER TABLE `erpx_dev_procurement`.`store_consumption` ADD COLUMN `mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `transaction_type`; ALTER TABLE `erpx_dev_finance`.`purchase_products` ADD COLUMN `mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `pack_style_id`; ALTER TABLE `erpx_dev_logistics`.`expenses` ADD COLUMN `mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `version_flag`; ALTER TABLE `erpx_dev_rm_procurement`.`rm_invoice` ADD COLUMN `mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `rcpt_rowid`; ALTER TABLE `erpx_dev_logistics`.`container` ADD COLUMN `ship_containers_mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `shippment_details_status`; ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `hon_qty_mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `montly_mis_flag`; ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `montly_mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `flag`; ALTER TABLE `erpx_dev_sales`.`domestic_sales` ADD COLUMN `montly_mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `version_flag`; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_jobs` ADD COLUMN `montly_mis_flag` TINYINT(4) DEFAULT 0 NULL AFTER `total_job_loose_pouches`; ALTER TABLE `erpx_dev_finance`.`expenses` ADD COLUMN `type` ENUM('FIXED COST','MANUFACTURING COST','SALE COST','PACK MATERIAL COST','RM COST') NOT NULL AFTER `updated_user`; ALTER TABLE `erpx_dev_analytics`.`production_cost_analysis` ADD COLUMN `sale_order_id` INT(11) NULL AFTER `soak_style`, ADD COLUMN `inv_num` VARCHAR(50) NULL AFTER `sale_order_id`; ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `transaction_type` `transaction_type` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','stockIn','rework','productPurchase') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'palleting' NOT NULL; 27-09-2024(Raji) ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `transaction_type` `transaction_type` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','rework','labsamples','complements') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'rm' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `transaction_type` `transaction_type` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','stockIn','rework','productPurchase','labsamples','complements') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'palleting' NOT NULL; ALTER TABLE `erpx_dev_production`.`production_workers` ADD COLUMN `bill_no` VARCHAR(30) NOT NULL AFTER `transportation`; ALTER TABLE `erpx_dev_production`.`production_workers` ADD COLUMN `transport_charges` INT(11) NULL AFTER `bill_no`; ALTER TABLE `erpx_dev_analytics`.`cron_info` ADD COLUMN `created_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) NOT NULL AFTER `reason`, ADD COLUMN `updated_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) NOT NULL AFTER `created_at`; 27-09-2024(sunanda) ALTER TABLE `erpx_dev_masters`.`employee_details` ADD COLUMN `is_available` BOOLEAN DEFAULT 1 NOT NULL AFTER `gpa_no`; ALTER TABLE `erpx_dev_masters`.`vehicle-master` ADD COLUMN `is_available` BOOLEAN DEFAULT 1 NOT NULL AFTER `version_flag`; 01-10-2024(lokesh) ALTER TABLE `erpx_dev_warehouse`.`fork_lift_jobs` change job_purpose job_purpose enum('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','labsamples','complements','rm','rework') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'palleting' NOT NULL; ALTER TABLE `erpx_dev_rm_procurement`. `rm_invoice` ADD COLUMN bill_to_type varchar(50) NULL after mis_flag, ADD COLUMN financier_name varchar(50) NULL after bill_to_type; Alter TABLE `erpx_dev_rm_procurement`.`rm_invoice` change bill_to bill_to varchar(50) CHARSET utf8mb4 COLLATE utf8mb4_general_ci NULL; 07-10-2024(Hygreev) ALTER TABLE erpx_dev_finance.expenses_log ADD COLUMN `year` INT(11) NOT NULL AFTER `month`, ADD COLUMN `type` ENUM('FIXED COST','MANUFACTURING COST','SALE COST','PACK MATERIAL COST','RM COST') NOT NULL AFTER `year` ALTER TABLE erpx_dev_finance.expenses ADD COLUMN `year` INT(11) NOT NULL AFTER `month`, ADD COLUMN `type` ENUM('FIXED COST','MANUFACTURING COST','SALE COST','PACK MATERIAL COST','RM COST') NOT NULL AFTER `year` 9-10-2024(Raji) ALTER TABLE `erpx_dev_production`.`child_clubbed_lots` ADD COLUMN `count` INT(11) NOT NULL AFTER `master_lot_id`; ALTER TABLE `erpx_dev_production`.`master_clubbed_lots` ADD COLUMN `count` INT(11) NOT NULL AFTER `prod_inv_id`; 18-10-2024(vineela) ALTER TABLE `erpx_dev_masters`.`workers` ADD COLUMN `village_from_id` INT(11) NOT NULL AFTER `address`; 19-10-2024(Raji) ALTER TABLE `erpx_dev_production`.`child_clubbed_lots` CHANGE `quantity` `quantity` DECIMAL(10,3) NOT NULL; ALTER TABLE `erpx_dev_production`.`master_clubbed_lots` ADD COLUMN `qty_avail` DECIMAL(10,3) NOT NULL AFTER `count`, ADD COLUMN `qty_aft_club` DECIMAL(10,3) NOT NULL AFTER `qty_avail`; 26-10-2024(Raji) ALTER TABLE `erpx_dev_production`.`grade_inventory` ADD COLUMN `material_from` TINYINT(4) DEFAULT 0 NULL COMMENT '1 for outside material,0 for iside material' AFTER `supervisor`; ALTER TABLE `erpx_dev_production`.`grade_inventory_log` ADD COLUMN `material_from` TINYINT(4) DEFAULT 0 NULL AFTER `supervisor`; ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `material_from` TINYINT(4) DEFAULT 0 NULL COMMENT 'having value for grading operation' AFTER `peeling_price_based_on`; 29-10-2024(Raji) ALTER TABLE `erpx_dev_sales`.`domestic_sales` ADD COLUMN `daywise_shrimp_flag` TINYINT(4) DEFAULT 0 NULL AFTER `rcpt_rowid`; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_jobs` ADD COLUMN `daywise_shrimp_flag` TINYINT(4) DEFAULT 0 NULL AFTER `montly_mis_flag`; ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `daywise_shrimp_flag` TINYINT(4) DEFAULT 0 NULL AFTER `hon_qty_mis_flag`; 1-11-2024 (Raji) ALTER TABLE `erpx_dev_analytics`.`daywise_shrimp_analysis` CHANGE `variant` `variant` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `variant_id` `variant_id` INT(11) NOT NULL, CHANGE `pack_style_id` `pack_style_id` INT(11) NOT NULL, CHANGE `pack_style` `pack_style` VARCHAR(30) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `grade` `grade` VARCHAR(30) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `grade_id` `grade_id` INT(11) NOT NULL, CHANGE `va1` `va1` VARCHAR(10) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `va2` `va2` VARCHAR(10) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `va3` `va3` VARCHAR(10) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `va4` `va4` VARCHAR(10) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `va5` `va5` VARCHAR(10) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `product_category` `product_category` VARCHAR(30) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL, CHANGE `plant_id` `plant_id` INT(11) NOT NULL, CHANGE `date` `date` DATETIME(6) NOT NULL, CHANGE `food_type_id` `food_type_id` INT(11) NOT NULL, CHANGE `product_id` `product_id` INT(11) NOT NULL, CHANGE `soak_style` `soak_style` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL; 05-11-2024(vineela) ALTER TABLE `erpx_dev_rm_procurement`.`grn` ADD COLUMN `seal_number` VARCHAR(225) NULL AFTER `vehicle_number`, ADD COLUMN `reweighment_date` DATE NULL AFTER `seal_number`, ADD COLUMN `supervisor_id` INT(11) NULL AFTER `reweighment_date`; 08-11-2024(Raji) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `main_batch_num` VARCHAR(30) NULL AFTER `procure_mis_flag`; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `year` INT(11) NULL AFTER `main_batch_num`; 05-11-2024(vineela) ALTER TABLE `erpx_dev_rm_procurement`.`grn` ADD COLUMN `seal_number` VARCHAR(225) NULL AFTER `vehicle_number`, ADD COLUMN `reweighment_date` DATE NULL AFTER `seal_number`, ADD COLUMN `supervisor_id` INT(11) NULL AFTER `reweighment_date`; 11-11-2024(Hygreev) ALTER TABLE `erpx_dev_masters`.`end_customers` CHANGE `state_name` `state_name` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE `erpx_dev_masters`.`address` CHANGE `add_line_three` `add_line_three` VARCHAR(100) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `add_line_four` `add_line_four` VARCHAR(100) CHARSET latin1 COLLATE latin1_swedish_ci NULL; 12-11-2024(Raji) ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `year` INT(11) NULL AFTER `material_from`; ALTER TABLE `erpx_dev_production`.`production_inventory` ADD COLUMN `year` INT(11) NULL AFTER `product`; ALTER TABLE `erpx_dev_production`.`non_soaked_products` ADD COLUMN `year` INT(11) NULL AFTER `plant_id`; ALTER TABLE `erpx_dev_production`.`lot_code_data` ADD COLUMN `year` INT(11) NULL AFTER `version_flag`; ALTER TABLE `erpx_dev_production`.`grade_inventory_log` ADD COLUMN `year` INT(11) NULL AFTER `material_from`; ALTER TABLE `erpx_dev_production`.`grade_inventory` ADD COLUMN `year` INT(11) NULL AFTER `main_lot`; 03-12-2024(Raji) ALTER TABLE `erpx_dev_production`.`grade_inventory_log` ADD COLUMN `date` DATETIME(6) NULL AFTER `year`; ------------------------------------------------- already executed ---------------------------------------------------- ALTER TABLE `erpx_dev_finance`.`expenses_log` ADD COLUMN `plant_id` INT(11) NOT NULL AFTER `expenses_id`; ALTER TABLE `erpx_dev_finance`.`expenses` ADD COLUMN `plant_id` INT(11) NOT NULL AFTER `type`; ALTER TABLE `erpx_dev_analytics`.`production_cost_analysis` CHANGE `product` `product` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NULL COMMENT 'Vanami or Black Tiger'; ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `product_category` `product_category` ENUM('Over Count','Over Count Full Cut','Over Count Pull veined','Under Count','G1','G2','Cut','RJ(Rejections)','For Weight','Damaged','GI','GII') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'GI' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `net_weight` `net_weight` DECIMAL(15,3) NULL; ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `product_category` `product_category` ENUM('overcountfullcut','overcountpullveined','undercount','rj','forweight','overcount','cut','damaged','jumble','GI','GII') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'GI' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_jobs` CHANGE `job_purpose` `job_purpose` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','rework','labsamples','complements') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'palleting' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `total_cartons` `total_cartons` INT(11) DEFAULT 0 NOT NULL, CHANGE `stockout_qunatity` `stockout_qunatity` INT(11) DEFAULT 0 NULL, CHANGE `stockin_qunatity` `stockin_qunatity` INT(11) DEFAULT 0 NULL, CHANGE `total_pouches` `total_pouches` INT(11) DEFAULT 0 NOT NULL, CHANGE `loose_pouches` `loose_pouches` INT(11) DEFAULT 0 NOT NULL, CHANGE `total_loose_pouches` `total_loose_pouches` INT(11) DEFAULT 0 NULL, CHANGE `stockout_loose_pouches` `stockout_loose_pouches` INT(11) DEFAULT 0 NULL; ALTER TABLE `erpx_dev_masters`.`sku_codes` CHANGE `soaking_style` `soaking_style` VARCHAR(70) CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL; ALTER TABLE `erpx_dev_sales`.`so_invoice_details` CHANGE `po_number` `po_number` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `buyer_po_number` `buyer_po_number` VARCHAR(50) CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE `erpx_dev_analytics`.`production_cost_analysis` ADD COLUMN `fg_to_hon_weight` DECIMAL(10,3) NULL COMMENT 'Production Yield Report (HON Weight in working pro analysis)' AFTER `inv_num`; ALTER TABLE `erpx_dev_analytics`.`production_cost_analysis` CHANGE `fg_to_hon_weight` `fg_to_hon_weight_kg` DECIMAL(10,3) NULL COMMENT 'Production Yield Report (HON Weight in working pro analysis)'; ALTER TABLE `erpx_dev_analytics`.`production_cost_analysis` CHANGE `gross_pouch_weight` `gross_pouch_weight` DECIMAL(10,3) NULL; ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `daywise_op_qty_flag` TINYINT(4) DEFAULT 0 NULL COMMENT 'Daywise opening qty report flag' AFTER `daywise_shrimp_flag`; ALTER TABLE `erpx_dev_analytics`.`daywise_opening_stock` CHANGE `variant_id` `variant_id` INT(11) NOT NULL, CHANGE `pack_style_id` `pack_style_id` INT(11) NOT NULL, CHANGE `cartons` `cartons` INT(11) NOT NULL, CHANGE `loose_pouches` `loose_pouches` INT(11) NOT NULL, CHANGE `opening_stock_kgs` `opening_stock_kgs` DECIMAL(10,3) NOT NULL, CHANGE `date` `date` DATETIME(6) NOT NULL, CHANGE `plant_id` `plant_id` INT(11) NOT NULL, ADD COLUMN `product_category` VARCHAR(20) NOT NULL AFTER `plant_id`; ALTER TABLE `erpx_dev_finance`.`purchases` ADD COLUMN `purchase_date` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) NULL AFTER `rcpt_rowid`; ALTER TABLE `erpx_dev_finance`.`purchase_products` CHANGE ```` `purchase_product_id` INT(11) NOT NULL AUTO_INCREMENT; 17-12-2024(Raji) ALTER TABLE `erpx_dev_sales`.`sale_order_track` ADD COLUMN `stock_in_flag` TINYINT(4) DEFAULT 0 NULL AFTER `is_codelist_allocated`; ALTER TABLE `erpx_dev_sales`.`so_invoice_details` ADD COLUMN `stock_in_flag` TINYINT(4) DEFAULT 0 NULL AFTER `port_of_discharge`; ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `stock_in_flag` TINYINT(4) DEFAULT 0 NULL AFTER `mc_per_bundle`; ALTER TABLE `erpx_dev_production`.`lot_code_data` ADD COLUMN `lot_club_status` TINYINT(4) NULL AFTER `year`, ADD COLUMN `clubbed_main_lot` VARCHAR(20) NULL AFTER `lot_club_status`; 18-12-2024(Raji) ALTER TABLE `erpx_dev_production`.`lot_code_data` ADD COLUMN `main_lot_number` VARCHAR(30) NULL AFTER `clubbed_main_lot`, ADD COLUMN `main_lot_after_club` VARCHAR(30) NULL AFTER `main_lot_number`; ------------------------------------------------- already executed ---------------------------------------------------- 27-12-2024(Raji) ALTER TABLE `erpx_dev_production`.`lot_code_data` CHANGE `test_result` `grading_test_result` ENUM('PASS','FAIL') NULL; ALTER TABLE `erpx_dev_production`.`lot_code_data` ADD COLUMN `grn_test_result` ENUM('PASS','FAIL') NULL AFTER `grading_test_result`; 28-12-2024(Raji) ALTER TABLE `erpx_dev_warehouse`.`stock` ADD COLUMN `antibiotic_test_result` TINYINT(4) DEFAULT 0 NULL COMMENT '0-pass,1-fail' AFTER `stockout_loose_pouches`; ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `antibiotic_test_result` TINYINT(4) DEFAULT 0 NULL COMMENT '0-pass,1-fail' AFTER `daywise_op_qty_flag`; ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `product_category` `product_category` ENUM('overcountfullcut','overcountpullveined','undercount','RJ(Rejections)','forweight','overcount','g1','g2','cut','damaged','GI','GII','jumble','rj') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'g1' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `product_category` `product_category` ENUM('overcountfullcut','overcountpullveined','undercount','RJ(Rejections)','forweight','overcount','g1','g2','cut','damaged','GI','GII','jumble') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'g1' NOT NULL; 09-01-2025(Raji) ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `price_based_on` INT(11) NULL AFTER `stock_in_flag`; 09-01-2025(sunanda) ALTER TABLE `erpx_dev_sales`.`sale_order` ADD COLUMN `financial_year` VARCHAR(50) NOT NULL AFTER `ref_no`; ALTER TABLE `erpx_dev_procurement`.`purchase_order` ADD COLUMN `financial_year` VARCHAR(255) NOT NULL AFTER `dispatched_through`; ALTER TABLE `erpx_dev_sales`.`customer_invoice` ADD COLUMN `financial_year` VARCHAR(50) NOT NULL AFTER `rodtep_status`; 10-01-2025(Raji) ALTER TABLE `erpx_dev_logistics`.`container` ADD COLUMN `mode_of_export` ENUM('CONTAINER','FLIGHT') NULL AFTER `ship_containers_mis_flag`; ALTER TABLE `erpx_dev_sales`.`so_invoice_details` ADD COLUMN `shipment_mode` VARCHAR(20) NULL AFTER `stock_in_flag`; 18-01-2025(Raji) ALTER TABLE `erpx_dev_production`.`lot_code_data` ADD COLUMN `sample_yield` DECIMAL(10,3) NULL AFTER `grn_test_result`; 28-01-2025(Raji) ALTER TABLE `erpx_dev_production`.`production_workers` ADD COLUMN `avg_wage` DECIMAL(10,3) NULL AFTER `transport_charges`, ADD COLUMN `avg_qty` DECIMAL(10,3) NULL AFTER `avg_wage`; 29-01-2025(hygreev) ALTER TABLE `erpx_dev_finance`.`collections` ADD COLUMN `received_amt_inr` DECIMAL(10,2) DEFAULT 0.00 NOT NULL AFTER `unit_id`; ALTER TABLE `erpx_dev_finance`.`collections` ADD COLUMN `exchange_rate` DECIMAL(10,2) DEFAULT 0.00 NOT NULL AFTER `received_amt_inr` 29-01-2025(sunanda) ALTER TABLE `erpx_dev_sales`.`so_invoice_details` ADD COLUMN `proforma_invoice_date` DATE NULL AFTER `shipment_mode`; 31-01-2025(Raji) ALTER TABLE `erpx_dev_enquiries`.`enquiry_products` ADD COLUMN `price_based_on` INT(11) NULL AFTER `brand_type`; 01-02-2025(Raji) ALTER TABLE `erpx_dev_masters`.`deheading-peeling_Logs` ADD COLUMN `value_add_3` INT(11) NULL AFTER `based_on`; ALTER TABLE `erpx_dev_masters`.`deheading_peeling_chart` ADD COLUMN `value_add_3` INT(11) NULL AFTER `based_on`; 08-02-2025(Raji) ALTER TABLE `erpx_dev_analytics`.`production_cost_analysis` ADD COLUMN `transaction_type` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','productPurchase','rework','labsamples','complements') NULL AFTER `fg_to_hon_weight_kg`; 12-02-2025(sunanda) ALTER TABLE `erpx_dev_finance`.`collections` CHANGE `ice_gate_status` `ice_gate_status` ENUM('UPDATE','NOT UPDATE','VERIFIED','NOT VERIFIED') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'NOT VERIFIED' NULL; ALTER TABLE `erpx_dev_finance`.`collections` CHANGE `recieved_amt` `recieved_amt` DECIMAL(10,2) DEFAULT 0.00 NULL, CHANGE `received_amt_inr` `received_amt_inr` DECIMAL(10,2) DEFAULT 0.00 NULL, CHANGE `exchange_rate` `exchange_rate` DECIMAL(10,2) DEFAULT 0.00 NULL; 14-02-2025(sunanda) ALTER TABLE `erpx_dev_finance`.`collections` CHANGE `rodtep_status` `rodtep_status` ENUM('OPEN','ICE GATE UPDATE','BRC UPDATE','ICE GATE AND BRC UPDATE','SCRIPT GENERATION','SALE','RECEIVED') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'OPEN' NULL; 24-02-2025 (Raji) ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `is_lot_code` TINYINT(4) DEFAULT 1 NULL AFTER `antibiotic_test_result`; ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `is_lot_code` `is_lot_code` TINYINT(4) DEFAULT 1 NULL COMMENT '1-lotcode, 0-jobcode'; 24-02-2025(Raji) ALTER TABLE `erpx_dev_enquiries`.`enquiries` CHANGE `no_of_containers` `no_of_containers` DECIMAL(10,1) NOT NULL; ALTER TABLE `erpx_dev_enquiries`.`enquiry_products` CHANGE `no_of_containers` `no_of_containers` DECIMAL(10,1) NULL, CHANGE `confirmed_containers` `confirmed_containers` DECIMAL(10,1) NULL; ALTER TABLE `erpx_dev_enquiries`.`cost_sheet` CHANGE `containers` `containers` DECIMAL(10,1) NULL; 24-02-2025(sunanda) ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `marks_and_no` TEXT NULL AFTER `price_based_on`; 03-03-2025(mukesh) ALTER TABLE `erpx_dev_procurement`.`store_consumption` ADD COLUMN `department_id` INT(11) NULL ALTER TABLE `erpx_dev_rm_procurement`.`rm_antibiotics_info` ADD COLUMN `lab_name` VARCHAR(50) 05-03-2025(vineela) ALTER TABLE `erpx_dev_enquiries`.`enquiries` ADD COLUMN `enquiry_reject_description` TEXT NULL AFTER `is_regenerated`; 06-03-2025(Raji) ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `is_rrb` TINYINT(4) DEFAULT 0 NULL AFTER `year`, ADD COLUMN `rejection_from` VARCHAR(30) NULL AFTER `is_rrb`; ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `process_type` ENUM('FRESHPRODUCITON','REPROCESS') DEFAULT 'FRESHPRODUCITON' NULL AFTER `rejection_from`; ALTER TABLE `erpx_dev_production`.`production_inventory` ADD COLUMN `process_type` ENUM('FRESHPRODUCITON','REPROCESS') DEFAULT 'FRESHPRODUCITON' NULL AFTER `year`; 06-03-2025(vineela) ALTER TABLE `erpx_dev_enquiries`.`enquiries` CHANGE `buyer_id` `buyer_id` INT(11) NULL 07-03-2025(Raji) ALTER TABLE `erpx_dev_rm_procurement`.`rm_invoice` ADD COLUMN `created_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) NULL AFTER `financier_name`, ADD COLUMN `created_user` VARCHAR(50) NULL AFTER `created_at`, ADD COLUMN `updated_at` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) NULL AFTER `created_user`, ADD COLUMN `updated_user` VARCHAR(50) NULL AFTER `updated_at`, ADD COLUMN `version_flag` INT(11) DEFAULT 1 NULL AFTER `updated_user`, ADD COLUMN `ref_no` INT(11) NULL AFTER `version_flag`; 08-08-2025(Raji) ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `loose_pouches` `loose_pouches` DECIMAL(10,3) NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `loose_pouches` `loose_pouches` DECIMAL(10,3) DEFAULT 0 NOT NULL, CHANGE `total_loose_pouches` `total_loose_pouches` DECIMAL(10,2) DEFAULT 0 NULL, CHANGE `stockout_loose_pouches` `stockout_loose_pouches` DECIMAL(10,2) DEFAULT 0 NULL; 09-03-2025(sunanda) ALTER TABLE `erpx_dev_finance`.`collections` ADD COLUMN `advance_amt` DECIMAL(10,2) DEFAULT 0 NULL AFTER `exchange_rate`; 11-03-2025(Raji) ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `certification_id` INT(11) NULL AFTER `marks_and_no`, ADD COLUMN `is_certified` ENUM('YES','NO') NULL AFTER `certification_id`, ADD COLUMN `rating` INT(11) NULL AFTER `is_certified`; 11-03-2025(Raji) ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `product_category` `product_category` ENUM('overcountfullcut','overcountpullveined','undercount','RJ(Rejections)','forweight','overcount','g1','g2','cut','damaged','GI','GII','jumble','A/B(REJECTIONS)') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'g1' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `product_category` `product_category` ENUM('Over Count','Over Count Full Cut','Over Count Pull veined','Under Count','G1','G2','Cut','RJ(Rejections)','For Weight','Damaged','GI','GII','A/B(REJECTIONS)') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'GI' NOT NULL; 11-03-2025(sunanda) ALTER TABLE `erpx_dev_finance`.`collections` ADD COLUMN `shipping_bill_date` DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) NULL AFTER `advance_amt`, ADD COLUMN `shipping_bill_no` VARCHAR(50) NULL AFTER `shipping_bill_date`; 12-03-2025(Raji) ALTER TABLE `erpx_dev_masters`.`deheading_peeling_chart` ADD COLUMN `is_rrp` BOOLEAN DEFAULT 0 NULL AFTER `value_add_3`; ALTER TABLE `erpx_dev_masters`.`deheading_peeling_chart` CHANGE `is_rrp` `is_rrp` TINYINT(4) DEFAULT 0 NULL; ALTER TABLE `erpx_dev_production`.`production_log` CHANGE `is_rrb` `is_rrp` TINYINT(4) DEFAULT 0 NULL; ALTER TABLE `erpx_dev_production`.`production_inventory` ADD COLUMN `is_rrp` TINYINT(4) DEFAULT 0 NULL AFTER `process_type`; 12-03-2025(Mukesh) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN antibiotics_test_status ENUM('PENDING', 'PROCESSING', 'COMPLETED') NOT NULL DEFAULT 'PENDING'; ALTER TABLE `erpx_dev_rm_procurement`.`rm_antibiotics_info` ADD COLUMN antibiotics_test_status ENUM('PENDING', 'PROCESSING', 'COMPLETED') NOT NULL DEFAULT 'PENDING'; ALTER TABLE `erpx_dev_production`.`grade_inventory` ADD COLUMN antibiotics_test_status ENUM('PENDING', 'PROCESSING', 'COMPLETED') NOT NULL DEFAULT 'PENDING'; 13-03-2025(sunanda) ALTER TABLE `erpx_dev_sales`.`customer_invoice` ADD COLUMN `igst_amt` DECIMAL(10,2) DEFAULT 0.00 NULL AFTER `financial_year`; ALTER TABLE `erpx_dev_finance`.`collections` CHANGE `payment_type` `payment_type` ENUM('EXPORT RECEIVABLES','DUTY DRAW BACK','RODTEP','IGST') CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE `erpx_dev_finance`.`collections` ADD COLUMN `received_bank_name` TEXT NULL AFTER `shipping_bill_no`; 14-03-2025(Mukesh) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` DROP COLUMN antibiotics_test_status; ALTER TABLE `erpx_dev_rm_procurement`.`rm_antibiotics_info` ADD COLUMN indent_item_id INT NOT NULL; ALTER TABLE `erpx_dev_rm_procurement`.`rm_antibiotics_info` ADD COLUMN indent_id INT NOT NULL; ALTER TABLE `erpx_dev_rm_procurement`.`indent_items` ADD COLUMN test_result VARCHAR(50) NULL; ALTER TABLE `erpx_dev_rm_procurement`.`indent_items` ADD COLUMN antibiotics_test_status ENUM('PENDING', 'PROCESSING', 'COMPLETED') NOT NULL DEFAULT 'PENDING'; ALTER TABLE `erpx_dev_rm_procurement`.`rm_antibiotics_info` MODIFY COLUMN grn_id INT NULL, MODIFY COLUMN grn_item_id INT NULL, MODIFY COLUMN indent_id INT NULL, MODIFY COLUMN indent_item_id INT NULL; 14-03-2025..uma ALTER TABLE `erpx_dev_enquiries`.`mfg_costs` ADD COLUMN `enquiry_product_id` INT(11) NOT NULL AFTER `variant_id`; 16-03-25(Mukesh) ALTER TABLE `erpx_dev_planning`.`code_list_log` ADD COLUMN code_list_status ENUM('PENDING', 'CLEARED') NOT NULL DEFAULT 'PENDING'; CREATE TABLE `erpx_dev_planning`.qc_clearance_info ( clearance_id INT AUTO_INCREMENT PRIMARY KEY, created_at DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) NOT NULL, created_user VARCHAR(50) NOT NULL, updated_at DATETIME(6) DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) NOT NULL, updated_user VARCHAR(50) NULL, version_flag INT DEFAULT 1 NOT NULL, so_id INT NOT NULL, po_number VARCHAR(50) NOT NULL, so_item_id INT NOT NULL, chemical_result ENUM('PASS', 'FAIL') NULL, micro_result ENUM('PASS', 'FAIL') NULL, fg_result ENUM('PASS', 'FAIL') NULL, others ENUM('PASS', 'FAIL') NULL, c_file VARCHAR(255) NULL, m_file VARCHAR(255) NULL, fg_file VARCHAR(255) NULL, others_file VARCHAR(255) NULL, clearance_status ENUM('PENDING', 'CLEARED') NOT NULL ) ENGINE=INNODB CHARSET=latin1 COLLATE=latin1_swedish_ci; ALTER TABLE `erpx_dev_planning`.qc_clearance_info ADD COLUMN code_list_log_id INT NOT NULL; 17-03-2024(Raji) ALTER TABLE `erpx_dev_production`.`non_soaked_products` ADD COLUMN `from_product` VARCHAR(30) NULL AFTER `year`; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `reweighment_date` DATETIME(6) NULL AFTER `test_result`; 18-03-2025(Raji) ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `grade_change` TINYINT(4) DEFAULT 0 NULL AFTER `process_type`, ADD COLUMN `soakingout_product` VARCHAR(30) NULL AFTER `grade_change`; 19-03-2025(sunanda) ALTER TABLE `erpx_dev_finance`.`collections` CHANGE `inv_num` `inv_num` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL; 20-03-2025(Raji) ALTER TABLE `erpx_dev_warehouse`.`stock` CHANGE `product_category` `product_category` ENUM('overcountfullcut','overcountpullveined','undercount','RJ(Rejections)','forweight','overcount','cut','damaged','GI','GII','jumble','A/B(REJECTIONS)','RRP') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'GI' NOT NULL; ALTER TABLE `erpx_dev_warehouse`.`reporting` CHANGE `product_category` `product_category` ENUM('Over Count','Over Count Full Cut','Over Count Pull veined','Under Count','G1','G2','Cut','RJ(Rejections)','For Weight','Damaged','GI','GII','A/B(REJECTIONS)','RRP') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'GI' NOT NULL; 21-03-2025(sunanda) ALTER TABLE `erpx_dev_sales`.`so_invoice_details` ADD COLUMN `proforma_invoice_no` VARCHAR(250) NOT NULL AFTER `proforma_invoice_date`; 21-03-2025(Raji) ALTER TABLE `erpx_dev_analytics`.`rm_purchase_analysis` ADD COLUMN `is_vehicle_required` TINYINT(4) NULL AFTER `intake_supervisor`, ADD COLUMN `ice_rate` INT(11) NULL AFTER `is_vehicle_required`; 21-03-2025(Mukesh) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN antibiotics_test_status ENUM('PENDING', 'PROCESSING', 'COMPLETED') NOT NULL DEFAULT 'PENDING'; 22-03-2025(Raji) CREATE TABLE `erpx_dev_rm_procurement`.`half_count_ranges`( `id` INT(11) NOT NULL, `reference_count` DECIMAL(10,2), `min_count` DECIMAL(10,2), `max_count` DECIMAL(10,2), PRIMARY KEY (`id`) ); 22-03-2025(Mukesh) ALTER TABLE `erpx_dev_planning`.`qc_clearance_info` ADD COLUMN overall_result ENUM('PASS', 'FAIL') NULL; 24-03-2025(pardhu) ALTER TABLE `erpx_dev_rm_procurement`.`rm_rates` CHANGE `count` `count` DECIMAL(10,2) NOT NULL; ALTER TABLE `erpx_dev_rm_procurement`.`rm_rates_logs` CHANGE `count` `count` DECIMAL(10,2) NOT NULL; 24-03-2025(mukesh) ALTER TABLE `erpx_dev_planning`.qc_clearance_info ADD COLUMN code_list_main_id INT NOT NULL; ALTER TABLE `erpx_dev_planning`.`code_list_main` ADD COLUMN code_list_status ENUM('PENDING', 'CLEARED') NOT NULL DEFAULT 'PENDING'; 26-03-2025(Raji) ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `pack_count` INT(11) NULL AFTER `rating`; ALTER TABLE `erpx_dev_production`.`production_inventory` CHANGE `process_type` `process_type` ENUM('FRESHPRODUCITON','REPROCESS','REPACKING','REWORK') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'FRESHPRODUCITON' NULL; ALTER TABLE `erpx_dev_production`.`production_log` CHANGE `process_type` `process_type` ENUM('FRESHPRODUCITON','REPROCESS','REPACKING','REWORK') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'FRESHPRODUCITON' NULL; ALTER TABLE `erpx_dev_production`.`grade_inventory` ADD COLUMN `price_count` INT(11) NULL AFTER `antibiotics_test_status`; 29-03-2025(Mukesh) ALTER TABLE `erpx_dev_masters`.`suppliers` ADD COLUMN aadhar_number VARCHAR(50) NOT NULL; 31-03-2025(sunanda) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `budget_range` VARCHAR(50) NULL AFTER `reweighment_date`; 10-04-2025(sunanda) ALTER TABLE `erpx_dev_enquiries`.`enquiries` CHANGE `source_from` `source_from` ENUM('AGENT','BUYER','EMPLOYEE') CHARSET latin1 COLLATE latin1_swedish_ci NOT NULL; 11-04-2025(Mukesh) ALTER TABLE `erpx_dev_masters`.`suppliers` ADD COLUMN `a_b_identified_farmer` ENUM('APPROVED', 'REJECTED') NOT NULL DEFAULT 'APPROVED'; 14-04-2025(Raji) ALTER TABLE `erpx_dev_enquiries`.`enquiries` ADD COLUMN `is_fob` TINYINT(4) NULL AFTER `enquiry_reject_description`; ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `reporting_log_id` INT(11) NULL AFTER `soakingout_product`; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_jobs` CHANGE `total_job_loose_pouches` `total_job_loose_pouches` DECIMAL(10,3) DEFAULT 0 NULL; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_items` CHANGE `job_loose_pouches` `job_loose_pouches` DECIMAL(10,3) DEFAULT 0 NULL; 15-04-2025(Mukesh) ALTER TABLE `erpx_dev_ums`.`employee_experience_details` CHANGE `from_date` `from_date` DATE NULL; ALTER TABLE `erpx_dev_ums`.`employee_experience_details` CHANGE `to_date` `to_date` DATE NULL; ALTER TABLE `erpx_dev_ums`.`employee_education_details` CHANGE `date_of_passout` `date_of_passout` DATE NULL; 17-04-2025(Raji) ALTER TABLE `erpx_dev_analytics`.`rm_purchase_analysis` ADD COLUMN `year` INT(11) NULL AFTER `ice_rate`; ALTER TABLE `erpx_dev_analytics`.`rm_purchase_analysis` ADD COLUMN `grade_inv_id` INT(11) NULL AFTER `year`; ------------------------------------------------- already executed ---------------------------------------------------- 17-04-2025(Raji) ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `rejection_from` VARCHAR(50) NULL AFTER `is_lot_code`, ADD COLUMN `soakingout_product` VARCHAR(50) NULL AFTER `rejection_from`; 21-04-2025(vineela) ALTER TABLE `erpx_dev_warehouse`.`fork_lift_items` ADD COLUMN `domestic_sale_id` INT(11) NULL AFTER `variant_id`; ALTER TABLE `erpx_dev_warehouse`.`fork_lift_jobs` CHANGE `job_purpose` `job_purpose` ENUM('palleting','repalleting','repacking','reprocessing','dispatch','unregistered','stockTransfer','rm','rework','labsamples','complements','domesticSales') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'palleting' NOT NULL; 28-04-2025(sunanda) ALTER TABLE `erpx_dev_rm_procurement`.`rm_rates` CHANGE `price` `price` DECIMAL(10,2) NOT NULL; ALTER TABLE `erpx_dev_rm_procurement`.`rm_rates_logs` CHANGE `price` `price` DECIMAL(10,2) NOT NULL; 30-04-2025(sunanda) ALTER TABLE `erpx_dev_finance`.`rodtep` CHANGE `irmn_num` `irmn_num` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `brc_num` `brc_num` VARCHAR(255) CHARSET latin1 COLLATE latin1_swedish_ci NULL; 30-04-2025(mukesh) ALTER TABLE `erpx_dev_rm_procurement`.`rm_rates` ADD COLUMN `effective_date` DATETIME NULL; ALTER TABLE `erpx_dev_rm_procurement`.`rm_rates` ADD COLUMN `effective_to_date` DATETIME NULL AFTER `effective_date`; ALTER TABLE `erpx_dev_rm_procurement`.`rm_rates_logs` ADD COLUMN `effective_to_date` DATETIME NULL AFTER `effective_from`; ALTER TABLE `erpx_dev_rm_procurement`.`rm_rates` CHANGE COLUMN `effective_date` `effective_from_date` DATETIME NULL; 2-05-2025(Raji) ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `year` INT(11) NULL AFTER `soakingout_product`; 15-5-25(Raji) ALTER TABLE `erpx_dev_rm_procurement`.`rm_invoice` ADD COLUMN `financial_year` VARCHAR(20) NULL AFTER `ref_no`; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `tds_applicable` TINYINT(4) NULL AFTER `budget_range`, ADD COLUMN `taxable_amount` DECIMAL(10,2) NULL AFTER `tds_applicable`; ALTER TABLE `erpx_dev_procurement`.`grn_items` ADD COLUMN `tds_applicable` TINYINT(4) NULL AFTER `inspected_qty`, ADD COLUMN `taxable_amount` DECIMAL(10,2) NULL AFTER `tds_applicable`; 16-5-25(Hygreev) ALTER TABLE `erpx_dev_ums`.`user` CHANGE `role` `role` ENUM('L1','L2','L3','L4','L5','L6','ADMIN','ASSISTANT SALES MANAGER','SALES MANAGER','SENIOR SALES MANAGER','PLANT SALES MANAGER', 'OPERATIONS_MANAGER','OPERATIONS_EXECUTIVE','DOCUMENTATION HEAD','DOCUMENTATION EXECUTIVE','LOGISTICS PLANT HEAD','LOGISTICS HEAD','LOGISTICS PLANT EXECUTIVE','LOGISTICS AND WAREHOUSE MANAGER', 'WAREHOUSE MANAGER','TRANSPORTATION_MANAGER','TRANSPORTATION_EXECUTIVE','PROCUREMENT_MANAGER','DRIVER','RM_GRN','NAVTECH_WH','ASSISTANT PACKAGING MANAGER','HO PACKAGING MANAGER', 'SENIOR PACKAGING MANAGER','PACKAGING SUPERVISOR','INDENT PERSON','LOGISTICS EXECUTIVE','PACKING CAPTAINS','UNIT PACKING CONTROLLER','PACKING WAREHOUSE CONTROLLER','SUPER ADMIN','QAQC PERSON', 'PRODUCTION PERSON','ENQUIRY PERSON','REWEIGHTMENT PERSON','FINANCE PERSON') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'ADMIN' NULL; 15-05-2025(sunanda) ALTER TABLE `erpx_dev_rm_procurement`.`grn` ADD COLUMN `payment_status` ENUM('OPEN','PAID','PARTIALLY PAID') NULL AFTER `test_result`; ALTER TABLE `erpx_dev_procurement`.`grn` ADD COLUMN `payment_status` ENUM('PAID','PARTIALLY PAID','OPEN') NULL AFTER `test_result`; ALTER TABLE `erpx_dev_rm_procurement`.`rm_invoice` ADD COLUMN `payment_status` ENUM('PAID','PARTIALLY PAID','OPEN') DEFAULT 'OPEN' NULL AFTER `financial_year`; ALTER TABLE `erpx_dev_procurement`.`grn_items` ADD COLUMN `payment_status` ENUM('PAID','PARTIALLY PAID','OPEN') DEFAULT 'OPEN' NULL AFTER `taxable_amount`; 16-05-2025(sunanda) ALTER TABLE `erpx_dev_procurement`.`grn_items` ADD COLUMN `payment` DECIMAL(10,2) DEFAULT 0 NULL AFTER `payment_status`; ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `payment_status` ENUM('PAID','PARTIALLY PAID','OPEN') DEFAULT 'OPEN' NULL AFTER `payment`; 16-5-25(Raji) ALTER TABLE `erpx_dev_sales`.`so_invoice_details` ADD COLUMN `destination_changed` TINYINT(4) NULL AFTER `proforma_invoice_no`; 17-05-2025(sunanda) ALTER TABLE `erpx_dev_rm_procurement`.`rm_invoice` ADD COLUMN `payment` DECIMAL(10,2) DEFAULT 0 NULL AFTER `payment_status`; 19-5-25(Raji) ALTER TABLE `erpx_dev_masters`.`hlpercentage` ADD COLUMN `type` ENUM('RM','Grading') NULL AFTER `hl_percentage`; 20-5-25(Raji) ALTER TABLE `erpx_dev_production`.`non_soaked_products` ADD COLUMN `date` DATETIME(6) NULL AFTER `from_product`; 20-05-2025(sunanda) ALTER TABLE `erpx_dev_masters`.`global_price_chart` ADD COLUMN `is_costing` BOOLEAN DEFAULT TRUE NULL AFTER `type`; 21-05-25(Raji) ALTER TABLE `erpx_dev_rm_procurement`.`grn_items` ADD COLUMN `reweighment_bill_to` ENUM('BMR INDUSTRIES PRIVATE LIMITED','BMR EXPORTS-AP','BMR EXPORTS-ODISHA') NULL AFTER `payment_status`; 23-05-2025(sunanda) ALTER TABLE `erpx_dev_enquiries`.`enquiries` ADD COLUMN `cancel_reason` TEXT(255) NULL AFTER `is_fob`; 25-05-2025(sunanda) CREATE TABLE `payables` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `invoice_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci DEFAULT NULL, `invoice_id` INT(11) DEFAULT NULL, `status` ENUM('PAID','PARTIALLY PAID','OPEN') CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci DEFAULT NULL, `invoice_number` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci DEFAULT NULL, `vendor_id` INT(11) DEFAULT NULL, `received_date` DATE DEFAULT NULL, `quantity` DECIMAL(10,2) DEFAULT NULL, `amount` DECIMAL(10,2) DEFAULT NULL, `deduction` DECIMAL(10,2) DEFAULT NULL, `final_amount` DECIMAL(10,2) DEFAULT NULL, `payment` DECIMAL(10,2) DEFAULT NULL, `tds_applicable` TINYINT(4) NOT NULL DEFAULT 1, `is_active` TINYINT(4) NOT NULL DEFAULT 1, `created_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), `created_user` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci NOT NULL, `updated_at` DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), `updated_user` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci DEFAULT NULL, `invoice_date` DATE DEFAULT NULL, `version_flag` INT(11) NOT NULL DEFAULT 1, PRIMARY KEY (`id`) ) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*[Error Code 1273: Unknown collation: 'utf8mb4_uca1400_ai_ci']*/ ALTER TABLE erpx_dev_procurement.grn ADD COLUMN payment DECIMAL(10,2) DEFAULT 0.00 NULL AFTER payment_status; 01-07-2025(sunanda) ALTER TABLE `erpx_dev_masters`.`suppliers` ADD COLUMN `pan_number` VARCHAR(20) NULL AFTER `a_b_identified_farmer`; 02-07-25(Raji) ALTER TABLE `erpx_dev_analytics`.`rm_purchase_analysis` ADD COLUMN `grn_count` DECIMAL(10,2) NULL AFTER `grade_inv_id`; ALTER TABLE `erpx_dev_production`.`grade_inventory` ADD COLUMN `grn_count` DECIMAL(10,2) NULL AFTER `price_count`; 15-7-25(Raji) ALTER TABLE `erpx_dev_production`.`production_log` ADD COLUMN `deheading_price_based_on` ENUM('HON','HL') NULL AFTER `reporting_log_id`; 31-7-25(Raji) ALTER TABLE `erpx_dev_sales`.`sale_order_items` ADD COLUMN `stockin_remarks` VARCHAR(50) NULL AFTER `gross_weight`; 12-08-25(Raji) ALTER TABLE `erpx_dev_warehouse`.`reporting` ADD COLUMN `job_completed` TINYINT(4) NULL AFTER `year`; ------------------------------------------------- already executed ---------------------------------------------------- 10-11-25(Mukesh) ALTER TABLE `erpx_dev_rm_procurement`.`rm_rates_logs` ADD COLUMN `product_id` INT(11) NULL AFTER `rm_rates_id`; ALTER TABLE `erpx_dev_rm_procurement`.`rm_rates` ADD COLUMN `product_id` INT(11) NULL AFTER `type`;