/**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 ='FACCESSTOKEN') 
ALTER TABLE T_HRCS_CHARGECOMPANY ADD (FACCESSTOKEN NVARCHAR(50) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_CHARGECOMPANY' AND KSQL_COL_NAME ='FACCESSTOKEN_ENP') 
ALTER TABLE T_HRCS_CHARGECOMPANY ADD (FACCESSTOKEN_ENP NVARCHAR(255) DEFAULT ' ' NOT NULL);

--电子合同许可详情--
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_LICDECRDETAIL' AND KSQL_COL_NAME ='FCHARGEREGISTERID') 
ALTER TABLE T_HRCS_LICDECRDETAIL ADD (FCHARGEREGISTERID BIGINT DEFAULT 0 NOT NULL);

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