/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\POM_table.sql **/
--组件清单
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY_S' AND KSQL_COL_NAME ='FTRACKNUMBERID') 
 ALTER TABLE T_POM_MFTORDERENTRY_S ADD (FTRACKNUMBERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY_S' AND KSQL_COL_NAME ='FCONFIGUREDCODEID') 
 ALTER TABLE T_POM_MFTORDERENTRY_S ADD (FCONFIGUREDCODEID BIGINT DEFAULT 0 NOT NULL );
  --组件清单分录
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MANUSTOCKENTRY' AND KSQL_COL_NAME ='FENTRYCONFIGUREDCODEID') 
 ALTER TABLE T_POM_MANUSTOCKENTRY ADD (FENTRYCONFIGUREDCODEID BIGINT DEFAULT 0 NOT NULL );
 --调拨计划
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_ALLOCATIONPLAN' AND KSQL_COL_NAME ='FTRACKNUMBERID') 
 ALTER TABLE T_POM_ALLOCATIONPLAN ADD (FTRACKNUMBERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_ALLOCATIONPLAN' AND KSQL_COL_NAME ='FCONFIGUREDCODEID') 
 ALTER TABLE T_POM_ALLOCATIONPLAN ADD (FCONFIGUREDCODEID BIGINT DEFAULT 0 NOT NULL );
 --工单汇报分录
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTREPORTSUMMARY' AND KSQL_COL_NAME ='FTRACKNUMBERID') 
 ALTER TABLE T_POM_MFTREPORTSUMMARY ADD (FTRACKNUMBERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTREPORTSUMMARY' AND KSQL_COL_NAME ='FCONFIGUREDCODEID') 
 ALTER TABLE T_POM_MFTREPORTSUMMARY ADD (FCONFIGUREDCODEID BIGINT DEFAULT 0 NOT NULL );
 --工单分录
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY' AND KSQL_COL_NAME ='FTRACKNUMBERID') 
 ALTER TABLE T_POM_MFTORDERENTRY ADD (FTRACKNUMBERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_MFTORDERENTRY' AND KSQL_COL_NAME ='FCONFIGUREDCODEID') 
 ALTER TABLE T_POM_MFTORDERENTRY ADD (FCONFIGUREDCODEID BIGINT DEFAULT 0 NOT NULL ); 
 --工单变更分录
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMFTORDERENTRY' AND KSQL_COL_NAME ='FTRACKNUMBERID') 
 ALTER TABLE T_POM_XMFTORDERENTRY ADD (FTRACKNUMBERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMFTORDERENTRY' AND KSQL_COL_NAME ='FCONFIGUREDCODEID') 
 ALTER TABLE T_POM_XMFTORDERENTRY ADD (FCONFIGUREDCODEID BIGINT DEFAULT 0 NOT NULL );

  --组件清单变更分录
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMANUSTOCKENTRY' AND KSQL_COL_NAME ='FTRACKNUMBERID') 
 ALTER TABLE T_POM_XMANUSTOCKENTRY ADD (FTRACKNUMBERID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMANUSTOCKENTRY' AND KSQL_COL_NAME ='FCONFIGUREDCODEID') 
 ALTER TABLE T_POM_XMANUSTOCKENTRY ADD (FCONFIGUREDCODEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_XMANUSTOCKENTRY' AND KSQL_COL_NAME ='FENTRYCONFIGUREDCODEID') 
 ALTER TABLE T_POM_XMANUSTOCKENTRY ADD (FENTRYCONFIGUREDCODEID BIGINT DEFAULT 0 NOT NULL );

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