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

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMANUSTOCKENTRY' AND KSQL_COL_NAME ='FPARENTENTRYID') 
 ALTER TABLE T_POM_XMANUSTOCKENTRY ADD (FPARENTENTRYID BIGINT DEFAULT 0 NOT NULL );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MANUSTOCKENTRY_A' AND KSQL_COL_NAME ='FREPLACEPLAN') 
 ALTER TABLE T_POM_MANUSTOCKENTRY_A ADD (FREPLACEPLAN BIGINT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMANUSTOCKENTRY_A' AND KSQL_COL_NAME ='FREPLACEPLAN') 
 ALTER TABLE T_POM_XMANUSTOCKENTRY_A ADD (FREPLACEPLAN BIGINT DEFAULT 0 NOT NULL );

  IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MANUSTOCKENTRY_A' AND KSQL_COL_NAME ='FPRIORITY') 
 ALTER TABLE T_POM_MANUSTOCKENTRY_A ADD (FPRIORITY BIGINT DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMANUSTOCKENTRY_A' AND KSQL_COL_NAME ='FPRIORITY') 
 ALTER TABLE T_POM_XMANUSTOCKENTRY_A ADD (FPRIORITY BIGINT DEFAULT 0 NOT NULL );
 
  IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MANUSTOCKENTRY_A' AND KSQL_COL_NAME ='FISMAINREPLACE') 
 ALTER TABLE T_POM_MANUSTOCKENTRY_A ADD (FISMAINREPLACE CHAR(1) DEFAULT '0' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMANUSTOCKENTRY_A' AND KSQL_COL_NAME ='FISMAINREPLACE') 
 ALTER TABLE T_POM_XMANUSTOCKENTRY_A ADD (FISMAINREPLACE CHAR(1) DEFAULT '0' NOT NULL);
/**End D:\PDM_UPGRADE\PDM1\POM_table.sql **/
