/**Begin C:\Users\rd_jin_gu\Documents\work\PDM_UPGRADE\PDM1\HRPTMC_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRPTMC_RPTQUERYCONFIG' AND KSQL_COL_NAME ='FJOBID') 
 ALTER TABLE T_HRPTMC_RPTQUERYCONFIG ADD (FJOBID VARCHAR(36) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRPTMC_RPTQUERYCONFIG' AND KSQL_COL_NAME ='FSCHEDULEID') 
 ALTER TABLE T_HRPTMC_RPTQUERYCONFIG ADD (FSCHEDULEID VARCHAR(36) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRPTMC_RPTQUERYCONFIG' AND KSQL_COL_NAME ='FNEWENTITYNUM') 
 ALTER TABLE T_HRPTMC_RPTQUERYCONFIG ADD (FNEWENTITYNUM VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRPTMC_RPTQUERYCONFIG' AND KSQL_COL_NAME ='FENABLEEXTRACT') 
 ALTER TABLE T_HRPTMC_RPTQUERYCONFIG ADD (FENABLEEXTRACT CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRPTMC_RPTQUERYCONFIG' AND KSQL_COL_NAME ='FCYCLE') 
 ALTER TABLE T_HRPTMC_RPTQUERYCONFIG ADD (FCYCLE VARCHAR(10) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRPTMC_RPTQUERYCONFIG' AND KSQL_COL_NAME ='FSCHEDULETIME') 
 ALTER TABLE T_HRPTMC_RPTQUERYCONFIG ADD (FSCHEDULETIME VARCHAR(10) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRPTMC_RPTQUERYCONFIG' AND KSQL_COL_NAME ='FWEEK') 
 ALTER TABLE T_HRPTMC_RPTQUERYCONFIG ADD (FWEEK VARCHAR(10) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRPTMC_RPTQUERYCONFIG' AND KSQL_COL_NAME ='FDAY') 
 ALTER TABLE T_HRPTMC_RPTQUERYCONFIG ADD (FDAY VARCHAR(10) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HRPTMC_RPTQUERYCONFIG' AND KSQL_COL_NAME ='FEXECUTEWITHSAVE') 
 ALTER TABLE T_HRPTMC_RPTQUERYCONFIG ADD (FEXECUTEWITHSAVE CHAR(1) DEFAULT '0' NOT NULL );

/**End C:\Users\rd_jin_gu\Documents\work\PDM_UPGRADE\PDM1\HRPTMC_table.sql **/
