# `Sp_Del_BasicsTable_Data` (procedure)

> 根据模块sId删除模块（包含子模块）


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | OUT | `sReturn` | `varchar(4000)` |
| 2 | OUT | `sCode` | `int` |

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_Del_BasicsTable_Data`'`._

## Narrative

**Business context:** Installation / data-purge tool — wipes only the basic-data (master-data) tables: customers, suppliers, employees, products, materials, machines, processes, knife-moulds, plus their classifications and the related `sis*` lookup tables. Sibling of `Sp_Del_BusinessTable_Data` (transactional only) and `Sp_Del_AllTable_Data` (everything).

**What it does:** Sets `sCode=1`/`sReturn=''`, then `TRUNCATE`s the basic-data set: `eleworkcenter`, `elecustomer*`, `siscustomerclassify`, `siscustomerproperty`, `sftlogininfo*` group-binding tables, `eleknifemould*`, `elemachine`, `elematerials*`, `eleprocess*`, `sisprocessclassify*`, `eleproduct*`, `sisproductclassify*`, `elesupply*`, `sissupplyclassify`, `eleteam*`, `eleemployee`, plus `sisbank`, `sisdeliver`, `sisexchangerates`, `sislevel`, `sislosstype`, `sismaterialsclassify`, `sisposition`, `sisproperty`, `sissalesman`, `sisdepart`, `sismerchandiser`, `sischeckphaselogininfo`. Does not touch transactional `mft*`/`pit*`/`cah*`/`sal*` tables.

**Invocation:** Status: appears orphaned. No `gdsmodule` hook, no `gdsconfigformmaster` data-source, no other routine references it. xly-src ships `script/del/Sp_Del_BasicsTable_Data.sql` as part of the `script/del/` reset family — operators invoke it manually when reseeding only basic data.
