-- 公式平台函数分类表
-- 增加适用范围字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_FUNCTIONTYPE' AND KSQL_COL_NAME ='FSCOPETYPE')
ALTER TABLE T_HRCS_FUNCTIONTYPE ADD (FSCOPETYPE CHAR(1) DEFAULT '1' NOT NULL );
-- comment
--comment on table T_HRCS_FUNCTIONTYPE is '公式平台函数分类表';
--comment on column T_HRCS_FUNCTIONTYPE.FSCOPETYPE is '适用范围';