  --排程方案定义增加查询订单号，数据源id字段
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_PLS_SCHEME' AND KSQL_COL_NAME ='FALLORDERNOS') 
	 ALTER TABLE T_MRP_PLS_SCHEME ADD (FALLORDERNOS NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_PLS_SCHEME' AND KSQL_COL_NAME ='FALLORDERNOS_TAG') 
	 ALTER TABLE T_MRP_PLS_SCHEME ADD (FALLORDERNOS_TAG NCLOB );
	 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_PLS_SCHEME' AND KSQL_COL_NAME ='FSOURCECONFIGIDS') 
	 ALTER TABLE T_MRP_PLS_SCHEME ADD (FSOURCECONFIGIDS NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_PLS_SCHEME' AND KSQL_COL_NAME ='FSOURCECONFIGIDS_TAG') 
	 ALTER TABLE T_MRP_PLS_SCHEME ADD (FSOURCECONFIGIDS_TAG NCLOB );