-- phpMyAdmin SQL Dump
-- version 2.11.3deb1ubuntu1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 11, 2008 at 06:25 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.4-2ubuntu5.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mud`
--

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

--
-- Table structure for table `D_ECONOMY`
--
-- Creation: Feb 20, 2008 at 02:08 PM
-- Last update: Feb 20, 2008 at 02:10 PM
-- Last check: Feb 25, 2008 at 12:03 AM
--

CREATE TABLE IF NOT EXISTS `D_ECONOMY` (
  `ID` smallint(3) NOT NULL auto_increment,
  `Name` varchar(25) NOT NULL,
  `Rate` float NOT NULL,
  `Weight` float NOT NULL,
  `Inflation` float NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='/secure/daemon/economy.c - Currencies and attributes' AUTO_INCREMENT=7 ;

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

--
-- Table structure for table `LIB_MEAL`
--
-- Creation: Aug 25, 2008 at 08:40 PM
-- Last update: Aug 25, 2008 at 08:40 PM
--

CREATE TABLE IF NOT EXISTS `LIB_MEAL` (
  `MealID` varchar(25) NOT NULL,
  `KeyName` varchar(25) NOT NULL,
  `Id` varchar(255) NOT NULL,
  `Short` varchar(50) NOT NULL,
  `Long` varchar(255) NOT NULL,
  `Mass` int(5) NOT NULL,
  `MealType` varchar(255) NOT NULL,
  `Strength` smallint(3) NOT NULL,
  `MealMessageEater` varchar(255) NOT NULL,
  `MealMessageRoom` varchar(255) NOT NULL,
  `EmptyName` varchar(25) default NULL,
  `EmptyShort` varchar(50) default NULL,
  `EmptyLong` varchar(255) default NULL,
  `BaseCost` int(5) NOT NULL,
  `BaseUnit` varchar(15) NOT NULL,
  `Adjectives` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `LIB_NPC`
--
-- Creation: Aug 04, 2008 at 07:52 AM
-- Last update: Aug 23, 2008 at 01:50 AM
-- Last check: Aug 30, 2008 at 11:14 PM
--

CREATE TABLE IF NOT EXISTS `LIB_NPC` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(25) NOT NULL,
  `Short` varchar(50) NOT NULL,
  `Filename` varchar(100) NOT NULL COMMENT 'Path and filename of the npc',
  `Gender` varchar(15) NOT NULL,
  `Class` varchar(25) default NULL,
  `Race` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `Filename` (`Filename`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=111 ;

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

--
-- Table structure for table `LIB_PERSIST`
--
-- Creation: Aug 25, 2008 at 09:12 PM
-- Last update: Aug 25, 2008 at 09:12 PM
--

CREATE TABLE IF NOT EXISTS `LIB_PERSIST` (
  `ID` int(11) NOT NULL auto_increment,
  `Location` varchar(255) NOT NULL,
  `SubLocation` varchar(255) default NULL,
  `SaveString` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `LIB_PLAYERS`
--
-- Creation: Feb 20, 2008 at 08:51 PM
-- Last update: Aug 20, 2008 at 09:36 PM
-- Last check: Aug 30, 2008 at 11:14 PM
--

CREATE TABLE IF NOT EXISTS `LIB_PLAYERS` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(25) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

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

--
-- Table structure for table `LIB_PLAYERS_OLD`
--
-- Creation: Feb 20, 2008 at 02:08 PM
-- Last update: Feb 20, 2008 at 02:08 PM
--

CREATE TABLE IF NOT EXISTS `LIB_PLAYERS_OLD` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(15) NOT NULL,
  `CapName` varchar(15) default NULL COMMENT 'Capitalized Name',
  `Short` varchar(50) NOT NULL default '$N the unaccomplished',
  `InternalDesc` varchar(100) default NULL,
  `ExternalDesc` varchar(100) default NULL,
  `Invisible` tinyint(1) default NULL COMMENT 'Is Invisible?',
  `ProperNoun` tinyint(1) default NULL COMMENT 'Is a proper noun?',
  `Modify` tinyint(1) default NULL,
  `Opacity` int(11) default NULL,
  `Items` text COMMENT 'Mapping of dummy items the person has.',
  `Properties` text COMMENT 'Mapping of properties',
  `Inventory` text COMMENT 'Mapping of Inventory',
  `Messages` text COMMENT 'Mapping of messages',
  `RestrictedChannels` text COMMENT 'Array of restricted channels',
  `NoChanColors` tinyint(1) default NULL,
  `Paused` tinyint(1) default NULL,
  `localcmds` text COMMENT 'Array of local commands',
  `next_command` varchar(100) default NULL COMMENT 'Array',
  `HistorySize` int(11) default NULL,
  `CurrentWorkingDirectory` varchar(100) default NULL,
  `PreviousWorkingDirectory` varchar(100) default NULL,
  `Nicknames` text COMMENT 'Mapping of nicknames for people',
  `Aliases` text COMMENT 'Mapping of aliases',
  `Xverbs` text COMMENT 'Mapping of xverbs',
  `Prompt` varchar(100) default NULL COMMENT 'The user''s prompt string ie ''> ''',
  `Terminal` varchar(15) default NULL COMMENT 'Terminal type, ie ''ansi''',
  `Blocked` text COMMENT 'Mapping of blocked channels ie ''channame:0, otherchanname:1''',
  `Screen` varchar(25) default NULL COMMENT 'Array of screen dimensions in characters',
  `MessageQueue` text,
  `PauseMessages` text,
  `MessageExceptions` text,
  `Age` bigint(20) default NULL COMMENT 'User age, in ticks? seconds? minutes? ???',
  `WhereBlock` int(11) default NULL,
  `Brief` tinyint(1) default NULL COMMENT 'Brief mode',
  `LoginTime` timestamp NULL default NULL COMMENT 'Unix time they logged in',
  `BirthTime` timestamp NULL default NULL COMMENT 'Unix time they joined',
  `RescueBit` tinyint(1) default '0',
  `Password` char(43) default NULL,
  `Email` varchar(35) default NULL,
  `RealName` varchar(30) default NULL,
  `Rank` varchar(255) default NULL COMMENT '??? ie ''citizen''',
  `LoginSite` varchar(50) default NULL COMMENT 'Path the user logs in to',
  `HostSite` varchar(50) default NULL COMMENT 'Last place the user logged in from',
  `WebPage` varchar(75) default NULL COMMENT 'Web page',
  `News` text COMMENT 'Mapping of last time they checked each news readout',
  `Marriages` text COMMENT 'Array of marriages',
  `MaxCarry` int(11) default NULL COMMENT 'How much is the most they can carry? 0=infinite',
  `Position` int(11) default NULL,
  `Undead` tinyint(1) default NULL,
  `UndeadType` int(11) default NULL,
  `Mount` tinyint(1) default '0',
  `Riders` text COMMENT 'Array of riders.',
  `BodyMass` int(11) default '100' COMMENT 'Player''s body mass',
  `SaveRecurse` tinyint(1) default NULL COMMENT 'Is it a recursive save? (LIB_PERSIST)',
  `Saved` varchar(255) default NULL COMMENT 'Array of ??? (LIB_PERSIST)',
  `HealthPoints` int(11) default '1' COMMENT 'HP',
  `MagicPoints` int(11) default '0' COMMENT 'MP',
  `ExperiencePoints` int(11) default '0' COMMENT 'XP',
  `QuestPoints` int(11) default '0' COMMENT 'QP',
  `melee` tinyint(1) default '1' COMMENT 'Can the player fight without weapons?',
  `Alcohol` int(11) default '0' COMMENT 'How much alcohol they''ve got in them',
  `Caffeine` int(11) default '0' COMMENT 'How much caffeine the''ve got in them',
  `Food` int(11) default '0' COMMENT 'How much food they''ve got in them',
  `Drink` int(11) default '0' COMMENT 'How much drink they''ve got in them',
  `Poison` int(11) default '0' COMMENT 'How much poison they''ve got in them',
  `Sleeping` tinyint(1) default NULL,
  `DeathEvents` varchar(255) default NULL COMMENT 'Whether the user still has to see the death events??',
  `StaminaPoints` float default NULL,
  `Torso` varchar(25) default NULL COMMENT 'What body part is their torso? ie ''torso'', ''abdomen'', etc',
  `Biter` tinyint(1) default '0' COMMENT 'Does this user''s race bite as an attack?',
  `Fingers` text COMMENT 'Mapping of limbs and how many fingers on each',
  `Limbs` text COMMENT 'Mapping of limbs, their class, health, and children',
  `MissingLimbs` varchar(255) default NULL COMMENT 'Mapping of missing limbs',
  `ExtraChannels` text COMMENT 'Array of extra channels the user can listen to',
  `Agent` varchar(255) default NULL COMMENT '???',
  `Blind` tinyint(1) default '0',
  `CustomStats` int(11) default '0' COMMENT 'How many more stat points can the user assign?',
  `LightSensitivity` varchar(255) default NULL COMMENT 'Array of light sensitivity',
  `Resistance` varchar(255) default NULL COMMENT 'Mapping of resistances',
  `Stats` text COMMENT 'Mapping of Stats, their class, level, and points',
  `Polyglot` tinyint(1) default '0' COMMENT 'Is the user polyglottized?',
  `Languages` text COMMENT 'Mapping of user''s languages, their proper name, level, points, and whether a native speaker',
  `DefaultLanguage` varchar(25) default 'english',
  `Town` varchar(25) default NULL,
  `Race` varchar(25) default NULL,
  `Gender` varchar(8) default 'male',
  `Level` int(11) default '1',
  `Skills` text COMMENT 'Mapping of a user''s skills, their class, level and points.',
  `Morality` int(11) default NULL COMMENT 'A user''s morality value. Positive or Negative',
  `Class` varchar(25) default NULL,
  `Clan` varchar(25) default NULL,
  `SkillModifiers` varchar(255) default NULL COMMENT 'Mapping of user''s skill modifiers',
  `Religion` varchar(50) default NULL COMMENT 'Array of a user''s religion',
  `Wimpy` int(11) default NULL COMMENT 'Percentage of Health the user wimpies out on',
  `Dead` tinyint(1) default '0',
  `WimpyCommand` varchar(100) default 'go back' COMMENT 'What the user does when they wimpy',
  `Currency` varchar(255) default NULL COMMENT 'Mapping of the user''s money on-hand',
  `Bank` varchar(255) default NULL COMMENT 'Mapping of the user''s bank accounts',
  `Spellbook` text COMMENT 'Mapping of the user''s spells and levels',
  `isPK` tinyint(1) default NULL,
  `Attackable` tinyint(1) default NULL,
  `NoCondition` tinyint(1) default NULL,
  `Titles` text COMMENT 'Array of titles gained',
  `Muffed` text COMMENT 'People muffed',
  `Quests` text COMMENT 'Array of quests and when they were completed',
  `TrainingPoints` int(11) default NULL COMMENT 'How many training points the user has',
  `TitleLength` tinyint(4) default NULL COMMENT '(Players): How many titles? 1 or 2?',
  `CreatorAge` int(11) default NULL COMMENT 'How long has the user been a creator?',
  `CreatorBirth` timestamp NULL default NULL COMMENT 'Unix time the user became a creator.',
  `CarriedMass` int(11) default NULL,
  `Retain` tinyint(1) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `Name_2` (`Name`),
  KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Player Data' AUTO_INCREMENT=7 ;

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

--
-- Table structure for table `LIB_ROOM`
--
-- Creation: Feb 20, 2008 at 02:08 PM
-- Last update: Feb 20, 2008 at 02:08 PM
--

CREATE TABLE IF NOT EXISTS `LIB_ROOM` (
  `ID` int(11) NOT NULL auto_increment,
  `ActionChance` int(11) default NULL,
  `ActionVal` text,
  `ActionsMap` text,
  `Frequency` int(11) default NULL,
  `TerrainType` tinyint(2) default NULL,
  `Bury` varchar(255) default NULL,
  `DayLong` text,
  `NightLong` text,
  `Climate` varchar(25) default NULL,
  `Gravity` float default NULL,
  `DayLight` tinyint(4) default NULL,
  `NightLight` tinyint(4) default NULL,
  `Items` text,
  `Listen` text,
  `NoReplace` tinyint(2) default NULL,
  `PlayerKill` tinyint(2) default NULL,
  `PoisonGas` int(11) default NULL,
  `Read` text,
  `Shade` tinyint(2) default NULL,
  `Search` text,
  `Smell` text,
  `Touch` text,
  `Town` varchar(50) default NULL,
  `CustomInclude` text,
  `CustomCreate` text,
  `CustomInit` text,
  `CustomFunc` text,
  `NoClean` tinyint(2) default NULL,
  `Opacity` int(11) default '100',
  `Enters` text,
  `EnterMessage` varchar(255) default NULL,
  `Exits` text,
  `GoMessage` varchar(255) default NULL,
  `ObviousExits` varchar(50) default NULL,
  `Sky` varchar(255) default NULL,
  `NoModify` tinyint(2) default NULL,
  `Short` varchar(100) NOT NULL COMMENT 'LIB_DESCRIPTION',
  `InventoryCheck` text COMMENT 'LIB_INVENTORY',
  `Inventory` text COMMENT 'LIB_INVENTORY',
  `Money` varchar(255) default NULL COMMENT 'LIB_MONEY',
  `Invis` varchar(255) default NULL COMMENT 'LIB_LOOK',
  `AmbientLight` text COMMENT 'LIB_AMBIANCE',
  `Reads` int(11) default NULL,
  `Language` varchar(50) default NULL,
  `Properties` text,
  `Long` text,
  `CanFly` tinyint(2) default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `LOG_CHAT`
--
-- Creation: Aug 20, 2008 at 04:42 PM
-- Last update: Nov 11, 2008 at 06:21 PM
-- Last check: Oct 28, 2008 at 08:36 PM
--

CREATE TABLE IF NOT EXISTS `LOG_CHAT` (
  `ID` int(11) NOT NULL auto_increment,
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Channel` int(11) NOT NULL,
  `Who` int(11) NOT NULL,
  `What` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=93594 ;

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

--
-- Table structure for table `LOG_CHAT_CHANNELS`
--
-- Creation: Aug 20, 2008 at 04:42 PM
-- Last update: Oct 29, 2008 at 09:34 PM
-- Last check: Oct 28, 2008 at 08:36 PM
--

CREATE TABLE IF NOT EXISTS `LOG_CHAT_CHANNELS` (
  `ID` tinyint(4) NOT NULL auto_increment,
  `Name` varchar(25) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

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

--
-- Table structure for table `LOG_CHAT_CHATTERS`
--
-- Creation: Aug 20, 2008 at 04:42 PM
-- Last update: Nov 11, 2008 at 12:44 AM
-- Last check: Oct 28, 2008 at 08:36 PM
--

CREATE TABLE IF NOT EXISTS `LOG_CHAT_CHATTERS` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=521 ;

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

--
-- Table structure for table `LOG_CONNECT`
--
-- Creation: Feb 20, 2008 at 08:39 PM
-- Last update: Jul 11, 2008 at 06:54 PM
-- Last check: Aug 01, 2008 at 10:15 PM
--

CREATE TABLE IF NOT EXISTS `LOG_CONNECT` (
  `ID` int(11) NOT NULL auto_increment,
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Who` int(11) NOT NULL COMMENT 'From LIB_PLAYERS',
  `What` char(1) NOT NULL,
  `Host` int(11) NOT NULL COMMENT 'From LOG_HOST',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=114 ;

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

--
-- Table structure for table `LOG_DEATHS`
--
-- Creation: Aug 04, 2008 at 03:48 PM
-- Last update: Aug 13, 2008 at 04:38 PM
-- Last check: Aug 18, 2008 at 04:31 PM
--

CREATE TABLE IF NOT EXISTS `LOG_DEATHS` (
  `ID` bigint(11) NOT NULL auto_increment,
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT 'When it happened',
  `Killer` int(11) default NULL COMMENT 'ID Number of the Killer from LIB_NPC',
  `Victim` int(11) NOT NULL COMMENT 'ID of the player, from LIB_PLAYERS',
  `Reason` int(11) default NULL COMMENT 'Either need a Killer in the Killer field or a Reason for death in this field.',
  PRIMARY KEY  (`ID`),
  KEY `Reason` (`Reason`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table `LOG_DEATHS_REASONS`
--
-- Creation: Aug 04, 2008 at 03:28 PM
-- Last update: Aug 13, 2008 at 05:13 PM
-- Last check: Aug 18, 2008 at 04:31 PM
--

CREATE TABLE IF NOT EXISTS `LOG_DEATHS_REASONS` (
  `ID` tinyint(4) NOT NULL auto_increment,
  `Reason` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `File` (`Reason`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

--
-- Table structure for table `LOG_FILE`
--
-- Creation: Mar 04, 2008 at 12:13 AM
-- Last update: Aug 02, 2008 at 09:53 PM
-- Last check: Aug 01, 2008 at 10:15 PM
--

CREATE TABLE IF NOT EXISTS `LOG_FILE` (
  `FileID` tinyint(4) NOT NULL,
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Message` varchar(1000) NOT NULL,
  `ID` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=969 ;

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

--
-- Table structure for table `LOG_FILE_FILES`
--
-- Creation: Mar 03, 2008 at 11:59 PM
-- Last update: Aug 02, 2008 at 09:48 PM
-- Last check: Aug 01, 2008 at 10:15 PM
--

CREATE TABLE IF NOT EXISTS `LOG_FILE_FILES` (
  `ID` tinyint(4) NOT NULL auto_increment,
  `File` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `File` (`File`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

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

--
-- Table structure for table `LOG_HOST`
--
-- Creation: Feb 20, 2008 at 08:52 PM
-- Last update: Feb 24, 2008 at 12:10 AM
-- Last check: Aug 01, 2008 at 10:15 PM
--

CREATE TABLE IF NOT EXISTS `LOG_HOST` (
  `ID` int(11) NOT NULL auto_increment,
  `Host` varchar(50) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `Host` (`Host`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

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

--
-- Table structure for table `MISC`
--
-- Creation: Aug 02, 2008 at 09:58 PM
-- Last update: Oct 28, 2008 at 08:38 PM
-- Last check: Oct 28, 2008 at 08:36 PM
--

CREATE TABLE IF NOT EXISTS `MISC` (
  `Name` varchar(25) NOT NULL,
  `Value` varchar(75) NOT NULL,
  KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Stand-in structure for view `VIEW_CHATLOG`
--
CREATE TABLE IF NOT EXISTS `VIEW_CHATLOG` (
`Time` timestamp
,`Channel` varchar(25)
,`Username` varchar(50)
,`Message` text
);
-- --------------------------------------------------------

--
-- Structure for view `VIEW_CHATLOG`
--
DROP TABLE IF EXISTS `VIEW_CHATLOG`;

CREATE VIEW `mud`.`VIEW_CHATLOG` AS select `mud`.`LOG_CHAT`.`Timestamp` AS `Time`,`mud`.`LOG_CHAT_CHANNELS`.`Name` AS `Channel`,`mud`.`LOG_CHAT_CHATTERS`.`Name` AS `Username`,`mud`.`LOG_CHAT`.`What` AS `Message` from ((`mud`.`LOG_CHAT` join `mud`.`LOG_CHAT_CHANNELS`) join `mud`.`LOG_CHAT_CHATTERS`) where ((`mud`.`LOG_CHAT`.`Channel` = `mud`.`LOG_CHAT_CHANNELS`.`ID`) and (`mud`.`LOG_CHAT`.`Who` = `mud`.`LOG_CHAT_CHATTERS`.`ID`));