--计划中台的五个表增加字段：是否预设
--实体字段映射（本次不增加，因为已有系统预设字段fissysteminsert了），数据源同样也有该字段了。
 
 --资源注册模型
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_RSREGISTER' AND KSQL_COL_NAME ='FISSYS') 
ALTER TABLE T_MRP_RSREGISTER ADD (FISSYS CHAR(1) DEFAULT '0' NOT NULL);
 
 
 --算法注册配置
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_ALGOREGISTER' AND KSQL_COL_NAME ='FISSYS') 
ALTER TABLE T_MRP_ALGOREGISTER ADD (FISSYS CHAR(1) DEFAULT '0' NOT NULL);
 
 
  --业务方案配置
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_BUSINESSPLAN' AND KSQL_COL_NAME ='FISSYS') 
ALTER TABLE T_MRP_BUSINESSPLAN ADD (FISSYS CHAR(1) DEFAULT '0' NOT NULL);
 
 
  --计算方案配置
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_CALPLANCONFIG' AND KSQL_COL_NAME ='FISSYS') 
ALTER TABLE T_MRP_CALPLANCONFIG ADD (FISSYS CHAR(1) DEFAULT '0' NOT NULL);
 