19 lines
546 B
MySQL
19 lines
546 B
MySQL
|
-- Version: 2025.7.31 14:52:27
|
|||
|
|
Drop Table T_OPR_CFG@
|
|||
|
|
|
|||
|
|
Create Table T_OPR_CFG(
|
|||
|
|
modular VARCHAR(50) NOT NULL,
|
|||
|
|
operation VARCHAR(50) NOT NULL,
|
|||
|
|
flag DECIMAL(1),
|
|||
|
|
CONSTRAINT pk_T_OPR_CFG PRIMARY KEY (modular, operation)
|
|||
|
|
)
|
|||
|
|
IN TB8KUSREMS INDEX IN TB8KIDXEMS@
|
|||
|
|
Alter Table T_OPR_CFG ALTER COLUMN flag SET WITH Default 0@
|
|||
|
|
|
|||
|
|
COMMENT ON Table T_OPR_CFG IS '操作日志配置'@
|
|||
|
|
|
|||
|
|
COMMENT ON T_OPR_CFG (modular IS '操作模块')@
|
|||
|
|
COMMENT ON T_OPR_CFG (operation IS '操作')@
|
|||
|
|
COMMENT ON T_OPR_CFG (flag IS '是否记录日志[0:不记录，1:记录]')@
|
|||
|
|
|