Public paste
planis
By: burn | Date: Feb 18 2008 22:36 | Format: None | Expires: never | Size: 3.62 KB | Hits: 745

  1. -- phpMyAdmin SQL Dump
  2. -- version 2.10.0.2
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Feb 18, 2008 at 09:34 PM
  7. -- Server version: 5.0.27
  8. -- PHP Version: 5.2.4
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Database: `empireuniverse`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Table structure for table `planeten`
  20. --
  21.  
  22. CREATE TABLE `planeten` (
  23.   `AID` bigint(20) unsigned NOT NULL default '0',
  24.   `PID` bigint(20) unsigned NOT NULL auto_increment,
  25.   `nickname` varchar(20) NOT NULL default '',
  26.   `planet` varchar(60) NOT NULL default '',
  27.   `x` int(10) unsigned NOT NULL default '0',
  28.   `y` int(10) unsigned NOT NULL default '0',
  29.   `z` int(10) unsigned NOT NULL default '0',
  30.   `ord` int(11) NOT NULL default '0',
  31.   `cid` bigint(20) NOT NULL default '0',
  32.   `truppen` int(16) unsigned NOT NULL default '0',
  33.   `type` int(4) unsigned NOT NULL default '3',
  34.   `gold` int(11) NOT NULL default '0',
  35.   PRIMARY KEY  (`PID`),
  36.   UNIQUE KEY `coords` (`x`,`y`,`z`),
  37.   KEY `AID` (`AID`),
  38.   KEY `ord` (`ord`),
  39.   KEY `x` (`x`,`y`,`z`)
  40. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=47640 ;
  41.  
  42. --
  43. -- Dumping data for table `planeten`
  44. --
  45.  
  46. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  47. (0, 1, '333', 'FarmMich1', 30001, 30001, 30001, 1, 95654548, 0, 3, 0);
  48. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  49. (0, 426, '', '', 131, 401, 529, 0, 0, 0, 9, 0);
  50. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  51. (0, 428, '', '', 130, 410, 571, 1, 0, 0, 2, 0);
  52. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  53. (0, 461, '', '', 135, 420, 468, 0, 0, 0, 12, 0);
  54. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  55. (0, 462, '', '', 126, 413, 495, 0, 0, 0, 10, 0);
  56. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  57. (0, 463, '', '', 117, 438, 531, 0, 0, 0, 13, 0);
  58. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  59. (0, 464, '', '', 137, 422, 545, 0, 0, 0, 8, 0);
  60. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  61. (0, 465, '', '', 121, 438, 573, 0, 0, 0, 1, 0);
  62. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  63. (0, 466, '', '', 125, 436, 611, 0, 0, 0, 4, 0);
  64. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  65. (0, 468, '', '', 137, 422, 658, 0, 0, 0, 9, 0);
  66. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  67. (0, 469, '', '', 137, 433, 673, 0, 0, 0, 2, 0);
  68. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  69. (0, 497, '', '', 129, 461, 442, 0, 0, 0, 1, 0);
  70. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  71. (0, 498, '', '', 125, 458, 484, 0, 0, 0, 10, 0);
  72. INSERT INTO `planeten` (`AID`, `PID`, `nickname`, `planet`, `x`, `y`, `z`, `ord`, `cid`, `truppen`, `type`, `gold`) VALUES
  73. (0, 499, '', '', 130, 458, 492, 0, 0, 0, 10, 0);