aDriv4 website!

Linux server64.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64
LiteSpeed
198.54.116.248

File Name : fud.sql

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!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 */;

--
-- Database: `fud320`
--

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `fud30_action_log`
--

INSERT INTO `fud30_action_log` VALUES
(1, [[timestamp]], 'Forum', 2, 'Installed', 0);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=40 ;

--
-- Dumping data for table `fud30_avatar`
--

INSERT INTO `fud30_avatar` VALUES
(1, 'smiley01.jpg', 'Smiley01', 'default'),
(2, 'smiley02.jpg', 'Smiley02', 'default'),
(3, 'smiley03.jpg', 'Smiley03', 'default'),
(4, 'smiley04.jpg', 'Smiley04', 'default'),
(5, 'smiley05.jpg', 'Smiley05', 'default'),
(6, 'smiley06.jpg', 'Smiley06', 'default'),
(7, 'smiley07.jpg', 'Smiley07', 'default'),
(8, 'smiley08.jpg', 'Smiley08', 'default'),
(9, 'smiley09.jpg', 'Smiley09', 'default'),
(10, 'smiley10.jpg', 'Smiley10', 'default'),
(11, 'smiley11.jpg', 'Smiley11', 'default'),
(12, 'smiley12.jpg', 'Smiley12', 'default'),
(13, 'smiley13.jpg', 'Smiley13', 'default'),
(14, 'smiley14.jpg', 'Smiley14', 'default'),
(15, 'smiley15.jpg', 'Smiley15', 'default'),
(16, 'smiley16.jpg', 'Smiley16', 'default'),
(17, 'smiley17.jpg', 'Smiley17', 'default'),
(18, 'smiley18.jpg', 'Smiley18', 'default'),
(19, 'smiley19.jpg', 'Smiley19', 'default'),
(20, 'smiley20.jpg', 'Smiley20', 'default'),
(21, 'smiley21.jpg', 'Smiley21', 'default'),
(22, 'smiley22.jpg', 'Smiley22', 'default'),
(23, 'smiley23.jpg', 'Smiley23', 'default'),
(24, 'smiley24.jpg', 'Smiley24', 'default'),
(25, 'smiley25.jpg', 'Smiley25', 'default'),
(26, 'tux01.jpg', 'Tux01', 'Tux'),
(27, 'tux02.jpg', 'Tux02', 'Tux'),
(28, 'tux03.jpg', 'Tux03', 'Tux'),
(29, 'tux04.jpg', 'Tux04', 'Tux'),
(30, 'tux05.jpg', 'Tux05', 'Tux'),
(31, 'tux06.jpg', 'Tux06', 'Tux'),
(32, 'tux07.jpg', 'Tux07', 'Tux'),
(33, 'tux08.jpg', 'Tux08', 'Tux'),
(34, 'tux09.jpg', 'Tux09', 'Tux'),
(35, 'tux10.jpg', 'Tux10', 'Tux'),
(36, 'tux11.jpg', 'Tux11', 'Tux'),
(37, 'tux12.jpg', 'Tux12', 'Tux'),
(38, 'tux13.jpg', 'Tux13', 'Tux'),
(39, 'tux14.jpg', 'Tux14', 'Tux');

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `fud30_bookmarks` (
  `user_id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`thread_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fud30_bookmarks`
--

INSERT INTO `fud30_bookmarks` VALUES
(2, 1);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

--
-- Dumping data for table `fud30_calendar`
--

INSERT INTO `fud30_calendar` VALUES
(1, '1', '1', '*', NULL, 'New Year''s Day'),
(2, '14', '2', '*', NULL, 'Valentine''s Day'),
(3, '17', '3', '*', NULL, 'St. Patrick''s'),
(4, '1', '4', '*', NULL, 'All Fool''s Day'),
(5, '22', '4', '*', NULL, 'Earth Day'),
(6, '5', '5', '*', NULL, 'Cinco de Mayo'),
(7, '6', '6', '*', NULL, 'D-Day'),
(8, '24', '10', '*', NULL, 'United Nations Day'),
(9, '31', '10', '*', NULL, 'Halloween'),
(10, '11', '11', '*', NULL, 'Veterans Day'),
(11, '25', '12', '*', NULL, 'Christmas Day'),
(12, '2', '*', '*', NULL, 'Second day of the month, do your time sheets.');

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `fud30_cat`
--

INSERT INTO `fud30_cat` VALUES
(1, 'Public Forums', 'A test category for demonstration purposes.', 3, 1, 0),
(2, 'Private Forums', 'Another test category for demonstration purposes.', 3, 2, 0);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `fud30_custom_tags`
--

INSERT INTO `fud30_custom_tags` VALUES
(1, 'Administrator', 2);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `fud30_fc_view`
--

INSERT INTO `fud30_fc_view` VALUES
(1, 1, 1, 0),
(2, 2, 2, 0),
(3, 2, 3, 0);

-- --------------------------------------------------------

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

CREATE TABLE `fud30_fl_1` (
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `fud30_fl_2`
--

CREATE TABLE `fud30_fl_2` (
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fud30_fl_3`
--

CREATE TABLE `fud30_fl_3` (
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

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

CREATE TABLE `fud30_fl_pg` (
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `fud30_fl_pm` (
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `fud30_forum`
--

INSERT INTO `fud30_forum` VALUES
(1, 1, 'First Forum', 'Test forum for demonstration purposes. Please login and navigate to Administration -> Category &amp; Forum Management to create your own categories and forums.', 0, NULL, NULL, NULL, [[timestamp]], 1, 1, 1, 1, 1024, 5, NULL, 0, 16),
(2, 2, 'Members', 'This is a private forum for registered users.', 0, NULL, NULL, NULL, [[timestamp]], 0, 0, 0, 2, 1024, 5, NULL, 0, 16),
(3, 2, 'Staff', 'Private forum for staff (Administrators and Moderators).', 0, NULL, NULL, NULL, [[timestamp]], 0, 0, 0, 3, 1024, 5, NULL, 0, 16);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `fud30_forum_read`
--

INSERT INTO `fud30_forum_read` VALUES
(1, 1, 2, 0);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `fud30_groups`
--

INSERT INTO `fud30_groups` VALUES
(1, 'Global Anonymous Access', 0, 0, 262147, 0),
(2, 'Global Registered Access', 0, 0, 313231, 0),
(3, 'First Forum', 0, 1, 327679, 0),
(4, 'Members', 0, 2, 327679, 0),
(5, 'Staff', 0, 3, 327679, 0);

-- --------------------------------------------------------

--
-- Table structure for table `fud30_group_cache`
--

CREATE TABLE `fud30_group_cache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `resource_id` int(11) NOT NULL DEFAULT '0',
  `group_id` int(11) NOT NULL DEFAULT '0',
  `group_cache_opt` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fud30_group_cache_i_ru` (`resource_id`,`user_id`),
  KEY `fud30_group_cache_i_g` (`group_id`),
  KEY `fud30_group_cache_i_u` (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `fud30_group_cache`
--

INSERT INTO `fud30_group_cache` VALUES
(1, 0, 1, 3, 262147),
(2, 2147483647, 1, 3, 313231),
(3, 0, 2, 4, 0),
(4, 2147483647, 2, 4, 313231),
(5, 0, 3, 4, 0),
(6, 2, 3, 4, 313231),
(7, 2147483647, 3, 4, 0);

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `fud30_group_members`
--

INSERT INTO `fud30_group_members` VALUES
(1, 0, 3, 327683),
(2, 2147483647, 3, 378767),
(3, 0, 4, 65536),
(4, 2147483647, 4, 378767),
(5, 0, 5, 65536),
(6, 2, 5, 378767),
(7, 2147483647, 5, 65536);

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `fud30_group_resources`
--

INSERT INTO `fud30_group_resources` VALUES
(1, 3, 1),
(2, 4, 2),
(3, 5, 3);

-- --------------------------------------------------------

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

CREATE TABLE `fud30_index` (
  `word_id` int(11) NOT NULL DEFAULT '0',
  `msg_id` int(11) NOT NULL DEFAULT '0',
  `frequency` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`word_id`,`msg_id`),
  KEY `fud30_index_i_m` (`msg_id`),
  KEY `fud30_index_i_mf` (`msg_id`,`frequency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `fud30_level`
--

INSERT INTO `fud30_level` VALUES
(1, 'Senior Member', 100, NULL, 0),
(2, 'Member', 30, NULL, 0),
(3, 'Junior Member', 0, NULL, 0);

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=44 ;

--
-- Dumping data for table `fud30_mime`
--

INSERT INTO `fud30_mime` VALUES
(1, 'aiff', 'audio/x-aiff', 'AIFF File', 'sound.gif'),
(2, 'wav', 'audio/x-wav', 'Wave File', 'sound.gif'),
(3, 'midi', 'audio/midi', 'MIDI File', 'midi.gif'),
(4, 'au', 'audio/basic', 'Sun ulaw-Compressed Audio File', 'sound.gif'),
(5, 'mp3', 'audio/mpeg', 'MP3 File', 'sound.gif'),
(6, 'rm', 'audio/x-realaudio', 'Real Audio', 'real.gif'),
(7, 'gif', 'image/gif', 'GIF Image', 'image.gif'),
(8, 'ico', 'image/ico', 'Icon File', 'image.gif'),
(9, 'jpeg', 'image/jpeg', 'JPEG Image', 'image.gif'),
(10, 'jpg', 'image/jpeg', 'JPEG Image', 'image.gif'),
(11, 'tiff', 'image/tiff', 'TIFF Image', 'image.gif'),
(12, 'tif', 'image/tiff', 'TIFF Image', 'image.gif'),
(13, 'pict', 'image/x-pict', 'Macintosh PICT format', 'image.gif'),
(14, 'bmp', 'image/x-win-bmp', 'BMP Image', 'image.gif'),
(15, 'png', 'image/png', 'PNG Image', 'image.gif'),
(16, 'mpeg', 'video/mpeg', 'MPEG Movie', 'video.gif'),
(17, 'mpg', 'video/mpeg', 'MPEG Movie', 'video.gif'),
(18, 'qt', 'video/quicktime', 'QuickTime Movie', 'video.gif'),
(19, 'mov', 'video/quicktime', 'QuickTime Movie', 'video.gif'),
(20, 'vivo', 'video/vnd.vivo', 'VIVO Movie', 'video.gif'),
(21, 'avi', 'video/x-msvideo', 'Microsoft Video', 'video.gif'),
(22, 'gz', 'application/x-gzip', 'GZIP Archive', 'tgz.gif'),
(23, 'tar', 'application/x-tar', 'TAR Archive', 'tar.gif'),
(24, 'zip', 'application/zip', 'ZIP Archive', 'tgz.gif'),
(25, 'doc', 'application/msword', 'MS Word Document', 'word.gif'),
(26, 'dot', 'application/msword', 'MS Word Document', 'word.gif'),
(27, 'xls', 'application/vnd.ms-excel', 'MS Excel', 'excel.gif'),
(28, 'ppt', 'application/vnd.ms-powerpoint', 'MS PowerPoint', 'ppt.gif'),
(29, 'pdf', 'application/pdf', 'PDF Document', 'pdf.gif'),
(30, 'rtf', 'application/rtf', 'Rich Text Format', 'txt.gif'),
(31, 'htm', 'text/html', 'HTML Page', 'html.gif'),
(32, 'html', 'text/html', 'HTML Page', 'html.gif'),
(33, 'txt', 'text/plain', 'Plain Text', 'txt.gif'),
(34, 'ps', 'application/postscript', 'Postscript', 'postscript.gif'),
(35, 'swf', 'application/x-shockwave-flash', 'ShockWave Flash', 'flash.gif'),
(36, 'exe', 'application/application', 'Binary File', 'binary.gif'),
(37, 'bin', 'application/application', 'Binary File', 'binary.gif'),
(38, 'sh', 'application/sh', 'UNIX Shell Script', 'sh.gif'),
(39, 'hqx', 'application/mac-binhex40', 'Mac Binary', 'binary.gif'),
(40, '*', 'application/octet-stream', 'Unknown', 'unknown.gif'),
(41, 'pl', 'application/x-perl', 'Perl Script', 'source.gif'),
(42, 'pm', 'application/x-perl', 'Perl Module', 'source.gif'),
(43, 'php', 'application/x-httpd-php', 'PHP Script', 'source.gif');

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `fud30_msg`
--

INSERT INTO `fud30_msg` VALUES
(1, 1, 2, 0, '::1', NULL, [[timestamp]], 0, 0, NULL, 'Welcome to FUDforum', 0, 0, -1, 459, 1, -1, 0, 0, NULL, NULL, NULL, 1, 1, NULL, NULL);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `fud30_msg_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `fud30_msg_store`
--

INSERT INTO `fud30_msg_store` VALUES
(1, 'Congratulations! You have successfully installed FUDforum and are well on your way to creating a vibrant community that you and your members can enjoy for years to come. :-) \n \nTo get you started, please read the documentation on our <a href="https://github.com/fudforum/FUDforum/wiki">wiki</a> and report any problems on the <a href="https://github.com/fudforum/FUDforum/discussions">support forum</a>. \n \nLogin and head over to the Admin Control Panel to start configuring your forum. \n \nThanks for using our software. \n \nEnjoy! \nThe FUDforum team \n');

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `fud30_replace`
--

INSERT INTO `fud30_replace` VALUES
(1, '/fuck you/i', 'I love you', '//', '', 0);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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',
  `score` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`srch_query`,`query_type`,`msg_id`),
  KEY `fud30_search_cache_i_e` (`expiry`),
  KEY `fud30_search_cache_i_qtn` (`srch_query`,`query_type`,`n_match`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

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

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(64) 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_i` (`ip_addr`),
  KEY `fud30_ses_i_tu` (`time_sec`,`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `fud30_ses`
--

-- --------------------------------------------------------

--
-- Table structure for table `fud30_settings`
--

CREATE TABLE `fud30_settings` (
  `conf_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `conf_value` varchar(2048) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`conf_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=32 ;

--
-- Dumping data for table `fud30_smiley`
--

INSERT INTO `fud30_smiley` VALUES
(1, 'icon_redface.gif', 'Embarrassed', ':blush:', 1),
(2, 'icon_razz.gif', 'Razz', ':P~:-P~:razz:', 2),
(3, 'icon_mad.gif', 'Mad', ':x~:-x~:mad:', 3),
(4, 'icon_lol.gif', 'Laughing', ':lol:', 4),
(5, 'icon_cool.gif', 'Cool', '8)~8-)~:cool:', 5),
(6, 'icon_confused.gif', 'Confused', ':?~:-?~:???:', 6),
(7, 'icon_eek.gif', 'Shocked', '8O~8-O~:shock:', 7),
(8, 'icon_surprised.gif', 'Surprised', ':o~:-o~:eek:', 8),
(9, 'icon_sad.gif', 'Sad', ':(~:-(~:sad:', 9),
(10, 'icon_smile.gif', 'Smile', ':)~:-)~:smile:', 10),
(11, 'icon_biggrin.gif', 'Very Happy', ':D~:-D~:grin:', 11),
(12, 'icon_cry.gif', 'Crying or Very Sad', ':cry:~:((~:-((', 12),
(13, 'icon_evil.gif', 'Evil or Very Mad', ':evil:', 13),
(14, 'icon_twisted.gif', 'Twisted Evil', ':twisted:', 14),
(15, 'icon_rolleyes.gif', 'Rolling Eyes', ':roll:', 15),
(16, 'icon_wink.gif', 'Wink', ';)~;-)~:wink:', 16),
(17, 'icon_exclaim.gif', 'Exclamation', ':!:', 17),
(18, 'icon_question.gif', 'Question', ':?:', 18),
(19, 'icon_idea.gif', 'Idea', ':idea:', 19),
(20, 'icon_arrow.gif', 'Arrow', ':arrow:', 20),
(21, 'icon_neutral.gif', 'Neutral', ':|~:-|~:neutral:', 21),
(22, 'icon_mrgreen.gif', 'Grin', ':]~:-]~:brgin:', 22),
(23, 'icon_dead.gif', 'Dead', 'x(~:dead:', 23),
(24, 'icon_frown.gif', 'Frown', ':frown:', 24),
(25, 'icon_nod.gif', 'Nod', ':nod:', 25),
(26, 'icon_proud.gif', 'Proud', ':proud:', 26),
(27, 'icon_smug.gif', 'Smug', ':smug:', 27),
(28, 'icon_thumbsup.gif', 'Thumbs Up', ':thumbup:', 28),
(29, 'icon_thumbdown.gif', 'Thumbs Down', ':thumbdown:', 29),
(30, 'icon_uhoh.gif', 'Uh Oh', ':uhoh:', 30),
(31, 'icon_yawn.gif', 'Bored', ':yawn:', 31);

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `fud30_spiders`
--

INSERT INTO `fud30_spiders` VALUES
(1, 'Google', 'Googlebot', NULL, 3, 1, 1),
(2, 'Yahoo!', 'Slurp', NULL, 4, 1, 1),
(3, 'Bing', 'msnbot', NULL, 5, 1, 1);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fud30_stats_cache`
--

INSERT INTO `fud30_stats_cache` VALUES
(0, 0, 0, 0, 0, '', 0, 0, 0);

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `fud30_themes`
--

INSERT INTO `fud30_themes` VALUES
(1, 'default', 'default', 'en', 'en_US.UTF-8', 'en', 3);

-- --------------------------------------------------------

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

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`),
  KEY `fud30_thread_i_rt` (`rating`,`n_rating`),
  KEY `fud30_thread_i_frm` (`forum_id`,`root_msg_id`,`moved_to`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `fud30_thread`
--

INSERT INTO `fud30_thread` VALUES
(1, 1, 1, [[timestamp]], 0, 1, 5, 1, 1, 0, 1000000000, 4, 'Welcome, welcome, welcome!');

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fud30_thread_notify`
--

INSERT INTO `fud30_thread_notify` VALUES
(2, 1);

-- --------------------------------------------------------

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

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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `fud30_thread_rate_track`
--

INSERT INTO `fud30_thread_rate_track` VALUES
(1, 1, 2, [[timestamp]], 5);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `fud30_title_index` (
  `word_id` int(11) NOT NULL DEFAULT '0',
  `msg_id` int(11) NOT NULL DEFAULT '0',
  `frequency` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`word_id`,`msg_id`),
  KEY `fud30_title_index_i_m` (`msg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fud30_tv_1`
--

INSERT INTO `fud30_tv_1` VALUES
(1, 1, 4);

-- --------------------------------------------------------

--
-- Table structure for table `fud30_tv_2`
--

CREATE TABLE `fud30_tv_2` (
  `thread_id` int(11) NOT NULL,
  `seq` int(11) NOT NULL,
  `iss` int(11) NOT NULL,
  PRIMARY KEY (`thread_id`),
  KEY `fud30_tv_2_seq` (`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fud30_tv_3`
--

CREATE TABLE `fud30_tv_3` (
  `thread_id` int(11) NOT NULL,
  `seq` int(11) NOT NULL,
  `iss` int(11) NOT NULL,
  PRIMARY KEY (`thread_id`),
  KEY `fud30_tv_3_seq` (`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

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

CREATE TABLE `fud30_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `alias` varchar(50) COLLATE utf8_unicode_ci 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,
  `facebook` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `yahoo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `jabber` 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,
  `reset_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',
  `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',
  `ban_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `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=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `fud30_users`
--

INSERT INTO `fud30_users` VALUES
(1, 'Anonymous', 'Anonymous', '1', NULL, 'Anonymous', 'dev@null', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'America/New_York', NULL, [[timestamp]], NULL, NULL, NULL, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4488117, NULL, '::1', '::1', 0, NULL, 40, 0, NULL, NULL, NULL),
(2, '[[admin_username]]', '[[admin_username]]', '[[admin_pass]]', '[[salt]]', 'Administrator', '[[admin_email]]', NULL, NULL, NULL, 3, '<img src="[[relativeurl]]/images/avatars/smiley03.jpg" alt="" width="64" height="64" />', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'America/New_York', NULL, [[timestamp]], NULL, NULL, NULL, 1, 1, 0, 0, 0, 'Administrator', NULL, 3, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13777910, NULL, '::1', '::1', 0, NULL, 40, 0, NULL, NULL, NULL),
(3, 'Google', 'Google', '[[admin_pass]]', '[[salt]]', 'Googlebot', 'Google@fud_spiders', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'America/New_York', NULL, [[timestamp]], NULL, NULL, NULL, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1715893141, NULL, '::1', '::1', 0, NULL, 40, 0, NULL, NULL, NULL),
(4, 'Yahoo', 'Yahoo', '[[admin_pass]]', '[[salt]]', 'Yahoo!', 'Yahoo@fud_spiders', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'America/New_York', NULL, [[timestamp]], NULL, NULL, NULL, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1715893141, NULL, '::1', '::1', 0, NULL, 40, 0, NULL, NULL, NULL),
(5, 'Bing', 'Bing', '[[admin_pass]]', '[[salt]]', 'Bing', 'Bing@fud_spiders', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'America/New_York', NULL, [[timestamp]], NULL, NULL, NULL, 1, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1715893141, NULL, '::1', '::1', 0, NULL, 40, 0, NULL, NULL, NULL);

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

/*!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 */;

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	0755	2025-01-20 11:23:42
..	dir	-	root/root	0755	2026-05-05 10:24:39
default	dir	-	root/root	0755	2025-01-20 11:23:42
images	dir	-	root/root	0755	2025-01-20 11:23:42
php53	dir	-	root/root	0755	2025-01-20 11:23:42
php56	dir	-	root/root	0755	2025-01-20 11:23:42
php71	dir	-	root/root	0755	2025-01-20 11:23:42
php81	dir	-	root/root	0755	2025-01-20 11:23:42
php82	dir	-	root/root	0755	2025-01-20 11:23:42
.htaccess	file	1.95 KB	root/root	0644	2021-12-23 11:54:36
GLOBALS.php	file	4.51 KB	root/root	0644	2025-01-20 12:26:18
_upgrade.php	file	3.15 KB	root/root	0644	2021-12-23 11:54:36
_upgrade.xml	file	382 B	root/root	0644	2021-12-23 11:54:36
data.zip	file	3.06 MB	root/root	0644	2025-01-20 12:26:18
edit.php	file	4.44 KB	root/root	0644	2025-01-20 12:30:32
edit.xml	file	433 B	root/root	0644	2021-12-23 11:54:36
feed.php	file	32.99 KB	root/root	0644	2025-01-20 12:26:18
fileindex.php	file	183 B	root/root	0644	2025-01-20 12:26:18
fud.sql	file	53.3 KB	root/root	0644	2025-01-20 12:26:18
fud.zip	file	3.68 MB	root/root	0644	2025-01-20 12:26:18
import.php	file	4.32 KB	root/root	0644	2025-01-20 12:30:32
index.php	file	38.59 KB	root/root	0644	2025-01-20 12:26:18
info.xml	file	5.05 KB	root/root	0644	2025-01-20 12:26:18
install.js	file	921 B	root/root	0644	2021-12-23 11:54:36
install.php	file	9.11 KB	root/root	0644	2025-01-20 12:30:32
install.xml	file	1.01 KB	root/root	0644	2021-12-23 11:54:36
md5	file	4.19 KB	root/root	0644	2025-01-20 12:30:32
notes.txt	file	4.44 KB	root/root	0644	2025-01-20 12:26:18
pdf.php	file	50.78 KB	root/root	0644	2025-01-20 12:26:18
rdf.php	file	562 B	root/root	0644	2021-12-23 11:54:36

For more Private tool come to me!

https://t.me/aDriv4vz