/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BASE_table.sql **/
/**配置号*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_BOMENTRY' AND KSQL_COL_NAME ='FENTRYCONFIGCODEID')
 ALTER TABLE T_BD_BOMENTRY ADD (FENTRYCONFIGCODEID BIGINT DEFAULT 0 NOT NULL );
/**是否替代件*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_BOMENTRY' AND KSQL_COL_NAME ='FENTRYISREPLACE')
 ALTER TABLE T_BD_BOMENTRY ADD (FENTRYISREPLACE CHAR(1) DEFAULT '0' NOT NULL );

 /**跳层*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_BOMENTRY' AND KSQL_COL_NAME ='FENTRYISJUMPLEVEL')
 ALTER TABLE T_BD_BOMENTRY ADD (FENTRYISJUMPLEVEL CHAR(1) DEFAULT '0' NOT NULL );

/**是否替代件*/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_SYNCRULESV' AND KSQL_COL_NAME ='FISREPLACE')
 ALTER TABLE T_BD_SYNCRULESV ADD (FISREPLACE CHAR(1) DEFAULT '0' NOT NULL);

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