1234567891011 |
- 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='菜单表 ';
|