insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M01000','010001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M01000','010002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M01000','010003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M01000','010004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M01000','010005'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M12000','010006'); /**客户管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M02000','020001'); /**价格管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M02000','020002'); /**部门管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M02000','020003'); /**信用管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M02000','020004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M02001','090010'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M02001','090011'); /**信息管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M03000','030001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M03000','030002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M03000','030003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M03000','030004'); /**安全管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M04000','040001'); /**商品管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M05000','050001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M05000','050002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M05000','050003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M05000','050004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M05000','030006'); /**仓库管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060005'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060006'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060007'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060008'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060009'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060010'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060011'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060012'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060013'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060014'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M06000','060015'); /**协同管理:生产计划管理、采购计划*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M07000','070001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M07000','070002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M07000','070003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M07000','070004'); /**结算管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M08000','080001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M08000','080002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M08000','080003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M08000','080004'); /**采购管理:采购合同、采购订单*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M09000','090001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M09000','090002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M09000','090003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M09000','090004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M09000','090005'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M09000','090006'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M09000','090007'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M09000','090008'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M09000','010007'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M02001','090005'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M02001','090006'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M02001','090007'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M02001','090009'); /**销售管理:销售合同、销售订单*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M10000','100001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M10000','100002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M10000','100003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M10000','100004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M10000','100005'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M10000','010008'); /**消息管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M11000','110001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M11000','110002'); /**发票管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M12000','120001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M12000','120002'); /**物流管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M13000','130001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M13000','130002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M13000','130003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M13000','130004'); /**收付款管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M14000','150001'); /**物流相关*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M15000','160001'); /**铝产品相关*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170005'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170006'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170007'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170008'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170009'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170010'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170011'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170012'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170013'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170014'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170015'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M16000','170016'); /**氧化铝相关*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M17000','180001'); /**订单相关*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M18000','190001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M18000','190002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M18000','190003'); /**合同相关*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M19000','200001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M19000','200002'); /**综合对账表*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M20000','210001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M20000','210002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M20000','210003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M20000','210004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M20000','210005'); /**预付款管理*/ insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M21000','220001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M22000','230001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M22000','230002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M24000','240001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M24000','240002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M25000','250001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M25000','250002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M26000','260001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M26000','260002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M26000','260003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M26000','260004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M27000','270001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M27000','270002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M27000','270003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M27000','270004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M28000','280001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M28000','280002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M28000','280003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M29000','290001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M29000','290002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M29000','290003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M29000','290004'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M30000','300001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M30000','300002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M31000','310001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M31000','310002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M31000','310003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M32000','320001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M32000','320002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M32000','320003'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M33000','330001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M33000','330002'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M48000','480001'); insert into im_menu_item_rel (MIR_MENUID, MIR_ITEMID) values('M48000','480002');