CREATE TABLE im_menu ( MEU_ID varchar(8) NOT NULL COMMENT '菜单编号', MEU_NAME varchar(60) COMMENT '菜单名称', MEU_DESC varchar(300) COMMENT '菜单描述', MEU_PARENTID varchar(8) COMMENT '上级菜单编号', MEU_STT char(1) COMMENT '菜单状态 0:激活 1:冻结', MEU_LEVEL varchar(3) COMMENT '菜单级别', MEU_SERIALNO varchar(3) DEFAULT '0' COMMENT '显示序号', MEU_IMG_PATH varchar(100) COMMENT '菜单图片', PRIMARY KEY (MEU_ID) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单表 ';