#
# Table structure for table `{$db_prefix}art_sections`
#

CREATE TABLE `{$db_prefix}art_sections` (
  `ID_SECTION` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `banner` text NOT NULL,
  `memberGroups` text NOT NULL,
  `position` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID_SECTION`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}articles`
#

CREATE TABLE `{$db_prefix}articles` (
  `ID_ARTICLE` int(11) NOT NULL auto_increment,
  `ID_SECTION` int(11) NOT NULL default '0',
  `stage` tinyint(2) NOT NULL default '0',
  `heading` text NOT NULL,
  `sub_heading` text,
  `summary` text NOT NULL,
  `story` text NOT NULL,
  `ID_POSTER` int(11) NOT NULL default '-1',
  `byline` tinytext,
  `posterEmail` tinytext,
  `ID_REVIEWER` int(11) NOT NULL default '0',
  `dateEntered` bigint(20) NOT NULL default '0',
  `dateModified` bigint(20) default NULL,
  `yabbce` tinyint(2) NOT NULL default '0',
  `publish` tinyint(2) NOT NULL default '0',
  `featureFlag` tinyint(2) NOT NULL default '0',
  `reviewFlag` tinyint(2) NOT NULL default '0',
  `comment` text,
  PRIMARY KEY  (`ID_ARTICLE`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}banned`
#

CREATE TABLE `{$db_prefix}banned` (
  `type` tinytext NOT NULL,
  `value` tinytext NOT NULL
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}banned`
#

INSERT INTO `{$db_prefix}banned` VALUES ('ip', '');
INSERT INTO `{$db_prefix}banned` VALUES ('email', '');
INSERT INTO `{$db_prefix}banned` VALUES ('username', '');
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}blocks`
#

CREATE TABLE `{$db_prefix}blocks` (
  `id` int(11) NOT NULL auto_increment,
  `border` tinyint(11) NOT NULL default '0',
  `name` text NOT NULL,
  `contents` text NOT NULL,
  `allowance` text NOT NULL,
  `visible` text NOT NULL,
  `side` tinytext NOT NULL,
  `type` mediumtext NOT NULL,
  `tbg` varchar(12) NOT NULL default '',
  `bg` varchar(12) NOT NULL default '',
  `tbgi` varchar(200) NOT NULL default '',
  `bgi` varchar(200) NOT NULL default '',
  `frontOnly` tinyint(1) NOT NULL default '0',
  `phpe` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}blocks`
#

INSERT INTO `{$db_prefix}blocks` VALUES (14, 2, 'Site Statistics', '', '0', 'all', 'right', 'sitestats', '', '', '', '', 0, 0);
INSERT INTO `{$db_prefix}blocks` VALUES (8, 2, 'login', '', '-1', 'all', 'left', 'login', '', '', '', '', 0, 0);
INSERT INTO `{$db_prefix}blocks` VALUES (17, 1, 'Online', '', '0', 'all', 'left', 'uonline', '', '', '', '', 0, 0);
INSERT INTO `{$db_prefix}blocks` VALUES (22, 0, 'Menu', '<yabb menu2>', '0', 'all', 'left', 'custom', '', '', '', '', 0, 0);
INSERT INTO `{$db_prefix}blocks` VALUES (28, 0, 'Top News', '', '0', 'all', 'right', 'headlines', '', '', '', '', 0, 0);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}boards`
#

CREATE TABLE `{$db_prefix}boards` (
  `ID_CAT` tinyint(4) NOT NULL default '0',
  `ID_BOARD` int(11) NOT NULL auto_increment,
  `name` tinytext NOT NULL,
  `description` text,
  `moderators` text,
  `boardOrder` tinyint(4) NOT NULL default '0',
  `numTopics` int(11) NOT NULL default '0',
  `numPosts` int(11) NOT NULL default '0',
  `isAnnouncement` tinyint(4) NOT NULL default '0',
  `notifyAnnouncements` tinyint(4) NOT NULL default '0',
  `count` tinyint(4) NOT NULL default '0',
  `ID_LAST_TOPIC` int(11) default NULL,
  PRIMARY KEY  (`ID_BOARD`),
  KEY `ID_CAT` (`ID_CAT`),
  KEY `boardOrder` (`boardOrder`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}boards`
#

INSERT INTO `{$db_prefix}boards` VALUES (1, 1, 'Chit Chat', 'Anything and everything allowed here', '', 0, 1, 1, 0, 0, 0, 2);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}calendar`
#

CREATE TABLE `{$db_prefix}calendar` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_board` int(10) unsigned NOT NULL default '0',
  `id_topic` int(10) unsigned NOT NULL default '0',
  `title` char(30) NOT NULL default '',
  `id_member` int(10) unsigned NOT NULL default '0',
  `month` tinyint(4) NOT NULL default '0',
  `day` tinyint(4) NOT NULL default '0',
  `year` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `idx_year_month` (`year`,`month`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}calendar_holiday`
#

CREATE TABLE `{$db_prefix}calendar_holiday` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` char(30) NOT NULL default '',
  `month` tinyint(4) NOT NULL default '0',
  `day` tinyint(4) NOT NULL default '0',
  `year` smallint(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_month` (`month`),
  KEY `idx_year` (`year`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}calendar_holiday`
#

INSERT INTO `{$db_prefix}calendar_holiday` VALUES (1, 'New Years', 1, 1, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (2, 'Christmas', 12, 25, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (3, 'Independence Day', 7, 4, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (4, 'Cinco de Mayo', 5, 5, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (5, 'Flag Day', 6, 14, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (6, 'Veterans Day', 11, 11, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (7, 'Groundhog Day', 2, 2, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (8, 'Valentine\'s Day', 2, 14, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (9, 'St. Patrick\'s Day', 3, 17, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (10, 'April Fools', 4, 1, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (11, 'Earth Day', 4, 22, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (12, 'United Nations Day', 10, 24, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (13, 'Halloween', 10, 31, NULL);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (14, 'Thanksgiving', 11, 28, 2002);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (15, 'Thanksgiving', 11, 27, 2003);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (16, 'Thanksgiving', 11, 25, 2004);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (17, 'Thanksgiving', 11, 24, 2005);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (18, 'Thanksgiving', 11, 23, 2006);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (19, 'Thanksgiving', 11, 22, 2007);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (20, 'Thanksgiving', 11, 27, 2008);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (21, 'Thanksgiving', 11, 26, 2009);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (22, 'Thanksgiving', 11, 25, 2010);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (23, 'Memorial Day', 5, 27, 2002);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (24, 'Memorial Day', 5, 26, 2003);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (25, 'Memorial Day', 5, 31, 2004);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (26, 'Memorial Day', 5, 30, 2005);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (27, 'Memorial Day', 5, 29, 2006);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (28, 'Memorial Day', 5, 28, 2007);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (29, 'Memorial Day', 5, 26, 2008);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (30, 'Memorial Day', 5, 25, 2009);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (31, 'Memorial Day', 5, 31, 2010);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (32, 'Mother\'s Day', 5, 12, 2002);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (33, 'Mother\'s Day', 5, 11, 2003);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (34, 'Mother\'s Day', 5, 9, 2004);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (35, 'Mother\'s Day', 5, 8, 2005);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (36, 'Mother\'s Day', 5, 14, 2006);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (37, 'Mother\'s Day', 5, 13, 2007);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (38, 'Mother\'s Day', 5, 11, 2008);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (39, 'Mother\'s Day', 5, 10, 2009);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (40, 'Mother\'s Day', 5, 9, 2010);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (41, 'Father\'s Day', 6, 16, 2002);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (42, 'Father\'s Day', 6, 15, 2003);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (43, 'Father\'s Day', 6, 20, 2004);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (44, 'Father\'s Day', 6, 19, 2005);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (45, 'Father\'s Day', 6, 18, 2006);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (46, 'Father\'s Day', 6, 17, 2007);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (47, 'Father\'s Day', 6, 15, 2008);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (48, 'Father\'s Day', 6, 21, 2009);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (49, 'Father\'s Day', 6, 20, 2010);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (50, 'Labor Day', 9, 2, 2002);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (51, 'Labor Day', 9, 1, 2003);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (52, 'Labor Day', 9, 6, 2004);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (53, 'Labor Day', 9, 5, 2005);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (54, 'Labor Day', 9, 4, 2006);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (55, 'Labor Day', 9, 3, 2007);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (56, 'Labor Day', 9, 1, 2008);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (57, 'Labor Day', 9, 7, 2009);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (58, 'Labor Day', 9, 6, 2010);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (59, 'Summer Solstice', 6, 21, 2002);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (60, 'Summer Solstice', 6, 21, 2003);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (61, 'Summer Solstice', 6, 20, 2004);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (62, 'Summer Solstice', 6, 20, 2005);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (63, 'Summer Solstice', 6, 21, 2006);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (64, 'Summer Solstice', 6, 21, 2007);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (65, 'Summer Solstice', 6, 20, 2008);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (66, 'Summer Solstice', 6, 20, 2009);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (67, 'Summer Solstice', 6, 21, 2010);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (68, 'Vernal Equinox', 3, 20, 2002);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (69, 'Vernal Equinox', 3, 20, 2003);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (70, 'Vernal Equinox', 3, 19, 2004);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (71, 'Vernal Equinox', 3, 20, 2005);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (72, 'Vernal Equinox', 3, 20, 2006);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (73, 'Vernal Equinox', 3, 20, 2007);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (74, 'Vernal Equinox', 3, 19, 2008);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (75, 'Vernal Equinox', 3, 20, 2009);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (76, 'Vernal Equinox', 3, 20, 2010);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (77, 'Winter Solstice', 12, 21, 2002);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (78, 'Winter Solstice', 12, 21, 2003);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (79, 'Winter Solstice', 12, 21, 2004);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (80, 'Winter Solstice', 12, 21, 2005);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (81, 'Winter Solstice', 12, 21, 2006);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (82, 'Winter Solstice', 12, 21, 2007);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (83, 'Winter Solstice', 12, 21, 2008);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (84, 'Winter Solstice', 12, 21, 2009);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (85, 'Winter Solstice', 12, 21, 2010);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (86, 'Autumnal Equinox', 9, 22, 2002);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (87, 'Autumnal Equinox', 9, 23, 2003);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (88, 'Autumnal Equinox', 9, 22, 2004);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (89, 'Autumnal Equinox', 9, 22, 2005);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (90, 'Autumnal Equinox', 9, 22, 2006);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (91, 'Autumnal Equinox', 9, 23, 2007);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (92, 'Autumnal Equinox', 9, 22, 2008);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (93, 'Autumnal Equinox', 9, 22, 2009);
INSERT INTO `{$db_prefix}calendar_holiday` VALUES (94, 'Autumnal Equinox', 9, 22, 2010);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}categories`
#

CREATE TABLE `{$db_prefix}categories` (
  `ID_CAT` tinyint(4) NOT NULL auto_increment,
  `name` tinytext NOT NULL,
  `memberGroups` text,
  `catOrder` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ID_CAT`),
  KEY `catOrder` (`catOrder`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}categories`
#

INSERT INTO `{$db_prefix}categories` VALUES (1, 'General', '', 0);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}censor`
#

CREATE TABLE `{$db_prefix}censor` (
  `vulgar` tinytext,
  `proper` tinytext
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}download_cats`
#

CREATE TABLE `{$db_prefix}download_cats` (
  `id` int(11) NOT NULL auto_increment,
  `name` mediumtext NOT NULL,
  `description` text NOT NULL,
  `isSub` tinyint(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}download_items`
#

CREATE TABLE `{$db_prefix}download_items` (
  `id` int(11) NOT NULL auto_increment,
  `cat` tinyint(11) NOT NULL default '0',
  `name` mediumtext NOT NULL,
  `ddesc` text NOT NULL,
  `filename` text NOT NULL,
  `author_name` text NOT NULL,
  `author_email` text NOT NULL,
  `filesize` int(255) NOT NULL default '0',
  `downloads` int(255) NOT NULL default '0',
  `website` text NOT NULL,
  `website_title` text NOT NULL,
  `date` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}faqanswer`
#

CREATE TABLE `{$db_prefix}faqanswer` (
  `id` tinyint(4) NOT NULL auto_increment,
  `id_cat` tinyint(4) default NULL,
  `question` varchar(255) default NULL,
  `answer` text,
  PRIMARY KEY  (`id`),
  KEY `idxfaqansweridcat` (`id_cat`),
  KEY `idxfaqanswerididcat` (`id`,`id_cat`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}faqcategories`
#

CREATE TABLE `{$db_prefix}faqcategories` (
  `id_cat` tinyint(3) NOT NULL auto_increment,
  `categories` varchar(255) default NULL,
  PRIMARY KEY  (`id_cat`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}faqcategories`
#

INSERT INTO `{$db_prefix}faqcategories` VALUES (1, 'About this site');
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}guestbook`
#

CREATE TABLE `{$db_prefix}guestbook` (
  `id` int(11) NOT NULL auto_increment,
  `guestName` tinytext,
  `emailaddress` tinytext,
  `signtime` bigint(20) default NULL,
  `body` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}instant_messages`
#

CREATE TABLE `{$db_prefix}instant_messages` (
  `ID_IM` bigint(20) NOT NULL auto_increment,
  `ID_MEMBER_FROM` int(11) NOT NULL default '0',
  `ID_MEMBER_TO` int(11) NOT NULL default '0',
  `deletedBy` int(11) NOT NULL default '-1',
  `fromName` tinytext NOT NULL,
  `toName` tinytext NOT NULL,
  `msgtime` bigint(20) default NULL,
  `subject` tinytext,
  `body` text,
  `readBy` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ID_IM`),
  KEY `ID_MEMBER_FROM` (`ID_MEMBER_FROM`),
  KEY `ID_MEMBER_TO` (`ID_MEMBER_TO`),
  KEY `deletedBy` (`deletedBy`),
  KEY `msgtime` (`msgtime`),
  KEY `readBy` (`readBy`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}links_cats`
#

CREATE TABLE `{$db_prefix}links_cats` (
  `catID` mediumint(9) NOT NULL auto_increment,
  `name` tinytext NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`catID`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}links_items`
#

CREATE TABLE `{$db_prefix}links_items` (
  `linkID` mediumint(9) unsigned NOT NULL auto_increment,
  `catID` mediumint(9) unsigned NOT NULL default '0',
  `name` tinytext NOT NULL,
  `linkURL` tinytext NOT NULL,
  `description` text NOT NULL,
  `ID_SUBMITTER` int(11) NOT NULL default '-1',
  `ID_REVIEWER` int(11) default NULL,
  `dateEntered` bigint(20) NOT NULL default '0',
  `dateModified` bigint(20) default NULL,
  `submitterEmail` tinytext NOT NULL,
  `submittedBy` tinytext NOT NULL,
  `clicks` mediumint(9) unsigned NOT NULL default '0',
  `stage` tinyint(2) NOT NULL default '0',
  `reviewFlag` tinyint(2) NOT NULL default '1',
  `comment` text,
  PRIMARY KEY  (`linkID`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}log_activity`
#

CREATE TABLE `{$db_prefix}log_activity` (
  `month` tinyint(4) NOT NULL default '0',
  `day` tinyint(4) NOT NULL default '0',
  `year` mediumint(9) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `topics` int(11) NOT NULL default '0',
  `posts` int(11) NOT NULL default '0',
  `registers` int(11) NOT NULL default '0',
  `mostOn` int(11) NOT NULL default '0',
  PRIMARY KEY  (`month`,`day`,`year`),
  KEY `hits` (`hits`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}log_banned`
#

CREATE TABLE `{$db_prefix}log_banned` (
  `ip` tinytext,
  `email` tinytext,
  `logTime` bigint(20) default NULL
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}log_boards`
#

CREATE TABLE `{$db_prefix}log_boards` (
  `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
  `ID_BOARD` smallint(5) unsigned NOT NULL default '0',
  `logTime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID_BOARD`,`ID_MEMBER`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}log_boards`
#

INSERT INTO `{$db_prefix}log_boards` VALUES (1, 1, 1062179813);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}log_clicks`
#

CREATE TABLE `{$db_prefix}log_clicks` (
  `ip` tinytext,
  `logTime` bigint(20) NOT NULL default '0',
  `agent` tinytext,
  `toUrl` tinytext,
  `fromUrl` tinytext,
  KEY `logTime` (`logTime`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}log_errors`
#

CREATE TABLE `{$db_prefix}log_errors` (
  `ID_ERROR` smallint(5) unsigned NOT NULL auto_increment,
  `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
  `logTime` int(10) unsigned NOT NULL default '0',
  `IP` tinytext NOT NULL,
  `url` text NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY  (`ID_ERROR`),
  KEY `logTime` (`logTime`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}log_floodcontrol`
#

CREATE TABLE `{$db_prefix}log_floodcontrol` (
  `ip` tinytext NOT NULL,
  `logTime` bigint(20) default NULL,
  PRIMARY KEY  (`ip`(16))
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}log_karma`
#

CREATE TABLE `{$db_prefix}log_karma` (
  `ID_TARGET` int(11) NOT NULL default '0',
  `ID_EXECUTOR` int(11) NOT NULL default '0',
  `action` tinytext NOT NULL,
  `logTime` bigint(20) NOT NULL default '0',
  KEY `ID_TARGET` (`ID_TARGET`),
  KEY `ID_EXECUTOR` (`ID_EXECUTOR`),
  KEY `logTime` (`logTime`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}log_mark_read`
#

CREATE TABLE `{$db_prefix}log_mark_read` (
  `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
  `ID_BOARD` smallint(5) unsigned NOT NULL default '0',
  `logTime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID_BOARD`,`ID_MEMBER`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}log_online`
#

CREATE TABLE `{$db_prefix}log_online` (
  `identity` int(11) unsigned NOT NULL default '0',
  `logTime` bigint(20) default NULL,
  PRIMARY KEY  (`identity`),
  KEY `logTime` (`logTime`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}log_online`
#

INSERT INTO `{$db_prefix}log_online` VALUES (1, 1062180211);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}log_topics`
#

CREATE TABLE `{$db_prefix}log_topics` (
  `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
  `ID_TOPIC` mediumint(8) unsigned NOT NULL default '0',
  `logTime` int(10) unsigned NOT NULL default '0',
  `notificationSent` tinyint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID_TOPIC`,`ID_MEMBER`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}membergroups`
#

CREATE TABLE `{$db_prefix}membergroups` (
  `ID_GROUP` int(11) NOT NULL auto_increment,
  `membergroup` tinytext NOT NULL,
  `grouptype` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ID_GROUP`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}membergroups`
#

INSERT INTO `{$db_prefix}membergroups` VALUES (1, 'Administrator', 0);
INSERT INTO `{$db_prefix}membergroups` VALUES (2, 'Moderator', 0);
INSERT INTO `{$db_prefix}membergroups` VALUES (3, 'Newbie', 0);
INSERT INTO `{$db_prefix}membergroups` VALUES (4, 'Jr. Member', 0);
INSERT INTO `{$db_prefix}membergroups` VALUES (5, 'Full Member', 0);
INSERT INTO `{$db_prefix}membergroups` VALUES (6, 'Sr. Member', 0);
INSERT INTO `{$db_prefix}membergroups` VALUES (7, 'YaBB God', 0);
INSERT INTO `{$db_prefix}membergroups` VALUES (8, 'Global Moderator', 0);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}members`
#

CREATE TABLE `{$db_prefix}members` (
  `ID_MEMBER` int(10) unsigned NOT NULL auto_increment,
  `memberName` varchar(80) NOT NULL default '',
  `realName` tinytext,
  `passwd` tinytext NOT NULL,
  `emailAddress` tinytext,
  `dateRegistered` bigint(20) default NULL,
  `personalText` tinytext,
  `memberGroup` tinytext,
  `gender` tinytext,
  `birthdate` date NOT NULL default '0000-00-00',
  `websiteTitle` tinytext,
  `websiteUrl` tinytext,
  `location` tinytext,
  `ICQ` tinytext,
  `AIM` tinytext,
  `YIM` tinytext,
  `hideEmail` tinyint(4) default NULL,
  `timeFormat` tinytext,
  `signature` text,
  `posts` int(11) default NULL,
  `timeOffset` float default NULL,
  `avatar` tinytext,
  `im_ignore_list` text,
  `im_email_notify` tinyint(4) NOT NULL default '0',
  `lastLogin` bigint(20) default NULL,
  `karmaBad` int(11) NOT NULL default '0',
  `karmaGood` int(11) NOT NULL default '0',
  `usertitle` tinytext,
  `lngfile` tinytext,
  `notifyAnnouncements` tinyint(4) NOT NULL default '1',
  `notifyOnce` tinyint(4) NOT NULL default '1',
  `MSN` tinytext,
  `memberIP` tinytext,
  `secretQuestion` tinytext NOT NULL,
  `secretAnswer` tinytext NOT NULL,
  `astatus` tinytext NOT NULL,
  `skin` text NOT NULL,
  PRIMARY KEY  (`ID_MEMBER`),
  KEY `memberName` (`memberName`(30)),
  KEY `dateRegistered` (`dateRegistered`),
  KEY `memberGroup` (`memberGroup`(30)),
  KEY `birthdate` (`birthdate`),
  KEY `posts` (`posts`),
  KEY `lastLogin` (`lastLogin`),
  KEY `lngfile` (`lngfile`(30))
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}menu`
#

CREATE TABLE `{$db_prefix}menu` (
  `id` int(11) NOT NULL auto_increment,
  `grpID` tinyint(11) NOT NULL default '1',
  `memberGroup` text NOT NULL,
  `img` text NOT NULL,
  `alt` text NOT NULL,
  `position` tinyint(11) NOT NULL default '0',
  `url` text NOT NULL,
  `imgfolder` text,
  `imgborder` tinyint(11) NOT NULL default '0',
  `imgwidth` tinytext,
  `imgheight` tinytext,
  `imgloc` tinyint(1) NOT NULL default '0',
  `urltarget` text,
  `special` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}menu`
#

INSERT INTO `{$db_prefix}menu` VALUES (1, 1, '0', 'home.gif', 'home', 0, 'index.php', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (2, 1, '0', 'forum.gif', 'forums', 2, 'index.php?op=forum', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (3, 1, '0', 'downloads.gif', 'downloads', 3, 'index.php?op=downloads', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (13, 1, '0', 'faq.gif', 'FAQ', 4, 'index.php?action=faq', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (5, 1, '0', 'search.gif', 'search', 6, 'index.php?action=search', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (6, 1, '1', 'admin.gif', 'admin', 5, 'index.php?op=admin', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (7, 1, '-2', 'profile.gif', 'profile', 8, '', '', 0, '', '', 0, '', 'profile');
INSERT INTO `{$db_prefix}menu` VALUES (9, 1, '-2', 'notification.gif', 'notifications', 9, 'index.php?action=shownotify', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (10, 1, '-1', 'login.gif', 'login', 10, 'index.php?action=login', '', 0, '', '', 0, '', 'login');
INSERT INTO `{$db_prefix}menu` VALUES (11, 1, '-1', 'register.gif', 'register', 11, 'index.php?action=register', '', 0, '', '', 0, '', 'register');
INSERT INTO `{$db_prefix}menu` VALUES (12, 1, '-2', 'logout.gif', 'logout', 10, '', '', 0, '', '', 0, '', 'logout');
INSERT INTO `{$db_prefix}menu` VALUES (24, 3, '0', '', 'news', 0, 'index.php', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (25, 3, '0', 'forum.gif', 'forums', 4, 'index.php?op=forum', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (26, 3, '0', 'downloads.gif', 'downloads', 2, 'index.php?op=downloads', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (27, 3, '0', 'faq.gif', 'FAQ', 3, 'index.php?action=faq', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (28, 3, '0', '', 'guestbook', 6, 'index.php?op=guestbook', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (30, 3, '0', '', 'submissions', 8, 'index.php?op=submit', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (33, 3, '0', '', 'calendar', 1, 'index.php?action=calendar', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (34, 3, '0', '', 'links', 7, 'index.php?op=links', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (36, 3, '0', '', 'News Index', 7, 'index.php?op=newsarchive', '', 0, '', '', 0, '', '');
INSERT INTO `{$db_prefix}menu` VALUES (37, 3, '0', '', 'Article Index', 7, 'index.php?op=artarchive', '', 0, '', '', 0, '', '');
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}menugrps`
#

CREATE TABLE `{$db_prefix}menugrps` (
  `grpID` tinyint(11) NOT NULL auto_increment,
  `menutype` tinyint(1) NOT NULL default '0',
  `itemsep` text,
  `tagname` text NOT NULL,
  `css` text,
  UNIQUE KEY `grpID` (`grpID`),
  FULLTEXT KEY `itemsep` (`itemsep`,`tagname`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}menugrps`
#

INSERT INTO `{$db_prefix}menugrps` VALUES (1, 0, '  ', 'menu', '');
INSERT INTO `{$db_prefix}menugrps` VALUES (3, 1, '<br />', 'menu2', '');
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}messages`
#

CREATE TABLE `{$db_prefix}messages` (
  `ID_MSG` int(11) NOT NULL auto_increment,
  `ID_TOPIC` int(11) NOT NULL default '0',
  `ID_MEMBER` int(11) NOT NULL default '0',
  `subject` tinytext,
  `posterName` tinytext NOT NULL,
  `posterEmail` tinytext,
  `posterTime` bigint(20) default NULL,
  `posterIP` tinytext NOT NULL,
  `smiliesEnabled` tinyint(4) NOT NULL default '1',
  `modifiedTime` bigint(20) default NULL,
  `modifiedName` tinytext,
  `body` text,
  `icon` tinytext,
  `attachmentSize` mediumint(9) NOT NULL default '0',
  `attachmentFilename` tinytext,
  PRIMARY KEY  (`ID_MSG`),
  KEY `ID_TOPIC` (`ID_TOPIC`),
  KEY `ID_MEMBER` (`ID_MEMBER`),
  KEY `posterTime` (`posterTime`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}messages`
#

INSERT INTO `{$db_prefix}messages` VALUES (2, 2, 1, 'Welcome!', 'Enigma Dev Team', 'admin@yourserver.com', 1062179813, '127.0.0.1', 1, NULL, NULL, 'Welcome to your new Enigma portal site. You may delete this message after you read it, but make sure to log in with the Admin account you set up during the installation, and use the Admin Center (link above) to customize your settings.<br /><br />Enigma Dev Team', 'xx', 0, NULL);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}news`
#

CREATE TABLE `{$db_prefix}news` (
  `ID_NEWS` int(11) NOT NULL auto_increment,
  `ID_CATEGORY` int(11) NOT NULL default '0',
  `ID_TOPIC` int(11) NOT NULL default '0',
  `ID_POSTER` int(11) NOT NULL default '0',
  `ID_REVIEWER` int(11) default NULL,
  `reviewFlag` tinyint(2) NOT NULL default '1',
  `featureFlag` tinyint(2) NOT NULL default '0',
  `stage` tinyint(4) NOT NULL default '0',
  `publish` tinyint(2) NOT NULL default '0',
  `comment` text,
  `dateEntered` bigint(20) default NULL,
  `dateModified` bigint(20) default NULL,
  PRIMARY KEY  (`ID_NEWS`),
  KEY `ID_TOPIC` (`ID_TOPIC`),
  KEY `ID_POSTER` (`ID_POSTER`),
  KEY `ID_CATEGORY` (`ID_CATEGORY`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}news`
#

INSERT INTO `{$db_prefix}news` VALUES (2, 0, 2, 1, NULL, 0, 1, 0, 0, NULL, 1062179813, NULL);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}news_categories`
#

CREATE TABLE `{$db_prefix}news_categories` (
  `ID_CATEGORY` tinyint(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `image` text NOT NULL,
  `sub` tinyint(4) NOT NULL default '-1',
  PRIMARY KEY  (`ID_CATEGORY`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}news_categories`
#

INSERT INTO `{$db_prefix}news_categories` VALUES (1, 'News', 'blank.gif', -1);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}page_folders`
#

CREATE TABLE `{$db_prefix}page_folders` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `isSub` tinyint(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}pages`
#

CREATE TABLE `{$db_prefix}pages` (
  `id` int(11) NOT NULL auto_increment,
  `title` mediumtext NOT NULL,
  `stitle` mediumtext NOT NULL,
  `contents` text NOT NULL,
  `phpe` tinyint(2) NOT NULL default '0',
  `memberGroup` text NOT NULL,
  `folder` tinyint(11) NOT NULL default '0',
  `yabbce` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}pages`
#
INSERT INTO `{$db_prefix}pages` VALUES (2, 'Welcome to Enigma!', 'home', 'echo \'<div class="main"><div class="featured">\';\r\n\r\narticleSum();\r\n\r\necho \'</div>\';\r\n\r\nnews();\r\n\r\necho \'</div>\';', 1, '0', 0, 0);
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}polls`
#

CREATE TABLE `{$db_prefix}polls` (
  `ID_POLL` int(11) NOT NULL auto_increment,
  `question` tinytext NOT NULL,
  `votingLocked` tinyint(4) NOT NULL default '0',
  `votedMemberIDs` text,
  `option1` tinytext,
  `option2` tinytext,
  `option3` tinytext,
  `option4` tinytext,
  `option5` tinytext,
  `option6` tinytext,
  `option7` tinytext,
  `option8` tinytext,
  `votes1` int(11) NOT NULL default '0',
  `votes2` int(11) NOT NULL default '0',
  `votes3` int(11) NOT NULL default '0',
  `votes4` int(11) NOT NULL default '0',
  `votes5` int(11) NOT NULL default '0',
  `votes6` int(11) NOT NULL default '0',
  `votes7` int(11) NOT NULL default '0',
  `votes8` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID_POLL`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}prefs`
#

CREATE TABLE `{$db_prefix}prefs` (
  `variable` text NOT NULL,
  `value` text NOT NULL
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}prefs`
#

INSERT INTO `{$db_prefix}prefs` VALUES ('logo', 'elogos.gif');
INSERT INTO `{$db_prefix}prefs` VALUES ('loc', '');
INSERT INTO `{$db_prefix}prefs` VALUES ('title', 'My Community');
INSERT INTO `{$db_prefix}prefs` VALUES ('recentpn', '3');
INSERT INTO `{$db_prefix}prefs` VALUES ('recenttn', '6');
INSERT INTO `{$db_prefix}prefs` VALUES ('dlmemberGroup', '-2');
INSERT INTO `{$db_prefix}prefs` VALUES ('frontNews', '1');
INSERT INTO `{$db_prefix}prefs` VALUES ('lbwidth', '15');
INSERT INTO `{$db_prefix}prefs` VALUES ('rbwidth', '15');
INSERT INTO `{$db_prefix}prefs` VALUES ('cwidth', '70');
INSERT INTO `{$db_prefix}prefs` VALUES ('subArtsGroups', '-2');
INSERT INTO `{$db_prefix}prefs` VALUES ('gmemberGroup', '-2');
INSERT INTO `{$db_prefix}prefs` VALUES ('emailmode', '1');
INSERT INTO `{$db_prefix}prefs` VALUES ('pollnum', '');
INSERT INTO `{$db_prefix}prefs` VALUES ('showpoll', '-1');
INSERT INTO `{$db_prefix}prefs` VALUES ('usenews', '1');
INSERT INTO `{$db_prefix}prefs` VALUES ('usepage', '');
INSERT INTO `{$db_prefix}prefs` VALUES ('dldir', '');
INSERT INTO `{$db_prefix}prefs` VALUES ('dlurl', '');
INSERT INTO `{$db_prefix}prefs` VALUES ('newslimit', '5');
INSERT INTO `{$db_prefix}prefs` VALUES ('newspostbd', '0');
INSERT INTO `{$db_prefix}prefs` VALUES ('subNewsGroups', '-2');
INSERT INTO `{$db_prefix}prefs` VALUES ('revNewsGroups', '1,8');
INSERT INTO `{$db_prefix}prefs` VALUES ('subLinksGroups', '-2');
INSERT INTO `{$db_prefix}prefs` VALUES ('revLinksGroups', '1');
INSERT INTO `{$db_prefix}prefs` VALUES ('revArtsGroups', '1');
INSERT INTO `{$db_prefix}prefs` VALUES ('artslimit', '2');
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}rand_quotes`
#

CREATE TABLE `{$db_prefix}rand_quotes` (
  `id` tinyint(4) NOT NULL auto_increment,
  `quote` text NOT NULL,
  `author` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}reserved_names`
#

CREATE TABLE `{$db_prefix}reserved_names` (
  `setting` tinytext NOT NULL,
  `value` text NOT NULL
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}reserved_names`
#

INSERT INTO `{$db_prefix}reserved_names` VALUES ('matchword', '0');
INSERT INTO `{$db_prefix}reserved_names` VALUES ('matchcase', '1');
INSERT INTO `{$db_prefix}reserved_names` VALUES ('matchuser', '1');
INSERT INTO `{$db_prefix}reserved_names` VALUES ('matchname', '1');
INSERT INTO `{$db_prefix}reserved_names` VALUES ('word', 'Webmaster');
INSERT INTO `{$db_prefix}reserved_names` VALUES ('word', 'Admin');
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}settings`
#

CREATE TABLE `{$db_prefix}settings` (
  `variable` tinytext NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`variable`(30))
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}settings`
#

INSERT INTO `{$db_prefix}settings` VALUES ('news', 'Enigma - An Open Source Portal for YaBB SE Forum.');
INSERT INTO `{$db_prefix}settings` VALUES ('viewMode', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('compactTopicPagesContiguous', '5');
INSERT INTO `{$db_prefix}settings` VALUES ('compactTopicPagesEnable', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('userViewOverride', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('agreement', 'You agree, through your use of this YaBB forum, that you will not post any material which is false, defamatory, inaccurate, abusive, vulgar, hateful, harassing, obscene, profane, sexually oriented, threatening, invasive of a person\\\'s privacy, or otherwise in violation of ANY law. This is not only humorous, but legal actions can be taken against you. You also agree not to post any copyrighted material unless the copyright is owned by you or you have consent from the owner of the copyrighted material. Spam, flooding, advertisements, chain letters, pyramid schemes, and solicitations are also inappropriate to this YaBB forum. \r\n\r\nNote that it is impossible for us to confirm the validity of posts on this YaBB forum. Please remember that we do not actively monitor the posted messages and are not responsible for their content. We do not warrant the accuracy, completeness or usefulness of any information presented. The messages express the views of the author, not necessarily the views of this YaBB forum. Anyone who feels that a posted message is objectionable is encouraged to notify an administrator of this forum immediately. We have the rights to remove objectionable content, within a reasonable time frame, if we determine that removal is necessary. This is a manual process, however, so please realize that we may not be able to remove or edit particular messages immediately. This policy goes for member profile information as well.\r\n\r\nYou remain solely responsible for the content of your messages, and you agree to indemnify and hold harmless this forum, and any related websites to this forum. We at this YaBB forum also reserve the right to reveal your identity (or any information we have about you) in the event of a complaint or legal action arising from any information posted by you.\r\n\r\nYou have the ability, as you register, to choose your username. We advise that you keep the name appropriate. With this user account you are about to register, you agree to never give your password out to another member, for your protection and for validity reasons. You also agree to NEVER use another member\\\'s account to post messages or browse this forum.\r\n\r\nAfter you register and log into this YaBB forum, you can fill out a detailed profile. It is your responsibility to present clean and accurate information. Any information we deem inaccurate or vulgar will be removed.\r\n\r\nPlease note that with each post, your IP address is recorded, in the event that you need to be banned from this YaBB forum or your ISP contacted. This will only happen in the event of a major violation of this agreement.\r\n\r\nAlso note that the software places a cookie, a text file containing bits of information (such as your username and password), in your browsers cache. This is ONLY used to keep you logged in/out. The software does not collect or sends any other form of information to your computer.');
INSERT INTO `{$db_prefix}settings` VALUES ('maxdays', '30');
INSERT INTO `{$db_prefix}settings` VALUES ('yabbinfo', '1062180187');
INSERT INTO `{$db_prefix}settings` VALUES ('enableStickyTopics', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('todayMod', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('karmaMode', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('karmaTimeRestrictAdmins', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('enablePreviousNext', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('PreviousNext_back', '« previous');
INSERT INTO `{$db_prefix}settings` VALUES ('PreviousNext_forward', 'next »');
INSERT INTO `{$db_prefix}settings` VALUES ('pollPostingRestrictions', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('pollMode', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('pollEditMode', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('enableVBStyleLogin', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('enableCompressedOutput', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('karmaWaitTime', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('karmaMinPosts', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('karmaMemberGroups', 'Administrator');
INSERT INTO `{$db_prefix}settings` VALUES ('karmaLabel', 'Karma:');
INSERT INTO `{$db_prefix}settings` VALUES ('karmaSmiteLabel', '[smite]');
INSERT INTO `{$db_prefix}settings` VALUES ('karmaApplaudLabel', '[applaud]');
INSERT INTO `{$db_prefix}settings` VALUES ('attachmentSizeLimit', '100');
INSERT INTO `{$db_prefix}settings` VALUES ('attachmentDirSizeLimit', '10240');
INSERT INTO `{$db_prefix}settings` VALUES ('attachmentUploadDir', '');
INSERT INTO `{$db_prefix}settings` VALUES ('attachmentUrl', '');
INSERT INTO `{$db_prefix}settings` VALUES ('attachmentExtensions', 'txt,jpg,gif,pdf,mpg,png');
INSERT INTO `{$db_prefix}settings` VALUES ('attachmentCheckExtensions', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('attachmentShowImages', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('attachmentEnable', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('attachmentEnableGuest', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('attachmentMemberGroups', '');
INSERT INTO `{$db_prefix}settings` VALUES ('disableCaching', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('enableInlineLinks', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('enableSP1Info', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('censorWholeWord', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('mostOnline', '5');
INSERT INTO `{$db_prefix}settings` VALUES ('mostDate', '1053777616');
INSERT INTO `{$db_prefix}settings` VALUES ('notifyAnncmnts_UserDisable', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('viewNewestFirst', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('trackStats', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('hitStats', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('userLanguage', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('titlesEnable', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('topicSummaryPosts', '15');
INSERT INTO `{$db_prefix}settings` VALUES ('enableUserTopicLocking', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('enableReportToMod', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('enableErrorLogging', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('maxwidth', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('maxheight', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('onlineEnable', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('topbottomEnable', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_memberscanpost', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_holidaycolor', '000080');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_bdaycolor', '920AC4');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_eventcolor', '078907');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_todaycolor', 'C1E5FF');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_enabled', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_postgroups', '');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_maxyear', '2010');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_minyear', '2002');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_daysaslink', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_startmonday', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_defaultboard', '');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_showeventsonindex', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_showbdaysonindex', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_showholidaysonindex', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_captioncolor', 'FFFFFF');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_postmembers', '');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_showweeknum', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_allowspan', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('cal_maxspan', '7');
INSERT INTO `{$db_prefix}settings` VALUES ('smtp_host', '');
INSERT INTO `{$db_prefix}settings` VALUES ('smtp_username', '');
INSERT INTO `{$db_prefix}settings` VALUES ('smtp_password', '');
INSERT INTO `{$db_prefix}settings` VALUES ('mail_type', 'sendmail');
INSERT INTO `{$db_prefix}settings` VALUES ('timeLoadPageEnable', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('totalTopics', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('totalMessages', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('returnToPost', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('removeNestedQuotes', '1');
INSERT INTO `{$db_prefix}settings` VALUES ('simpleSearch', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('localCookies', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('enableEmbeddedFlash', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('default_skin', 'Enigma');
INSERT INTO `{$db_prefix}settings` VALUES ('smileydirEnable', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('smileyBlockType', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('smileyBlock', '0');
INSERT INTO `{$db_prefix}settings` VALUES ('hdetach', '290');
INSERT INTO `{$db_prefix}settings` VALUES ('wdetach', '290');
# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}smilies`
#

CREATE TABLE `{$db_prefix}smilies` (
  `id` int(11) NOT NULL auto_increment,
  `code` text NOT NULL,
  `url` text NOT NULL,
  `description` text NOT NULL,
  `linebreak` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM COMMENT='Smilies Table';

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}spolls`
#

CREATE TABLE `{$db_prefix}spolls` (
  `id` tinyint(11) NOT NULL auto_increment,
  `question` text NOT NULL,
  `options` text NOT NULL,
  `votes` text NOT NULL,
  `totalVotes` int(20) NOT NULL default '0',
  `votedmemIDs` text NOT NULL,
  `closed` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `{$db_prefix}topics`
#

CREATE TABLE `{$db_prefix}topics` (
  `ID_TOPIC` int(11) NOT NULL auto_increment,
  `ID_BOARD` int(11) NOT NULL default '0',
  `ID_MEMBER_STARTED` int(11) NOT NULL default '0',
  `ID_MEMBER_UPDATED` int(11) NOT NULL default '0',
  `ID_FIRST_MSG` int(11) NOT NULL default '0',
  `ID_LAST_MSG` int(11) NOT NULL default '0',
  `ID_POLL` int(11) NOT NULL default '-1',
  `numReplies` int(11) NOT NULL default '0',
  `numViews` int(11) NOT NULL default '0',
  `locked` tinyint(4) NOT NULL default '0',
  `notifies` text,
  `isSticky` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ID_TOPIC`)
) TYPE=MyISAM;

#
# Dumping data for table `{$db_prefix}topics`
#

INSERT INTO `{$db_prefix}topics` VALUES (2, 1, 1, 1, 2, 2, -1, 0, 1, 0, NULL, 0);