有什么好的mysql论坛_想找个好的数据库论坛?有吗?

满意答案

ljyydhlt

2014.10.23

采纳率：54%    等级：9

已帮助：865人

#

# Table structure for table forum_huati

#

#话题表

CREATE TABLE `forum_huati` (

`huatiid` int(4) NOT NULL AUTO_INCREMENT COMMENT '话题编号',

`formatid` int(4) NOT NULL DEFAULT '0' COMMENT '所属板块',

`huatititle` varchar(200) NOT NULL COMMENT '话题标题',

`centent` varchar(13568) NOT NULL COMMENT '话题内容',

`propeople` varchar(50) NOT NULL COMMENT '发布人',

`protime` datetime NOT NULL COMMENT '发布时间',

`updatetime` datetime DEFAULT NULL COMMENT '修改时间',

`lastpeople` varchar(200) DEFAULT NULL COMMENT '最后回复人',

`count` int(4) NOT NULL DEFAULT '0' COMMENT '回复数量',

`onclick` int(4) NOT NULL DEFAULT '0' COMMENT '点击数',

`typeid` int(4) DEFAULT NULL COMMENT '帖子类型编号',

`fileid` varchar(500) NOT NULL COMMENT '附件地址',

PRIMARY KEY (`huatiid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

select * from forum_huati

#回复表

CREATE TABLE `forum_huifu` (

`Id` int(4) NOT NULL AUTO_INCREMENT,

`huatiid` int(4) NOT NULL DEFAULT '0' COMMENT '回复编号',

`huifucentent` varchar(1024) NOT NULL COMMENT '回复内容',

`huifupeo` varchar(50) DEFAULT NULL COMMENT '回复人',

`huifutetime` datetime NOT NULL COMMENT '回复时间',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

select * from forum_huifu

#板块表

CREATE TABLE `forum_mat` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`matid` int(4) NOT NULL DEFAULT '0' COMMENT '板块编号',

`mattype` int(4) NOT NULL DEFAULT '0' COMMENT '上级板块编号',

`matvalue` varchar(100) NOT NULL COMMENT '板块格言',

`contOclick` int(4) NOT NULL DEFAULT '0' COMMENT '点击数量',

`count` int(4) NOT NULL DEFAULT '0' COMMENT '帖子总数',

`matname` varchar(100) NOT NULL COMMENT '板块名称',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

select * from forum_mat

#权限表

CREATE TABLE `forum_part` (

`Id` int(11) NOT NULL AUTO_INCREMENT,

`partid` int(4) NOT NULL DEFAULT '0' COMMENT '权限编号',

`partvalue` varchar(50) NOT NULL COMMENT '权限值',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

select * from forum_part

#

#注册表

CREATE TABLE `forum_regist` (

`Id` int(4) NOT NULL AUTO_INCREMENT,

`username` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '用户帐号',

`userpwd` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '用户密码',

`email` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户Email',

`nicheng` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户昵称',

`jisfen` int(4) NOT NULL DEFAULT '5' COMMENT '积分',

`userimg` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '用户头像地址',

`sex` varchar(2) COLLATE utf8_bin DEFAULT NULL COMMENT '用户性别',

`age` int(4) DEFAULT NULL COMMENT '用户年龄',

`birthday` datetime DEFAULT NULL COMMENT '出生日期',

`tel` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '联系方式',

`qq` int(4) DEFAULT NULL COMMENT 'qq号',

`msn` int(4) DEFAULT NULL COMMENT 'msn号',

`page` varchar(225) COLLATE utf8_bin DEFAULT NULL COMMENT '个人主页',

`partid` int(4) NOT NULL DEFAULT '0' COMMENT '角色编号',

`beizhu` text COLLATE utf8_bin COMMENT '备注',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

select * from forum_regist

#帖子类型表

CREATE TABLE `forum_type` (

`Id` int(4) NOT NULL AUTO_INCREMENT,

`typeid` int(4) NOT NULL DEFAULT '0' COMMENT '帖子类型编号',

`typevalue` varchar(50) NOT NULL COMMENT '帖子类型值',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

select * from forum_type

CREATE TABLE `forum_mail` (

`Id` int(4) NOT NULL AUTO_INCREMENT,

`title` varchar(50) NOT NULL COMMENT '消息标题',

`count` varchar(1024) NOT NULL COMMENT '消息内容',

`awaypeo` varchar(500) NOT NULL COMMENT '发件人',

`overpeo` varchar(500) NOT NULL COMMENT '收件人',

`awayday` datetime DEFAULT NULL COMMENT '发送日期',

`biaoji` int(4) DEFAULT NULL COMMENT '标记',

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

00分享举报