
-- 带组织基础资料要加管控策略 全局共享  物料控制组
--zhaohui_zeng  2020-06-05
IF NOT EXISTS (SELECT 1 FROM T_BD_DefaultCtrlStrategy WHERE FBASEDATAID = 'bd_materialcontrolgroup') 
insert into T_BD_DefaultCtrlStrategy (FID, FNUMBER, FBASEDATAID, FCTRLVIEW, FDATATYPE, FDEFAULTMANAGESTRATEGY, FDEFAULTCTRLSTRATEGY, FISSYSTEM, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FAPPSYSTEMID, FMASTERID, FPLUGIN)
values ('766549899830499328', ' ', 'bd_materialcontrolgroup', '4', '2', '1', '5', '0', '1', 'A', '1', {ts'2019-10-26 17:34:02'}, '1', {ts'2019-10-26 17:34:02'}, '0', null, '0efa1992000000ac', '766549899830499328', ' ');