Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/resources/sql/ – Rev 37867

Rev 37850 | Last modification | Compare with Previous | View Log | RSS feed

Last modification

Rev 37853 2026-10-05 19:51:04
Author: amit
Log message:
docs(warehouse): record-only migration files for 2026-10-05 HR move - suspended-warehouse brand mapping (1:1 HR substitution, 1,062 deleted / 51 added), 3 franchise stores 7678->13372, note for the store remap and pending-order move done outside the code (all already applied on hadb1, do not re-run)

Path	Last modification			Log	RSS
20260916_sync_internal_store_addresses.sql	37652	20 d 22 h	amit	Log	RSS
20261001_delete_hrgn1715_hr_uk_store.sql	37822	5 d 16 h	amit	Log	RSS
20261001_hr_gurugram_vendor_warehouses.sql	37822	5 d 16 h	amit	Log	RSS
20261001_hr_gurugram_virtual_warehouses.sql	37822	5 d 16 h	amit	Log	RSS
20261001_warehouseaddressmaster_active.sql	37822	5 d 16 h	amit	Log	RSS
20261002_hr_movement_hsn_tax_category_fixes.sql	37835	3 d 0 h	amit	Log	RSS
20261004_hr_warehouse_self_brand_mapping.sql	37835	3 d 0 h	amit	Log	RSS
20261005_franchise_stores_7678_to_13372.sql	37853	1 d 18 h	amit	Log	RSS
20261005_hr_ggn_central_brand_mapping.sql	37850	1 d 18 h	amit	Log	RSS
20261005_hr_move_stores_orders_NOTE.sql	37853	1 d 18 h	amit	Log	RSS
20261005_suspended_warehouse_brand_mapping.sql	37853	1 d 18 h	amit	Log	RSS
add_credit_block_log.sql	37030	91 d 23 h	amit	Log	RSS
add_credit_note_id_to_returnorderinfo.sql	36817	118 d 23 h	amit	Log	RSS
add_idx_account_statement_perf.sql	36691	133 d 20 h	amit	Log	RSS
add_idx_order_grn_pending.sql	37588	25 d 20 h	amit	Log	RSS
add_idx_uwh_timestamp_reftype.sql	36330	168 d 21 h	amit	Log	RSS
add_inventory_cost_layer_20260917.sql	37694	19 d 19 h	amit	Log	RSS
add_irn_error_message.sql	36675	134 d 18 h	amit	Log	RSS
add_po_created_by_20260924.sql	37769	12 d 19 h	amit	Log	RSS
add_po_reopened_at_20260918.sql	37708	19 d 9 h	amit	Log	RSS
add_reference_to_offer_scheme.sql	36451	157 d 20 h	amit	Log	RSS
add_return_b2c_refund_20260921.sql	37790	8 d 23 h	amit	Log	RSS
add_tag_listing_last_activated_20260929.sql	37805	8 d 9 h	amit	Log	RSS
add_uk_fofo_order_fofo_invoice.sql	36362	167 d 18 h	amit	Log	RSS
add_web_offer_circular_sync.sql	37525	33 d 20 h	amit	Log	RSS
add_web_offer_per_model.sql	37581	26 d 22 h	amit	Log	RSS
alter_monitor_type_normal_to_base.sql	36443	158 d 21 h	amit	Log	RSS
backdated_po_auto_approval_backfill_20260917.sql	37679	19 d 21 h	amit	Log	RSS
backfill_debit_note_status_old_flow_20260924.sql	37797	8 d 21 h	amit	Log	RSS
backfill_dn_return_credit_note_id.sql	36926	103 d 23 h	amit	Log	RSS
backfill_po_rejected_orders.sql	36790	124 d 0 h	amit	Log	RSS
backfill_receipt_origin_20260918.sql	37713	19 d 8 h	amit	Log	RSS
catalog_monitor_type.sql	36441	159 d 0 h	amit	Log	RSS
cleanup_abandoned_draft_orders.sql	36795	121 d 0 h	amit	Log	RSS
cleanup_phantom_payment_failed.sql	36795	121 d 0 h	amit	Log	RSS
contact_us.sql	36888	107 d 1 h	aman	Log	RSS
create_cron_batch_tables.sql	36305	171 d 5 h	amit	Log	RSS
create_tag_listing_price_log_20260915.sql	37634	21 d 20 h	amit	Log	RSS
delist_inactive_listings_rolling_24m.sql	37805	8 d 9 h	amit	Log	RSS
delist_samsung_pre2025_no_stock.sql	37562	27 d 13 h	amit	Log	RSS
drop_dead_ageing_columns_20260912.sql	37601	24 d 23 h	amit	Log	RSS
drop_internal_vendor_catalog_pricing_20260914.sql	37625	22 d 19 h	amit	Log	RSS
drop_internal_vendor_catalog_pricing_20260915.sql	37639	21 d 20 h	amit	Log	RSS
drop_internal_vendor_catalog_pricing_hotspot_20260916.sql	37667	20 d 18 h	amit	Log	RSS
drop_internal_vendor_pricing_20260912.sql	37608	24 d 20 h	amit	Log	RSS
drop_po_reopened_at_20260924.sql	37769	12 d 19 h	amit	Log	RSS
fix_dark_model_retire_20260924.sql	37778	12 d 15 h	amit	Log	RSS
fix_invoice_receiveDate_from_purchase.sql	36314	170 d 1 h	amit	Log	RSS
fix_item_color_prefix_space_20260929.sql	37805	8 d 9 h	amit	Log	RSS
flagship_credit_schema.sql	36557	144 d 7 h	amit	Log	RSS
hot_deal_brand_migration.sql	37646	21 d 19 h	amit	Log	RSS
hot_deal_brand_remove_5_catalogs_20260918.sql	37724	18 d 19 h	amit	Log	RSS
hot_deal_brand_schema.sql	37640	21 d 20 h	amit	Log	RSS
mail_outbox.sql	35956	214 d 1 h	amit	Log	RSS
migration_bulk_order_approval_report_menu.sql	35966	213 d 23 h	amit	Log	RSS
migration_demo_partner_access.sql	37785	11 d 21 h	amit	Log	RSS
migration_dn_status_retailer_ack.sql	36446	158 d 14 h	amit	Log	RSS
migration_dummy_warehouses.sql	36309	170 d 13 h	amit	Log	RSS
migration_external_api_client.sql	37149	71 d 23 h	amit	Log	RSS
migration_external_api_v2.sql	37284	57 d 21 h	amit	Log	RSS
migration_gst_to_fofo_store.sql	35908	219 d 2 h	amit	Log	RSS
migration_hdfc_payment_credited_flag.sql	36943	102 d 21 h	amit	Log	RSS
migration_imei_net_margin_modal_api.sql	36407	162 d 18 h	amit	Log	RSS
migration_lead_live_location.sql	36711	132 d 19 h	ranu	Log	RSS
migration_lead_visit_approval.sql	36642	137 d 17 h	ranu	Log	RSS
migration_loan_imei_table.sql	36958	98 d 22 h	amit	Log	RSS
migration_mail_outbox_sendgrid_to_relay.sql	37483	36 d 19 h	amit	Log	RSS
migration_menu_icons.sql	36567	143 d 23 h	amit	Log	RSS
migration_order_wallet_adjustment.sql	36713	132 d 19 h	amit	Log	RSS
migration_outlet_name_to_fofo_store.sql	36439	159 d 1 h	amit	Log	RSS
migration_pjp_agenda_instances.sql	37163	69 d 2 h	amit	Log	RSS
migration_pjp_agenda_menu.sql	37186	68 d 20 h	amit	Log	RSS
migration_po_transaction_mapping.sql	36910	105 d 2 h	amit	Log	RSS
migration_requested_hid_allocation_approved_by.sql	36894	106 d 22 h	amit	Log	RSS
migration_running_balance_wallet_history.sql	36515	149 d 18 h	amit	Log	RSS
migration_scheme_item_windowing.sql	36406	162 d 20 h	amit	Log	RSS
migration_store_closure.sql	37764	12 d 20 h	amit	Log	RSS
migration_unsettled_purchase_return_menu.sql	36318	169 d 18 h	aman	Log	RSS
model_flagship_schema.sql	36565	144 d 0 h	amit	Log	RSS
model_hot_deal_activated_to_fresh.sql	37268	58 d 3 h	amit	Log	RSS
model_hot_deal_attributes.sql	37268	58 d 3 h	amit	Log	RSS
model_hot_deal_schema.sql	37211	64 d 0 h	amit	Log	RSS
partner_investment_snapshot.sql	37592	25 d 18 h	amit	Log	RSS
reconcile_inventory_snapshot.sql	36512	149 d 21 h	amit	Log	RSS
register_aged_apple_imeis_api.sql	37597	25 d 18 h	amit	Log	RSS
retag_manual_scheme_reversals_to_others.sql	37074	85 d 3 h	amit	Log	RSS
retire_counter_privatedealuser_20260916.sql	37688	19 d 19 h	amit	Log	RSS
return_reversal_20260921.sql	37776	12 d 17 h	amit	Log	RSS
revert_price_drop_vendor_catalog_pricing_20260915.sql	37634	21 d 20 h	amit	Log	RSS
rollback_delist_recent_movement_20260910.sql	37566	27 d 1 h	amit	Log	RSS
sellerwarehouse_status_display_name_20261005.sql	37845	1 d 19 h	amit	Log	RSS
solr_update_failures.sql	35547	265 d 21 h	amit	Log	RSS
uppercase_fofo_store_gstin_20260928.sql	37804	8 d 13 h	amit	Log	RSS
void_net_settled_stranded_orders.sql	36796	121 d 0 h	amit	Log	RSS