/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\SYS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MUTEX_DATALOCK' AND KSQL_COL_NAME ='fclienttype') 
ALTER TABLE T_MUTEX_DATALOCK ADD (fclienttype NVARCHAR(36));

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MUTEX_DATALOCK' AND KSQL_COL_NAME ='ftraceid') 
ALTER TABLE T_MUTEX_DATALOCK ADD (ftraceid NVARCHAR(50));

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MUTEX_DATALOCK' AND KSQL_COL_NAME ='fobjectnumber') 
ALTER TABLE T_MUTEX_DATALOCK ADD (fobjectnumber NVARCHAR(36));

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MUTEX_DATALOCK' AND KSQL_COL_NAME ='fcallsource') 
ALTER TABLE T_MUTEX_DATALOCK ADD (fcallsource NVARCHAR(50));

/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\SYS_table.sql **/
