-- MySQL dump 9.11
--
-- Host: localhost    Database: mw_map_data
-- ------------------------------------------------------
-- Server version	4.0.27-standard-log

--
-- Current Database: mw_map_data
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ mw_map_data;

USE mw_map_data;

--
-- Table structure for table `mapdata`
--

DROP TABLE IF EXISTS mapdata;
CREATE TABLE mapdata (
  ID int(11) NOT NULL auto_increment,
  Name tinytext NOT NULL,
  EditorID tinytext NOT NULL,
  Region tinytext NOT NULL,
  ObLocX float NOT NULL default '0',
  ObLocY float NOT NULL default '0',
  ObLocZ float NOT NULL default '0',
  MarkerType tinyint(4) NOT NULL default '0',
  DisplayLevel tinyint(4) NOT NULL default '16',
  Enable tinyint(4) NOT NULL default '1',
  Namespace tinytext NOT NULL,
  WikiPage tinytext NOT NULL,
  PRIMARY KEY  (ID),
  FULLTEXT KEY NameText (Name)
) TYPE=MyISAM;

-- INSERT INTO mapdata SET Name='Assarnatmat', EditorID='Assarnatamat, Shrine', Region='Ashlands', ObLocX=4373, ObLocY=5517, ObLocZ=1203, MarkerType=14, DisplayLevel=9, Enable=1, Namespace='Morrowind', WikiPage='Assarnatamat';
-- INSERT INTO mapdata SET Name='Vacant Tower', EditorID='Dagon Fel, Vacant Tower', Region='Dagon Fel', ObLocX=64424, ObLocY=186752, ObLocZ=168, MarkerType=17, DisplayLevel=9, Enable=1, Namespace='Morrowind', WikiPage='Vacant Tower';
-- INSERT INTO mapdata SET Name='Castle Karstaag', EditorID='Solstheim, Castle Karstaag', Region='Solstheim', ObLocX=-194431, ObLocY=219438, ObLocZ=2581, MarkerType=23, DisplayLevel=9, Enable=1, Namespace='Bloodmoon', WikiPage='Castle Karstaag';