-- MySQL dump 10.7 -- -- Host: localhost Database: shadows -- ------------------------------------------------------ -- Server version 4.1.3-beta-Max /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO,MYSQL323" */; -- -- Table structure for table `account_donations` -- DROP TABLE IF EXISTS `account_donations`; CREATE TABLE `account_donations` ( `contributor` varchar(255) default NULL, `currency` varchar(255) default NULL, `amount` float default NULL, `deposited` float default NULL, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `account_referrals` -- DROP TABLE IF EXISTS `account_referrals`; CREATE TABLE `account_referrals` ( `account` varchar(255) default NULL, `referrer` varchar(255) default NULL, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `account_withdrawals` -- DROP TABLE IF EXISTS `account_withdrawals`; CREATE TABLE `account_withdrawals` ( `withdrawer` varchar(255) default NULL, `amount` float default NULL, `reason` varchar(255) default NULL, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `announcements` -- DROP TABLE IF EXISTS `announcements`; CREATE TABLE `announcements` ( `author` varchar(255) default NULL, `entry` text, `datestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `application_wait_times` -- DROP TABLE IF EXISTS `application_wait_times`; CREATE TABLE `application_wait_times` ( `wait_time` int(10) unsigned NOT NULL default '0' ) TYPE=MyISAM; -- -- Table structure for table `banned_sites` -- DROP TABLE IF EXISTS `banned_sites`; CREATE TABLE `banned_sites` ( `site` varchar(255) default NULL, `banned_by` varchar(255) default NULL, `banned_on` int(11) default NULL, `banned_until` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `boards` -- DROP TABLE IF EXISTS `boards`; CREATE TABLE `boards` ( `board_name` varchar(75) default NULL, `post_number` int(10) unsigned NOT NULL default '0', `subject` varchar(75) default NULL, `author` varchar(75) default NULL, `ooc_date` varchar(75) default NULL, `ic_date` varchar(75) default NULL, `message` text, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `building_log` -- DROP TABLE IF EXISTS `building_log`; CREATE TABLE `building_log` ( `author` varchar(255) default NULL, `entry` text, `datestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `building_totals` -- DROP TABLE IF EXISTS `building_totals`; CREATE TABLE `building_totals` ( `rooms` int(11) default NULL, `objects` int(11) default NULL, `mobiles` int(11) default NULL, `crafts` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `changed_helpfiles` -- DROP TABLE IF EXISTS `changed_helpfiles`; CREATE TABLE `changed_helpfiles` ( `staffer` varchar(255) default NULL, `change_type` varchar(255) default NULL, `category` varchar(255) default NULL, `name` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `clan_assignments` -- DROP TABLE IF EXISTS `clan_assignments`; CREATE TABLE `clan_assignments` ( `clan_name` varchar(255) default NULL, `imm_name` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `code_changelog` -- DROP TABLE IF EXISTS `code_changelog`; CREATE TABLE `code_changelog` ( `file_list` text, `history` text, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `coding_log` -- DROP TABLE IF EXISTS `coding_log`; CREATE TABLE `coding_log` ( `author` varchar(255) default NULL, `entry` text, `datestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `contributions` -- DROP TABLE IF EXISTS `contributions`; CREATE TABLE `contributions` ( `name` varchar(255) default NULL, `category` varchar(255) default NULL, `contributor` varchar(255) default NULL, `filename` varchar(255) default NULL, `date` int(11) default NULL, `uploaded_by` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `copyover_aiming` -- DROP TABLE IF EXISTS `copyover_aiming`; CREATE TABLE `copyover_aiming` ( `aimer_id` int(11) default NULL, `target_id` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `copyover_animations` -- DROP TABLE IF EXISTS `copyover_animations`; CREATE TABLE `copyover_animations` ( `animator` int(11) default NULL, `target` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `copyover_crafts` -- DROP TABLE IF EXISTS `copyover_crafts`; CREATE TABLE `copyover_crafts` ( `crafter_id` int(11) default NULL, `craft` varchar(255) default NULL, `phase` int(11) default NULL, `timer` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `copyover_delays` -- DROP TABLE IF EXISTS `copyover_delays`; CREATE TABLE `copyover_delays` ( `char_id` int(11) default NULL, `delay` int(11) default NULL, `delay_type` int(11) default NULL, `delay_info1` int(11) default NULL, `delay_info2` int(11) default NULL, `delay_who` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `copyover_doors` -- DROP TABLE IF EXISTS `copyover_doors`; CREATE TABLE `copyover_doors` ( `room` int(11) default NULL, `direction` int(11) default NULL, `state` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `copyover_fighting` -- DROP TABLE IF EXISTS `copyover_fighting`; CREATE TABLE `copyover_fighting` ( `fighter_id` int(11) default NULL, `target_id` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `copyover_followers` -- DROP TABLE IF EXISTS `copyover_followers`; CREATE TABLE `copyover_followers` ( `follower_id` int(11) default NULL, `leader_id` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `copyover_sighted_targets` -- DROP TABLE IF EXISTS `copyover_sighted_targets`; CREATE TABLE `copyover_sighted_targets` ( `sighter_id` int(11) default NULL, `target_id` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `copyover_subduers` -- DROP TABLE IF EXISTS `copyover_subduers`; CREATE TABLE `copyover_subduers` ( `subduer` int(11) default NULL, `target` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `crafts` -- DROP TABLE IF EXISTS `crafts`; CREATE TABLE `crafts` ( `craft` varchar(255) default NULL, `subcraft` varchar(255) default NULL, `command` varchar(255) default NULL, `opening` smallint(6) default NULL, `required_skills` varchar(255) default NULL, `clanned` smallint(6) default NULL, `race` smallint(6) default NULL, `opens_for` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `donation_tracking` -- DROP TABLE IF EXISTS `donation_tracking`; CREATE TABLE `donation_tracking` ( `donations` float default NULL, `spent` float default NULL ) TYPE=MyISAM; -- -- Table structure for table `downloads` -- DROP TABLE IF EXISTS `downloads`; CREATE TABLE `downloads` ( `host` varchar(255) default NULL, `timestamp` int(11) default NULL, `filename` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `failed_logins` -- DROP TABLE IF EXISTS `failed_logins`; CREATE TABLE `failed_logins` ( `account_name` varchar(255) default NULL, `hostname` varchar(255) default NULL, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `forum_auth_access` -- DROP TABLE IF EXISTS `forum_auth_access`; CREATE TABLE `forum_auth_access` ( `group_id` mediumint(8) NOT NULL default '0', `forum_id` smallint(5) unsigned NOT NULL default '0', `auth_view` tinyint(1) NOT NULL default '0', `auth_read` tinyint(1) NOT NULL default '0', `auth_post` tinyint(1) NOT NULL default '0', `auth_reply` tinyint(1) NOT NULL default '0', `auth_edit` tinyint(1) NOT NULL default '0', `auth_delete` tinyint(1) NOT NULL default '0', `auth_sticky` tinyint(1) NOT NULL default '0', `auth_announce` tinyint(1) NOT NULL default '0', `auth_vote` tinyint(1) NOT NULL default '0', `auth_pollcreate` tinyint(1) NOT NULL default '0', `auth_attachments` tinyint(1) NOT NULL default '0', `auth_mod` tinyint(1) NOT NULL default '0', KEY `group_id` (`group_id`), KEY `forum_id` (`forum_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_banlist` -- DROP TABLE IF EXISTS `forum_banlist`; CREATE TABLE `forum_banlist` ( `ban_id` mediumint(8) unsigned NOT NULL auto_increment, `ban_userid` mediumint(8) NOT NULL default '0', `ban_ip` varchar(8) NOT NULL default '', `ban_email` varchar(255) default NULL, PRIMARY KEY (`ban_id`), KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`) ) TYPE=MyISAM; -- -- Table structure for table `forum_categories` -- DROP TABLE IF EXISTS `forum_categories`; CREATE TABLE `forum_categories` ( `cat_id` mediumint(8) unsigned NOT NULL auto_increment, `cat_title` varchar(100) default NULL, `cat_order` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) ) TYPE=MyISAM; -- -- Table structure for table `forum_config` -- DROP TABLE IF EXISTS `forum_config`; CREATE TABLE `forum_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) ) TYPE=MyISAM; -- -- Table structure for table `forum_confirm` -- DROP TABLE IF EXISTS `forum_confirm`; CREATE TABLE `forum_confirm` ( `confirm_id` char(32) NOT NULL default '', `session_id` char(32) NOT NULL default '', `code` char(6) NOT NULL default '', PRIMARY KEY (`session_id`,`confirm_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_disallow` -- DROP TABLE IF EXISTS `forum_disallow`; CREATE TABLE `forum_disallow` ( `disallow_id` mediumint(8) unsigned NOT NULL auto_increment, `disallow_username` varchar(25) NOT NULL default '', PRIMARY KEY (`disallow_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_forum_lock` -- DROP TABLE IF EXISTS `forum_forum_lock`; CREATE TABLE `forum_forum_lock` ( `lock_id` mediumint(8) unsigned NOT NULL auto_increment, `forum_id` smallint(5) unsigned NOT NULL default '0', `lock_days` smallint(5) unsigned NOT NULL default '0', `lock_freq` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`lock_id`), KEY `forum_id` (`forum_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_forum_prune` -- DROP TABLE IF EXISTS `forum_forum_prune`; CREATE TABLE `forum_forum_prune` ( `prune_id` mediumint(8) unsigned NOT NULL auto_increment, `forum_id` smallint(5) unsigned NOT NULL default '0', `prune_days` smallint(5) unsigned NOT NULL default '0', `prune_freq` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`prune_id`), KEY `forum_id` (`forum_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_forums` -- DROP TABLE IF EXISTS `forum_forums`; CREATE TABLE `forum_forums` ( `forum_id` smallint(5) unsigned NOT NULL default '0', `cat_id` mediumint(8) unsigned NOT NULL default '0', `forum_name` varchar(150) default NULL, `forum_desc` text, `forum_status` tinyint(4) NOT NULL default '0', `forum_order` mediumint(8) unsigned NOT NULL default '1', `forum_posts` mediumint(8) unsigned NOT NULL default '0', `forum_topics` mediumint(8) unsigned NOT NULL default '0', `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0', `prune_next` int(11) default NULL, `prune_enable` tinyint(1) NOT NULL default '0', `auth_view` tinyint(2) NOT NULL default '0', `auth_read` tinyint(2) NOT NULL default '0', `auth_post` tinyint(2) NOT NULL default '0', `auth_reply` tinyint(2) NOT NULL default '0', `auth_edit` tinyint(2) NOT NULL default '0', `auth_delete` tinyint(2) NOT NULL default '0', `auth_sticky` tinyint(2) NOT NULL default '0', `auth_announce` tinyint(2) NOT NULL default '0', `auth_vote` tinyint(2) NOT NULL default '0', `auth_pollcreate` tinyint(2) NOT NULL default '0', `auth_attachments` tinyint(2) NOT NULL default '0', `forum_clan` varchar(255) default NULL, `lock_enable` tinyint(1) NOT NULL default '0', `lock_next` int(11) default NULL, PRIMARY KEY (`forum_id`), KEY `forums_order` (`forum_order`), KEY `cat_id` (`cat_id`), KEY `forum_last_post_id` (`forum_last_post_id`), KEY `forum_id` (`forum_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_groups` -- DROP TABLE IF EXISTS `forum_groups`; CREATE TABLE `forum_groups` ( `group_id` mediumint(8) NOT NULL auto_increment, `group_type` tinyint(4) NOT NULL default '1', `group_name` varchar(40) NOT NULL default '', `group_description` varchar(255) NOT NULL default '', `group_moderator` mediumint(8) NOT NULL default '0', `group_single_user` tinyint(1) NOT NULL default '1', PRIMARY KEY (`group_id`), KEY `group_single_user` (`group_single_user`) ) TYPE=MyISAM; -- -- Table structure for table `forum_posts` -- DROP TABLE IF EXISTS `forum_posts`; CREATE TABLE `forum_posts` ( `post_id` mediumint(8) unsigned NOT NULL auto_increment, `topic_id` mediumint(8) unsigned NOT NULL default '0', `forum_id` smallint(5) unsigned NOT NULL default '0', `poster_id` mediumint(8) NOT NULL default '0', `post_time` int(11) NOT NULL default '0', `poster_ip` varchar(8) NOT NULL default '', `post_username` varchar(25) default NULL, `enable_bbcode` tinyint(1) NOT NULL default '1', `enable_html` tinyint(1) NOT NULL default '0', `enable_smilies` tinyint(1) NOT NULL default '1', `enable_sig` tinyint(1) NOT NULL default '1', `post_edit_time` int(11) default NULL, `post_edit_count` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`post_id`), KEY `forum_id` (`forum_id`), KEY `topic_id` (`topic_id`), KEY `poster_id` (`poster_id`), KEY `post_time` (`post_time`) ) TYPE=MyISAM; -- -- Table structure for table `forum_posts_text` -- DROP TABLE IF EXISTS `forum_posts_text`; CREATE TABLE `forum_posts_text` ( `post_id` mediumint(8) unsigned NOT NULL default '0', `bbcode_uid` varchar(10) NOT NULL default '', `post_subject` varchar(60) default NULL, `post_text` text, PRIMARY KEY (`post_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_privmsgs` -- DROP TABLE IF EXISTS `forum_privmsgs`; CREATE TABLE `forum_privmsgs` ( `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment, `privmsgs_type` tinyint(4) NOT NULL default '0', `privmsgs_subject` varchar(255) NOT NULL default '0', `privmsgs_from_userid` mediumint(8) NOT NULL default '0', `privmsgs_to_userid` mediumint(8) NOT NULL default '0', `privmsgs_date` int(11) NOT NULL default '0', `privmsgs_ip` varchar(8) NOT NULL default '', `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1', `privmsgs_enable_html` tinyint(1) NOT NULL default '0', `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1', `privmsgs_attach_sig` tinyint(1) NOT NULL default '1', PRIMARY KEY (`privmsgs_id`), KEY `privmsgs_from_userid` (`privmsgs_from_userid`), KEY `privmsgs_to_userid` (`privmsgs_to_userid`) ) TYPE=MyISAM; -- -- Table structure for table `forum_privmsgs_text` -- DROP TABLE IF EXISTS `forum_privmsgs_text`; CREATE TABLE `forum_privmsgs_text` ( `privmsgs_text_id` mediumint(8) unsigned NOT NULL default '0', `privmsgs_bbcode_uid` varchar(10) NOT NULL default '0', `privmsgs_text` text, PRIMARY KEY (`privmsgs_text_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_ranks` -- DROP TABLE IF EXISTS `forum_ranks`; CREATE TABLE `forum_ranks` ( `rank_id` smallint(5) unsigned NOT NULL auto_increment, `rank_title` varchar(50) NOT NULL default '', `rank_min` mediumint(8) NOT NULL default '0', `rank_special` tinyint(1) default '0', `rank_image` varchar(255) default NULL, PRIMARY KEY (`rank_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_search_results` -- DROP TABLE IF EXISTS `forum_search_results`; CREATE TABLE `forum_search_results` ( `search_id` int(11) unsigned NOT NULL default '0', `session_id` varchar(32) NOT NULL default '', `search_array` text NOT NULL, PRIMARY KEY (`search_id`), KEY `session_id` (`session_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_search_wordlist` -- DROP TABLE IF EXISTS `forum_search_wordlist`; CREATE TABLE `forum_search_wordlist` ( `word_text` varchar(50) NOT NULL default '', `word_id` mediumint(8) unsigned NOT NULL auto_increment, `word_common` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`word_text`), KEY `word_id` (`word_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_search_wordmatch` -- DROP TABLE IF EXISTS `forum_search_wordmatch`; CREATE TABLE `forum_search_wordmatch` ( `post_id` mediumint(8) unsigned NOT NULL default '0', `word_id` mediumint(8) unsigned NOT NULL default '0', `title_match` tinyint(1) NOT NULL default '0', KEY `post_id` (`post_id`), KEY `word_id` (`word_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_sessions` -- DROP TABLE IF EXISTS `forum_sessions`; CREATE TABLE `forum_sessions` ( `session_id` char(32) NOT NULL default '', `session_user_id` mediumint(8) NOT NULL default '0', `session_start` int(11) NOT NULL default '0', `session_time` int(11) NOT NULL default '0', `session_ip` char(8) NOT NULL default '0', `session_page` int(11) NOT NULL default '0', `session_logged_in` tinyint(1) NOT NULL default '0', PRIMARY KEY (`session_id`), KEY `session_user_id` (`session_user_id`), KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_smilies` -- DROP TABLE IF EXISTS `forum_smilies`; CREATE TABLE `forum_smilies` ( `smilies_id` smallint(5) unsigned NOT NULL auto_increment, `code` varchar(50) default NULL, `smile_url` varchar(100) default NULL, `emoticon` varchar(75) default NULL, PRIMARY KEY (`smilies_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_themes` -- DROP TABLE IF EXISTS `forum_themes`; CREATE TABLE `forum_themes` ( `themes_id` mediumint(8) unsigned NOT NULL auto_increment, `template_name` varchar(30) NOT NULL default '', `style_name` varchar(30) NOT NULL default '', `head_stylesheet` varchar(100) default NULL, `body_background` varchar(100) default NULL, `body_bgcolor` varchar(6) default NULL, `body_text` varchar(6) default NULL, `body_link` varchar(6) default NULL, `body_vlink` varchar(6) default NULL, `body_alink` varchar(6) default NULL, `body_hlink` varchar(6) default NULL, `tr_color1` varchar(6) default NULL, `tr_color2` varchar(6) default NULL, `tr_color3` varchar(6) default NULL, `tr_class1` varchar(25) default NULL, `tr_class2` varchar(25) default NULL, `tr_class3` varchar(25) default NULL, `th_color1` varchar(6) default NULL, `th_color2` varchar(6) default NULL, `th_color3` varchar(6) default NULL, `th_class1` varchar(25) default NULL, `th_class2` varchar(25) default NULL, `th_class3` varchar(25) default NULL, `td_color1` varchar(6) default NULL, `td_color2` varchar(6) default NULL, `td_color3` varchar(6) default NULL, `td_class1` varchar(25) default NULL, `td_class2` varchar(25) default NULL, `td_class3` varchar(25) default NULL, `fontface1` varchar(50) default NULL, `fontface2` varchar(50) default NULL, `fontface3` varchar(50) default NULL, `fontsize1` tinyint(4) default NULL, `fontsize2` tinyint(4) default NULL, `fontsize3` tinyint(4) default NULL, `fontcolor1` varchar(6) default NULL, `fontcolor2` varchar(6) default NULL, `fontcolor3` varchar(6) default NULL, `span_class1` varchar(25) default NULL, `span_class2` varchar(25) default NULL, `span_class3` varchar(25) default NULL, `img_size_poll` smallint(5) unsigned default NULL, `img_size_privmsg` smallint(5) unsigned default NULL, PRIMARY KEY (`themes_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_themes_name` -- DROP TABLE IF EXISTS `forum_themes_name`; CREATE TABLE `forum_themes_name` ( `themes_id` smallint(5) unsigned NOT NULL default '0', `tr_color1_name` char(50) default NULL, `tr_color2_name` char(50) default NULL, `tr_color3_name` char(50) default NULL, `tr_class1_name` char(50) default NULL, `tr_class2_name` char(50) default NULL, `tr_class3_name` char(50) default NULL, `th_color1_name` char(50) default NULL, `th_color2_name` char(50) default NULL, `th_color3_name` char(50) default NULL, `th_class1_name` char(50) default NULL, `th_class2_name` char(50) default NULL, `th_class3_name` char(50) default NULL, `td_color1_name` char(50) default NULL, `td_color2_name` char(50) default NULL, `td_color3_name` char(50) default NULL, `td_class1_name` char(50) default NULL, `td_class2_name` char(50) default NULL, `td_class3_name` char(50) default NULL, `fontface1_name` char(50) default NULL, `fontface2_name` char(50) default NULL, `fontface3_name` char(50) default NULL, `fontsize1_name` char(50) default NULL, `fontsize2_name` char(50) default NULL, `fontsize3_name` char(50) default NULL, `fontcolor1_name` char(50) default NULL, `fontcolor2_name` char(50) default NULL, `fontcolor3_name` char(50) default NULL, `span_class1_name` char(50) default NULL, `span_class2_name` char(50) default NULL, `span_class3_name` char(50) default NULL, PRIMARY KEY (`themes_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_topics` -- DROP TABLE IF EXISTS `forum_topics`; CREATE TABLE `forum_topics` ( `topic_id` mediumint(8) unsigned NOT NULL auto_increment, `forum_id` smallint(8) unsigned NOT NULL default '0', `topic_title` char(60) NOT NULL default '', `topic_poster` mediumint(8) NOT NULL default '0', `topic_time` int(11) NOT NULL default '0', `topic_views` mediumint(8) unsigned NOT NULL default '0', `topic_replies` mediumint(8) unsigned NOT NULL default '0', `topic_status` tinyint(3) NOT NULL default '0', `topic_vote` tinyint(1) NOT NULL default '0', `topic_type` tinyint(3) NOT NULL default '0', `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0', `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0', `topic_moved_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`topic_id`), KEY `forum_id` (`forum_id`), KEY `topic_moved_id` (`topic_moved_id`), KEY `topic_status` (`topic_status`), KEY `topic_type` (`topic_type`) ) TYPE=MyISAM; -- -- Table structure for table `forum_topics_watch` -- DROP TABLE IF EXISTS `forum_topics_watch`; CREATE TABLE `forum_topics_watch` ( `topic_id` mediumint(8) unsigned NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `notify_status` tinyint(1) NOT NULL default '0', KEY `topic_id` (`topic_id`), KEY `user_id` (`user_id`), KEY `notify_status` (`notify_status`) ) TYPE=MyISAM; -- -- Table structure for table `forum_user_group` -- DROP TABLE IF EXISTS `forum_user_group`; CREATE TABLE `forum_user_group` ( `group_id` mediumint(8) NOT NULL default '0', `user_id` mediumint(8) NOT NULL default '0', `user_pending` tinyint(1) default NULL, KEY `group_id` (`group_id`), KEY `user_id` (`user_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_users` -- DROP TABLE IF EXISTS `forum_users`; CREATE TABLE `forum_users` ( `user_id` mediumint(8) NOT NULL default '0', `user_active` tinyint(1) default '1', `username` varchar(25) NOT NULL default '', `roleplay_points` int(10) unsigned default '0', `user_password` varchar(32) NOT NULL default '', `user_last_ip` varchar(80) default NULL, `user_subscription` smallint(5) unsigned default '1', `user_color` smallint(5) unsigned default '0', `user_session_time` int(11) NOT NULL default '0', `user_session_page` smallint(5) NOT NULL default '0', `user_lastvisit` int(11) NOT NULL default '0', `user_regdate` int(11) NOT NULL default '0', `user_level` tinyint(4) default '0', `user_posts` mediumint(8) unsigned NOT NULL default '0', `user_timezone` decimal(5,2) NOT NULL default '0.00', `user_style` tinyint(4) default NULL, `user_lang` varchar(255) default NULL, `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i', `user_new_privmsg` smallint(5) unsigned NOT NULL default '0', `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0', `user_last_privmsg` int(11) NOT NULL default '0', `user_emailtime` int(11) default NULL, `user_viewemail` tinyint(1) default NULL, `user_attachsig` tinyint(1) default NULL, `user_allowhtml` tinyint(1) default '1', `user_allowbbcode` tinyint(1) default '1', `user_allowsmile` tinyint(1) default '1', `user_allowavatar` tinyint(1) NOT NULL default '1', `user_allow_pm` tinyint(1) NOT NULL default '1', `user_allow_viewonline` tinyint(1) NOT NULL default '1', `user_notify` tinyint(1) NOT NULL default '1', `user_notify_pm` tinyint(1) NOT NULL default '0', `user_popup_pm` tinyint(1) NOT NULL default '0', `user_rank` int(11) default '0', `user_avatar` varchar(100) default NULL, `user_avatar_type` tinyint(4) NOT NULL default '0', `user_email` varchar(255) default NULL, `user_icq` varchar(15) default NULL, `user_website` varchar(100) default NULL, `user_from` varchar(100) default NULL, `user_sig` text, `user_sig_bbcode_uid` varchar(10) default NULL, `user_aim` varchar(255) default NULL, `user_yim` varchar(255) default NULL, `user_msnm` varchar(255) default NULL, `user_occ` varchar(100) default NULL, `user_interests` varchar(255) default NULL, `user_actkey` varchar(32) default NULL, `user_newpasswd` varchar(32) default NULL, `account_flags` int(11) NOT NULL default '0', `tms_votes` int(10) unsigned default '0', `last_tms_vote` int(10) unsigned default '0', `mm_votes` int(10) unsigned NOT NULL default '0', `last_mm_vote` int(10) unsigned NOT NULL default '0', `tmc_votes` int(10) unsigned NOT NULL default '0', `last_tmc_vote` int(10) unsigned NOT NULL default '0', `downloaded_code` int(10) unsigned default NULL, `last_rpp` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`user_id`), KEY `user_session_time` (`user_session_time`) ) TYPE=MyISAM; -- -- Table structure for table `forum_vote_desc` -- DROP TABLE IF EXISTS `forum_vote_desc`; CREATE TABLE `forum_vote_desc` ( `vote_id` mediumint(8) unsigned NOT NULL auto_increment, `topic_id` mediumint(8) unsigned NOT NULL default '0', `vote_text` text NOT NULL, `vote_start` int(11) NOT NULL default '0', `vote_length` int(11) NOT NULL default '0', PRIMARY KEY (`vote_id`), KEY `topic_id` (`topic_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_vote_results` -- DROP TABLE IF EXISTS `forum_vote_results`; CREATE TABLE `forum_vote_results` ( `vote_id` mediumint(8) unsigned NOT NULL default '0', `vote_option_id` tinyint(4) unsigned NOT NULL default '0', `vote_option_text` varchar(255) NOT NULL default '', `vote_result` int(11) NOT NULL default '0', KEY `vote_option_id` (`vote_option_id`), KEY `vote_id` (`vote_id`) ) TYPE=MyISAM; -- -- Table structure for table `forum_vote_voters` -- DROP TABLE IF EXISTS `forum_vote_voters`; CREATE TABLE `forum_vote_voters` ( `vote_id` mediumint(8) unsigned NOT NULL default '0', `vote_user_id` mediumint(8) NOT NULL default '0', `vote_user_ip` char(8) NOT NULL default '', KEY `vote_id` (`vote_id`), KEY `vote_user_id` (`vote_user_id`), KEY `vote_user_ip` (`vote_user_ip`) ) TYPE=MyISAM; -- -- Table structure for table `forum_words` -- DROP TABLE IF EXISTS `forum_words`; CREATE TABLE `forum_words` ( `word_id` mediumint(8) unsigned NOT NULL auto_increment, `word` char(100) NOT NULL default '', `replacement` char(100) NOT NULL default '', PRIMARY KEY (`word_id`) ) TYPE=MyISAM; -- -- Table structure for table `helpfiles` -- DROP TABLE IF EXISTS `helpfiles`; CREATE TABLE `helpfiles` ( `name` varchar(250) NOT NULL default '', `category` varchar(250) NOT NULL default '', `entry` text, `related_entries` varchar(250) default NULL, `required_level` int(10) unsigned default NULL, `last_changed` varchar(255) default NULL, `changed_by` varchar(255) default NULL, PRIMARY KEY (`name`,`category`) ) TYPE=MyISAM; -- -- Table structure for table `hobbitmail` -- DROP TABLE IF EXISTS `hobbitmail`; CREATE TABLE `hobbitmail` ( `account` varchar(255) default NULL, `flags` int(10) unsigned default '0', `from_line` varchar(255) default NULL, `from_account` varchar(255) default NULL, `sent_date` varchar(255) default NULL, `subject` varchar(255) default NULL, `message` text, `timestamp` int(10) unsigned NOT NULL default '0', `id` int(11) NOT NULL auto_increment, PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Table structure for table `massmail_messages` -- DROP TABLE IF EXISTS `massmail_messages`; CREATE TABLE `massmail_messages` ( `subject` varchar(255) default NULL, `message` text, `username` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `mob_resets` -- DROP TABLE IF EXISTS `mob_resets`; CREATE TABLE `mob_resets` ( `zone` int(11) default NULL, `cmd_no` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `new_crafts` -- DROP TABLE IF EXISTS `new_crafts`; CREATE TABLE `new_crafts` ( `command` varchar(255) default NULL, `subcraft` varchar(255) default NULL, `craft` varchar(255) default NULL, `creator` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `newsletter_issue` -- DROP TABLE IF EXISTS `newsletter_issue`; CREATE TABLE `newsletter_issue` ( `volume` int(11) default NULL, `issue` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `newsletter_stats` -- DROP TABLE IF EXISTS `newsletter_stats`; CREATE TABLE `newsletter_stats` ( `accepted_apps` int(11) NOT NULL default '0', `declined_apps` int(11) NOT NULL default '0', `resolved_typos` int(11) NOT NULL default '0', `resolved_bugs` int(11) NOT NULL default '0', `pc_deaths` int(11) NOT NULL default '0', `new_accounts` int(11) NOT NULL default '0', `guest_logins` int(11) NOT NULL default '0', `most_online` int(11) NOT NULL default '0' ) TYPE=MyISAM; -- -- Table structure for table `newsletters` -- DROP TABLE IF EXISTS `newsletters`; CREATE TABLE `newsletters` ( `timestamp` int(11) default NULL, `newsletter` text ) TYPE=MyISAM; -- -- Table structure for table `player_journals` -- DROP TABLE IF EXISTS `player_journals`; CREATE TABLE `player_journals` ( `name` varchar(75) default NULL, `post_number` int(10) unsigned NOT NULL default '0', `subject` varchar(75) default NULL, `author` varchar(75) default NULL, `date` varchar(75) default NULL, `message` text ) TYPE=MyISAM; -- -- Table structure for table `player_notes` -- DROP TABLE IF EXISTS `player_notes`; CREATE TABLE `player_notes` ( `name` varchar(75) default NULL, `post_number` int(10) unsigned NOT NULL default '0', `subject` varchar(75) default NULL, `author` varchar(75) default NULL, `date` varchar(75) default NULL, `message` text, `flags` int(11) default NULL, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `player_writing` -- DROP TABLE IF EXISTS `player_writing`; CREATE TABLE `player_writing` ( `db_key` int(11) default NULL, `author` varchar(255) default NULL, `page` int(11) default NULL, `date` varchar(255) default NULL, `ink` varchar(255) default NULL, `language` int(11) default NULL, `script` int(11) default NULL, `skill` int(11) default NULL, `writing` text, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `players_online` -- DROP TABLE IF EXISTS `players_online`; CREATE TABLE `players_online` ( `account` varchar(255) default NULL, `name` varchar(255) default NULL, `hostname` varchar(255) default NULL, `room` int(11) default NULL, `port` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `plot_log` -- DROP TABLE IF EXISTS `plot_log`; CREATE TABLE `plot_log` ( `author` varchar(255) default NULL, `entry` text, `datestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `professions` -- DROP TABLE IF EXISTS `professions`; CREATE TABLE `professions` ( `name` varchar(255) default NULL, `skill_list` varchar(255) default NULL, `id` int(10) unsigned NOT NULL auto_increment, `picked` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Table structure for table `queued_reviews` -- DROP TABLE IF EXISTS `queued_reviews`; CREATE TABLE `queued_reviews` ( `char_name` varchar(255) default NULL, `reviewer` varchar(255) default NULL, `new_keywords` varchar(255) default NULL, `new_sdesc` varchar(255) default NULL, `new_ldesc` varchar(255) default NULL, `new_desc` text, `new_comment` text, `accepted` smallint(5) unsigned default '0', `response` text ) TYPE=MyISAM; -- -- Table structure for table `queued_startups` -- DROP TABLE IF EXISTS `queued_startups`; CREATE TABLE `queued_startups` ( `port` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `queued_submissions` -- DROP TABLE IF EXISTS `queued_submissions`; CREATE TABLE `queued_submissions` ( `account` varchar(30) default NULL, `type` varchar(30) default NULL, `field1` text, `field2` text, `field3` text, `field4` text, `field5` text, `field6` text, `field7` text, `field8` text, `id` int(10) unsigned NOT NULL auto_increment, PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Table structure for table `race_rpp_data` -- DROP TABLE IF EXISTS `race_rpp_data`; CREATE TABLE `race_rpp_data` ( `race_name` varchar(255) default NULL, `point_req` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `reboot_mobiles` -- DROP TABLE IF EXISTS `reboot_mobiles`; CREATE TABLE `reboot_mobiles` ( `vnum` int(11) default NULL, `room` int(11) default NULL, `coldload_id` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `registered_characters` -- DROP TABLE IF EXISTS `registered_characters`; CREATE TABLE `registered_characters` ( `account_name` varchar(255) default NULL, `character_name` varchar(255) default NULL, `regdate` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `resolved_hosts` -- DROP TABLE IF EXISTS `resolved_hosts`; CREATE TABLE `resolved_hosts` ( `ip` varchar(255) default NULL, `hostname` varchar(255) default NULL, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `reviews_in_progress` -- DROP TABLE IF EXISTS `reviews_in_progress`; CREATE TABLE `reviews_in_progress` ( `char_name` varchar(255) default NULL, `reviewer` varchar(255) default NULL, `timestamp` int(10) unsigned default '0' ) TYPE=MyISAM; -- -- Table structure for table `saveroom_objs` -- DROP TABLE IF EXISTS `saveroom_objs`; CREATE TABLE `saveroom_objs` ( `room` int(11) default NULL, `wc` int(11) default NULL, `pos` int(11) default NULL, `objstack` int(11) default NULL, `obj_vnum` int(11) default NULL, `name` varchar(255) default NULL, `short_desc` varchar(255) default NULL, `long_desc` varchar(255) default NULL, `full_desc` text, `desc_keys` varchar(255) default NULL, `book_title` varchar(255) default NULL, `title_skill` int(11) default NULL, `title_language` int(11) default NULL, `title_script` int(11) default NULL, `loaded` int(11) default NULL, `extraflags` int(11) default NULL, `oval0` int(11) default NULL, `oval1` int(11) default NULL, `oval2` int(11) default NULL, `oval3` int(11) default NULL, `oval4` int(11) default NULL, `oval5` int(11) default NULL, `weight` int(11) default NULL, `size` int(11) default NULL, `count` int(11) default NULL, `timer` int(11) default NULL, `clock` int(11) default NULL, `morphto` int(11) default NULL, `morphTime` int(11) default NULL, `varcolor` varchar(255) default NULL, `omotestr` varchar(255) default NULL, `wounds` text, `lodged` text, `affects` text ) TYPE=MyISAM; -- -- Table structure for table `server_statistics` -- DROP TABLE IF EXISTS `server_statistics`; CREATE TABLE `server_statistics` ( `last_crash` int(11) default NULL, `last_reboot` int(11) default NULL, `max_players` int(11) default NULL, `morgul_arena` int(10) unsigned NOT NULL default '0' ) TYPE=MyISAM; -- -- Table structure for table `special_roles` -- DROP TABLE IF EXISTS `special_roles`; CREATE TABLE `special_roles` ( `summary` varchar(255) default NULL, `poster` varchar(255) default NULL, `date` varchar(255) default NULL, `cost` int(10) unsigned default NULL, `body` text, `timestamp` int(10) unsigned NOT NULL default '0' ) TYPE=MyISAM; -- -- Table structure for table `spells` -- DROP TABLE IF EXISTS `spells`; CREATE TABLE `spells` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `base_cost` int(11) default NULL, `sphere` smallint(6) default NULL, `circle` smallint(6) default NULL, `ch_echo` varchar(255) default NULL, `self_echo` varchar(255) default NULL, `vict_echo` varchar(255) default NULL, `room_echo` varchar(255) default NULL, `spell_description` text, `target_type` int(11) default NULL, `save_type` int(11) default NULL, `save_for` int(11) default NULL, `damage_form` int(11) default NULL, `affect1` int(11) default NULL, `dice1` varchar(20) default NULL, `act1` varchar(255) default NULL, `fade1` varchar(255) default NULL, `affect2` int(11) default NULL, `dice2` varchar(20) default NULL, `act2` varchar(255) default NULL, `fade2` varchar(255) default NULL, `affect3` int(11) default NULL, `dice3` varchar(20) default NULL, `act3` varchar(255) default NULL, `fade3` varchar(255) default NULL, `affect4` int(11) default NULL, `dice4` varchar(20) default NULL, `act4` varchar(255) default NULL, `fade4` varchar(255) default NULL, `affect5` int(11) default NULL, `dice5` varchar(20) default NULL, `act5` varchar(255) default NULL, `fade5` varchar(255) default NULL, `author` varchar(255) default NULL, `last_modified` int(10) unsigned default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Table structure for table `staff_roster` -- DROP TABLE IF EXISTS `staff_roster`; CREATE TABLE `staff_roster` ( `name` varchar(255) default NULL, `title` varchar(255) default NULL, `seniority` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `stayput_mobiles` -- DROP TABLE IF EXISTS `stayput_mobiles`; CREATE TABLE `stayput_mobiles` ( `vnum` int(11) default NULL, `room` int(11) default NULL, `coldload_id` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `testimonials` -- DROP TABLE IF EXISTS `testimonials`; CREATE TABLE `testimonials` ( `quote` text, `name` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `tracks` -- DROP TABLE IF EXISTS `tracks`; CREATE TABLE `tracks` ( `room` int(10) unsigned default NULL, `race` int(10) unsigned default NULL, `from_dir` int(10) unsigned default NULL, `to_dir` int(10) unsigned default NULL, `hours_passed` int(10) unsigned default NULL, `speed` int(10) unsigned default NULL, `flags` int(10) unsigned default NULL ) TYPE=MyISAM; -- -- Table structure for table `unneeded_helpfiles` -- DROP TABLE IF EXISTS `unneeded_helpfiles`; CREATE TABLE `unneeded_helpfiles` ( `name` varchar(255) default NULL, `datestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `virtual_boards` -- DROP TABLE IF EXISTS `virtual_boards`; CREATE TABLE `virtual_boards` ( `board_name` varchar(75) NOT NULL default '', `post_number` int(10) unsigned NOT NULL default '0', `subject` varchar(75) default NULL, `author` varchar(75) default NULL, `date_posted` varchar(75) default NULL, `message` text, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `vote_notifications` -- DROP TABLE IF EXISTS `vote_notifications`; CREATE TABLE `vote_notifications` ( `ip_addr` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `vote_tracking` -- DROP TABLE IF EXISTS `vote_tracking`; CREATE TABLE `vote_tracking` ( `ip_address` varchar(255) default NULL, `site_id` varchar(10) default NULL, `datestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `website_links` -- DROP TABLE IF EXISTS `website_links`; CREATE TABLE `website_links` ( `url` varchar(255) default NULL, `name` varchar(255) default NULL, `category` varchar(255) default NULL ) TYPE=MyISAM; -- -- Table structure for table `website_log` -- DROP TABLE IF EXISTS `website_log`; CREATE TABLE `website_log` ( `author` varchar(255) default NULL, `entry` text, `datestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `website_referrals` -- DROP TABLE IF EXISTS `website_referrals`; CREATE TABLE `website_referrals` ( `site` varchar(255) default NULL, `timestamp` int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `website_sessions` -- DROP TABLE IF EXISTS `website_sessions`; CREATE TABLE `website_sessions` ( `username` varchar(255) default NULL, `random_string` varchar(255) default NULL, `staff` smallint(6) NOT NULL default '0' ) TYPE=MyISAM; -- -- Table structure for table `wound_data` -- DROP TABLE IF EXISTS `wound_data`; CREATE TABLE `wound_data` ( `severity` varchar(255) default NULL, `points` int(11) default NULL, `time_to_heal` int(11) default NULL, `infected` int(11) default NULL, `constitution` int(11) default NULL ) TYPE=MyISAM; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;