谁能给我一个论坛的数据库！！！神啊！！

简单一点的就行..建表语句（T-SQL）的。谢谢！！

# # 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;

这周结束我们的数据字典会出来,到时候给q你.

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息