im_menu.sql 572 B

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