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`; -------------------------------------------------------- already executed ------------------------------------------------------------------