/**Begin D:\PDM_UPGRADE\PDM1\SOEHRR_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_RPTTPL' AND KSQL_COL_NAME ='FRPTTYPE')
ALTER TABLE T_SOEHRR_RPTTPL ADD (FRPTTYPE VARCHAR(10) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_RPTTPLENTRY' AND KSQL_COL_NAME ='FISNOWEDIT')
ALTER TABLE T_SOEHRR_RPTTPLENTRY ADD (FISNOWEDIT CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_RPTTPLENTRY' AND KSQL_COL_NAME ='FAUDITDATETIME')
ALTER TABLE T_SOEHRR_RPTTPLENTRY ADD (FAUDITDATETIME DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_REPORT' AND KSQL_COL_NAME ='FREPENTRYID')
ALTER TABLE T_SOEHRR_REPORT ADD (FREPENTRYID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_REPORT' AND KSQL_COL_NAME ='FFILLAREA')
ALTER TABLE T_SOEHRR_REPORT ADD (FFILLAREA VARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_COLLECTTASKOBJS' AND KSQL_COL_NAME ='FREPENTRYID')
ALTER TABLE T_SOEHRR_COLLECTTASKOBJS ADD (FREPENTRYID BIGINT DEFAULT 0 NOT NULL );

/**End D:\PDM_UPGRADE\PDM1\SOEHRR_table.sql **/


