-- 【PRJ-00603684】物料增加可配置物料和变式物料字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_MATERIAL' AND KSQL_COL_NAME ='FRELCONFIGMATERIAL')
 ALTER TABLE T_BD_MATERIAL ADD (FRELCONFIGMATERIAL BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_MATERIAL' AND KSQL_COL_NAME ='FISVARIANT') 
 ALTER TABLE T_BD_MATERIAL ADD (FISVARIANT CHAR(1) DEFAULT '0' NOT NULL );