tb_admin 管理员表
CREATE TABLE `tb_admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`manager` varchar(20) CHARACTER SET gb2312 NOT NULL,
`password` varchar(50) CHARACTER SET gb2312 NOT NULL,
`lastIP` varchar(20) CHARACTER SET gb2312 NOT NULL,
`lasttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`freeze` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=latin1
tb_article 博客文章列表
CREATE TABLE `tb_article` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`typename` varchar(20) CHARACTER SET gb2312 NOT NULL,
`title` varchar(50) CHARACTER SET gb2312 NOT NULL,
`content` mediumtext CHARACTER SET gb2312 NOT NULL,
`author` varchar(50) CHARACTER SET gb2312 NOT NULL,
`firsttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`artquote` varchar(300) CHARACTER SET gb2312 NOT NULL,
`hitnum` int(4) NOT NULL,
`renum` int(4) NOT NULL,
`examine` int(1) NOT NULL,
`isnominate` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1
tb_frd 用户好友信息表
CREATE TABLE `tb_frd` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`frdname` varchar(100) CHARACTER SET gb2312 NOT NULL,
`frdmem` varchar(100) CHARACTER SET gb2312 NOT NULL,
`frdlevel` int(11) NOT NULL,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1
tb_log 文章日志信息表
tb_member 用户信息数据表
CREATE TABLE `tb_member` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET gb2312 NOT NULL,
`pwd` varchar(50) CHARACTER SET gb2312 NOT NULL,
`question` varchar(50) CHARACTER SET gb2312 NOT NULL,
`answer` varchar(50) CHARACTER SET gb2312 NOT NULL,
`email` varchar(50) CHARACTER SET gb2312 NOT NULL,
`realname` varchar(50) CHARACTER SET gb2312 NOT NULL,
`sex` varchar(1) CHARACTER SET gb2312 NOT NULL,
`birthday` date NOT NULL DEFAULT '2008-06-12',
`tel` varchar(20) CHARACTER SET gb2312 NOT NULL,
`address` varchar(200) CHARACTER SET gb2312 NOT NULL,
`homepage` varchar(200) CHARACTER SET gb2312 NOT NULL,
`qq` varchar(10) CHARACTER SET gb2312 NOT NULL,
`unwrite` varchar(200) CHARACTER SET gb2312 NOT NULL,
`headgif` varchar(200) CHARACTER SET gb2312 NOT NULL,
`hitnum` int(4) NOT NULL,
`upfile` int(4) NOT NULL,
`uppics` int(4) NOT NULL,
`lasttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`freeze` int(1) NOT NULL,
`blogname` varchar(100) CHARACTER SET gb2312 NOT NULL,
`blogurl` varchar(200) CHARACTER SET gb2312 NOT NULL,
`arttype` varchar(300) CHARACTER SET gb2312 NOT NULL,
`pictype` varchar(300) CHARACTER SET gb2312 NOT NULL,
`isnew` int(1) NOT NULL DEFAULT '0',
`isnominate` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1
CREATE TABLE `tb_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(200) CHARACTER SET gb2312 NOT NULL,
`operator` varchar(50) CHARACTER SET gb2312 NOT NULL,
`uptime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=348 DEFAULT CHARSET=latin1
tb_mess 用户留言数据表
CREATE TABLE `tb_mess` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`messer` varchar(100) CHARACTER SET gb2312 NOT NULL,
`content` varchar(300) CHARACTER SET gb2312 NOT NULL,
`messered` varchar(100) CHARACTER SET gb2312 NOT NULL,
`messtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1
tb_review 文章评论表
CREATE TABLE `tb_review` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`artid` int(4) NOT NULL,
`content` varchar(300) CHARACTER SET gb2312 NOT NULL,
`man` varchar(100) CHARACTER SET gb2312 NOT NULL,
`firsttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1
tb_script 小纸条列表
CREATE TABLE `tb_script` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accept` varchar(100) CHARACTER SET gb2312 NOT NULL,
`sender` varchar(100) CHARACTER SET gb2312 NOT NULL,
`content` varchar(300) CHARACTER SET gb2312 NOT NULL,
`isnew` int(1) NOT NULL,
`sendtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
tb_uppics 上传图片信息表
CREATE TABLE `tb_uppics` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`picname` varchar(50) CHARACTER SET gb2312 NOT NULL,
`picpath` varchar(100) CHARACTER SET gb2312 NOT NULL,
`upauthor` varchar(100) CHARACTER SET gb2312 NOT NULL,
`pictype` varchar(50) CHARACTER SET gb2312 NOT NULL,
`hitnum` int(4) NOT NULL,
`examine` int(1) NOT NULL,
`uptime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1