/**Begin D:\work\PDM\PDM_UPGRADE_1224\PDM1\HRCS_table.sql **/

-- 支持是否自定义 变量映射
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_KEYMAPPINGENTRY' AND KSQL_COL_NAME ='FISCUSTOMIZE')
 ALTER TABLE T_HRCS_KEYMAPPINGENTRY ADD (FISCUSTOMIZE VARCHAR(2) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_KEYMAPPINGENTRY' AND KSQL_COL_NAME ='FCUSTOMIZEKEY')
 ALTER TABLE T_HRCS_KEYMAPPINGENTRY ADD (FCUSTOMIZEKEY NVARCHAR(60) DEFAULT ' ' NOT NULL );

/**End D:\work\PDM\PDM_UPGRADE_1224\PDM1\HRCS_table.sql **/
