-- phpMyAdmin SQL Dump -- version 2.9.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 13, 2007 at 05:57 PM -- Server version: 5.0.27 -- PHP Version: 5.2.1 -- -- Database: `blueprint` -- -- -------------------------------------------------------- -- -- Table structure for table `blueprintrequirements` -- CREATE TABLE `blueprintrequirements` ( `ID` int(11) NOT NULL auto_increment, `BlueprintID` int(11) NOT NULL, `MineralID` int(11) NOT NULL, `Amount` int(11) NOT NULL, `Purchased` enum('Yes','No') NOT NULL, `UserID` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ; -- -------------------------------------------------------- -- -- Table structure for table `blueprints` -- CREATE TABLE `blueprints` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(70) NOT NULL, `ItemSalePrice` double NOT NULL, `ME` int(11) NOT NULL, `PE` int(11) NOT NULL, `ItemsPerRun` int(11) NOT NULL, `userID` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -------------------------------------------------------- -- -- Table structure for table `mineralprices` -- CREATE TABLE `mineralprices` ( `ID` int(11) NOT NULL auto_increment, `RegionID` int(11) NOT NULL, `Name` varchar(40) NOT NULL, `Price` double NOT NULL, `UserID` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; -- -------------------------------------------------------- -- -- Table structure for table `regions` -- CREATE TABLE `regions` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(40) NOT NULL, `Sovereignty` varchar(50) NOT NULL, `UserID` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `ID` int(11) NOT NULL auto_increment, `username` varchar(30) NOT NULL, `email` varchar(50) NOT NULL, `password` varchar(40) NOT NULL, `VerificationCode` varchar(40) NOT NULL, `verified` enum('Yes','No') NOT NULL default 'No', PRIMARY KEY (`ID`), UNIQUE KEY `email` (`email`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;