messageboard_backup.sql

php开发实例完全剖析

/* 
SQLyog v3.71
Host - localhost : Database - messageboard
**************************************************************
Server version 4.1.7-nt
*/

create database if not exists `messageboard`;

use `messageboard`;

/*
Table structure for guestbook
*/

drop table if exists `guestbook`;
CREATE TABLE `guestbook` (
  `MesID` int(6) NOT NULL auto_increment,
  `username` varchar(20) default NULL,
  `password` varchar(50) default NULL,
  `gender` varchar(10) default NULL,
  `email` varchar(50) default NULL,
  `title` varchar(50) default NULL,
  `content` text,
  `posttime` datetime default NULL,
  `ip` varchar(20) default NULL,
  `hideIP` char(2) default NULL,
  `firstMesID` int(6) default NULL,
  `lastMesID` int(6) default NULL,
  PRIMARY KEY  (`MesID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*
Table data for messageboard.guestbook
*/

INSERT INTO `guestbook` VALUES 
(9,'sd','sd','帅哥','s@k.r','测试','Good！		  OK！		  这是留言测试！				','2005-01-02 14:01:52','127.0.0.1','Y',9,NULL),
(12,'sd','6226f7cbe59e99a90b5cef6f94f966fd','不告诉你','sd@t.k','测试','这是留言测试','2005-01-02 15:58:53','127.0.0.1','Y',12,NULL),
(15,'hai','42810cb02db3bb2cbb428af0d8b0376e','不告诉你','hai@t.r','[回复]测试','Good!		\r\n	\r\n		\r\n－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－\r\n   原主题：\r\n	  这是留言测试','2005-01-02 20:50:24','127.0.0.1','',12,12),
(16,'hai','42810cb02db3bb2cbb428af0d8b0376e','不告诉你','hai@t.r','[回复]测试','Good!		\r\n	\r\n		\r\n－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－\r\n   原主题：\r\n	  这是留言测试','2005-01-02 20:52:50','127.0.0.1','',12,12),
(21,'王刚','e08392bb89dedb8ed6fb298f8e729c15','不告诉你','[e-mail]','为印度洋海啸受灾地区捐款','为印度洋海啸受灾地区捐款，奉献爱心！','2005-01-03 11:29:14','127.0.0.1','',21,NULL);