/**Begin D:\work\PDM\PDM_UPGRADE_1224\PDM1\BRM_table.sql **/

-- 预置业务对象参数是否更新过输入输出参数，用于避免客户改动预置业务对象字段数据被重新预置，该字段仅适用于预置场景

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BRM_SCENEINPUT' AND KSQL_COL_NAME ='FPRESETISEDIT')
 ALTER TABLE T_BRM_SCENEINPUT ADD (FPRESETISEDIT CHAR(1) DEFAULT '0' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BRM_SCENEOUTPUT' AND KSQL_COL_NAME ='FPRESETISEDIT')
 ALTER TABLE T_BRM_SCENEOUTPUT ADD (FPRESETISEDIT CHAR(1) DEFAULT '0' NOT NULL );

/**End D:\work\PDM\PDM_UPGRADE_1224\PDM1\BRM_table.sql **/