-- MySQL dump 10.13  Distrib 5.5.24, for debian-linux-gnu (i686)
--
-- Host: localhost    Database: fud_test
-- ------------------------------------------------------
-- Server version	5.5.24-0ubuntu0.12.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `fud30_action_log`
--

DROP TABLE IF EXISTS `fud30_action_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_action_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `logtime` bigint(20) NOT NULL DEFAULT '0',
  `logaction` text COLLATE utf8_unicode_ci,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `a_res` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a_res_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_action_log_i_ul` (`user_id`,`logtime`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_ann_forums`
--

DROP TABLE IF EXISTS `fud30_ann_forums`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_ann_forums` (
  `ann_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`forum_id`,`ann_id`),
  KEY `fud30_ann_forums_i_a` (`ann_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_announce`
--

DROP TABLE IF EXISTS `fud30_announce`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_announce` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_started` bigint(20) NOT NULL DEFAULT '0',
  `date_ended` bigint(20) NOT NULL DEFAULT '0',
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `ann_opt` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_announce_i_dd` (`date_started`,`date_ended`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_attach`
--

DROP TABLE IF EXISTS `fud30_attach`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_attach` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `original_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `owner` int(11) NOT NULL DEFAULT '0',
  `attach_opt` int(11) NOT NULL DEFAULT '0',
  `message_id` int(11) NOT NULL DEFAULT '0',
  `dlcount` int(11) NOT NULL DEFAULT '0',
  `mime_type` int(11) NOT NULL DEFAULT '0',
  `fsize` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_attach_i_mp` (`message_id`,`attach_opt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_avatar`
--

DROP TABLE IF EXISTS `fud30_avatar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_avatar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `img` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `descr` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gallery` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
  PRIMARY KEY (`id`),
  KEY `fud30_avatar_i_g` (`gallery`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_blocked_logins`
--

DROP TABLE IF EXISTS `fud30_blocked_logins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_blocked_logins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_bookmarks`
--

DROP TABLE IF EXISTS `fud30_bookmarks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_bookmarks` (
  `user_id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`thread_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_buddy`
--

DROP TABLE IF EXISTS `fud30_buddy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_buddy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bud_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_buddy_i_ub` (`user_id`,`bud_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_calendar`
--

DROP TABLE IF EXISTS `fud30_calendar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_calendar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_day` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
  `event_month` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
  `event_year` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `descr` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fud30_calendar_i_ymd` (`event_year`,`event_month`,`event_day`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_cat`
--

DROP TABLE IF EXISTS `fud30_cat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cat_opt` int(11) NOT NULL DEFAULT '0',
  `view_order` int(11) NOT NULL DEFAULT '3',
  `parent` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_cat_p` (`parent`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_custom_fields`
--

DROP TABLE IF EXISTS `fud30_custom_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_custom_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type_opt` int(11) NOT NULL,
  `choice` text COLLATE utf8_unicode_ci,
  `field_opt` int(11) NOT NULL,
  `vieworder` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_custom_tags`
--

DROP TABLE IF EXISTS `fud30_custom_tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_custom_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_custom_tags_i_u` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_email_block`
--

DROP TABLE IF EXISTS `fud30_email_block`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_email_block` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_block_opt` int(11) NOT NULL DEFAULT '1',
  `string` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_email_block_i_s` (`string`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_ext_block`
--

DROP TABLE IF EXISTS `fud30_ext_block`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_ext_block` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ext` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_fc_view`
--

DROP TABLE IF EXISTS `fud30_fc_view`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_fc_view` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c` int(11) NOT NULL DEFAULT '0',
  `f` int(11) NOT NULL DEFAULT '0',
  `lvl` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_fc_view_i_f` (`f`),
  KEY `fud30_fc_view_i_c` (`c`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_fl_1`
--

DROP TABLE IF EXISTS `fud30_fl_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_fl_1` (
  `id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_fl_pg`
--

DROP TABLE IF EXISTS `fud30_fl_pg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_fl_pg` (
  `id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_fl_pm`
--

DROP TABLE IF EXISTS `fud30_fl_pm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_fl_pm` (
  `id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_forum`
--

DROP TABLE IF EXISTS `fud30_forum`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_forum` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `descr` text COLLATE utf8_unicode_ci,
  `parent` int(11) NOT NULL DEFAULT '0',
  `url_redirect` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `post_passwd` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `forum_icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_created` bigint(20) NOT NULL DEFAULT '0',
  `thread_count` int(11) NOT NULL DEFAULT '0',
  `post_count` int(11) NOT NULL DEFAULT '0',
  `last_post_id` int(11) NOT NULL DEFAULT '0',
  `view_order` int(11) NOT NULL DEFAULT '0',
  `max_attach_size` int(11) NOT NULL DEFAULT '0',
  `max_file_attachments` int(11) NOT NULL DEFAULT '1',
  `moderators` text COLLATE utf8_unicode_ci,
  `message_threshold` int(11) NOT NULL DEFAULT '0',
  `forum_opt` int(11) NOT NULL DEFAULT '16',
  PRIMARY KEY (`id`),
  KEY `fud30_forum_i_c` (`cat_id`),
  KEY `fud30_forum_i_lpi` (`last_post_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_forum_notify`
--

DROP TABLE IF EXISTS `fud30_forum_notify`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_forum_notify` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`forum_id`),
  KEY `fud30_forum_notify_i_f` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_forum_read`
--

DROP TABLE IF EXISTS `fud30_forum_read`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_forum_read` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `last_view` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_forum_read_i_fu` (`forum_id`,`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_geoip`
--

DROP TABLE IF EXISTS `fud30_geoip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_geoip` (
  `ips` bigint(20) NOT NULL,
  `ipe` bigint(20) NOT NULL,
  `cc` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ips`,`ipe`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_group_members`
--

DROP TABLE IF EXISTS `fud30_group_members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_group_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `group_id` int(11) NOT NULL DEFAULT '0',
  `group_members_opt` int(11) NOT NULL DEFAULT '65536',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_group_members_i_gu` (`group_id`,`user_id`),
  KEY `fud30_group_members_i_gmo` (`group_members_opt`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_group_resources`
--

DROP TABLE IF EXISTS `fud30_group_resources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_group_resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL DEFAULT '0',
  `resource_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_group_resources_i_gr` (`group_id`,`resource_id`),
  KEY `fud30_group_resources_i_r` (`resource_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_groups`
--

DROP TABLE IF EXISTS `fud30_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `inherit_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `groups_opt` int(11) NOT NULL DEFAULT '0',
  `groups_opti` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_groups_i_f` (`forum_id`),
  KEY `fud30_groups_i_i` (`inherit_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_index`
--

DROP TABLE IF EXISTS `fud30_index`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_index` (
  `word_id` int(11) NOT NULL DEFAULT '0',
  `msg_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`word_id`,`msg_id`),
  KEY `fud30_index_i_m` (`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_ip_block`
--

DROP TABLE IF EXISTS `fud30_ip_block`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_ip_block` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ca` int(11) NOT NULL DEFAULT '0',
  `cb` int(11) NOT NULL DEFAULT '0',
  `cc` int(11) NOT NULL DEFAULT '0',
  `cd` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_jobs`
--

DROP TABLE IF EXISTS `fud30_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `start_minute` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
  `start_hour` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
  `start_dom` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
  `start_month` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
  `start_dow` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
  `cmd` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `nextrun` bigint(20) NOT NULL DEFAULT '0',
  `lastrun` bigint(20) NOT NULL DEFAULT '0',
  `locked` bigint(20) NOT NULL DEFAULT '0',
  `job_opt` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_karma_rate_track`
--

DROP TABLE IF EXISTS `fud30_karma_rate_track`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_karma_rate_track` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `stamp` bigint(20) NOT NULL DEFAULT '0',
  `rating` int(11) NOT NULL DEFAULT '0',
  `poster_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_karma_i_mu` (`msg_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_level`
--

DROP TABLE IF EXISTS `fud30_level`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_level` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `post_count` int(11) NOT NULL DEFAULT '0',
  `img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `level_opt` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_level_i_p` (`post_count`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_mime`
--

DROP TABLE IF EXISTS `fud30_mime`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_mime` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fl_ext` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mime_hdr` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `descr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icon` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unknown.gif',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_mime_f` (`fl_ext`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_mlist`
--

DROP TABLE IF EXISTS `fud30_mlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_mlist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `subject_regex_haystack` text COLLATE utf8_unicode_ci,
  `subject_regex_needle` text COLLATE utf8_unicode_ci,
  `body_regex_haystack` text COLLATE utf8_unicode_ci,
  `body_regex_needle` text COLLATE utf8_unicode_ci,
  `additional_headers` text COLLATE utf8_unicode_ci,
  `mlist_opt` int(11) NOT NULL DEFAULT '76',
  `custom_sig` text COLLATE utf8_unicode_ci,
  `mbox_server` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mbox_user` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mbox_pass` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mbox_type` int(11) NOT NULL DEFAULT '0',
  `fixed_from_address` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fud30_mlist_i_f` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_mod`
--

DROP TABLE IF EXISTS `fud30_mod`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_mod` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_mod_i_uf` (`user_id`,`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_msg`
--

DROP TABLE IF EXISTS `fud30_msg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thread_id` int(11) NOT NULL DEFAULT '0',
  `poster_id` int(11) NOT NULL DEFAULT '0',
  `reply_to` int(11) NOT NULL DEFAULT '0',
  `ip_addr` varchar(46) COLLATE utf8_unicode_ci NOT NULL DEFAULT '::1',
  `host_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `post_stamp` bigint(20) NOT NULL DEFAULT '0',
  `update_stamp` bigint(20) NOT NULL DEFAULT '0',
  `updated_by` int(11) NOT NULL DEFAULT '0',
  `icon` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `attach_cnt` int(11) NOT NULL DEFAULT '0',
  `poll_id` int(11) NOT NULL DEFAULT '0',
  `foff` bigint(20) NOT NULL DEFAULT '0',
  `length` int(11) NOT NULL DEFAULT '0',
  `file_id` int(11) NOT NULL DEFAULT '1',
  `offset_preview` bigint(20) NOT NULL DEFAULT '0',
  `length_preview` int(11) NOT NULL DEFAULT '0',
  `file_id_preview` int(11) NOT NULL DEFAULT '0',
  `attach_cache` text COLLATE utf8_unicode_ci,
  `poll_cache` text COLLATE utf8_unicode_ci,
  `mlist_msg_id` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `msg_opt` int(11) NOT NULL DEFAULT '1',
  `apr` int(11) NOT NULL DEFAULT '0',
  `flag_cc` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `flag_country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fud30_msg_i_ta` (`thread_id`,`apr`),
  KEY `fud30_msg_i_ps` (`post_stamp`),
  KEY `fud30_msg_i_pa` (`poster_id`,`apr`),
  KEY `fud30_msg_i_a` (`apr`),
  KEY `fud30_msg_i_ac` (`attach_cnt`),
  KEY `fud30_msg_i_pi` (`poll_id`),
  KEY `fud30_msg_i_ip` (`ip_addr`,`post_stamp`),
  KEY `fud30_msg_i_mmi` (`mlist_msg_id`),
  KEY `fud30_msg_i_s` (`subject`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_msg_report`
--

DROP TABLE IF EXISTS `fud30_msg_report`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_msg_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `reason` text COLLATE utf8_unicode_ci,
  `stamp` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_msg_report_i_mu` (`msg_id`,`user_id`),
  KEY `fud30_msg_report_i_u` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_msg_store`
--

DROP TABLE IF EXISTS `fud30_msg_store`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_msg_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_nntp`
--

DROP TABLE IF EXISTS `fud30_nntp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_nntp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `nntp_opt` int(11) NOT NULL DEFAULT '44',
  `server` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `newsgroup` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `port` int(11) NOT NULL DEFAULT '0',
  `timeout` int(11) NOT NULL DEFAULT '0',
  `login` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pass` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `imp_limit` int(11) NOT NULL DEFAULT '0',
  `custom_sig` text COLLATE utf8_unicode_ci,
  `tracker` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_nntp_i_f` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_pages`
--

DROP TABLE IF EXISTS `fud30_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `foff` bigint(20) NOT NULL DEFAULT '0',
  `length` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) NOT NULL,
  `page_opt` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_pages_s` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_plugins`
--

DROP TABLE IF EXISTS `fud30_plugins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_plugins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `priority` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_plugins_n` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_pmsg`
--

DROP TABLE IF EXISTS `fud30_pmsg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_pmsg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `to_list` text COLLATE utf8_unicode_ci,
  `ouser_id` int(11) NOT NULL DEFAULT '0',
  `duser_id` int(11) NOT NULL DEFAULT '0',
  `pdest` int(11) NOT NULL DEFAULT '0',
  `ip_addr` varchar(46) COLLATE utf8_unicode_ci NOT NULL DEFAULT '::1',
  `host_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `post_stamp` bigint(20) NOT NULL DEFAULT '0',
  `read_stamp` bigint(20) NOT NULL DEFAULT '0',
  `icon` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `attach_cnt` int(11) NOT NULL DEFAULT '0',
  `foff` bigint(20) NOT NULL DEFAULT '0',
  `length` int(11) NOT NULL DEFAULT '0',
  `ref_msg_id` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fldr` int(11) NOT NULL DEFAULT '0',
  `pmsg_opt` int(11) NOT NULL DEFAULT '49',
  PRIMARY KEY (`id`),
  KEY `fud30_pmsg_i_dfr` (`duser_id`,`fldr`,`read_stamp`),
  KEY `fud30_pmsg_i_dfi` (`duser_id`,`fldr`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_poll`
--

DROP TABLE IF EXISTS `fud30_poll`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_poll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `owner` int(11) NOT NULL DEFAULT '0',
  `creation_date` bigint(20) NOT NULL DEFAULT '0',
  `expiry_date` bigint(20) NOT NULL DEFAULT '0',
  `max_votes` int(11) DEFAULT NULL,
  `total_votes` int(11) NOT NULL DEFAULT '0',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_poll_i_o` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_poll_opt`
--

DROP TABLE IF EXISTS `fud30_poll_opt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_poll_opt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `votes` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fud30_poll_opt_i_p` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_poll_opt_track`
--

DROP TABLE IF EXISTS `fud30_poll_opt_track`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_poll_opt_track` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `poll_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `ip_addr` varchar(46) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poll_opt` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_poll_opt_track_i_pu` (`poll_id`,`user_id`,`ip_addr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_read`
--

DROP TABLE IF EXISTS `fud30_read`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_read` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thread_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `msg_id` int(11) NOT NULL DEFAULT '0',
  `last_view` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_read_i_tu` (`thread_id`,`user_id`),
  KEY `fud30_read_i_u` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_replace`
--

DROP TABLE IF EXISTS `fud30_replace`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_replace` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `replace_str` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `with_str` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `from_post` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `to_msg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `replace_opt` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_search`
--

DROP TABLE IF EXISTS `fud30_search`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_search` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `word` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_search_i_w` (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_search_cache`
--

DROP TABLE IF EXISTS `fud30_search_cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_search_cache` (
  `srch_query` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `query_type` int(11) NOT NULL DEFAULT '0',
  `expiry` int(11) NOT NULL DEFAULT '0',
  `msg_id` int(11) NOT NULL DEFAULT '0',
  `n_match` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`srch_query`,`query_type`,`msg_id`),
  KEY `fud30_search_cache_i_e` (`expiry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_ses`
--

DROP TABLE IF EXISTS `fud30_ses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_ses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ses_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `sys_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `action` text COLLATE utf8_unicode_ci,
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `time_sec` bigint(20) NOT NULL DEFAULT '0',
  `ip_addr` varchar(46) COLLATE utf8_unicode_ci DEFAULT NULL,
  `useragent` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data` text COLLATE utf8_unicode_ci,
  `returnto` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_ses_i_s` (`ses_id`),
  UNIQUE KEY `fud30_ses_i_u` (`user_id`),
  KEY `fud30_ses_i_tu` (`time_sec`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_smiley`
--

DROP TABLE IF EXISTS `fud30_smiley`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_smiley` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `img` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `descr` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `vieworder` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_spiders`
--

DROP TABLE IF EXISTS `fud30_spiders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_spiders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `botname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `useragent` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `bot_ip` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `theme` int(11) NOT NULL,
  `bot_opts` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_stats_cache`
--

DROP TABLE IF EXISTS `fud30_stats_cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_stats_cache` (
  `user_count` int(11) NOT NULL DEFAULT '0',
  `last_user_id` int(11) NOT NULL DEFAULT '0',
  `online_users_reg` int(11) NOT NULL DEFAULT '0',
  `online_users_anon` int(11) NOT NULL DEFAULT '0',
  `online_users_hidden` int(11) NOT NULL DEFAULT '0',
  `online_users_text` text COLLATE utf8_unicode_ci,
  `most_online` int(11) NOT NULL DEFAULT '0',
  `most_online_time` bigint(20) NOT NULL DEFAULT '0',
  `cache_age` bigint(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_themes`
--

DROP TABLE IF EXISTS `fud30_themes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_themes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `theme` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `locale` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pspell_lang` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `theme_opt` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `fud30_themes_i_t` (`theme_opt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_thr_exchange`
--

DROP TABLE IF EXISTS `fud30_thr_exchange`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_thr_exchange` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `th` int(11) NOT NULL DEFAULT '0',
  `frm` int(11) NOT NULL DEFAULT '0',
  `req_by` int(11) NOT NULL DEFAULT '0',
  `reason_msg` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `fud30_thr_exchange_i_f` (`frm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_thread`
--

DROP TABLE IF EXISTS `fud30_thread`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_thread` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `root_msg_id` int(11) NOT NULL DEFAULT '0',
  `last_post_date` bigint(20) NOT NULL DEFAULT '0',
  `replies` int(11) NOT NULL DEFAULT '0',
  `views` int(11) NOT NULL DEFAULT '0',
  `rating` int(11) NOT NULL DEFAULT '0',
  `n_rating` int(11) NOT NULL DEFAULT '0',
  `last_post_id` int(11) NOT NULL DEFAULT '0',
  `moved_to` int(11) NOT NULL DEFAULT '0',
  `orderexpiry` bigint(20) NOT NULL DEFAULT '0',
  `thread_opt` int(11) NOT NULL DEFAULT '0',
  `tdescr` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fud30_thread_i_flm` (`forum_id`,`moved_to`),
  KEY `fud30_thread_i_t` (`thread_opt`),
  KEY `fud30_thread_i_rmi` (`root_msg_id`),
  KEY `fud30_thread_i_r` (`replies`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_thread_notify`
--

DROP TABLE IF EXISTS `fud30_thread_notify`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_thread_notify` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `thread_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`thread_id`),
  KEY `fud30_thread_notify_i_t` (`thread_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_thread_rate_track`
--

DROP TABLE IF EXISTS `fud30_thread_rate_track`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_thread_rate_track` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thread_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `stamp` bigint(20) NOT NULL DEFAULT '0',
  `rating` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_thread_rate_track_i_tu` (`thread_id`,`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_title_index`
--

DROP TABLE IF EXISTS `fud30_title_index`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_title_index` (
  `word_id` int(11) NOT NULL DEFAULT '0',
  `msg_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`word_id`,`msg_id`),
  KEY `fud30_title_index_i_m` (`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_tv_1`
--

DROP TABLE IF EXISTS `fud30_tv_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_tv_1` (
  `thread_id` int(11) NOT NULL,
  `seq` int(11) NOT NULL,
  `iss` int(11) NOT NULL,
  PRIMARY KEY (`thread_id`),
  KEY `fud30_tv_1_seq` (`seq`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_user_ignore`
--

DROP TABLE IF EXISTS `fud30_user_ignore`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_user_ignore` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ignore_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_user_ignore_i_ui` (`user_id`,`ignore_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_users`
--

DROP TABLE IF EXISTS `fud30_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `alias` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `passwd` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `salt` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `interests` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `occupation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `avatar` int(11) NOT NULL DEFAULT '0',
  `avatar_loc` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icq` bigint(20) DEFAULT NULL,
  `aim` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `yahoo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `msnm` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `jabber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `affero` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `google` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `posts_ppg` int(11) NOT NULL DEFAULT '0',
  `time_zone` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'UTC',
  `birthday` char(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `join_date` bigint(20) NOT NULL DEFAULT '0',
  `conf_key` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `theme` int(11) NOT NULL DEFAULT '0',
  `posted_msg_count` int(11) NOT NULL DEFAULT '0',
  `last_visit` bigint(20) NOT NULL DEFAULT '0',
  `referer_id` int(11) NOT NULL DEFAULT '0',
  `last_read` bigint(20) NOT NULL DEFAULT '0',
  `custom_status` text COLLATE utf8_unicode_ci,
  `sig` text COLLATE utf8_unicode_ci,
  `level_id` int(11) NOT NULL DEFAULT '0',
  `karma` int(11) NOT NULL DEFAULT '0',
  `reset_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `u_last_post_id` int(11) NOT NULL DEFAULT '0',
  `home_page` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bio` text COLLATE utf8_unicode_ci,
  `cat_collapse_status` text COLLATE utf8_unicode_ci,
  `custom_color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `buddy_list` text COLLATE utf8_unicode_ci,
  `ignore_list` text COLLATE utf8_unicode_ci,
  `group_leader_list` text COLLATE utf8_unicode_ci,
  `users_opt` int(11) NOT NULL DEFAULT '4488117',
  `sq` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `registration_ip` varchar(46) COLLATE utf8_unicode_ci NOT NULL DEFAULT '::1',
  `last_used_ip` varchar(46) COLLATE utf8_unicode_ci NOT NULL DEFAULT '::1',
  `ban_expiry` bigint(20) NOT NULL DEFAULT '0',
  `topics_per_page` int(11) NOT NULL DEFAULT '40',
  `last_login` bigint(20) NOT NULL DEFAULT '0',
  `flag_cc` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `flag_country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_fields` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_users_i_l` (`login`),
  UNIQUE KEY `fud30_users_i_e` (`email`),
  UNIQUE KEY `fud30_users_i_a` (`alias`),
  KEY `fud30_users_i_rk` (`reset_key`),
  KEY `fud30_users_i_lv` (`last_visit`),
  KEY `fud30_users_i_ck` (`conf_key`),
  KEY `fud30_users_i_ri` (`referer_id`),
  KEY `fud30_users_i_uo` (`users_opt`),
  KEY `fud30_users_i_jd` (`join_date`),
  KEY `fud30_users_i_bd` (`birthday`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `fud30_xmlagg`
--

DROP TABLE IF EXISTS `fud30_xmlagg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fud30_xmlagg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `forum_id` int(11) NOT NULL DEFAULT '0',
  `xmlagg_opt` int(11) NOT NULL DEFAULT '2',
  `last_load_date` bigint(20) NOT NULL DEFAULT '0',
  `custom_sig` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `fud30_xmlagg_i_f` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-06-23  9:37:11