Subversion Repositories SmartDukaan

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

Last modification

Rev 37562 2026-09-10 00:50:44
Author: amit
Log message:
Add SQL to delist pre-2025 Samsung listings with no stock

Marks 738 catalog.tag_listing rows (tag_id 4) inactive with eol_date
2026-09-08. These are Samsung listings published before 2025-01-01 holding
no stock in any SmartDukaan warehouse and none at any active partner store.

Id list is frozen from the prod evaluation rather than re-derived, so the
same listings are delisted in every environment; stock tables in a copy
drift from prod. Script is idempotent and carries guards, verification and
a rollback block.

Applied to prod hadb1 and the local dev copy.

Path	Last modification			Log	RSS
add_credit_block_log.sql	37030	93 d 12 h	amit	Log	RSS
add_credit_note_id_to_returnorderinfo.sql	36817	120 d 11 h	amit	Log	RSS
add_idx_account_statement_perf.sql	36691	135 d 9 h	amit	Log	RSS
add_idx_uwh_timestamp_reftype.sql	36330	170 d 10 h	amit	Log	RSS
add_irn_error_message.sql	36675	136 d 7 h	amit	Log	RSS
add_reference_to_offer_scheme.sql	36451	159 d 9 h	amit	Log	RSS
add_uk_fofo_order_fofo_invoice.sql	36362	169 d 6 h	amit	Log	RSS
add_web_offer_circular_sync.sql	37525	35 d 8 h	amit	Log	RSS
alter_monitor_type_normal_to_base.sql	36443	160 d 10 h	amit	Log	RSS
backfill_dn_return_credit_note_id.sql	36926	105 d 12 h	amit	Log	RSS
backfill_po_rejected_orders.sql	36790	125 d 13 h	amit	Log	RSS
catalog_monitor_type.sql	36441	160 d 12 h	amit	Log	RSS
cleanup_abandoned_draft_orders.sql	36795	122 d 13 h	amit	Log	RSS
cleanup_phantom_payment_failed.sql	36795	122 d 13 h	amit	Log	RSS
contact_us.sql	36888	108 d 14 h	aman	Log	RSS
create_cron_batch_tables.sql	36305	172 d 18 h	amit	Log	RSS
delist_samsung_pre2025_no_stock.sql	37562	29 d 1 h	amit	Log	RSS
fix_invoice_receiveDate_from_purchase.sql	36314	171 d 14 h	amit	Log	RSS
flagship_credit_schema.sql	36557	145 d 20 h	amit	Log	RSS
mail_outbox.sql	35956	215 d 13 h	amit	Log	RSS
migration_bulk_order_approval_report_menu.sql	35966	215 d 12 h	amit	Log	RSS
migration_dn_status_retailer_ack.sql	36446	160 d 2 h	amit	Log	RSS
migration_dummy_warehouses.sql	36309	172 d 2 h	amit	Log	RSS
migration_external_api_client.sql	37149	73 d 11 h	amit	Log	RSS
migration_external_api_v2.sql	37284	59 d 9 h	amit	Log	RSS
migration_gst_to_fofo_store.sql	35908	220 d 15 h	amit	Log	RSS
migration_hdfc_payment_credited_flag.sql	36943	104 d 10 h	amit	Log	RSS
migration_imei_net_margin_modal_api.sql	36407	164 d 6 h	amit	Log	RSS
migration_lead_live_location.sql	36711	134 d 8 h	ranu	Log	RSS
migration_lead_visit_approval.sql	36642	139 d 6 h	ranu	Log	RSS
migration_loan_imei_table.sql	36958	100 d 11 h	amit	Log	RSS
migration_mail_outbox_sendgrid_to_relay.sql	37483	38 d 8 h	amit	Log	RSS
migration_menu_icons.sql	36567	145 d 12 h	amit	Log	RSS
migration_order_wallet_adjustment.sql	36713	134 d 7 h	amit	Log	RSS
migration_outlet_name_to_fofo_store.sql	36439	160 d 14 h	amit	Log	RSS
migration_pjp_agenda_instances.sql	37163	70 d 15 h	amit	Log	RSS
migration_pjp_agenda_menu.sql	37186	70 d 9 h	amit	Log	RSS
migration_po_transaction_mapping.sql	36910	106 d 14 h	amit	Log	RSS
migration_requested_hid_allocation_approved_by.sql	36894	108 d 11 h	amit	Log	RSS
migration_running_balance_wallet_history.sql	36515	151 d 7 h	amit	Log	RSS
migration_scheme_item_windowing.sql	36406	164 d 8 h	amit	Log	RSS
migration_unsettled_purchase_return_menu.sql	36318	171 d 7 h	aman	Log	RSS
model_flagship_schema.sql	36565	145 d 13 h	amit	Log	RSS
model_hot_deal_activated_to_fresh.sql	37268	59 d 16 h	amit	Log	RSS
model_hot_deal_attributes.sql	37268	59 d 16 h	amit	Log	RSS
model_hot_deal_schema.sql	37211	65 d 13 h	amit	Log	RSS
reconcile_inventory_snapshot.sql	36512	151 d 10 h	amit	Log	RSS
retag_manual_scheme_reversals_to_others.sql	37074	86 d 16 h	amit	Log	RSS
solr_update_failures.sql	35547	267 d 10 h	amit	Log	RSS
void_net_settled_stranded_orders.sql	36796	122 d 12 h	amit	Log	RSS