Perl Guestbook

###################################################################################################
# Jon Sagara's Perl/MySQL Guestbook
#
# gb.sql - Table for creating the guestbook table, perl_gb.
#
# Copyright � 2002 Jon Sagara.  All rights reserved.
#
# This code may be used and modified in any way you desire. This file may be redistributed 
# unmodified by any means PROVIDING it is not sold for profit without the authors written consent, 
# and providing that this notice and the author's name and all copyright notices remains intact. 
#
# An email letting me know how you are using it would be nice as well. 
#
# This file is provided "as is" with no expressed or implied warranty. The author accepts no 
# liability for any damage/loss of business that this product may cause.
#
# Author:	Jon Sagara
# Web:		http://www.sagara.org/perlgb/
# Email:	http://www.sagara.org/contact.php
###################################################################################################


#
# Table structure for table `perl_gb`
#

drop table if exists perl_gb;
CREATE TABLE perl_gb (
  message_id int(10) unsigned NOT NULL auto_increment,
  post_date timestamp(14) NOT NULL,
  first_name varchar(15) NOT NULL default '',
  last_name varchar(20) NOT NULL default '',
  city varchar(20) default NULL,
  state varchar(18) default NULL,
  country varchar(25) default NULL,
  email_addr varchar(50) NOT NULL default '',
  url varchar(75) default NULL,
  ip_address char(15) DEFAULT NULL,
  comments text NOT NULL,
  PRIMARY KEY  (message_id)
) TYPE=MyISAM COMMENT='perl_gb';