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`; 19-12-2024(Raji) ALTER TABLE `alpha_live_masters`.`fixed_prices_chart_log` CHANGE `packing_category` `packing_category` ENUM('Pouch','Ring','Carton','Skewer','Platter','Trim','ALL') CHARSET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; ALTER TABLE `alpha_live_production`.`production_log` ADD COLUMN `material_from` TINYINT(4) DEFAULT 0 NULL COMMENT 'having value for grading operation' AFTER `peeling_price_based_on`; ALTER TABLE `alpha_live_enquiries`.`enquiries` CHANGE `source_from` `source_from` ENUM('AGENT','BUYER') CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `buyer_id` `buyer_id` INT(11) NULL, CHANGE `sale_person_id` `sale_person_id` INT(11) NULL, CHANGE `buyer_address_id` `buyer_address_id` INT(11) NULL, CHANGE `delivery_terms_id` `delivery_terms_id` INT(11) NULL, CHANGE `payment_terms_id` `payment_terms_id` INT(11) NULL, CHANGE `shipment_terms_id` `shipment_terms_id` INT(11) NULL, CHANGE `processing_unit_id` `processing_unit_id` INT(11) NULL, CHANGE `manufacturing_unit_id` `manufacturing_unit_id` INT(11) NULL; ALTER TABLE `alpha_live_enquiries`.`enquiry_products` CHANGE `category` `category` ENUM('Skewers','Ring','Pouch','Platter','Nobashi') CHARSET latin1 COLLATE latin1_swedish_ci NULL, CHANGE `brand_id` `brand_id` INT(11) NULL; ALTER TABLE `alpha_live_production`.`grade_inventory_log` ADD COLUMN `date` DATETIME(6) NULL AFTER `year`; ALTER TABLE `alpha_live_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`; ALTER TABLE `alpha_live_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`; 20-12-2024(Raji) ALTER TABLE `alpha_live_production`.`grade_inventory` ADD COLUMN `min_grade` INT(11) NULL AFTER `year`, ADD COLUMN `max_grade` INT(11) NULL AFTER `min_grade`; ALTER TABLE `alpha_live_production`.`production_log` ADD COLUMN `min_grade` INT(11) NULL AFTER `year`, ADD COLUMN `max_grade` INT(11) NULL AFTER `min_grade`; ALTER TABLE `alpha_live_production`.`production_inventory` ADD COLUMN `min_grade` INT(11) NULL AFTER `year`, ADD COLUMN `max_grade` INT(11) NULL AFTER `min_grade`; ALTER TABLE `alpha_live_production`.`grade_inventory_log` ADD COLUMN `min_grade` INT(11) NULL AFTER `date`, ADD COLUMN `max_grade` INT(11) NULL AFTER `min_grade`; 23-12-2024(Raji) ALTER TABLE `alpha_live_production`.`production_workers` CHANGE `transportation` `transportation` VARCHAR(20) CHARSET latin1 COLLATE latin1_swedish_ci NULL; ALTER TABLE `alpha_live_sales`.`sale_order_track` ADD COLUMN `stock_in_flag` TINYINT(4) DEFAULT 0 NULL AFTER `is_codelist_allocated`; ALTER TABLE `alpha_live_sales`.`so_invoice_details` ADD COLUMN `stock_in_flag` TINYINT(4) DEFAULT 0 NULL AFTER `port_of_discharge`; ALTER TABLE `alpha_live_sales`.`sale_order_items` ADD COLUMN `stock_in_flag` TINYINT(4) DEFAULT 0 NULL AFTER `mc_per_bundle`; 27-12-2024(Raji) ALTER TABLE `alpha_live_masters`.`bank_details` CHANGE `company` `company` ENUM('ALPHA MARINES','ALPHA MARINE LIMITED') CHARSET utf8mb4 COLLATE utf8mb4_general_ci NULL; ALTER TABLE `alpha_live_warehouse`.`stock` ADD COLUMN `antibiotic_test_result` TINYINT(4) DEFAULT 0 NULL COMMENT '0-pass;1-fail' AFTER `stockout_loose_pouches`; ALTER TABLE `alpha_live_warehouse`.`reporting` ADD COLUMN `antibiotic_test_result` TINYINT(4) DEFAULT 0 NULL AFTER `daywise_shrimp_flag`; ALTER TABLE `alpha_live_warehouse`.`reporting` CHANGE `antibiotic_test_result` `antibiotic_test_result` TINYINT(4) DEFAULT 0 NULL COMMENT '0-pass;1-fail'; 28-12-2024(Hygreev) ALTER TABLE alpha_live_masters.employee_details ADD COLUMN date_of_exit VARCHAR(100) NULL AFTER is_available; ALTER TABLE alpha_live_masters.employee_details ADD COLUMN date_of_rejoin VARCHAR(100) NULL AFTER date_of_exit; ------------------------------------------------- already executed ---------------------------------------------------- 30-12-2024(raji) ALTER TABLE `alpha_live_rm_procurement`.`grn` CHANGE `reweighment_bill_to` `reweighment_bill_to` ENUM('ALPHA MARINES','ALPHA MARINE LIMITED') CHARSET latin1 COLLATE latin1_swedish_ci NULL; 01-01-2025(lokesh) Alter table `alpha_live_production`.`grade_inventory` add column `test_result` varchar(50) NULL after `max_grade`; Alter table `alpha_live_rm_procurement`.`grn_items` add column `test_result` enum('PASS','FAIL') NULL after `year`; Alter table `alpha_live_rm_procurement`.`grn` add column `test_result` enum('PASS','FAIL') NULL after `supervisor_id`; Alter table `alpha_live_production`.`lot_code_data` change `test_result` `grading_test_result` enum('PASS','FAIL') CHARSET latin1 COLLATE latin1_swedish_ci NULL; 01-01-2025(Hygreev) ALTER TABLE alpha_live_hrms.employee_leaves_log CHANGE employee_leaves_id employee_leaves_id INT(11) NOT NULL, DROP PRIMARY KEY ALTER TABLE alpha_live_hrms.employee_leaves_log CHANGE employee_leaves_log_id employee_leaves_log_id INT(11) NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (employee_leaves_log_id) 21-01-2025(HYGREEV) ALTER TABLE `alpha_live_hrms`.`attendance_log` ADD COLUMN `unit_id` INT(11) NULL AFTER `status`; ALTER TABLE `alpha_live_masters`.`vendors` CHANGE `category_id` `category_id` INT(11) NULL; 21-01-2025(sunanda) ALTER TABLE alpha_dev_sales.sale_order ADD COLUMN financial_year VARCHAR(50) NULL AFTER ref_no; ALTER TABLE `alpha_dev_procurement`.`purchase_order` ADD COLUMN `financial_year` VARCHAR(50) NULL AFTER `dispatched_through`; ALTER TABLE alpha_dev_masters.employee_details ADD COLUMN is_authorised TINYINT(1) DEFAULT 0 NULL AFTER date_of_rejoin; 24-01-2025(sunanda) ALTER TABLE `alpha_dev_sales`.`customer_invoice` ADD COLUMN `financial_year` VARCHAR(50) NULL AFTER `rodtep_status`; 27-01-2025(Raji) ALTER TABLE `alpha_live_masters`.`rack_position` ADD COLUMN `barcode` VARCHAR(30) NULL AFTER `rack_reserve_code`; 03-02-2025(Raji) ALTER TABLE `alpha_live_enquiries`.`enquiry_products` ADD COLUMN `price_uom` INT(11) NULL AFTER `brand_type`; ALTER TABLE `alpha_live_sales`.`sale_order_items` ADD COLUMN `price_uom` INT(11) NULL AFTER `stock_in_flag`; 04-02-2025(Raji) ALTER TABLE `alpha_live_warehouse`.`reporting` ADD COLUMN `carton_barcode` VARCHAR(30) NULL AFTER `antibiotic_test_result`; 12-02-2025(Raji) ALTER TABLE `alpha_live_enquiries`.`enquiry_products` ADD COLUMN `glaze` INT(11) NULL AFTER `price_uom`; ALTER TABLE `alpha_live_sales`.`sale_order_items` ADD COLUMN `glaze` INT(11) NULL AFTER `price_uom`; 29-01-2025(naveen) ALTER TABLE `alpha_live_masters`.`rack_position` ADD COLUMN `no_of_pallet` INT(30) NULL AFTER `barcode`; --------------------------------------already executed -------------------------------------------------------------------- 17-02-2025(Raji) ALTER TABLE `alpha_dev_warehouse`.`stock` CHANGE `status` `status` ENUM('StockIn','StockOut','Cancelled','AssignedToStockOut') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'StockIn' NOT NULL; ALTER TABLE `alpha_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','Assigned For Labsamples','Assigned For Compliments') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'Stock' NOT NULL; 17-022025(sunanda) ALTER TABLE `erpx_dev_masters`.`pallet` CHANGE `occupancy` `occupancy` ENUM('Occupied','Occupied-NR','Assigned','Not Occupied','Partially Occupied') CHARSET latin1 COLLATE latin1_swedish_ci DEFAULT 'Not Occupied' NOT NULL; --------------------------------------already executed --------------------------------------------------------------------