guomao/DOC/DB/01_data/im_menu_item_rel_data.sql

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');