

#
# Table structure for table 'book_ban'
#

CREATE TABLE book_ban (
  ban_ip varchar(15) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table 'book_ban'
#

INSERT INTO book_ban VALUES ('123.123.123.123');

#
# Table structure for table 'book_com'
#

CREATE TABLE book_com (
  com_id int(11) NOT NULL auto_increment,
  id int(11) NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  comments text NOT NULL,
  host varchar(60) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (com_id)
) TYPE=MyISAM;

#
# Table structure for table 'book_data'
#

CREATE TABLE book_data (
  id int(11) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  gender char(1) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  url varchar(70) NOT NULL default '',
  date int(11) NOT NULL default '0',
  location varchar(50) NOT NULL default '',
  host varchar(60) NOT NULL default '',
  browser varchar(70) NOT NULL default '',
  comment text NOT NULL,
  image varchar(25) NOT NULL default '',
  icq int(11) NOT NULL default '0',
  aim varchar(70) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'book_data'
#


#
# Table structure for table 'book_ip'
#

CREATE TABLE book_ip (
  guest_ip varchar(15) NOT NULL default '',
  timestamp int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table 'book_ip'
#


#
# Table structure for table 'book_private'
#

CREATE TABLE book_private (
  id int(11) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  gender char(1) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  url varchar(70) NOT NULL default '',
  date int(11) NOT NULL default '0',
  location varchar(50) NOT NULL default '',
  host varchar(60) NOT NULL default '',
  browser varchar(70) NOT NULL default '',
  comment text NOT NULL,
  image varchar(25) NOT NULL default '',
  icq int(11) NOT NULL default '0',
  aim varchar(70) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'book_private'
#


#
# Table structure for table 'book_smilies'
#

CREATE TABLE book_smilies (
  id int(11) NOT NULL auto_increment,
  s_code varchar(20) NOT NULL default '',
  s_filename varchar(60) NOT NULL default '',
  s_emotion varchar(60) NOT NULL default '',
  width smallint(6) NOT NULL default '0',
  height smallint(6) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table 'book_smilies'
#

INSERT INTO book_smilies VALUES (1,':-)','a1.gif','smile',15,15);
INSERT INTO book_smilies VALUES (2,':-(','a2.gif','frown',15,15);
INSERT INTO book_smilies VALUES (3,';-)','a3.gif','wink',15,15);
INSERT INTO book_smilies VALUES (4,':o','a4.gif','embarrassment',15,15);
INSERT INTO book_smilies VALUES (5,':D','a5.gif','big grin',15,15);
INSERT INTO book_smilies VALUES (6,':p','a6.gif','razz (stick out tongue)',15,15);
INSERT INTO book_smilies VALUES (7,':cool:','a7.gif','cool',21,15);
INSERT INTO book_smilies VALUES (8,':rolleyes:','a8.gif','roll eyes (sarcastic)',15,15);
INSERT INTO book_smilies VALUES (9,':mad:','a9.gif','#@*%!',15,15);
INSERT INTO book_smilies VALUES (10,':eek:','a10.gif','eek!',15,15);
INSERT INTO book_smilies VALUES (11,':confused:','a11.gif','confused',15,22);

#
# Table structure for table 'book_words'
#

CREATE TABLE book_words (
  word varchar(30) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table 'book_words'
#

INSERT INTO book_words VALUES ('fuck');

