u3HHd90U

1CREATE TABLE IF NOT EXISTS `maphouses` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `houseID` int(11) NOT NULL,
4 `houseOWNER` int(11) NOT NULL,
5 `houseDESC` varchar(255) NOT NULL,
6 `housesize` int(11) NOT NULL,
7 `allowguests` int(11) NOT NULL,
8 `itemslot1` int(11) NOT NULL,
9 `itemslot2` int(11) NOT NULL,
10 `itemslot3` int(11) NOT NULL,
11 `itemslot4` int(11) NOT NULL,
12 `itemslot5` int(11) NOT NULL,
13 `itemslot6` int(11) NOT NULL,
14 `itemslot7` int(11) NOT NULL,
15 `itemslot8` int(11) NOT NULL,
16 `itemslot9` int(11) NOT NULL,
17 `itemslot10` int(11) NOT NULL,
18 `itemslot11` int(11) NOT NULL,
19 `itemslot12` int(11) NOT NULL,
20 `itemslot13` int(11) NOT NULL,
21 `itemslot14` int(11) NOT NULL,
22 `itemslot15` int(11) NOT NULL,
23 `itemslot16` int(11) NOT NULL,
24 `itemslot17` int(11) NOT NULL,
25 `itemslot18` int(11) NOT NULL,
26 `itemslot19` int(11) NOT NULL,
27 `itemslot20` int(11) NOT NULL,
28 PRIMARY KEY (`id`)
29) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
30
31
32--
33-- Table structure for table `mapmission`
34--
35
36CREATE TABLE IF NOT EXISTS `mapmission` (
37 `id` int(11) NOT NULL AUTO_INCREMENT,
38 `locationy` int(11) NOT NULL DEFAULT '0',
39 `locationx` int(11) NOT NULL DEFAULT '0',
40 `missionname` text,
41 `missionlength` int(11) NOT NULL DEFAULT '1',
42 `missionlink` text,
43 `missiontext` text,
44 `missionnext` text,
45 `locationynext` int(11) NOT NULL DEFAULT '0',
46 `locationxnext` int(11) NOT NULL DEFAULT '0',
47 `cash` int(11) NOT NULL DEFAULT '0',
48 `crystals` int(11) NOT NULL DEFAULT '0',
49 `rewardnumber` int(11) NOT NULL DEFAULT '0',
50 PRIMARY KEY (`id`)
51) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
52
53
54
55-- --------------------------------------------------------
56
57--
58-- Table structure for table `maptowns`
59--
60
61CREATE TABLE IF NOT EXISTS `maptowns` (
62 `id` int(11) NOT NULL AUTO_INCREMENT,
63 `townID` varchar(20) NOT NULL,
64 `locationx` int(11) NOT NULL,
65 `locationy` int(11) NOT NULL,
66 PRIMARY KEY (`id`)
67) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
68
69--
70-- Dumping data for table `maptowns`
71--
72
73INSERT INTO `maptowns` (`id`, `townID`, `locationx`, `locationy`) VALUES
74(2, 'Launceston', 5, 5);
75
76-- --------------------------------------------------------
77
78--
79-- Table structure for table `mapusers`
80--
81
82CREATE TABLE IF NOT EXISTS `mapusers` (
83 `missionID` int(11) NOT NULL DEFAULT '0',
84 `userID` int(11) NOT NULL DEFAULT '0',
85 `completed` int(11) NOT NULL DEFAULT '0'
86) ENGINE=InnoDB DEFAULT CHARSET=latin1;