#
# Table structure for table `forum_post`
#

CREATE TABLE `forum_post` (
`post_id` int(10) NOT NULL auto_increment,
`topic_id` int(10) NOT NULL default '0',
`poster` varchar(50) NOT NULL default '',
`post_time` varchar(20) default NULL,
`email` varchar(75) NOT NULL default '',
`web` varchar(75) NOT NULL default '',
PRIMARY KEY (`post_id`),
KEY `post_id` (`post_id`),
KEY `topic_id` (`topic_id`),
KEY `poster_id` (`poster`)
) TYPE=MyISAM AUTO_INCREMENT=1071 ;
# --------------------------------------------------------

#
# Table structure for table `forum_postext`
#

CREATE TABLE `forum_postext` (
`post_id` int(10) NOT NULL default '0',
`post_text` text,
PRIMARY KEY (`post_id`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `forum_smile`
#

CREATE TABLE `forum_smile` (
`id` int(10) NOT NULL auto_increment,
`code` varchar(50) default NULL,
`smile_url` varchar(100) default NULL,
`emotion` varchar(75) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=32 ;
# --------------------------------------------------------

#
# Table structure for table `forum_topic`
#

CREATE TABLE `forum_topic` (
`topic_id` int(10) NOT NULL auto_increment,
`topic_title` varchar(100) default NULL,
`topic_poster` varchar(50) NOT NULL default '',
`topic_time` varchar(20) default NULL,
`topic_views` int(10) NOT NULL default '0',
`topic_replies` int(10) NOT NULL default '0',
`topic_last_post_id` int(10) NOT NULL default '0',
PRIMARY KEY (`topic_id`),
KEY `topic_id` (`topic_id`),
KEY `topic_last_post_id` (`topic_last_post_id`)
) TYPE=MyISAM AUTO_INCREMENT=191 ;


INSERT INTO forum_smile VALUES("1", "", "icon_biggrin.gif", "Very Happy");
INSERT INTO forum_smile VALUES("2", ":-D", "icon_biggrin.gif", "Very Happy");
INSERT INTO forum_smile VALUES("3", ":grin:", "icon_biggrin.gif", "Very Happy");
INSERT INTO forum_smile VALUES("4", "", "icon_smile.gif", "Smile");
INSERT INTO forum_smile VALUES("5", ":-)", "icon_smile.gif", "Smile");
INSERT INTO forum_smile VALUES("6", ":smile:", "icon_smile.gif", "Smile");
INSERT INTO forum_smile VALUES("7", "", "icon_frown.gif", "Sad");
INSERT INTO forum_smile VALUES("8", ":-(", "icon_frown.gif", "Sad");
INSERT INTO forum_smile VALUES("9", ":sad:", "icon_frown.gif", "Sad");
INSERT INTO forum_smile VALUES("10", "", "icon_eek.gif", "Surprised");
INSERT INTO forum_smile VALUES("11", ":-o", "icon_eek.gif", "Surprised");
INSERT INTO forum_smile VALUES("12", "", "icon_eek.gif", "Suprised");
INSERT INTO forum_smile VALUES("13", ":-?", "icon_confused.gif", "Confused");
INSERT INTO forum_smile VALUES("14", ":???:", "icon_confused.gif", "Confused");
INSERT INTO forum_smile VALUES("15", "8)", "icon_cool.gif", "Cool");
INSERT INTO forum_smile VALUES("16", "8-)", "icon_cool.gif", "Cool");
INSERT INTO forum_smile VALUES("17", "", "icon_cool.gif", "Cool");
INSERT INTO forum_smile VALUES("18", ":lol:", "icon_lol.gif", "Laughing");
INSERT INTO forum_smile VALUES("19", ":x", "icon_mad.gif", "Mad");
INSERT INTO forum_smile VALUES("20", ":-x", "icon_mad.gif", "Mad");
INSERT INTO forum_smile VALUES("21", "", "icon_mad.gif", "Mad");
INSERT INTO forum_smile VALUES("22", ":P", "icon_razz.gif", "Razz");
INSERT INTO forum_smile VALUES("23", ":-P", "icon_razz.gif", "Razz");
INSERT INTO forum_smile VALUES("24", ":razz:", "icon_razz.gif", "Razz");
INSERT INTO forum_smile VALUES("25", "ops:", "icon_redface.gif", "Embaressed");
INSERT INTO forum_smile VALUES("26", "", "icon_cry.gif", "Crying (very sad)");
INSERT INTO forum_smile VALUES("27", ":evil:", "icon_evil.gif", "Evil or Very Mad");
INSERT INTO forum_smile VALUES("28", ":roll:", "icon_rolleyes.gif", "Rolling Eyes");
INSERT INTO forum_smile VALUES("29", ":wink:", "icon_wink.gif", "Wink");
INSERT INTO forum_smile VALUES("30", "", "icon_wink.gif", "Wink");
INSERT INTO forum_smile VALUES("31", ";-)", "icon_wink.gif", "Wink");