You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
9 lines
488 B
9 lines
488 B
-- 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='羁绊-交友大厅(合服保留)';
|