-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 23, 2011 at 02:20 AM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `romdb`
--

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

--
-- Table structure for table `act_flags`
--

CREATE TABLE IF NOT EXISTS `act_flags` (
  `act_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`act_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `act_flags`
--

INSERT INTO `act_flags` (`act_flag_id`, `glyph`, `flag`, `description`) VALUES
(1, 'A', 'NPC', 'Mobile is an NPC (set automatically by the game)'),
(2, 'B', 'sentinel', 'Mobile doesnt wander'),
(3, 'C', 'scavenger', 'Mobile picks up items on the floor'),
(4, 'F', 'aggressive', 'Mobile attacks any character in the same room (see the section dealing with aggression)'),
(5, 'G', 'stay area', 'Mobile will not leave a zone (this should be set)'),
(6, 'H', 'wimpy', 'Mobile will fly when badly hurt'),
(7, 'J', 'pet', 'Mobile is a pet (and hence safe from attack)'),
(8, 'K', 'train', 'Mobile can train statistics'),
(9, 'U', 'noalign', 'Mobile is unaligned (unintelligent animals, golems, etc.)'),
(10, 'V', 'nopurge', 'Mobile isnt removed by the purge command'),
(11, 'W', 'outdoors', 'Mobile will not wander outside a building'),
(12, 'Y', 'indoors', 'Mobile will not wander into a building'),
(13, 'a', 'healer', 'Mobile can heal characters (i.e. the heal command)'),
(14, 'b', 'gain', 'Mobile can grant new skills (i.e. the gain command)'),
(15, 'c', 'update', 'Mobile is always updated, even in idle zones (rarely needed)'),
(16, 'd', 'changer', 'Mobile can change coins (i.e. Otho the Money Changer)');

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

--
-- Table structure for table `affect_flags`
--

CREATE TABLE IF NOT EXISTS `affect_flags` (
  `affect_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`affect_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `affect_flags`
--

INSERT INTO `affect_flags` (`affect_flag_id`, `glyph`, `flag`, `description`) VALUES
(1, 'B', 'invisible', 'Mobile is invisible'),
(2, 'C', 'detect evil', 'Mobile can sense evil'),
(3, 'D', 'detect invis', 'Mobile can see invisible'),
(4, 'E', 'detect powers', 'Mobile can see powers'),
(5, 'F', 'detect hide', 'Mobile can see hidden (sneaking/hiding) characters'),
(6, 'G', 'detect good', 'Mobile can sense good'),
(7, 'H', 'sanctuary', 'Mobile is protected by a sanctuary spell'),
(8, 'I', 'unused', 'You may enter a new value here'),
(9, 'J', 'infravision', 'Mobile can see heat sources in the dark'),
(10, 'N', 'protect evil', 'Mobile takes less damage from evil characters'),
(11, 'O', 'protect good', 'Mobile takes less damage from good characters'),
(12, 'P', 'sneaking', 'Mobile is sneaking (hard to detect while moving)'),
(13, 'Q', 'hiding', 'Mobile is hiding (cannot be seen without detect hidden)'),
(14, 'T', 'flying', 'Mobile is flying'),
(15, 'U', 'pass door', 'Mobile can walk through closed doors'),
(16, 'V', 'haste', 'Mobile is affected by a haste spell'),
(17, 'Z', 'dark vision', 'Mobile can see in the dark without a light source'),
(18, 'b', 'swimming', 'Mobile is swimming (or capable of swimming)'),
(19, 'c', 'regeneration', 'Mobile recovers hit points and mana faster than usual');

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

--
-- Table structure for table `areas`
--

CREATE TABLE IF NOT EXISTS `areas` (
  `area_id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(100) NOT NULL,
  `min_level` int(11) NOT NULL,
  `max_level` int(11) NOT NULL,
  `detail` varchar(255) NOT NULL,
  `vnum_first` int(11) NOT NULL,
  `vnum_last` int(11) NOT NULL,
  PRIMARY KEY (`area_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `attack_flags`
--

CREATE TABLE IF NOT EXISTS `attack_flags` (
  `attack_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`attack_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `attack_flags`
--

INSERT INTO `attack_flags` (`attack_flag_id`, `glyph`, `flag`, `description`) VALUES
(1, 'A', 'summon', 'Summoning'),
(2, 'B', 'unused', 'You may enter a value here'),
(3, 'C', 'powers', 'All powers (be very careful using this flag)'),
(4, 'D', 'weapons', 'All physical attacks (be very careful using this flag)'),
(5, 'E', 'bash', 'Blunt weapons'),
(6, 'F', 'pierce', 'Piercing weapons'),
(7, 'G', 'slash', 'Slashing weapons'),
(8, 'H', 'Fire', 'Flame and heat attacks'),
(9, 'I', 'Cold', 'Cold and ice attacks'),
(10, 'J', 'Lightning', 'Electrical attacks'),
(11, 'K', 'Acid', 'Corrosive attacks'),
(12, 'L', 'Poison', 'Venoms and toxic vapors'),
(13, 'M', 'Negative', 'Life draining attacks'),
(14, 'N', 'unused', 'You may enter a value here'),
(15, 'O', 'Energy', 'Generic powers'),
(16, 'P', 'Mental', 'Mental attacks (such as a mind flayers mind blasts)'),
(17, 'Q', 'Disease', 'Disease, from the common cold to the black death'),
(18, 'R', 'Drowning', 'Watery attacks and suffocation'),
(19, 'S', 'Light', 'Light-based attacks, whether blinding or cutting'),
(20, 'T', 'Sound', 'Sonic attacks and weapons, or deafening noises'),
(21, 'X', 'Wood', 'Wooden weapons and creatures'),
(22, 'Y', 'Silver', 'Silver or mithril weapons and creatures'),
(23, 'Z', 'Iron', 'Iron and steel weapons and creatures');

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

--
-- Table structure for table `damage_types`
--

CREATE TABLE IF NOT EXISTS `damage_types` (
  `damage_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `damage_type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`damage_type_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `damage_types`
--

INSERT INTO `damage_types` (`damage_type_id`, `damage_type`) VALUES
(1, 'bash'),
(2, 'disease'),
(3, 'light'),
(4, 'pierce'),
(5, 'drowning'),
(6, 'lightning'),
(7, 'slash'),
(8, 'energy'),
(9, 'mental acid'),
(10, 'fire'),
(11, 'negative'),
(12, 'charm'),
(13, 'harm'),
(14, 'poison'),
(15, 'cold'),
(16, 'sound');

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

--
-- Table structure for table `door_reset_flags`
--

CREATE TABLE IF NOT EXISTS `door_reset_flags` (
  `door_reset_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`door_reset_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `door_reset_flags`
--

INSERT INTO `door_reset_flags` (`door_reset_flag_id`, `glyph`, `description`) VALUES
(1, '0', 'Normal exit, no door'),
(2, 'A', 'Door that may be opened and closed, but no lock and resets to open'),
(3, 'B', 'Door resets to closed'),
(4, 'C', 'Door that is locked'),
(5, 'F', 'Door with a lock that cannot be picked (key needed to open)'),
(6, 'G', 'Door that the pass door ability will not allow passage through (the lock may still be picked)'),
(7, 'H', 'Lock that is easy to pick'),
(8, 'I', 'Lock that is hard to pick'),
(9, 'J', 'Lock that is infuriating to pick'),
(10, 'K', 'Door that cannot be closed'),
(11, 'L', 'Door that cannot be locked');

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

--
-- Table structure for table `door_states`
--

CREATE TABLE IF NOT EXISTS `door_states` (
  `door_state_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` int(11) NOT NULL,
  `state` varchar(50) NOT NULL,
  PRIMARY KEY (`door_state_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `door_states`
--

INSERT INTO `door_states` (`door_state_id`, `glyph`, `state`) VALUES
(1, 0, 'Open'),
(2, 1, 'Closed'),
(3, 2, 'Closed & Locked');

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

--
-- Table structure for table `exit_directions`
--

CREATE TABLE IF NOT EXISTS `exit_directions` (
  `exit_direction_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` int(11) NOT NULL,
  `direction` varchar(50) NOT NULL,
  PRIMARY KEY (`exit_direction_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `exit_directions`
--

INSERT INTO `exit_directions` (`exit_direction_id`, `glyph`, `direction`) VALUES
(1, 0, 'North'),
(2, 1, 'East'),
(3, 2, 'South'),
(4, 3, 'West'),
(5, 4, 'Up'),
(6, 5, 'Down');

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

--
-- Table structure for table `extra_flags`
--

CREATE TABLE IF NOT EXISTS `extra_flags` (
  `extra_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`extra_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `extra_flags`
--

INSERT INTO `extra_flags` (`extra_flag_id`, `glyph`, `flag`) VALUES
(1, 'A', '(Glowing)'),
(2, 'B', '(Humming)'),
(3, 'C', 'Dark (hidden)'),
(4, 'E', 'Evil'),
(5, 'F', 'Invis'),
(6, 'G', 'Powerful'),
(7, 'H', 'Nodrop'),
(8, 'I', 'Unused'),
(9, 'J', 'Anti-good'),
(10, 'K', 'Anti-evil'),
(11, 'L', 'Anti-Neutral'),
(12, 'M', 'Noremove'),
(13, 'N', 'Inventory'),
(14, 'O', 'Nopurge'),
(15, 'P', 'Rot_death'),
(16, 'Q', 'Vis_death'),
(17, 'R', 'Nosac'),
(18, 'T', 'Nolocate'),
(19, 'U', 'Melt_drop'),
(20, 'W', 'Sell extract'),
(21, 'Y', 'Burn proof');

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

--
-- Table structure for table `form_flags`
--

CREATE TABLE IF NOT EXISTS `form_flags` (
  `form_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`form_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Dumping data for table `form_flags`
--

INSERT INTO `form_flags` (`form_flag_id`, `glyph`, `flag`, `description`) VALUES
(1, 'A', 'edible (corpse)', 'Mobile can be eaten (corpses)'),
(2, 'B', 'poison (corpse)', 'Mobile is poisonous when eaten (should also be edible)'),
(3, 'C', 'powerful (corpse)', 'Mobiles powerful nature causes strange effects when eaten'),
(4, 'D', 'vanishes (corpse)', 'Mobile vanishes after death'),
(5, 'E', 'other (corpse)', 'Mobile is not flesh and blood (defined by material type)'),
(6, 'G', 'animal', 'Mobile is a dumb animal'),
(7, 'H', 'sentient', 'Mobile is capable of higher reasoning'),
(8, 'I', 'undead', 'Mobile is an undead, and not truly alive at all'),
(9, 'J', 'hologram', 'Mobile is a holographic construct'),
(10, 'K', 'mist', 'Mobile is a partially material mist'),
(11, 'L', 'intangible', 'Mobile is immaterial'),
(12, 'M', 'biped', 'Mobile is bipedal (like a human)'),
(13, 'N', 'centaur', 'Mobile has a humanoid torso, but a beasts lower body'),
(14, 'O', 'insect', 'Mobile is an insect'),
(15, 'P', 'spider', 'Mobile is an arachnid'),
(16, 'Q', 'crustacean', 'Mobile is a crustacean (i.e. a crab or lobster)'),
(17, 'R', 'worm', 'Mobile is a worm, that is a tube-shaped invertebrate'),
(18, 'S', 'blob', 'Mobile is a formless blob (when used with mist, a cloud)'),
(19, 'V', 'mammal', 'Mobile is a mammal'),
(20, 'W', 'bird', 'Mobile is a bird'),
(21, 'X', 'reptile', 'Mobile is a reptile (and should be cold-blooded)'),
(22, 'Y', 'snake', 'Mobile is a snake (and should be a reptile)'),
(23, 'Z', 'dragon', 'Mobile is a dragon'),
(24, 'a', 'amphibian', 'Mobile is an amphibian (and should be able to swim)'),
(25, 'b', 'fish', 'Mobile is a fish (and should be able to swim)'),
(26, 'c', 'cold blood', 'Mobile is cold-blooded');

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

--
-- Table structure for table `furniture_flags`
--

CREATE TABLE IF NOT EXISTS `furniture_flags` (
  `furniture_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`furniture_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `furniture_flags`
--

INSERT INTO `furniture_flags` (`furniture_flag_id`, `glyph`, `flag`) VALUES
(1, 'A', 'Stand at'),
(2, 'B', 'Stand on'),
(3, 'C', 'Stand in'),
(4, 'D', 'Sit at'),
(5, 'E', 'Sit on'),
(6, 'F', 'Sit in'),
(7, 'G', 'Rest at'),
(8, 'H', 'Rest on'),
(9, 'I', 'Rest in'),
(10, 'J', 'Sleep at'),
(11, 'K', 'Sleep on'),
(12, 'L', 'Sleep in'),
(13, 'M', 'Put at'),
(14, 'N', 'Put on'),
(15, 'O', 'Put in'),
(16, 'P', 'Put inside');

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

--
-- Table structure for table `liquid_types`
--

CREATE TABLE IF NOT EXISTS `liquid_types` (
  `liquid_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `liquid_type` varchar(50) DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`liquid_type_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;

--
-- Dumping data for table `liquid_types`
--

INSERT INTO `liquid_types` (`liquid_type_id`, `liquid_type`, `color`) VALUES
(1, 'water', 'clear'),
(2, 'beer', 'amber'),
(3, 'red wine', 'burgundy'),
(4, 'ale', 'brown'),
(5, 'dark ale', 'dark'),
(6, 'whisky', 'golden'),
(7, 'lemonade', 'pink'),
(8, 'firebreather', 'boiling'),
(9, 'local specialty', 'clear'),
(10, 'slime mold juice', 'green'),
(11, 'milk', 'white'),
(12, 'tea', 'tan'),
(13, 'coffee', 'black'),
(14, 'blood', 'red'),
(15, 'salt water', 'clear'),
(16, 'coke', 'brown'),
(17, 'root beer', 'brown'),
(18, 'elvish wine', 'green'),
(19, 'white wine', 'golden'),
(20, 'champagne', 'golden'),
(21, 'mead', 'honey-colored'),
(22, 'rose wine', 'pink'),
(23, 'benedictine wine', 'burgundy'),
(24, 'vodka', 'clear'),
(25, 'cranberry juice', 'red'),
(26, 'orange juice', 'orange'),
(27, 'absinthe', 'green'),
(28, 'brandy', 'golden'),
(29, 'aquavit', 'clear'),
(30, 'schnapps', 'clear'),
(31, 'icewine', 'purple'),
(32, 'amontillado', 'burgundy'),
(33, 'sherry', 'red'),
(34, 'framboise', 'red'),
(35, 'rum', 'amber'),
(36, 'cordial', 'clear');

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

--
-- Table structure for table `materials`
--

CREATE TABLE IF NOT EXISTS `materials` (
  `material_id` int(11) NOT NULL AUTO_INCREMENT,
  `material` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`material_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=87 ;

--
-- Dumping data for table `materials`
--

INSERT INTO `materials` (`material_id`, `material`) VALUES
(1, 'plastic'),
(2, 'slime'),
(3, 'jelly'),
(4, 'wax'),
(5, 'rubberoil'),
(6, 'balm'),
(7, 'cream'),
(8, 'hard'),
(9, 'soft'),
(10, 'leatherkid'),
(11, 'leather'),
(12, 'fur'),
(13, 'snakeskin'),
(14, 'gut'),
(15, 'food'),
(16, 'meat'),
(17, 'bread'),
(18, 'wood'),
(19, 'hardwood'),
(20, 'softwood'),
(21, 'bamboo'),
(22, 'ebony'),
(23, 'cork'),
(24, 'horn'),
(25, 'light'),
(26, 'laen'),
(27, 'sponge'),
(28, 'elastic'),
(29, 'silk'),
(30, 'satin'),
(31, 'lacewool'),
(32, 'linen'),
(33, 'canvas'),
(34, 'cloth'),
(35, 'velvet'),
(36, 'felt'),
(37, 'paper'),
(38, 'parchment'),
(39, 'vellum'),
(40, 'hemp'),
(41, 'feathers'),
(42, 'webbing'),
(43, 'cardboard'),
(44, 'steel'),
(45, 'gold'),
(46, 'silver'),
(47, 'mithril'),
(48, 'platinum'),
(49, 'iron'),
(50, 'lead'),
(51, 'copper'),
(52, 'electrum'),
(53, 'bronze'),
(54, 'brass'),
(55, 'wire'),
(56, 'tin'),
(57, 'pewter'),
(58, 'metal'),
(59, 'dark'),
(60, 'laen'),
(61, 'porcelain'),
(62, 'ivory'),
(63, 'marble'),
(64, 'stone'),
(65, 'quartz'),
(66, 'corundum'),
(67, 'flint'),
(68, 'lodestone'),
(69, 'granite'),
(70, 'enamel'),
(71, 'glass'),
(72, 'pottery'),
(73, 'crystal'),
(74, 'icebone'),
(75, 'shell'),
(76, 'coral'),
(77, 'energy'),
(78, 'water'),
(79, 'acid'),
(80, 'coal'),
(81, 'sandstone'),
(82, 'clay'),
(83, 'ash'),
(84, 'earth'),
(85, 'diamond'),
(86, 'nothingness');

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

--
-- Table structure for table `mobiles`
--

CREATE TABLE IF NOT EXISTS `mobiles` (
  `mobile_id` int(11) NOT NULL AUTO_INCREMENT,
  `area_id` int(11) NOT NULL,
  `vnum` varchar(100) NOT NULL,
  `name` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `alignment` int(11) DEFAULT NULL,
  `group` varchar(100) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `to_hit` int(11) DEFAULT NULL,
  `hit_dice` int(11) DEFAULT NULL,
  `power_dice` int(11) DEFAULT NULL,
  `damage` int(11) DEFAULT NULL,
  `pierce_ac` int(11) DEFAULT NULL,
  `bash_ac` int(11) DEFAULT NULL,
  `slash_ac` int(11) DEFAULT NULL,
  `power_ac` int(11) DEFAULT NULL,
  `act_flags` varchar(50) DEFAULT NULL,
  `affect_flags` varchar(50) DEFAULT NULL,
  `offensive_flags` varchar(50) DEFAULT NULL,
  `immunity_flags` varchar(50) DEFAULT NULL,
  `resistance_flags` varchar(50) DEFAULT NULL,
  `vulnerability_flags` varchar(50) DEFAULT NULL,
  `form_flags` varchar(50) DEFAULT NULL,
  `part_flags` varchar(50) DEFAULT NULL,
  `treasure` int(11) DEFAULT NULL,
  `damage_type` int(11) DEFAULT NULL,
  `gender` int(11) DEFAULT NULL,
  `start_position` int(11) DEFAULT NULL,
  `default_position` int(11) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `race` int(11) NOT NULL,
  `material` int(11) DEFAULT NULL,
  PRIMARY KEY (`mobile_id`),
  KEY `area_id` (`area_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `modifier_locations`
--

CREATE TABLE IF NOT EXISTS `modifier_locations` (
  `modifier_location_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` int(11) NOT NULL,
  `location` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`modifier_location_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `modifier_locations`
--

INSERT INTO `modifier_locations` (`modifier_location_id`, `glyph`, `location`) VALUES
(1, 1, 'Strength'),
(2, 2, 'Dexterity'),
(3, 3, 'Intelligence'),
(4, 4, 'Wisdom'),
(5, 5, 'Constitution'),
(6, 6, 'Gender'),
(7, 7, 'Charisma'),
(8, 12, 'Power'),
(9, 13, 'Hitpoints'),
(10, 14, 'Movement'),
(11, 17, 'AC'),
(12, 18, 'Hitroll'),
(13, 19, 'Damroll'),
(14, 20, 'Power');

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

--
-- Table structure for table `objects`
--

CREATE TABLE IF NOT EXISTS `objects` (
  `object_id` int(11) NOT NULL AUTO_INCREMENT,
  `area_id` int(11) NOT NULL,
  `vnum` varchar(50) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `short_description` varchar(255) DEFAULT NULL,
  `long_description` varchar(255) DEFAULT NULL,
  `material` int(11) DEFAULT NULL,
  `object_type` int(11) DEFAULT NULL,
  `extra_flags` varchar(50) DEFAULT NULL,
  `wear_flags` varchar(50) DEFAULT NULL,
  `v0` varchar(50) DEFAULT NULL,
  `v1` varchar(50) DEFAULT NULL,
  `v2` varchar(50) DEFAULT NULL,
  `v3` varchar(50) DEFAULT NULL,
  `v4` varchar(50) DEFAULT NULL,
  `level` int(11) NOT NULL,
  `weight` int(11) NOT NULL,
  `cost` int(11) NOT NULL,
  PRIMARY KEY (`object_id`),
  KEY `area_id` (`area_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `object_affect_flags`
--

CREATE TABLE IF NOT EXISTS `object_affect_flags` (
  `object_affect_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`object_affect_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `object_affect_flags`
--

INSERT INTO `object_affect_flags` (`object_affect_id`, `glyph`, `flag`) VALUES
(1, 'A', 'Blind'),
(2, 'B', 'Invisible'),
(3, 'C', 'Detect_evil'),
(4, 'D', 'Detect_invis'),
(5, 'E', 'Detect_magic'),
(6, 'F', 'Detect_hidden'),
(7, 'G', 'Detect good'),
(8, 'H', 'Sanctuary'),
(9, 'J', 'Infrared'),
(10, 'M', 'Poisoned'),
(11, 'N', 'Prot_evil'),
(12, 'O', 'Prot good'),
(13, 'P', 'Sneak'),
(14, 'Q', 'Hide'),
(15, 'R', 'Sleep'),
(16, 'T', 'Flying'),
(17, 'U', 'Pass_door'),
(18, 'V', 'Haste'),
(19, 'W', 'Calm'),
(20, 'X', 'Plague'),
(21, 'Y', 'Weaken'),
(22, 'Z', 'Dark_vis'),
(23, 'a', 'Berserk'),
(24, 'c', 'Regen.'),
(25, 'd', 'Slow');

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

--
-- Table structure for table `object_extra_descriptions`
--

CREATE TABLE IF NOT EXISTS `object_extra_descriptions` (
  `object_extra_description_id` int(11) NOT NULL AUTO_INCREMENT,
  `object_id` int(11) NOT NULL,
  `extra_keywords` varchar(255) NOT NULL,
  `extra_description` text NOT NULL,
  PRIMARY KEY (`object_extra_description_id`),
  KEY `object_id` (`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `object_modifiers`
--

CREATE TABLE IF NOT EXISTS `object_modifiers` (
  `object_modifier_id` int(11) NOT NULL AUTO_INCREMENT,
  `object_id` int(11) NOT NULL,
  `modifier_location` int(11) NOT NULL,
  `modifier` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`object_modifier_id`),
  KEY `object_id` (`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `object_types`
--

CREATE TABLE IF NOT EXISTS `object_types` (
  `object_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `object_type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`object_type_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `object_types`
--

INSERT INTO `object_types` (`object_type_id`, `object_type`) VALUES
(1, 'weapon'),
(2, 'armor'),
(3, 'container'),
(4, 'light'),
(5, 'food'),
(6, 'drink'),
(7, 'money'),
(8, 'wand'),
(9, 'staff'),
(10, 'potion'),
(11, 'scroll'),
(12, 'pill'),
(13, 'furniture'),
(14, 'portal'),
(15, 'innkey'),
(16, 'clothing'),
(17, 'fountain'),
(18, 'key'),
(19, 'boat'),
(20, 'map'),
(21, 'warpstone'),
(22, 'treasure'),
(23, 'jewelry'),
(24, 'gem'),
(25, 'trash');

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

--
-- Table structure for table `offensive_flags`
--

CREATE TABLE IF NOT EXISTS `offensive_flags` (
  `offensive_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`offensive_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `offensive_flags`
--

INSERT INTO `offensive_flags` (`offensive_flag_id`, `glyph`, `flag`, `description`) VALUES
(1, 'B', 'backstab', 'Mobile can backstab to start a combat'),
(2, 'C', 'bash', 'Mobile can bash characters off their feet'),
(3, 'D', 'berserk', 'Mobile may go berserk in a fight'),
(4, 'E', 'disarm', 'Mobile can disarm _without_ a weapon wielded'),
(5, 'F', 'dodge', 'Mobile dodges blows'),
(6, 'G', 'fade', 'Mobile can fade "out of phase" to avoid blows'),
(7, 'H', 'fast', 'Mobile is faster than most others, so has extra attacks'),
(8, 'I', 'kick', 'Mobile can kick in combat for extra damage'),
(9, 'J', 'kick dirt', 'Mobile kicks dirt, blinding opponents'),
(10, 'K', 'parry', 'Mobile can parry _without_ a weapon wielded'),
(11, 'L', 'rescue', 'Mobile may rescue allies in a fight'),
(12, 'M', 'tail', 'Mobile can legsweep with its tail or tentacles'),
(13, 'N', 'trip', 'Mobile trips in combat'),
(14, 'O', 'crush', 'Mobile can crush opponents in its arms'),
(15, 'P', 'all', 'Mobile helps all other mobiles in combat'),
(16, 'Q', 'align', 'Mobile assists mobiles of like alignment'),
(17, 'R', 'race', 'Mobile will assist other mobiles of the same race'),
(18, 'S', 'players', 'Mobile will assist players (by race/alignment)'),
(19, 'T', 'guard', 'Mobile assists as a cityguard'),
(20, 'U', 'vnum', 'Mobile assists mobiles of the same number only');

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

--
-- Table structure for table `part_flags`
--

CREATE TABLE IF NOT EXISTS `part_flags` (
  `part_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`part_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `part_flags`
--

INSERT INTO `part_flags` (`part_flag_id`, `glyph`, `flag`, `description`) VALUES
(1, 'A', 'head', 'Mobile has a head'),
(2, 'B', 'arms', 'Mobile has arm(s) (usually assumed to be 2)'),
(3, 'C', 'legs', 'Mobile has leg(s)'),
(4, 'D', 'heart', 'Mobile has a heart'),
(5, 'E', 'brains', 'Mobile has brains (not all mobs with heads have brains)'),
(6, 'F', 'guts', 'Mobile has intestines'),
(7, 'G', 'hands', 'Mobile has hands capable of manipulating objects'),
(8, 'H', 'feet', 'Mobile has feet'),
(9, 'I', 'fingers', 'Mobile has fingers capable of wearing rings'),
(10, 'J', 'ear', 'Mobile has ear(s)'),
(11, 'K', 'eye', 'Mobile has eye(s)'),
(12, 'L', 'tongue', 'Mobile has a _long_ tongue (like a lizard)'),
(13, 'M', 'eyestalks', 'Mobile has eyestalks (it should also have eyes)'),
(14, 'N', 'tentacles', 'Mobile has one or more tentacles'),
(15, 'O', 'fins', 'Mobile has fins'),
(16, 'P', 'wings', 'Mobile has wings'),
(17, 'Q', 'tail', 'Mobile has a usable tail (no stubs)'),
(18, 'U', 'claws', 'Mobile has combat-capable claws'),
(19, 'V', 'fangs', 'Mobile has combat-capable teeth'),
(20, 'W', 'horns', 'Mobile has horns, not necessarily dangerous ones'),
(21, 'X', 'scales', 'Mobile is covered with scales'),
(22, 'Y', 'tusks', 'Mobile has some teeth elongated into tusks');

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

--
-- Table structure for table `positions`
--

CREATE TABLE IF NOT EXISTS `positions` (
  `position_id` int(11) NOT NULL AUTO_INCREMENT,
  `position` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`position_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `positions`
--

INSERT INTO `positions` (`position_id`, `position`) VALUES
(1, 'stand'),
(2, 'sit'),
(3, 'rest'),
(4, 'sleep');

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

--
-- Table structure for table `races`
--

CREATE TABLE IF NOT EXISTS `races` (
  `race_id` int(11) NOT NULL AUTO_INCREMENT,
  `race` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`race_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `races`
--

INSERT INTO `races` (`race_id`, `race`) VALUES
(1, 'bat'),
(2, 'bear'),
(3, 'cat');

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

--
-- Table structure for table `resets`
--

CREATE TABLE IF NOT EXISTS `resets` (
  `reset_id` int(11) NOT NULL AUTO_INCREMENT,
  `area_id` int(11) NOT NULL,
  `reset_type` int(11) NOT NULL,
  `v1` varchar(100) DEFAULT NULL,
  `v2` varchar(100) DEFAULT NULL,
  `v3` varchar(100) DEFAULT NULL,
  `v4` varchar(100) DEFAULT NULL,
  `v5` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`reset_id`),
  KEY `area_id` (`area_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `reset_types`
--

CREATE TABLE IF NOT EXISTS `reset_types` (
  `reset_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` int(11) NOT NULL,
  `reset_type` varchar(100) NOT NULL,
  PRIMARY KEY (`reset_type_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `reset_types`
--

INSERT INTO `reset_types` (`reset_type_id`, `glyph`, `reset_type`) VALUES
(1, 0, 'load a mobile into a room'),
(2, 0, 'load an object into a room'),
(3, 0, 'put an object in an object (gold in a safe, etc.)'),
(4, 0, 'give an object to mobile'),
(5, 0, 'equip an object to mobile'),
(6, 0, 'set state of door');

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

--
-- Table structure for table `reset_wear_locations`
--

CREATE TABLE IF NOT EXISTS `reset_wear_locations` (
  `reset_wear_location_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` int(11) NOT NULL,
  `location` varchar(50) NOT NULL,
  PRIMARY KEY (`reset_wear_location_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `reset_wear_locations`
--

INSERT INTO `reset_wear_locations` (`reset_wear_location_id`, `glyph`, `location`) VALUES
(1, 1, 'Left finger'),
(2, 2, 'Right finger'),
(3, 3, 'Neck (1)'),
(4, 4, 'Neck (2)'),
(5, 5, 'On Torso'),
(6, 6, 'Head'),
(7, 7, 'Legs'),
(8, 8, 'Feet'),
(9, 9, 'Hands'),
(10, 10, 'Arms'),
(11, 11, 'Shield'),
(12, 12, 'About body'),
(13, 13, 'Waist'),
(14, 14, 'Left Wrist'),
(15, 15, 'Right Wrist'),
(16, 16, 'Wield'),
(17, 17, 'Held'),
(18, 18, 'Floating');

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

--
-- Table structure for table `rooms`
--

CREATE TABLE IF NOT EXISTS `rooms` (
  `room_id` int(11) NOT NULL AUTO_INCREMENT,
  `area_id` int(11) NOT NULL,
  `vnum` varchar(50) DEFAULT NULL,
  `header` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `room_flags` varchar(50) DEFAULT NULL,
  `ap_recovery` int(11) DEFAULT NULL,
  `hp_recovery` int(11) DEFAULT NULL,
  `clan` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`room_id`),
  KEY `area_id` (`area_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `room_exits`
--

CREATE TABLE IF NOT EXISTS `room_exits` (
  `room_exit_id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL,
  `exit_direction` int(11) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `door_keyword` varchar(100) DEFAULT NULL,
  `door_state` int(11) NOT NULL,
  `exit_vnum` varchar(50) NOT NULL,
  `key_vnum` varchar(50) NOT NULL,
  PRIMARY KEY (`room_exit_id`),
  KEY `room_id` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `room_extra_descriptions`
--

CREATE TABLE IF NOT EXISTS `room_extra_descriptions` (
  `room_extra_description_id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL,
  `extra_keywords` varchar(255) NOT NULL,
  `extra_description` text NOT NULL,
  PRIMARY KEY (`room_extra_description_id`),
  KEY `room_id` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `room_flags`
--

CREATE TABLE IF NOT EXISTS `room_flags` (
  `room_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`room_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `room_flags`
--

INSERT INTO `room_flags` (`room_flag_id`, `glyph`, `flag`, `description`) VALUES
(1, 'A', 'Dark', 'A light source must be carried to see in this room'),
(2, 'C', 'No Mob', 'Monsters cannot enter this room'),
(3, 'D', 'Indoors', 'Room is inside (i.e. not affected by weather)'),
(4, 'J', 'Private', 'Room is limited to two characters (i.e. chat rooms)'),
(5, 'K', 'Safe', 'Safe from pkilling and aggressive mobs'),
(6, 'L', 'Solitary', 'One character only can enter this room'),
(7, 'M', 'Petshop', 'see addendum about pet shops'),
(8, 'N', 'No Recall', 'players cannot use the recall command to leave this room');

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

--
-- Table structure for table `sector_types`
--

CREATE TABLE IF NOT EXISTS `sector_types` (
  `sector_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` int(11) NOT NULL,
  `sector_type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`sector_type_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `sector_types`
--

INSERT INTO `sector_types` (`sector_type_id`, `glyph`, `sector_type`) VALUES
(1, 0, 'Inside'),
(2, 1, 'City'),
(3, 2, 'Field'),
(4, 3, 'Forest'),
(5, 4, 'Hills'),
(6, 5, 'Mountain'),
(7, 6, 'Water'),
(8, 7, 'Deep Water (need boat)'),
(9, 9, 'Air'),
(10, 10, 'Desert');

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

--
-- Table structure for table `shops`
--

CREATE TABLE IF NOT EXISTS `shops` (
  `shop_id` int(11) NOT NULL AUTO_INCREMENT,
  `area_id` int(11) NOT NULL,
  `keeper` int(11) NOT NULL,
  `item_type1` int(11) DEFAULT NULL,
  `item_type2` int(11) DEFAULT NULL,
  `item_type3` int(11) DEFAULT NULL,
  `item_type4` int(11) DEFAULT NULL,
  `item_type5` int(11) DEFAULT NULL,
  `profit_buy` int(11) DEFAULT NULL,
  `profit_sell` int(11) DEFAULT NULL,
  `hours_open` int(11) DEFAULT NULL,
  `hours_close` int(11) DEFAULT NULL,
  PRIMARY KEY (`shop_id`),
  KEY `area_id` (`area_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `shop_item_types`
--

CREATE TABLE IF NOT EXISTS `shop_item_types` (
  `shop_item_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` int(11) NOT NULL,
  `shop_item_type` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`shop_item_type_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `shop_item_types`
--

INSERT INTO `shop_item_types` (`shop_item_type_id`, `glyph`, `shop_item_type`) VALUES
(1, 1, 'Light'),
(2, 2, 'Scroll'),
(3, 3, 'Wand'),
(4, 4, 'Staff'),
(5, 5, 'Weapon'),
(6, 8, 'Treasure'),
(7, 9, 'Armor'),
(8, 10, 'Potion'),
(9, 11, 'Clothing'),
(10, 12, 'Furniture'),
(11, 15, 'Container'),
(12, 17, 'Drink container'),
(13, 22, 'Boat'),
(14, 26, 'Pill'),
(15, 28, 'Map'),
(16, 29, 'Portal'),
(17, 30, 'Warpstone'),
(18, 32, 'Gem'),
(19, 33, 'Jewelry');

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

--
-- Table structure for table `specials`
--

CREATE TABLE IF NOT EXISTS `specials` (
  `special_id` int(11) NOT NULL AUTO_INCREMENT,
  `area_id` int(11) NOT NULL,
  `mobile` int(11) NOT NULL,
  `special_function` int(11) NOT NULL,
  PRIMARY KEY (`special_id`),
  KEY `area_id` (`area_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `special_functions`
--

CREATE TABLE IF NOT EXISTS `special_functions` (
  `special_function_id` int(11) NOT NULL AUTO_INCREMENT,
  `special_function` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`special_function_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `special_functions`
--

INSERT INTO `special_functions` (`special_function_id`, `special_function`, `description`) VALUES
(1, 'breath_acid', 'Mobile breathes acid in combat'),
(2, 'breath_fire', 'Mobile breathes fire in combat (area attack)'),
(3, 'breath_frost', 'Mobile breathes frost in combat (area attack)'),
(4, 'breath_gas', 'Mobile breathes poison gas in combat area attack)'),
(5, 'breath_lightning', 'Mobile breathes lightning in combat'),
(6, 'breath_any', 'Mobile may use any breath weapon'),
(7, 'executioner', 'Mobile attacks Killers and Thieves'),
(8, 'fido', 'Mobile devours corpses'),
(9, 'guard', 'Mobile protects good-aligned people from attack'),
(10, 'janitor', 'Mobile cleans up junk lying on the ground'),
(11, 'poison', 'Mobile has a poison attack'),
(12, 'thief', 'Mobile steals gold (ALWAYS set the thief act flag)'),
(13, 'nasty_thief', 'Mobile attacks, robs, and runs (ALWAYS set thief flag)');

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

--
-- Table structure for table `weapon_flags`
--

CREATE TABLE IF NOT EXISTS `weapon_flags` (
  `weapon_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`weapon_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `weapon_flags`
--

INSERT INTO `weapon_flags` (`weapon_flag_id`, `glyph`, `flag`) VALUES
(1, 'A', 'flaming'),
(2, 'B', 'frost'),
(3, 'C', 'draining'),
(4, 'D', 'sharp'),
(5, 'E', 'vorpal'),
(6, 'F', 'two-handed'),
(7, 'G', 'shocking (electrical)'),
(8, 'H', 'poisoned');

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

--
-- Table structure for table `wear_flags`
--

CREATE TABLE IF NOT EXISTS `wear_flags` (
  `wear_flag_id` int(11) NOT NULL AUTO_INCREMENT,
  `glyph` varchar(5) DEFAULT NULL,
  `flag` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`wear_flag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `wear_flags`
--

INSERT INTO `wear_flags` (`wear_flag_id`, `glyph`, `flag`) VALUES
(1, 'A', 'Take'),
(2, 'B', 'Finger'),
(3, 'C', 'Neck'),
(4, 'D', 'Body'),
(5, 'E', 'Head'),
(6, 'F', 'Legs'),
(7, 'G', 'Feet'),
(8, 'H', 'Hands'),
(9, 'I', 'Arms'),
(10, 'J', 'Shield'),
(11, 'K', 'About body'),
(12, 'L', 'Waist'),
(13, 'M', 'Wrist'),
(14, 'N', 'Wield'),
(15, 'O', 'Hold'),
(16, 'Q', 'Float');

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