   `voted` text NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `academy`
+--
+
+CREATE TABLE `academy` (
+  `academyid` int(11) UNSIGNED NOT NULL,
+  `academyname` text NOT NULL,
+  `academydesc` text NOT NULL,
+  `academycost` int(11) UNSIGNED NOT NULL,
+  `academylevel` int(11) UNSIGNED NOT NULL,
+  `academydays` int(11) UNSIGNED NOT NULL,
+  `effect1_on` enum('false','true') NOT NULL,
+  `effect1` text NOT NULL,
+  `effect2_on` enum('false','true') NOT NULL,
+  `effect2` text NOT NULL,
+  `effect3_on` enum('false','true') NOT NULL,
+  `effect3` text NOT NULL,
+  `effect4_on` enum('false','true') NOT NULL,
+  `effect4` text NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
 --
 -- Indexes for dumped tables
 --

ALTER TABLE `users`
  MODIFY `userid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
 CREATE TABLE `shops` (
  `shopID` int(11) NOT NULL auto_increment,
  `shopLOCATION` int(11) NOT NULL default '0',
  `shopNAME` varchar(255) NOT NULL default '',

  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `academy`
--
ALTER TABLE `academy`
  ADD PRIMARY KEY (`academyid`);
  
--
-- AUTO_INCREMENT for dumped tables
--

