数据库设计:
DROP DATABASE IF EXISTS Messageboard;
CREATE DATABASE Messageboard;
USE MessageBoard;
CREATE TABLE guestbook(
MesID INT(6) NOT NULL AUTO_INCREMENT,
username VARCHAR(20),
pwd VARCHAR(50),
gender VARCHAR(10),
email VARCHAR(50),
title VARCHAR(50),
content TEXT,
posttime DATETIME,
ip VARCHAR(20),
hideIP CHAR(2),
firstMesID INT(6),
lastMesID INT(6),
PRIMARY KEY(MesID)
)
其他的待续