###############################################################################
# guestBook.sql                                                               #
# This SQL Script performs dynamic generation of guestBook database.          #
#                                                                             #
# Copyright (C) 2002 Mohammad Sahed                                           # 
#                                                                             #
# To run guestBook.sql download this file and then enter the following        #
# command in the command line:                                                # 
#                                                                             #
# shell> mysql < guestBook.sql -u userId -p                                   #
#                                                                             #
###############################################################################

create database guestBook;

\u guestBook;

CREATE TABLE guestBook (
id int(11) unsigned NOT NULL auto_increment,
name varchar(30) default NULL,
email varchar(40) default NULL,
url varchar(40) default NULL,
web varchar(30) default NULL,
comments text,
PRIMARY KEY (id)
) TYPE=MyISAM COMMENT='';

describe guestBook;