# `sp_updateEnglishBasic` (procedure)


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | OUT | `sCode` | `int` |
| 2 | OUT | `sReturn` | `longtext` |

## Body

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

## Narrative

**Business context:** Internationalisation one-shot — swaps the Chinese `sName`/`sProcessName`/`sMaterialsName`/`sBoxType`/`sColorName` columns with their English counterparts (`sEnglishName`, `sEnglishProcessName`, `sMaterialsEnglishName`, etc.) across the basic-data dictionaries. Effectively flips a tenant's primary language by promoting the English column to the displayed column.

**What it does:** For each basic-data table (`sisproductclassify`, `sisprocessclassify`, `eleprocess`, `elematerials`, `sisboxtype`, `sisproductclassifycolor`, `eleprocessdynamic`, `sisboxtypeparam`, `sisboxtypesetting`, `sisproductclassifypart`, …), creates a temp snapshot via `CREATE TEMPORARY TABLE tmp_X SELECT sId, sName, sEnglishName FROM X` then does `UPDATE X JOIN tmp_X ON sId SET X.sEnglishName=tmp.sName, X.sName=tmp.sEnglishName` — i.e. a column swap. The 工序分类表 branch guards `IFNULL(sEnglishName,'')<>''` to skip rows with no English set.

**Invocation:** Status: appears orphaned. No caller found in any channel — no form-master, no gdsmodule hook, no other routine, no xly-src grep. One-off DBA migration helper; running it twice undoes itself. Candidate for maintainer audit before any tenant relies on it.