DOC/3设计阶段/DB/01_data/im_menu_data.sql

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