DELETE FROM im_menu_item_rel; DELETE FROM im_menu; DELETE FROM Im_item; ##一级菜单 INSERT INTO im_menu (MEU_ID, MEU_NAME, MEU_DESC, MEU_PARENTID, MEU_STT, MEU_LEVEL, MEU_SERIALNO, MEU_IMG_PATH) VALUES('M01000','首页','首页','M00000','0','1','0',NULL); INSERT INTO im_menu (MEU_ID, MEU_NAME, MEU_DESC, MEU_PARENTID, MEU_STT, MEU_LEVEL, MEU_SERIALNO, MEU_IMG_PATH) VALUES('M10000','系统管理','系统管理','M00000','0','1','1',NULL); INSERT INTO im_menu (MEU_ID, MEU_NAME, MEU_DESC, MEU_PARENTID, MEU_STT, MEU_LEVEL, MEU_SERIALNO, MEU_IMG_PATH) VALUES('M20000','机器管理','机器管理','M00000','0','1','0',NULL); INSERT INTO im_menu (MEU_ID, MEU_NAME, MEU_DESC, MEU_PARENTID, MEU_STT, MEU_LEVEL, MEU_SERIALNO, MEU_IMG_PATH) VALUES('M30000','商品管理','商品管理','M00000','0','1','0',NULL); INSERT INTO im_menu (MEU_ID, MEU_NAME, MEU_DESC, MEU_PARENTID, MEU_STT, MEU_LEVEL, MEU_SERIALNO, MEU_IMG_PATH) VALUES('M40000','财务管理','财务管理','M00000','0','1','0',NULL); INSERT INTO im_menu (MEU_ID, MEU_NAME, MEU_DESC, MEU_PARENTID, MEU_STT, MEU_LEVEL, MEU_SERIALNO, MEU_IMG_PATH) VALUES('M50000','支付管理','支付管理','M00000','0','1','0',NULL); #首页 INSERT INTO im_menu (MEU_ID, MEU_NAME, MEU_DESC, MEU_PARENTID, MEU_STT, MEU_LEVEL, MEU_SERIALNO, MEU_IMG_PATH) VALUES('M01100','首页','首页','M01000','0','2','1',NULL); ##系统管理 INSERT INTO im_menu (MEU_ID, MEU_NAME, MEU_DESC, MEU_PARENTID, MEU_STT, MEU_LEVEL, MEU_SERIALNO, MEU_IMG_PATH) VALUES('M10100','系统管理','运营中心','M31000','0','2','5',NULL); ##机器管理 INSERT INTO im_menu (MEU_ID, MEU_NAME, MEU_DESC, MEU_PARENTID, MEU_STT, MEU_LEVEL, MEU_SERIALNO, MEU_IMG_PATH) VALUES('M40100','机器管理','机器管理','M40000','0','2','1',NULL);