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