-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Sep 04, 2008 at 09:27 PM
-- Server version: 5.0.17
-- PHP Version: 5.1.1
-- 
-- Database: `iso`
-- 

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

-- 
-- Table structure for table `iso_object`
-- 

CREATE TABLE `iso_object` (
  `objectID` int(11) NOT NULL auto_increment,
  `objectName` varchar(50) NOT NULL,
  `imageName` varchar(50) NOT NULL,
  `mapID` int(11) NOT NULL,
  `mapX` int(11) NOT NULL,
  `mapY` int(11) NOT NULL,
  PRIMARY KEY  (`objectID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `iso_object`
-- 

INSERT INTO `iso_object` VALUES (1, 'Tree', 'tree', 1, 5, 5);
INSERT INTO `iso_object` VALUES (2, 'Tree', 'tree', 1, 5, 6);
INSERT INTO `iso_object` VALUES (3, 'Tree', 'tree', 1, 4, 5);
INSERT INTO `iso_object` VALUES (4, 'Tree', 'tree', 1, 4, 6);

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

-- 
-- Table structure for table `iso_unit`
-- 

CREATE TABLE `iso_unit` (
  `unitID` int(11) NOT NULL auto_increment,
  `unitName` varchar(50) NOT NULL,
  `imageName` varchar(50) NOT NULL,
  `ownerID` int(11) NOT NULL default '0',
  `mapID` int(11) default '0',
  `mapX` int(11) default '-1',
  `mapY` int(11) default '-1',
  `damage` int(11) NOT NULL default '5',
  `life` int(11) NOT NULL default '100',
  `range` int(11) NOT NULL default '3',
  `movement` int(11) NOT NULL default '2',
  `waitTime` int(11) NOT NULL default '0',
  PRIMARY KEY  (`unitID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `iso_unit`
-- 


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

-- 
-- Table structure for table `iso_user`
-- 

CREATE TABLE `iso_user` (
  `userID` int(11) NOT NULL auto_increment,
  `username` varchar(25) NOT NULL,
  `password` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `isGuest` varchar(1) NOT NULL,
  PRIMARY KEY  (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `iso_user`
--