/**Begin D:\PDM_UPGRADE\PDM1\SOEHRR_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_REPORT' AND KSQL_COL_NAME ='FDISUNIT')
ALTER TABLE T_SOEHRR_REPORT ADD (FDISUNIT BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_REPORT' AND KSQL_COL_NAME ='FCOLLECTTASK')
ALTER TABLE T_SOEHRR_REPORT ADD (FCOLLECTTASK BIGINT DEFAULT 0 NOT NULL  );
/**End D:\PDM_UPGRADE\PDM1\SOEHRR_table.sql **/


