-- phpMyAdmin SQL Dump

-- version 2.10.0.2

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Feb 18, 2008 at 09:34 PM

-- Server version: 5.0.27

-- PHP Version: 5.2.4

 

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

 

--

-- Database: `empireuniverse`

--

 

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

 

--

-- Table structure for table `planeten`

--

 

CREATE TABLE `planeten` (

  `AID` bigint(20) unsigned NOT NULL default '0',

  `PID` bigint(20) unsigned NOT NULL auto_increment,

  `nickname` varchar(20) NOT NULL default '',

  `planet` varchar(60) NOT NULL default '',

  `x` int(10) unsigned NOT NULL default '0',

  `y` int(10) unsigned NOT NULL default '0',

  `z` int(10) unsigned NOT NULL default '0',

  `ord` int(11) NOT NULL default '0',

  `cid` bigint(20) NOT NULL default '0',

  `truppen` int(16) unsigned NOT NULL default '0',

  `type` int(4) unsigned NOT NULL default '3',

  `gold` int(11) NOT NULL default '0',

  PRIMARY KEY  (`PID`),

  UNIQUE KEY `coords` (`x`,`y`,`z`),

  KEY `AID` (`AID`),

  KEY `ord` (`ord`),

  KEY `x` (`x`,`y`,`z`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=47640 ;

 

--

-- Dumping data for table `planeten`

--

 

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 1, '333', 'FarmMich1', 30001, 30001, 30001, 1, 95654548, 0, 3, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 426, '', '', 131, 401, 529, 0, 0, 0, 9, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 428, '', '', 130, 410, 571, 1, 0, 0, 2, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 461, '', '', 135, 420, 468, 0, 0, 0, 12, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 462, '', '', 126, 413, 495, 0, 0, 0, 10, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 463, '', '', 117, 438, 531, 0, 0, 0, 13, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 464, '', '', 137, 422, 545, 0, 0, 0, 8, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 465, '', '', 121, 438, 573, 0, 0, 0, 1, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 466, '', '', 125, 436, 611, 0, 0, 0, 4, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 468, '', '', 137, 422, 658, 0, 0, 0, 9, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 469, '', '', 137, 433, 673, 0, 0, 0, 2, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 497, '', '', 129, 461, 442, 0, 0, 0, 1, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 498, '', '', 125, 458, 484, 0, 0, 0, 10, 0);

INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES

(0, 499, '', '', 130, 458, 492, 0, 0, 0, 10, 0);