36 lines
3.6 KiB
SQL
36 lines
3.6 KiB
SQL
-- 清理业务数据
|
|
UPDATE client_error_report SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE client_login_log SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE client_material_call SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE client_material_consume SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE client_material_return SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE client_outsourcing_exec SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE client_quality_exec_item SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE client_quality_exec_main SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE client_work_exec SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE client_work_report SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE client_work_store SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE pd_product SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE pd_product_design SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE pd_product_drawing SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_outsourcing_details SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_outsourcing_order SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_product_order SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_project_main SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_purchase_details SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_purchase_order SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_sale_additional SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_sale_details SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_sale_order SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_schedule_log SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE plan_work_order SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE prod_material SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE prod_material_detail SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE wms_flow SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE wms_inventory_detail SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE wms_inventory_task SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE wms_inventory_template SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE wms_material_ledger SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE wms_materiel SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|
|
UPDATE wms_plan SET deleted = UNIX_TIMESTAMP() WHERE tenant_uuid = '<tenantUuid>' AND deleted = 0;
|