66 lines
2.5 KiB
SQL
66 lines
2.5 KiB
SQL
-- 仅用于用户确认可丢弃数据的海外采购测试环境，MySQL 8.0+。
|
|
-- 清空六张当前采购表的数据，删除二十一张旧采购表及其数据。
|
|
-- 仅作用于 baiyue_lastleg 的采购专属表；不修改共用费用、余额、文件对象及库存。
|
|
-- 共用表中已有的采购关联记录不会自动删除或退款；本脚本不用于财务结算。
|
|
-- 先更新分离后的后端并停止采购写入，整份执行，遇错停止，不使用 --force。
|
|
-- 无存储过程、无 DELIMITER、无需设置会话确认变量；DDL 隐式提交。
|
|
USE baiyue_lastleg;
|
|
START TRANSACTION;
|
|
DELETE FROM ll_procurement_workflow_command;
|
|
DELETE FROM ll_procurement_workflow_outbound;
|
|
DELETE FROM ll_procurement_workflow_receipt;
|
|
DELETE FROM ll_overseas_procurement_file;
|
|
DELETE FROM ll_overseas_procurement_status_history;
|
|
DELETE FROM ll_overseas_procurement_order;
|
|
COMMIT;
|
|
|
|
DROP TABLE IF EXISTS
|
|
ll_procurement_closure_item,
|
|
ll_procurement_closure,
|
|
ll_procurement_control_note,
|
|
ll_procurement_fee_correction_item,
|
|
ll_procurement_fee_correction,
|
|
ll_procurement_repack,
|
|
ll_procurement_estimate_review,
|
|
ll_procurement_label_item,
|
|
ll_procurement_label_set,
|
|
ll_procurement_shipment_item,
|
|
ll_procurement_shipment,
|
|
ll_procurement_carton_source,
|
|
ll_procurement_carton,
|
|
ll_procurement_manifest,
|
|
ll_procurement_disposition,
|
|
ll_procurement_receipt,
|
|
ll_procurement_budget_authorization,
|
|
ll_procurement_command,
|
|
ll_procurement_flow,
|
|
ll_procurement_wallet_attempt,
|
|
ll_overseas_procurement_fee;
|
|
|
|
SELECT 'procurement_test_reset_complete' AS result,
|
|
(SELECT COUNT(*) FROM ll_overseas_procurement_order) AS procurement_orders,
|
|
(SELECT COUNT(*) FROM information_schema.tables
|
|
WHERE table_schema='baiyue_lastleg' AND table_name IN (
|
|
'll_overseas_procurement_fee',
|
|
'll_procurement_wallet_attempt',
|
|
'll_procurement_flow',
|
|
'll_procurement_command',
|
|
'll_procurement_budget_authorization',
|
|
'll_procurement_receipt',
|
|
'll_procurement_disposition',
|
|
'll_procurement_manifest',
|
|
'll_procurement_carton',
|
|
'll_procurement_carton_source',
|
|
'll_procurement_shipment',
|
|
'll_procurement_shipment_item',
|
|
'll_procurement_label_set',
|
|
'll_procurement_label_item',
|
|
'll_procurement_estimate_review',
|
|
'll_procurement_repack',
|
|
'll_procurement_fee_correction',
|
|
'll_procurement_fee_correction_item',
|
|
'll_procurement_control_note',
|
|
'll_procurement_closure',
|
|
'll_procurement_closure_item'
|
|
)) AS remaining_legacy_procurement_tables;
|