-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.18-nt


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

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


--
-- Create schema kaladea_db
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ kaladea_db;
USE kaladea_db;

--
-- Table structure for table `kaladea_db`.`disabled_commands`
--

DROP TABLE IF EXISTS `disabled_commands`;
CREATE TABLE `disabled_commands` (
  `command` varchar(100) NOT NULL default '',
  `disabler` varchar(100) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kaladea_db`.`disabled_commands`
--

/*!40000 ALTER TABLE `disabled_commands` DISABLE KEYS */;
/*!40000 ALTER TABLE `disabled_commands` ENABLE KEYS */;


--
-- Table structure for table `kaladea_db`.`help`
--

DROP TABLE IF EXISTS `help`;
CREATE TABLE `help` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `text` text NOT NULL,
  `author` varchar(20) NOT NULL default '',
  `creation_date` varchar(40) NOT NULL default '',
  `last_update` varchar(40) NOT NULL default '',
  `permission` varchar(45) NOT NULL default '',
  `name` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kaladea_db`.`help`
--

/*!40000 ALTER TABLE `help` DISABLE KEYS */;
INSERT INTO `help` (`id`,`text`,`author`,`creation_date`,`last_update`,`permission`,`name`) VALUES 
 (1,'The look command displays the room\'s basic description, people who (visibly) share the room with you, and any common exits you may take.','Odis','Tue Jan 31 2006 12:34:56','Tue Jan 31 2006 12:34:56','player','look'),
 (3,'This command will initiate a copyover to run the mud off a new binary.','Odis','Tue Jan 31 2006 22:45:01','Tue Jan 31 2006 22:50:19','imp','reboot'),
 (6,'The shutdown command will shutdown the mud correctly and kill off all outstanding connections.','Odis','Tue Jan 31 2006 23:06:17','Tue Jan 31 2006 23:06:41','imp','shutdown'),
 (5,'The hedit command is used to access the help file editing interface. Through it you can update, view, revise, and/or create help files and set their parameters.','Odis','Tue Jan 31 2006 23:04:49','Tue Jan 31 2006 23:05:59','imp','hedit'),
 (7,'Implementors may change the permission\'s (or groups) of a user with this command. Used to bypass using the edit interface.','Odis','Tue Jan 31 2006 23:06:50','Tue Jan 31 2006 23:07:30','imp','changeperm'),
 (8,'Used to edit characteristics of avatars.','Odis','Tue Jan 31 2006 23:09:59','Tue Jan 31 2006 23:10:17','imp','edit');
INSERT INTO `help` (`id`,`text`,`author`,`creation_date`,`last_update`,`permission`,`name`) VALUES 
 (9,'The disable command is used to disable commands within the mud and make them unusable. To enable, simply use the command again.','Odis','Tue Jan 31 2006 23:10:29','Tue Jan 31 2006 23:11:14','imp','disable');
/*!40000 ALTER TABLE `help` ENABLE KEYS */;


--
-- Table structure for table `kaladea_db`.`room`
--

DROP TABLE IF EXISTS `room`;
CREATE TABLE `room` (
  `room_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default 'An Endless Void',
  `description` text NOT NULL,
  `exits` text NOT NULL,
  `version` int(10) unsigned NOT NULL default '1',
  `vnum` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`room_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kaladea_db`.`room`
--

/*!40000 ALTER TABLE `room` DISABLE KEYS */;
INSERT INTO `room` (`room_id`,`name`,`description`,`exits`,`version`,`vnum`) VALUES 
 (1,'Limbo','Puff the magic dragon, who lives by the sea...','south 2;southwest 3;',1,1),
 (2,'South of Limbo','The dragon is near.','north 1;west 3;',1,2),
 (3,'Southwest of Limbo','You smell a dragon.','east 2;northeast 1;southeast 4;',1,3),
 (4,'Nearing the Abyss','Magnificent colors swirl all around.','east 8;northwest 3;south 6;',1,4),
 (5,'Shining Light','A gigantic shining light shines in the distance...','north 4;south 5;',1,6),
 (6,'Closer to civilization','The tunnel ends and a city street is visible.','north 6;south 7;',1,5),
 (7,'Civilization','Oh my, civilization.','north 5;south 9;',1,7),
 (8,'Blah','test','north 7;',1,9),
 (9,'Holla','Wooty.','west 4;',1,8);
/*!40000 ALTER TABLE `room` ENABLE KEYS */;


--
-- Table structure for table `kaladea_db`.`tasks`
--

DROP TABLE IF EXISTS `tasks`;
CREATE TABLE `tasks` (
  `task_id` int(10) unsigned NOT NULL auto_increment,
  `post_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `poster` varchar(45) NOT NULL default '',
  `for_who` varchar(45) NOT NULL default '',
  `type` enum('Building','Coding','Idea','Typo','General') NOT NULL default 'General',
  `problem` text,
  `level` enum('Low','Medium','High','Supreme') NOT NULL default 'Low',
  `due_date` datetime default NULL,
  `solve_date` datetime default NULL,
  `public` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`task_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kaladea_db`.`tasks`
--

/*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
INSERT INTO `tasks` (`task_id`,`post_date`,`poster`,`for_who`,`type`,`problem`,`level`,`due_date`,`solve_date`,`public`) VALUES 
 (1,'2006-01-17 12:58:21','Odis','Odis','Coding','Finish this!','Medium','2006-01-17 12:58:21','2006-01-17 12:58:21',0);
/*!40000 ALTER TABLE `tasks` ENABLE KEYS */;


--
-- Table structure for table `kaladea_db`.`user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `username` varchar(100) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  `_group` varchar(100) NOT NULL default 'player',
  `login` varchar(100) NOT NULL default '',
  `reply` varchar(100) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `prompt` varchar(100) NOT NULL default '',
  `last_room` varchar(10) NOT NULL default '1',
  `version` int(10) unsigned NOT NULL default '1',
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;

--
-- Dumping data for table `kaladea_db`.`user`
--

/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`username`,`password`,`_group`,`login`,`reply`,`title`,`prompt`,`last_room`,`version`) VALUES 
 ('Odis','dragon','player imp admin enforcer','Wed Mar 15 2006 02:47:15','gabe',' God of All','>','3',1),
 ('Gabe','dragon','player admin enforcer','Wed Jan 25 2006 19:49:19','odis',' the Enforcer','TM: %T >%s','1',1),
 ('Syncarn','dragon','player','Tue Jan 31 2006 23:13:05','',' ','Giddy Up>','3',1);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;

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