# `Sp_Con_Reset` (procedure)

> 配置还原


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

## Parameters

_No parameters._

## Body

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

## Narrative

**Business context:** 系统平台 → 表单配置 — 配置还原 ("config restore") for every approval-info config row in the tenant. Walks all `sysbillcheckresult`-bound `gdsconfigformmaster` rows under brand/subsidiary `1111111111/1111111111` and resets each one's `sSqlStr`/`sOrder`/slave columns back to the canonical 审批信息 layout, so a tenant-wide layout corruption can be undone in one shot.

**What it does:** Counts the `gdsconfigformmaster` rows whose `sTbName='sysbillcheckresult'` for the hardcoded standard-tenant id, then cursors over each `sId`: `DELETE FROM gdsconfigformslave WHERE sParentId=p_sParentId`, `UPDATE gdsconfigformmaster` to restore the standard `biz_todo_item × biz_flow` data-source SQL, and `INSERT INTO gdsconfigformslave` the full canonical column set (`sItemName`, `sNodeName`, `bView`, `bHandle`, `tToDate`, `tHandleDate`, …).

**Invocation:** Status: appears orphaned. No `gdsmodule` hook, `gdsconfigformmaster` reference, or other-routine caller; xly-src only ships the install script `script/标版/30100101/Sp_Con_Reset.sql`. Tenant-wide variant of `Sp_Con_FormsReset`; intended as a maintenance/seeding tool, not normal runtime traffic.
