sp_alert_bit (procedure)
设置bit为必填，默认值为0
- 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 PROCEDUREspalert_bit'._
Narrative
Business context: DBA schema-migration helper. Header says 设置bit为必填，默认值为0 — one-shot installer that hardens every nullable bit column in the xlyweberp database to NOT NULL DEFAULT 0.
What it does: Counts the columns in information_schema.COLUMNS where IS_NULLABLE='YES', DATA_TYPE='bit', and the table is not a viw_* view nor the two gdsconfigform*masterview views. For each match, cursors through, runs UPDATE <tbl> SET <col>=0 WHERE <col> IS NULL, then ALTER TABLE <tbl> CHANGE <col> <col> bit NOT NULL default 0 via dynamic SQL.
Invocation: Status: appears orphaned. Lives in xly-src/script/标版/30100101/sp_alert_bit.sql (the install-time DDL bundle), not bound to any gdsmodule hook, form, or other routine. Run manually by a DBA during initial deployment or schema-hardening sweeps. Candidate for maintainer audit if found in a runtime call path.