/**Begin D:\idea_workspace\pdm\PDM1\HRCS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_PERAUTHRECORD' AND KSQL_COL_NAME ='FNAMEMD5VAL') 
 ALTER TABLE T_HRCS_PERAUTHRECORD ADD (FNAMEMD5VAL VARCHAR(120) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_PERAUTHRECORD' AND KSQL_COL_NAME ='FMOBILEMD5VAL') 
 ALTER TABLE T_HRCS_PERAUTHRECORD ADD (FMOBILEMD5VAL VARCHAR(120) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRCS_PERAUTHRECORD' AND KSQL_COL_NAME ='FIDENTITYMD5VAL') 
 ALTER TABLE T_HRCS_PERAUTHRECORD ADD (FIDENTITYMD5VAL VARCHAR(120) DEFAULT ' ' NOT NULL );
 
/**End D:\idea_workspace\pdm\PDM1\HRCS_table.sql **/
