Server : ApacheSystem : Linux host44.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64 User : vapecompany ( 2719) PHP Version : 7.4.33 Disable Function : NONE Directory : /proc/self/root/var/softaculous/aef/ |
Upload File : |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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: `aefs`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]apps`
--
CREATE TABLE `[[dbprefix]]apps` (
`apid` mediumint(8) NOT NULL AUTO_INCREMENT,
`ap_name` varchar(100) NOT NULL DEFAULT '',
`ap_version` varchar(15) NOT NULL DEFAULT '',
`installed_time` int(10) NOT NULL DEFAULT '0',
`ap_info` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`apid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `[[dbprefix]]apps`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]apps_registry`
--
CREATE TABLE `[[dbprefix]]apps_registry` (
`apid` mediumint(8) NOT NULL DEFAULT '0',
`uid` mediumint(8) NOT NULL DEFAULT '0',
`apps_registry` text NOT NULL,
UNIQUE KEY `apid` (`apid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]apps_registry`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attachments`
--
CREATE TABLE `[[dbprefix]]attachments` (
`atid` mediumint(8) NOT NULL AUTO_INCREMENT,
`at_original_file` tinytext NOT NULL,
`at_file` tinytext NOT NULL,
`at_mimetype_id` smallint(5) NOT NULL DEFAULT '0',
`at_size` int(10) NOT NULL DEFAULT '0',
`at_fid` smallint(5) NOT NULL DEFAULT '0',
`at_pid` int(10) NOT NULL DEFAULT '0',
`at_downloads` int(10) NOT NULL DEFAULT '0',
`at_time` int(10) NOT NULL DEFAULT '0',
`at_mid` mediumint(8) NOT NULL DEFAULT '0',
`at_width` smallint(5) NOT NULL DEFAULT '0',
`at_height` smallint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`atid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `[[dbprefix]]attachments`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attachment_mimetypes`
--
CREATE TABLE `[[dbprefix]]attachment_mimetypes` (
`atmtid` smallint(5) NOT NULL AUTO_INCREMENT,
`atmt_ext` varchar(20) NOT NULL DEFAULT '',
`atmt_mimetype` varchar(255) NOT NULL DEFAULT '',
`atmt_icon` tinytext NOT NULL,
`atmt_posts` tinyint(2) NOT NULL DEFAULT '0',
`atmt_avatar` tinyint(2) NOT NULL DEFAULT '0',
`atmt_isimage` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`atmtid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `[[dbprefix]]attachment_mimetypes`
--
INSERT INTO `[[dbprefix]]attachment_mimetypes` VALUES(1, 'png', 'image/png', 'png.png', 1, 1, 1);
INSERT INTO `[[dbprefix]]attachment_mimetypes` VALUES(2, 'jpg', 'image/jpeg', 'jpg.png', 1, 1, 1);
INSERT INTO `[[dbprefix]]attachment_mimetypes` VALUES(3, 'gif', 'image/gif', 'gif.png', 1, 1, 1);
INSERT INTO `[[dbprefix]]attachment_mimetypes` VALUES(4, 'bmp', 'image/bitmap', 'bmp.png', 1, 1, 1);
INSERT INTO `[[dbprefix]]attachment_mimetypes` VALUES(5, 'tiff', 'image/tiff', 'tiff.png', 1, 1, 1);
INSERT INTO `[[dbprefix]]attachment_mimetypes` VALUES(6, 'txt', 'plain/text', 'txt.png', 1, 0, 0);
INSERT INTO `[[dbprefix]]attachment_mimetypes` VALUES(7, 'jpeg', 'image/jpeg', 'jpg.png', 1, 1, 1);
INSERT INTO `[[dbprefix]]attachment_mimetypes` VALUES(8, 'doc', 'application/msword', 'doc.png', 1, 0, 0);
INSERT INTO `[[dbprefix]]attachment_mimetypes` VALUES(9, 'mpg', 'video/mpeg', 'mpg.png', 1, 0, 0);
INSERT INTO `[[dbprefix]]attachment_mimetypes` VALUES(10, 'zip', 'application/zip', 'zip.png', 1, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]categories`
--
CREATE TABLE `[[dbprefix]]categories` (
`cid` smallint(5) NOT NULL AUTO_INCREMENT,
`name` tinytext NOT NULL,
`order` smallint(5) NOT NULL DEFAULT '0',
`collapsable` tinyint(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]categories`
--
INSERT INTO `[[dbprefix]]categories` VALUES(1, 'General Stuff', 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]errors`
--
CREATE TABLE `[[dbprefix]]errors` (
`type` tinyint(3) NOT NULL DEFAULT '0',
`id` mediumint(5) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]errors`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]forumpermissions`
--
CREATE TABLE `[[dbprefix]]forumpermissions` (
`fpfid` smallint(5) NOT NULL DEFAULT '0',
`fpugid` mediumint(5) NOT NULL DEFAULT '0',
`can_post_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_reply` tinyint(2) NOT NULL DEFAULT '0',
`can_vote_polls` tinyint(2) NOT NULL DEFAULT '0',
`can_post_polls` tinyint(2) NOT NULL DEFAULT '0',
`can_attach` tinyint(2) NOT NULL DEFAULT '0',
`can_view_attach` tinyint(2) NOT NULL DEFAULT '0',
UNIQUE KEY `fpfid` (`fpfid`,`fpugid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]forumpermissions`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]forums`
--
CREATE TABLE `[[dbprefix]]forums` (
`fid` smallint(5) NOT NULL AUTO_INCREMENT,
`cat_id` smallint(5) NOT NULL DEFAULT '0',
`par_board_id` smallint(5) NOT NULL DEFAULT '0',
`forum_order` smallint(5) NOT NULL DEFAULT '0',
`member_group` tinytext NOT NULL,
`fname` tinytext NOT NULL,
`description` tinytext NOT NULL,
`fimage` tinytext NOT NULL,
`fredirect` tinytext NOT NULL,
`ntopic` mediumint(8) NOT NULL DEFAULT '0',
`nposts` mediumint(8) NOT NULL DEFAULT '0',
`status` tinyint(3) NOT NULL DEFAULT '1',
`prune` tinyint(3) NOT NULL DEFAULT '0',
`allow_poll` tinyint(2) NOT NULL DEFAULT '0',
`allow_html` tinyint(2) NOT NULL DEFAULT '0',
`id_skin` smallint(5) NOT NULL DEFAULT '0',
`override_skin` tinyint(2) NOT NULL DEFAULT '0',
`inc_mem_posts` tinyint(2) NOT NULL DEFAULT '1',
`quick_reply` tinyint(2) NOT NULL DEFAULT '0',
`quick_topic` tinyint(2) NOT NULL DEFAULT '0',
`f_last_pid` int(10) NOT NULL DEFAULT '0',
`frulestitle` tinytext NOT NULL,
`frules` text NOT NULL,
`mod_topics` tinyint(2) NOT NULL DEFAULT '0',
`mod_posts` tinyint(2) NOT NULL DEFAULT '0',
`rss` int(4) NOT NULL DEFAULT '0',
`rss_topic` int(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]forums`
--
INSERT INTO `[[dbprefix]]forums` VALUES(1, 1, 0, 1, '-1,0,2,3', 'Generals', 'Talk about anything you like in general!', '', '', 1, 1, 1, 0, 1, 1, 0, 0, 1, 0, 0, 0, '', '0', 0, 10, 10, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]fpass`
--
CREATE TABLE `[[dbprefix]]fpass` (
`fpuid` mediumint(8) NOT NULL DEFAULT '0',
`resetcode` varchar(10) NOT NULL DEFAULT '',
`fptime` int(10) NOT NULL DEFAULT '0',
UNIQUE KEY `fpuid` (`fpuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]fpass`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]mark_read`
--
CREATE TABLE `[[dbprefix]]mark_read` (
`mr_uid` mediumint(8) NOT NULL DEFAULT '0',
`mr_fid` smallint(5) NOT NULL DEFAULT '0',
`mr_time` int(10) NOT NULL DEFAULT '0',
UNIQUE KEY `mr_uid` (`mr_uid`,`mr_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]mark_read`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]moderators`
--
CREATE TABLE `[[dbprefix]]moderators` (
`mod_mem_id` mediumint(8) NOT NULL DEFAULT '0',
`mod_fid` smallint(5) NOT NULL DEFAULT '0',
UNIQUE KEY `mod_mem_id` (`mod_mem_id`,`mod_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]moderators`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]news`
--
CREATE TABLE `[[dbprefix]]news` (
`nid` mediumint(8) NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) NOT NULL DEFAULT '0',
`title` tinytext NOT NULL,
`news` text NOT NULL,
`time` int(12) NOT NULL DEFAULT '0',
`image` tinytext NOT NULL,
`fullstorylink` tinytext NOT NULL,
`approved` tinyint(2) NOT NULL DEFAULT '0',
`showinticker` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `[[dbprefix]]news`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]notify_forum`
--
CREATE TABLE `[[dbprefix]]notify_forum` (
`notify_mid` mediumint(8) NOT NULL DEFAULT '0',
`notify_fid` smallint(5) NOT NULL DEFAULT '0',
UNIQUE KEY `notify_mid` (`notify_mid`,`notify_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]notify_forum`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]notify_topic`
--
CREATE TABLE `[[dbprefix]]notify_topic` (
`notify_mid` mediumint(8) NOT NULL DEFAULT '0',
`notify_tid` mediumint(8) NOT NULL DEFAULT '0',
UNIQUE KEY `notify_mid` (`notify_mid`,`notify_tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]notify_topic`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]permissions`
--
CREATE TABLE `[[dbprefix]]permissions` (
`member_group_id` mediumint(8) NOT NULL DEFAULT '0',
`view_forum` tinyint(2) NOT NULL DEFAULT '0',
`can_post_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_reply` tinyint(2) NOT NULL DEFAULT '0',
`can_edit_own_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_edit_other_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_edit_own` tinyint(2) NOT NULL DEFAULT '0',
`can_edit_other` tinyint(2) NOT NULL DEFAULT '0',
`approve_topics` tinyint(2) NOT NULL DEFAULT '0',
`approve_posts` tinyint(2) NOT NULL DEFAULT '0',
`can_del_own_post` tinyint(2) NOT NULL DEFAULT '0',
`can_del_other_post` tinyint(2) NOT NULL DEFAULT '0',
`can_search` tinyint(2) NOT NULL DEFAULT '0',
`can_email_mem` tinyint(2) NOT NULL DEFAULT '0',
`can_email_friend` tinyint(2) NOT NULL DEFAULT '0',
`can_edit_own_profile` tinyint(2) NOT NULL DEFAULT '0',
`can_edit_other_profile` tinyint(2) NOT NULL DEFAULT '0',
`can_del_own_account` tinyint(2) NOT NULL DEFAULT '0',
`can_del_other_account` tinyint(2) NOT NULL DEFAULT '0',
`can_ban_user` tinyint(2) NOT NULL DEFAULT '0',
`can_del_own_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_del_other_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_view_poll` tinyint(2) NOT NULL DEFAULT '0',
`can_vote_polls` tinyint(2) NOT NULL DEFAULT '0',
`can_post_polls` tinyint(2) NOT NULL DEFAULT '0',
`can_edit_other_poll` tinyint(2) NOT NULL DEFAULT '0',
`can_edit_own_poll` tinyint(2) NOT NULL DEFAULT '0',
`add_poll_topic_own` tinyint(2) NOT NULL DEFAULT '0',
`add_poll_topic_other` tinyint(2) NOT NULL DEFAULT '0',
`can_rem_own_poll` tinyint(2) NOT NULL DEFAULT '0',
`can_rem_other_poll` tinyint(2) NOT NULL DEFAULT '0',
`can_merge_topics` tinyint(2) NOT NULL DEFAULT '0',
`can_merge_posts` tinyint(2) NOT NULL DEFAULT '0',
`can_split_topics` tinyint(2) NOT NULL DEFAULT '0',
`can_email_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_make_sticky` tinyint(2) NOT NULL DEFAULT '0',
`can_move_own_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_move_other_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_lock_own_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_lock_other_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_announce_topic` tinyint(2) NOT NULL DEFAULT '0',
`can_report_post` tinyint(2) NOT NULL DEFAULT '0',
`can_report_pm` tinyint(2) NOT NULL DEFAULT '0',
`prefix` varchar(80) NOT NULL DEFAULT '',
`suffix` varchar(80) NOT NULL DEFAULT '',
`can_attach` tinyint(2) NOT NULL DEFAULT '0',
`can_view_attach` tinyint(2) NOT NULL DEFAULT '0',
`can_remove_attach` tinyint(2) NOT NULL DEFAULT '0',
`max_attach` mediumint(8) NOT NULL DEFAULT '0',
`notify_new_posts` tinyint(2) NOT NULL DEFAULT '0',
`notify_new_topics` tinyint(2) NOT NULL DEFAULT '0',
`use_avatar` tinyint(2) NOT NULL DEFAULT '0',
`url_avatar` tinyint(2) NOT NULL DEFAULT '0',
`upload_avatar` tinyint(2) NOT NULL DEFAULT '0',
`hide_online` tinyint(2) NOT NULL DEFAULT '0',
`view_active` tinyint(2) NOT NULL DEFAULT '0',
`view_anonymous` tinyint(2) NOT NULL DEFAULT '0',
`allow_html` tinyint(2) NOT NULL DEFAULT '0',
`has_priviliges` tinyint(2) NOT NULL DEFAULT '0',
`view_ip` tinyint(2) NOT NULL DEFAULT '0',
`can_admin` tinyint(2) NOT NULL DEFAULT '0',
`can_use_pm` tinyint(2) NOT NULL DEFAULT '0',
`max_stored_pm` mediumint(8) NOT NULL DEFAULT '0',
`max_mass_pm` mediumint(8) NOT NULL DEFAULT '0',
`view_offline_board` tinyint(2) NOT NULL DEFAULT '0',
`can_view_profile` tinyint(2) NOT NULL DEFAULT '0',
`view_members` tinyint(2) NOT NULL DEFAULT '0',
`view_stats` tinyint(2) NOT NULL DEFAULT '0',
`can_submit_news` tinyint(2) NOT NULL DEFAULT '0',
`can_approve_news` tinyint(2) NOT NULL DEFAULT '0',
`can_edit_news` tinyint(2) NOT NULL DEFAULT '0',
`can_delete_news` tinyint(2) NOT NULL DEFAULT '0',
`group_message` text NOT NULL,
`can_shout` tinyint(2) NOT NULL DEFAULT '0',
`can_del_shout` tinyint(2) NOT NULL DEFAULT '0',
`view_calendar` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`member_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]permissions`
--
INSERT INTO `[[dbprefix]]permissions` VALUES(-1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, '', 0, 0, 1);
INSERT INTO `[[dbprefix]]permissions` VALUES(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '', '', 1, 1, 1, 50000, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, '', 1, 1, 1);
INSERT INTO `[[dbprefix]]permissions` VALUES(3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '', '', 1, 1, 1, 2048, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 1, 150, 0, 0, 1, 1, 1, 1, 0, 0, 0, '', 1, 0, 1);
INSERT INTO `[[dbprefix]]permissions` VALUES(2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '', '', 1, 1, 1, 2048, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 0, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, '', 1, 1, 1);
INSERT INTO `[[dbprefix]]permissions` VALUES(-3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 1);
INSERT INTO `[[dbprefix]]permissions` VALUES(0, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, '', '', 1, 1, 0, 1024, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 200, 5, 0, 1, 1, 1, 1, 0, 0, 0, '', 1, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]pm`
--
CREATE TABLE `[[dbprefix]]pm` (
`pmid` mediumint(8) NOT NULL AUTO_INCREMENT,
`pm_from` mediumint(8) NOT NULL DEFAULT '0',
`pm_to` mediumint(8) NOT NULL DEFAULT '0',
`pm_time` int(10) NOT NULL DEFAULT '0',
`pm_read_time` int(10) NOT NULL DEFAULT '0',
`pm_folder` tinyint(2) NOT NULL DEFAULT '0',
`pm_subject` tinytext NOT NULL,
`pm_body` text NOT NULL,
`pm_track` tinyint(2) NOT NULL DEFAULT '0',
`pm_to_text` tinytext NOT NULL,
PRIMARY KEY (`pmid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `[[dbprefix]]pm`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]polls`
--
CREATE TABLE `[[dbprefix]]polls` (
`poid` mediumint(8) NOT NULL AUTO_INCREMENT,
`poll_qt` tinytext NOT NULL,
`poll_mid` mediumint(8) NOT NULL DEFAULT '0',
`poll_locked` tinyint(2) NOT NULL DEFAULT '0',
`poll_tid` mediumint(8) NOT NULL DEFAULT '0',
`poll_expiry` int(10) NOT NULL DEFAULT '0',
`poll_change_vote` tinyint(2) NOT NULL DEFAULT '0',
`poll_started` int(10) NOT NULL DEFAULT '0',
`poll_show_when` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`poid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `[[dbprefix]]polls`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]poll_options`
--
CREATE TABLE `[[dbprefix]]poll_options` (
`pooid` mediumint(10) NOT NULL AUTO_INCREMENT,
`poo_poid` mediumint(8) NOT NULL DEFAULT '0',
`poo_option` tinytext NOT NULL,
`poo_votes` smallint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`pooid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `[[dbprefix]]poll_options`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]poll_voters`
--
CREATE TABLE `[[dbprefix]]poll_voters` (
`pv_mid` mediumint(8) NOT NULL DEFAULT '0',
`pv_pooid` mediumint(10) NOT NULL DEFAULT '0',
`pv_poid` mediumint(8) NOT NULL DEFAULT '0',
UNIQUE KEY `pv_mid` (`pv_mid`,`pv_pooid`,`pv_poid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]poll_voters`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]posts`
--
CREATE TABLE `[[dbprefix]]posts` (
`pid` int(10) NOT NULL AUTO_INCREMENT,
`post_tid` mediumint(8) NOT NULL DEFAULT '0',
`p_top_sticky` tinyint(2) NOT NULL DEFAULT '0',
`post_fid` smallint(5) NOT NULL DEFAULT '0',
`ptime` int(10) NOT NULL DEFAULT '0',
`poster_id` mediumint(8) NOT NULL DEFAULT '0',
`poster_ip` varchar(20) NOT NULL DEFAULT '',
`modtime` int(10) NOT NULL DEFAULT '0',
`modifiers_id` mediumint(8) NOT NULL DEFAULT '0',
`post` text NOT NULL,
`use_smileys` tinyint(2) NOT NULL DEFAULT '1',
`gposter_name` varchar(80) NOT NULL DEFAULT '',
`gposter_email` varchar(80) NOT NULL DEFAULT '',
`post_title` varchar(255) NOT NULL DEFAULT '',
`num_attachments` tinyint(4) NOT NULL DEFAULT '0',
`par_id` int(10) NOT NULL DEFAULT '0',
`p_approved` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]posts`
--
INSERT INTO `[[dbprefix]]posts` VALUES(1, 1, 0, 1, [[timestamp]], -1, '', 0, 0, 'Hi,\r\n\r\n We would like to thank you for using AEF.\r\nIf you need any assistance :??: , feel free to ask us for help at the [url=http://www.anelectron.com/board/]support board[/url].\r\n\r\nThanks and enjoy AEF!!! ;-D \r\n\r\n', 1, 'AEF Team', 'aef@anelectron.com', '', 0, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]read_board`
--
CREATE TABLE `[[dbprefix]]read_board` (
`rb_uid` mediumint(8) NOT NULL DEFAULT '0',
`rb_time` int(12) NOT NULL DEFAULT '0',
UNIQUE KEY `rb_uid` (`rb_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]read_board`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]read_forums`
--
CREATE TABLE `[[dbprefix]]read_forums` (
`rf_uid` mediumint(8) NOT NULL DEFAULT '0',
`rf_fid` smallint(5) NOT NULL DEFAULT '0',
`rf_time` int(10) NOT NULL DEFAULT '0',
UNIQUE KEY `rf_uid` (`rf_uid`,`rf_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]read_forums`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]read_topics`
--
CREATE TABLE `[[dbprefix]]read_topics` (
`rt_uid` mediumint(8) NOT NULL DEFAULT '0',
`rt_tid` smallint(5) NOT NULL DEFAULT '0',
`rt_time` int(10) NOT NULL DEFAULT '0',
UNIQUE KEY `rt_uid` (`rt_uid`,`rt_tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]read_topics`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]registry`
--
CREATE TABLE `[[dbprefix]]registry` (
`name` varchar(255) NOT NULL DEFAULT '',
`regval` text NOT NULL,
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]registry`
--
INSERT INTO `[[dbprefix]]registry` VALUES('reserved_names', 'admin\r\nwebmaster\r\nmaster\r\nuser\r\nlocalhost\r\nlord');
INSERT INTO `[[dbprefix]]registry` VALUES('latest_mem', '[[admin_username]]|1');
INSERT INTO `[[dbprefix]]registry` VALUES('num_mem', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('recyclebin', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('mostactive', '1|[[timestamp]]');
INSERT INTO `[[dbprefix]]registry` VALUES('maxtopics', '30');
INSERT INTO `[[dbprefix]]registry` VALUES('maxpostsintopics', '15');
INSERT INTO `[[dbprefix]]registry` VALUES('maxreplyhot', '15');
INSERT INTO `[[dbprefix]]registry` VALUES('maxreplyveryhot', '25');
INSERT INTO `[[dbprefix]]registry` VALUES('disableshoutingtopics', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('disableshoutingdesc', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('prenextopic', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('warnoldtopic', '120');
INSERT INTO `[[dbprefix]]registry` VALUES('prefixsticky', 'Sticky:');
INSERT INTO `[[dbprefix]]registry` VALUES('prefixmoved', 'Moved:');
INSERT INTO `[[dbprefix]]registry` VALUES('prefixpolls', 'Poll:');
INSERT INTO `[[dbprefix]]registry` VALUES('maxtitlechars', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('mintitlechars', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('maxdescchars', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('mindescchars', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('allow_taf', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('maxcharposts', '20000');
INSERT INTO `[[dbprefix]]registry` VALUES('mincharposts', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('timepostfromuser', '10');
INSERT INTO `[[dbprefix]]registry` VALUES('maxemotpost', '15');
INSERT INTO `[[dbprefix]]registry` VALUES('maximgspost', '15');
INSERT INTO `[[dbprefix]]registry` VALUES('allowdynimg', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('maximgwidthpost', '300');
INSERT INTO `[[dbprefix]]registry` VALUES('maximgheightpost', '300');
INSERT INTO `[[dbprefix]]registry` VALUES('removenestedquotes', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('attachsigtopost', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('embedflashinpost', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('maxflashpost', '5');
INSERT INTO `[[dbprefix]]registry` VALUES('maxflashwidthinpost', '300');
INSERT INTO `[[dbprefix]]registry` VALUES('maxflashheightinpost', '300');
INSERT INTO `[[dbprefix]]registry` VALUES('enablepolls', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('maxpollsintopic', '3');
INSERT INTO `[[dbprefix]]registry` VALUES('maxoptionspoll', '10');
INSERT INTO `[[dbprefix]]registry` VALUES('maxpollqtlen', '100');
INSERT INTO `[[dbprefix]]registry` VALUES('censor_words_from', '');
INSERT INTO `[[dbprefix]]registry` VALUES('censor_words_to', '');
INSERT INTO `[[dbprefix]]registry` VALUES('maintenance', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('censor_words_case', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('parsebbc', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('autolink', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_hr', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_b', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_i', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_u', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_s', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_left', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_right', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_center', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_size', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_font', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_sup', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_sub', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_color', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_url', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_ftp', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_email', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_img', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_flash', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_code', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_quote', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_php', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_ul', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_ol', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('bbc_parseHTML', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('reg_method', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('allow_reg', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('wel_email', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('reg_notify', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('max_pass', '20');
INSERT INTO `[[dbprefix]]registry` VALUES('max_uname', '20');
INSERT INTO `[[dbprefix]]registry` VALUES('min_pass', '4');
INSERT INTO `[[dbprefix]]registry` VALUES('min_uname', '4');
INSERT INTO `[[dbprefix]]registry` VALUES('sec_conf', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('samepc_reg', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('age_limit', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('age_rest_act', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('age_rest_act_address', '');
INSERT INTO `[[dbprefix]]registry` VALUES('age_rest_act_fax', '');
INSERT INTO `[[dbprefix]]registry` VALUES('age_rest_act_tele', '');
INSERT INTO `[[dbprefix]]registry` VALUES('reserved_match_whole', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('reserved_match_insensitive', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('login_failed', '5');
INSERT INTO `[[dbprefix]]registry` VALUES('anon_login', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('fpass_sec_conf', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('userstextlen', '100');
INSERT INTO `[[dbprefix]]registry` VALUES('wwwlen', '150');
INSERT INTO `[[dbprefix]]registry` VALUES('customtitlelen', '30');
INSERT INTO `[[dbprefix]]registry` VALUES('locationlen', '100');
INSERT INTO `[[dbprefix]]registry` VALUES('realnamelen', '100');
INSERT INTO `[[dbprefix]]registry` VALUES('secretqtlen', '200');
INSERT INTO `[[dbprefix]]registry` VALUES('secretansmaxlen', '20');
INSERT INTO `[[dbprefix]]registry` VALUES('secretansminlen', '4');
INSERT INTO `[[dbprefix]]registry` VALUES('usersiglen', '200');
INSERT INTO `[[dbprefix]]registry` VALUES('showavatars', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('avatardir', '[[softpath]]/avatars');
INSERT INTO `[[dbprefix]]registry` VALUES('avatarurl', '[[softurl]]/avatars');
INSERT INTO `[[dbprefix]]registry` VALUES('uploadavatardir', '[[softpath]]/uploads/avatars');
INSERT INTO `[[dbprefix]]registry` VALUES('uploadavatarurl', '[[softurl]]/uploads/avatars');
INSERT INTO `[[dbprefix]]registry` VALUES('uploadavatarmaxsize', '5000');
INSERT INTO `[[dbprefix]]registry` VALUES('avatartypes', 'gif,jpg,png');
INSERT INTO `[[dbprefix]]registry` VALUES('uploadppicdir', '[[softpath]]/uploads/personalpic');
INSERT INTO `[[dbprefix]]registry` VALUES('uploadppicurl', '[[softurl]]/uploads/personalpic');
INSERT INTO `[[dbprefix]]registry` VALUES('uploadppicmaxsize', '5000');
INSERT INTO `[[dbprefix]]registry` VALUES('ppictypes', 'gif,jpg,png,tiff');
INSERT INTO `[[dbprefix]]registry` VALUES('pmon', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('notifynewpm', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('pmusesmileys', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('pmnumshowinfolders', '50');
INSERT INTO `[[dbprefix]]registry` VALUES('pmsaveinsentitems', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('attachmentmode', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('allownewattachment', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('attachmentdir', '[[softpath]]/uploads/attachments');
INSERT INTO `[[dbprefix]]registry` VALUES('maxattachmentpost', '3');
INSERT INTO `[[dbprefix]]registry` VALUES('maxattachsize', '150');
INSERT INTO `[[dbprefix]]registry` VALUES('maxattachsizepost', '250');
INSERT INTO `[[dbprefix]]registry` VALUES('attachmentshowimage', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('attachmentshowimagemaxwidth', '200');
INSERT INTO `[[dbprefix]]registry` VALUES('attachmentshowimagemaxheight', '200');
INSERT INTO `[[dbprefix]]registry` VALUES('attachmenturl', '[[softurl]]/uploads/attachments');
INSERT INTO `[[dbprefix]]registry` VALUES('usesmileys', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('maintenance_subject', '');
INSERT INTO `[[dbprefix]]registry` VALUES('maintenance_message', '');
INSERT INTO `[[dbprefix]]registry` VALUES('mail', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('mail_user', '');
INSERT INTO `[[dbprefix]]registry` VALUES('mail_pass', '');
INSERT INTO `[[dbprefix]]registry` VALUES('mail_server', '');
INSERT INTO `[[dbprefix]]registry` VALUES('mail_port', '');
INSERT INTO `[[dbprefix]]registry` VALUES('notifications', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('numsubinpage', '30');
INSERT INTO `[[dbprefix]]registry` VALUES('session_timeout', '3600');
INSERT INTO `[[dbprefix]]registry` VALUES('last_active_span', '15');
INSERT INTO `[[dbprefix]]registry` VALUES('only_users', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('stats', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('memhideemail', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('showmemdetails', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('maxactivelist', '50');
INSERT INTO `[[dbprefix]]registry` VALUES('maxmemberlist', '50');
INSERT INTO `[[dbprefix]]registry` VALUES('theme', 'default');
INSERT INTO `[[dbprefix]]registry` VALUES('theme_id', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('choose_theme', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('version', '1.0.9');
INSERT INTO `[[dbprefix]]registry` VALUES('enablenews', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('enableshoutbox', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('shouts', '10');
INSERT INTO `[[dbprefix]]registry` VALUES('shoutboxtime', '1440');
INSERT INTO `[[dbprefix]]registry` VALUES('countinboardposts', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('subscribeauto', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('enablesig', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('showimgs', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('shoutbox_emot', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('shoutbox_nbbc', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('shoutbox_sbbc', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('language', 'english');
INSERT INTO `[[dbprefix]]registry` VALUES('choose_language', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('smiley_space_boundary', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('users_visited_today', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('av_width', '90');
INSERT INTO `[[dbprefix]]registry` VALUES('av_height', '90');
INSERT INTO `[[dbprefix]]registry` VALUES('ppic_width', '90');
INSERT INTO `[[dbprefix]]registry` VALUES('ppic_height', '90');
INSERT INTO `[[dbprefix]]registry` VALUES('last_posts_reply', '10');
INSERT INTO `[[dbprefix]]registry` VALUES('recent_posts', '8');
INSERT INTO `[[dbprefix]]registry` VALUES('who_read_topic', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('show_groups', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('change_username', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('rss_recent', '10');
INSERT INTO `[[dbprefix]]registry` VALUES('smart_redirect', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('report_posts', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('charset', 'ISO-8859-1');
INSERT INTO `[[dbprefix]]registry` VALUES('title_in_link', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('seo', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('timezone', '0');
INSERT INTO `[[dbprefix]]registry` VALUES('tickednews', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('todaysnews', '1');
INSERT INTO `[[dbprefix]]registry` VALUES('newsperpage', '12');
INSERT INTO `[[dbprefix]]registry` VALUES('bannedip', '');
INSERT INTO `[[dbprefix]]registry` VALUES('keywords', '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]sessions`
--
CREATE TABLE `[[dbprefix]]sessions` (
`sid` varchar(32) NOT NULL DEFAULT '',
`uid` mediumint(8) NOT NULL DEFAULT '0',
`time` int(12) NOT NULL DEFAULT '0',
`data` text NOT NULL,
`ip` varchar(20) NOT NULL DEFAULT '',
`last_activity` tinytext NOT NULL,
`activity` text NOT NULL,
`viewing_board` smallint(5) NOT NULL DEFAULT '0',
`viewing_topic` mediumint(8) NOT NULL DEFAULT '0',
`anonymous` tinyint(2) NOT NULL DEFAULT '0',
UNIQUE KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]sessions`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]shouts`
--
CREATE TABLE `[[dbprefix]]shouts` (
`shid` int(10) NOT NULL AUTO_INCREMENT,
`shtime` int(10) NOT NULL DEFAULT '0',
`shuid` mediumint(8) NOT NULL DEFAULT '0',
`shtext` text NOT NULL,
PRIMARY KEY (`shid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `[[dbprefix]]shouts`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]smileys`
--
CREATE TABLE `[[dbprefix]]smileys` (
`smid` smallint(5) NOT NULL AUTO_INCREMENT,
`smcode` varchar(40) NOT NULL DEFAULT '',
`smfile` varchar(40) NOT NULL DEFAULT '',
`smtitle` varchar(40) NOT NULL DEFAULT '',
`smorder` smallint(5) NOT NULL DEFAULT '0',
`smstatus` tinyint(2) NOT NULL DEFAULT '0',
`smfolder` varchar(70) NOT NULL DEFAULT '',
PRIMARY KEY (`smid`),
UNIQUE KEY `smcode` (`smcode`),
UNIQUE KEY `smcode_2` (`smcode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `[[dbprefix]]smileys`
--
INSERT INTO `[[dbprefix]]smileys` VALUES(1, ':)', 'smile.png', 'Smile', 1, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(2, ':D', 'bigsmile.png', 'Big Smile', 2, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(3, ':angel:', 'angel.png', 'Angel', 3, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(4, ':-x', 'crossedlips.png', 'Crossed Lips', 0, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(5, ':cry:', 'cry.png', 'Cry', 0, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(6, ':kiss:', 'kiss.png', 'Kiss', 0, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(7, ':nerd:', 'nerd.png', 'Nerd', 0, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(8, ':neu:', 'neutral.png', 'Neutral', 0, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(9, ':??:', 'ooh.png', 'Question ??', 0, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(10, ':-(', 'sad.png', 'Sad', 0, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(11, ':squi:', 'squigglemouth.png', 'Squiggle mouth', 0, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(12, ':P', 'tongue.png', 'Sticking tongue out', 0, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(13, ';-D', 'wink.png', 'Wink', 0, 0, 'cutemoticons');
INSERT INTO `[[dbprefix]]smileys` VALUES(14, ':xd:', 'xd.png', 'XD', 0, 0, 'cutemoticons');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]stats`
--
CREATE TABLE `[[dbprefix]]stats` (
`timestamp` int(12) NOT NULL DEFAULT '0',
`users` mediumint(8) NOT NULL DEFAULT '0',
`topics` mediumint(8) NOT NULL DEFAULT '0',
`posts` mediumint(8) NOT NULL DEFAULT '0',
`active` mediumint(8) NOT NULL DEFAULT '0',
`pageviews` int(10) NOT NULL DEFAULT '0',
UNIQUE KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]stats`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]themes`
--
CREATE TABLE `[[dbprefix]]themes` (
`thid` mediumint(5) NOT NULL AUTO_INCREMENT,
`th_name` varchar(100) NOT NULL DEFAULT '',
`th_folder` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`thid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]themes`
--
INSERT INTO `[[dbprefix]]themes` VALUES(1, 'Electron', 'default');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]theme_registry`
--
CREATE TABLE `[[dbprefix]]theme_registry` (
`thid` mediumint(8) NOT NULL DEFAULT '0',
`uid` mediumint(8) NOT NULL DEFAULT '0',
`theme_registry` text NOT NULL,
UNIQUE KEY `thid` (`thid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]theme_registry`
--
INSERT INTO `[[dbprefix]]theme_registry` VALUES(1, 0, 'a:15:{s:4:"name";s:8:"Electron";s:4:"path";[[softpath_ser]]s:3:"url";[[softurl_ser]]s:6:"images";[[softurl_ser_image]]s:7:"wysiwyg";i:1;s:11:"fixshoutbox";i:0;s:8:"showdock";i:1;s:9:"headerimg";s:0:"";s:9:"headerads";s:0:"";s:13:"headernavtree";i:1;s:14:"shownumqueries";i:1;s:14:"showntimetaken";i:1;s:9:"copyright";s:0:"";s:9:"footerads";s:0:"";s:13:"footernavtree";i:0;}');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]topics`
--
CREATE TABLE `[[dbprefix]]topics` (
`tid` mediumint(8) NOT NULL AUTO_INCREMENT,
`topic` mediumtext NOT NULL,
`t_description` mediumtext NOT NULL,
`t_bid` smallint(5) NOT NULL DEFAULT '0',
`t_status` tinyint(2) NOT NULL DEFAULT '1',
`n_posts` smallint(5) NOT NULL DEFAULT '0',
`n_views` smallint(5) NOT NULL DEFAULT '0',
`type_image` mediumint(3) NOT NULL DEFAULT '0',
`t_mem_id` mediumint(8) NOT NULL DEFAULT '0',
`poll_id` mediumint(8) NOT NULL DEFAULT '0',
`t_sticky` tinyint(2) NOT NULL DEFAULT '0',
`first_post_id` int(10) NOT NULL DEFAULT '0',
`last_post_id` int(10) NOT NULL DEFAULT '0',
`mem_id_last_post` mediumint(8) NOT NULL DEFAULT '0',
`has_attach` smallint(5) NOT NULL DEFAULT '0',
`t_approved` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]topics`
--
INSERT INTO `[[dbprefix]]topics` VALUES(1, 'Welcome to AEF', '', 1, 1, 0, 0, 6, -1, 0, 0, 1, 0, 0, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]users`
--
CREATE TABLE `[[dbprefix]]users` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`username` varchar(80) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`salt` varchar(5) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`r_time` int(12) NOT NULL DEFAULT '0',
`r_ip` varchar(20) NOT NULL DEFAULT '',
`cookpass` varchar(32) NOT NULL DEFAULT '',
`lastlogin` int(12) NOT NULL DEFAULT '0',
`lastlogin_1` int(12) NOT NULL DEFAULT '0',
`posts` mediumint(8) NOT NULL DEFAULT '0',
`u_member_group` mediumint(5) NOT NULL DEFAULT '0',
`realname` tinytext NOT NULL,
`pm` smallint(5) NOT NULL DEFAULT '0',
`unread_pm` smallint(5) NOT NULL DEFAULT '0',
`users_text` tinytext NOT NULL,
`gender` tinyint(2) NOT NULL DEFAULT '0',
`birth_date` date NOT NULL DEFAULT '0000-00-00',
`customtitle` varchar(100) NOT NULL DEFAULT '',
`location` varchar(255) NOT NULL DEFAULT '',
`www` tinytext NOT NULL,
`timezone` varchar(6) NOT NULL DEFAULT '0',
`gmail` varchar(255) NOT NULL DEFAULT '',
`icq` varchar(255) NOT NULL DEFAULT '',
`aim` varchar(255) NOT NULL DEFAULT '',
`yim` varchar(255) NOT NULL DEFAULT '',
`msn` varchar(255) NOT NULL DEFAULT '',
`sig` text NOT NULL,
`avatar` tinytext NOT NULL,
`avatar_type` tinyint(2) NOT NULL DEFAULT '0',
`avatar_width` tinyint(4) NOT NULL DEFAULT '0',
`avatar_height` tinyint(4) NOT NULL DEFAULT '0',
`ppic` tinytext NOT NULL,
`ppic_type` tinyint(2) NOT NULL DEFAULT '0',
`ppic_width` tinyint(4) NOT NULL DEFAULT '0',
`ppic_height` tinyint(4) NOT NULL DEFAULT '0',
`timeformat` varchar(80) NOT NULL DEFAULT '',
`secret_question` tinytext NOT NULL,
`secret_answer` tinytext NOT NULL,
`user_theme` mediumint(5) NOT NULL DEFAULT '1',
`act_status` tinyint(2) NOT NULL DEFAULT '0',
`activation_code` varchar(10) NOT NULL DEFAULT '',
`validation_code` varchar(32) NOT NULL DEFAULT '',
`total_time_loggedin` int(12) NOT NULL DEFAULT '0',
`warns` tinyint(2) NOT NULL DEFAULT '0',
`last_warned` int(10) NOT NULL DEFAULT '0',
`language` varchar(50) NOT NULL DEFAULT '0',
`temp_ban` int(10) NOT NULL DEFAULT '0',
`temp_ban_time` int(10) NOT NULL DEFAULT '0',
`temp_ban_ug` mediumint(5) NOT NULL DEFAULT '0',
`adminemail` tinyint(2) NOT NULL DEFAULT '0',
`hideemail` tinyint(2) NOT NULL DEFAULT '0',
`subscribeauto` tinyint(2) NOT NULL DEFAULT '0',
`sendnewreply` tinyint(2) NOT NULL DEFAULT '0',
`pm_email_notify` tinyint(2) NOT NULL DEFAULT '0',
`pm_notify` tinyint(2) NOT NULL DEFAULT '0',
`saveoutgoingpm` tinyint(2) NOT NULL DEFAULT '0',
`showsigs` tinyint(2) NOT NULL DEFAULT '0',
`showavatars` tinyint(2) NOT NULL DEFAULT '0',
`showsmileys` tinyint(2) NOT NULL DEFAULT '0',
`autofastreply` tinyint(2) NOT NULL DEFAULT '0',
`showimgs` tinyint(2) NOT NULL DEFAULT '0',
`i_am_anon` tinyint(2) NOT NULL DEFAULT '0',
`user_settings` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]users`
--
INSERT INTO `[[dbprefix]]users` VALUES(1, '[[admin_username]]', '[[admin_pass]]', '[[adminsalt]]', '[[admin_email]]', [[timestamp]], '[[clientip]]', '', 0, 0, 0, 1, '', 0, 0, '', 0, '0000-00-00', '', '', '', '0', '', '', '', '', '', '', '', 0, 0, 0, '', 0, 0, 0, '', '', '', 1, 1, '', '', 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]user_groups`
--
CREATE TABLE `[[dbprefix]]user_groups` (
`member_group` mediumint(5) NOT NULL AUTO_INCREMENT,
`mem_gr_name` varchar(80) NOT NULL DEFAULT '',
`mem_gr_colour` varchar(20) NOT NULL DEFAULT '',
`post_count` mediumint(8) NOT NULL DEFAULT '0',
`image_name` varchar(30) NOT NULL DEFAULT '',
`image_count` mediumint(5) NOT NULL DEFAULT '0',
`max_pm` mediumint(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`member_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `[[dbprefix]]user_groups`
--
INSERT INTO `[[dbprefix]]user_groups` VALUES(-3, 'Banned', '#000000', -1, 'banned.gif', 1, 0);
INSERT INTO `[[dbprefix]]user_groups` VALUES(-1, 'Guest', '#000000', -1, 'guests.png', 1, 0);
INSERT INTO `[[dbprefix]]user_groups` VALUES(1, 'Administrator', '#FF0000', -1, 'admin.gif', 7, 0);
INSERT INTO `[[dbprefix]]user_groups` VALUES(2, 'Universal Moderator', '#0000FF', -1, 'unimod.gif', 6, 0);
INSERT INTO `[[dbprefix]]user_groups` VALUES(3, 'Moderator', '#339933', -1, 'mod.gif', 5, 0);
INSERT INTO `[[dbprefix]]user_groups` VALUES(4, 'Newbie', '#000000', 0, 'member.gif', 1, 0);
INSERT INTO `[[dbprefix]]user_groups` VALUES(5, 'Working Newbie', '#000000', 50, 'member.gif', 2, 0);
INSERT INTO `[[dbprefix]]user_groups` VALUES(6, 'Working Member', '#000000', 100, 'member.gif', 3, 0);
INSERT INTO `[[dbprefix]]user_groups` VALUES(7, 'Elite Member', '#000000', 250, 'member.gif', 4, 0);
INSERT INTO `[[dbprefix]]user_groups` VALUES(8, 'Super Member', '#000000', 500, 'member.gif', 5, 0);
INSERT INTO `[[dbprefix]]user_groups` VALUES(0, 'Member', '#000000', -1, 'member.gif', 2, 0);