/**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_SCH_TASK' AND KSQL_COL_NAME ='FSCHEDULETIME') 
 ALTER TABLE T_SCH_TASK ADD (FSCHEDULETIME DATETIME );

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

/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\SYS_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_SCH_TASK' AND KSQL_INDNAME = 'IDX_SCH_TASK_SCHEDULETIME') CREATE INDEX IDX_SCH_TASK_SCHEDULETIME ON T_SCH_TASK ( FSCHEDULETIME );


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