yzySrv/db/21-01/21-01-09.sql

-- liushl
CREATE TABLE `mate_hall` (
  `role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色Id',
  `type` smallint(2) unsigned NOT NULL DEFAULT '0' COMMENT '发布类型##1普通发布|2置顶发布',
  `declaration` varchar(1000) NOT NULL DEFAULT '[]' COMMENT '交友宣言',
  `time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  PRIMARY KEY (`role_id`),
  KEY time(`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='羁绊-交友大厅(合服保留)';