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('M11000','统一数据中心','统一数据','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('M21000','业务中心','业务中心','M00000','0','1','2',NULL); INSERT INTO im_menu (MEU_ID, MEU_NAME, MEU_DESC, MEU_PARENTID, MEU_STT, MEU_LEVEL, MEU_SERIALNO, MEU_IMG_PATH) VALUES('M31000','运营中心','运营中心','M00000','0','1','3',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('M11100','用户管理','统一数据','M11000','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('M31500','系统管理','运营中心','M31000','0','2','5',NULL);