maps SQL

CREATE TABLE IF NOT EXISTS `maphouses` (
 `id` INT(11) NOT NULL AUTO_INCREMENT,
 `houseID` INT(11) NOT NULL,
 `houseOWNER` INT(11) NOT NULL,
 `houseDESC` VARCHAR(255) NOT NULL,
 `housesize` INT(11) NOT NULL,
 `allowguests` INT(11) NOT NULL,
 `itemslot1` INT(11) NOT NULL,
 `itemslot2` INT(11) NOT NULL,
 `itemslot3` INT(11) NOT NULL,
 `itemslot4` INT(11) NOT NULL,
 `itemslot5` INT(11) NOT NULL,
 `itemslot6` INT(11) NOT NULL,
 `itemslot7` INT(11) NOT NULL,
 `itemslot8` INT(11) NOT NULL,
 `itemslot9` INT(11) NOT NULL,
 `itemslot10` INT(11) NOT NULL,
 `itemslot11` INT(11) NOT NULL,
 `itemslot12` INT(11) NOT NULL,
 `itemslot13` INT(11) NOT NULL,
 `itemslot14` INT(11) NOT NULL,
 `itemslot15` INT(11) NOT NULL,
 `itemslot16` INT(11) NOT NULL,
 `itemslot17` INT(11) NOT NULL,
 `itemslot18` INT(11) NOT NULL,
 `itemslot19` INT(11) NOT NULL,
 `itemslot20` INT(11) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


--
-- Table structure for table `mapmission`
--

CREATE TABLE IF NOT EXISTS `mapmission` (
 `id` INT(11) NOT NULL AUTO_INCREMENT,
 `locationy` INT(11) NOT NULL DEFAULT '0',
 `locationx` INT(11) NOT NULL DEFAULT '0',
 `missionname` text,
 `missionlength` INT(11) NOT NULL DEFAULT '1',
 `missionlink` text,
 `missiontext` text,
 `missionnext` text,
 `locationynext` INT(11) NOT NULL DEFAULT '0',
 `locationxnext` INT(11) NOT NULL DEFAULT '0',
 `cash` INT(11) NOT NULL DEFAULT '0',
 `crystals` INT(11) NOT NULL DEFAULT '0',
 `rewardnumber` INT(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



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

--
-- Table structure for table `maptowns`
--

CREATE TABLE IF NOT EXISTS `maptowns` (
 `id` INT(11) NOT NULL AUTO_INCREMENT,
 `townID` VARCHAR(20) NOT NULL,
 `locationx` INT(11) NOT NULL,
 `locationy` INT(11) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `maptowns`
--

INSERT INTO `maptowns` (`id`, `townID`, `locationx`, `locationy`) VALUES
(2, 'Launceston', 5, 5);

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

--
-- Table structure for table `mapusers`
--

CREATE TABLE IF NOT EXISTS `mapusers` (
 `missionID` INT(11) NOT NULL DEFAULT '0',
 `userID` INT(11) NOT NULL DEFAULT '0',
 `completed` INT(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;