/**Begin D:\pdm\PDM_UPGRADE\PDM1\kd_1.5.225_01_addCol_fplugin.sql **/
-- 新增 实体模板配置表新增是否隐藏标识行字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HIES_DIAETPLCONF' AND KSQL_COL_NAME ='FHIDELOGOTYPELINEFLAG')
 ALTER TABLE T_HIES_DIAETPLCONF ADD (FHIDELOGOTYPELINEFLAG CHAR(1) DEFAULT '0' NOT NULL);
-- 新增 单据体模板配置表新增是否隐藏标识行字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HIES_ENTRYTPLCONF' AND KSQL_COL_NAME ='FHIDELOGOTYPELINEFLAG')
 ALTER TABLE T_HIES_ENTRYTPLCONF ADD (FHIDELOGOTYPELINEFLAG CHAR(1) DEFAULT '0' NOT NULL);
-- 新增 实体模板字段表新增是否虚实体字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HIES_DIAETPLFIELDCONF' AND KSQL_COL_NAME ='FISVIRFIELD')
 ALTER TABLE T_HIES_DIAETPLFIELDCONF ADD (FISVIRFIELD CHAR(1) DEFAULT '0' NOT NULL );

/**End D:\pdm\PDM_UPGRADE\PDM1\kd_1.5.225_01_addCol_fplugin.sql **/
