/**Begin D:\PDM_UPGRADE\PDM1\HRCS_table.sql **/
--计费系统用户--
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_CHARGECOMPANY' AND KSQL_COL_NAME ='FLINKUSERID') 
ALTER TABLE T_HRCS_CHARGECOMPANY ADD (FLINKUSERID BIGINT DEFAULT 0 NOT NULL);


--电子合同许可详情--
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_LICGRPDETAIL' AND KSQL_COL_NAME ='FMODIFIERID') 
ALTER TABLE T_HRCS_LICGRPDETAIL ADD (FMODIFIERID BIGINT DEFAULT 0 NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_LICGRPDETAIL' AND KSQL_COL_NAME ='FMODIFYTIME') 
ALTER TABLE T_HRCS_LICGRPDETAIL ADD (FMODIFYTIME DATETIME);
/**End D:\PDM_UPGRADE\PDM1\HRCS_table.sql **/
