Q3Qn0XvS

1-- MySQL dump 10.13  Distrib 5.1.32, for Win32 (ia32)
2--
3-- Host: localhost    Database: minecraft
4-- ------------------------------------------------------
5-- Server version	5.1.32-community
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `groups`
20--
21
22DROP TABLE IF EXISTS `groups`;
23SET @saved_cs_client     = @@character_set_client;
24SET character_set_client = utf8;
25CREATE TABLE `groups` (
26  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
27  `name` varchar(32) NOT NULL,
28  `prefix` varchar(16) NOT NULL,
29  `commands` LONGTEXT DEFAULT '',
30  `inheritedgroups` varchar(64) NOT NULL DEFAULT '',
31  `defaultgroup` tinyint(1) NOT NULL DEFAULT '0',
32  `admin` tinyint(1) NOT NULL DEFAULT '0',
33  `canmodifyworld` tinyint(1) NOT NULL DEFAULT '1',
34  `ignoresrestrictions` tinyint(1) NOT NULL DEFAULT '0',
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
37SET character_set_client = @saved_cs_client;
38
39--
40-- Dumping data for table `groups`
41--
42
43LOCK TABLES `groups` WRITE;
44/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
45INSERT INTO `groups` VALUES 
46(1,'default','f','/help,/sethome,/home,/spawn,/me,/msg,/kit,/playerlist,/warp,/motd,/compass,/tell,/m,/who','',1,0,1,0),
47(2,'vip','a','','default',0,0,1,0),
48(3,'mods','b','/ban,/kick,/item,/tp,/tphere,/s,/i,/give','vip',0,0,1,1),
49(4,'admins','c','*','mods',0,1,1,1);
50/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `homes`
55--
56
57DROP TABLE IF EXISTS `homes`;
58SET @saved_cs_client     = @@character_set_client;
59SET character_set_client = utf8;
60CREATE TABLE `homes` (
61  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
62  `name` varchar(45) NOT NULL,
63  `x` double NOT NULL,
64  `y` double NOT NULL,
65  `z` double NOT NULL,
66  `rotX` float NOT NULL,
67  `rotY` float NOT NULL,
68  `group` VARCHAR(64) NOT NULL DEFAULT '',
69  PRIMARY KEY (`id`)
70) ENGINE=InnoDB DEFAULT CHARSET=latin1;
71SET character_set_client = @saved_cs_client;
72
73--
74-- Dumping data for table `homes`
75--
76
77LOCK TABLES `homes` WRITE;
78/*!40000 ALTER TABLE `homes` DISABLE KEYS */;
79/*!40000 ALTER TABLE `homes` ENABLE KEYS */;
80UNLOCK TABLES;
81
82--
83-- Table structure for table `items`
84--
85
86DROP TABLE IF EXISTS `items`;
87SET @saved_cs_client     = @@character_set_client;
88SET character_set_client = utf8;
89CREATE TABLE `items` (
90  `name` varchar(64) NOT NULL,
91  `itemid` int(10) unsigned NOT NULL,
92  PRIMARY KEY (`name`)
93) ENGINE=InnoDB DEFAULT CHARSET=latin1;
94SET character_set_client = @saved_cs_client;
95
96--
97-- Dumping data for table `items`
98--
99LOCK TABLES `items` WRITE;
100/*!40000 ALTER TABLE `items` DISABLE KEYS */;
101INSERT INTO `items` VALUES 
102('air',0),('rock',1),('stone',1),('grass',2),('dirt',3),('cobblestone',4),
103('cobble',4),('wood',5),('sapling',6),('adminium',7),('bedrock',7),('water',8),
104('stillwater',9),('lava',10),('stilllava',11),('slava',11),('sand',12),('gravel',13),
105('goldore',14),('ironore',15),('coalore',16),('tree',17),('log',17),('leaves',18),
106('sponge',19),('glass',20),('lapislazuliore', 21),('lapislazuliblock', 22),
107('dispenser', 23), ('sandstone', 24), ('noteblock', 25), ('bedblock', 26), 
108('poweredrail', 27),('detectorrail', 28),('web', 30), ('cloth',35),('flower',37),('rose',38),
109('brownmushroom',39),('redmushroom',40),('gold',41),('goldblock',41),('iron',42),('ironblock',42),
110('doublestair',43),('stair',44),('step',44),('brickblock',45),('brickwall',45),
111('tnt',46),('bookshelf',47),('mossycobblestone',48),('mossy',48),('obsidian',49),
112('torch',50),('fire',51),('mobspawner',52),('woodstairs',53),('chest',54),('redstonewire',55),
113('diamondore',56),('diamondblock',57),('workbench',58),('crop',59),('crops',59),('soil',60),
114('furnace',61),('litfurnace',62),('signblock',63),('wooddoorblock',64),('ladder',65),('rails',66),
115('rail',66),('track',66),('tracks',66),('cobblestonestairs',67),('stairs',67),('signblocktop',68),
116('wallsign',68),('lever',69),('rockplate',70),('stoneplate',70),('irondoorblock',71),('woodplate',72),
117('redstoneore',73),('redstoneorealt',74),('redstonetorchoff',75),('redstonetorchon',76),('button',77),
118('snow',78),('ice',79),('snowblock',80),('cactus',81),('clayblock',82),('reedblock',83),('jukebox',84),
119('fence',85),('pumpkin',86),('netherstone',87),('slowsand',88),('lightstone',89),('portal',90),
120('jackolantern',91),('jacko',91),('cakeblock', 92),('redstonerepeateroff', 93),
121('redstonerepeateron', 94),('lockedchest', 95),('ironshovel',256),('ironspade',256),('ironpickaxe',257),
122('ironpick',257),('ironaxe',258),('flintandsteel',259),('lighter',259),('apple',260),('bow',261),
123('arrow',262),('coal',263),('diamond',264),('ironbar',265),('goldbar',266),('ironsword',267),
124('woodsword',268),('woodshovel',269),('woodspade',269),('woodpickaxe',270),('wodpick',270),
125('woodaxe',271),('stonesword',272),('stoneshovel',273),('stonespade',273),('stonepickaxe',274),
126('stonepick',274),('stoneaxe',275),('diamondsword',276),('diamondshovel',277),('diamondspade',277),
127('diamondpickaxe',278),('diamondpick',278),('diamondaxe',279),('stick',280),('bowl',281),
128('bowlwithsoup',282),('soupbowl',282),('soup',282),('goldsword',283),('goldshovel',284),
129('goldspade',284),('goldpickaxe',285),('goldpick',285),('goldaxe',286),('string',287),('feather',288),
130('gunpowder',289),('woodhoe',290),('stonehoe',291),('ironhore',292),('diamondhoe',293),('goldhoe',294),
131('seeds',295),('wheat',296),('bread',297),('leatherhelmet',298),('leatherchestplate',299),('leatherpants',300),
132('leatherboots',301),('chainmailhelmet',302),('chainmailchestplate',303),('chainmailpants',304),
133('chainmailboots',305),('ironhelmet',306),('ironchestplate',307),('ironpants',308),('ironboots',309),
134('diamondhelmets',310),('diamondchestplate',311),('diamondpants',312),('diamondboots',313),('goldhelmet',314),
135('goldchestplate',315),('goldpants',316),('goldboots',317),('flint',318),('meat',319),('pork',319),
136('cookedmeat',320),('cookedpork',320),('painting',321),('paintings',321),('goldenapple',322),('sign',323),
137('wooddoor',324),('bucket',325),('waterbucket',326),('lavabucket',327),('minecart',328),('saddle',329),
138('irondoor',330),('redstonedust',331),('snowball',332),('boat',333),('leather',334),('milkbucket',335),
139('brick',336),('clay',337),('reed',338),('paper',339),('book',340),('slimeorb',341),('storageminecart',342),
140('poweredminecart',343),('eggs',344),('compass',345),('fishingrod',346),('watch',347),('lightstonedust',348),
141('lightdust',348),('rawfish',349),('fish',349),('cookefish',350), ('bone', 352), ('sugar', 353), 
142('cake', 354),('bed', 355), ('redstonerepeater', 356),('cookie', 357),
143('goldrecord',2256),('greenrecord',2257); 
144/*!40000 ALTER TABLE `items` ENABLE KEYS */;
145UNLOCK TABLES;
146
147--
148-- Table structure for table `kits`
149--
150
151DROP TABLE IF EXISTS `kits`;
152SET @saved_cs_client     = @@character_set_client;
153SET character_set_client = utf8;
154CREATE TABLE `kits` (
155  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
156  `name` varchar(32) NOT NULL,
157  `items` varchar(512) NOT NULL,
158  `delay` int(10) unsigned NOT NULL,
159  `group` varchar(32) NOT NULL DEFAULT '',
160  PRIMARY KEY (`id`)
161) ENGINE=InnoDB DEFAULT CHARSET=latin1;
162SET character_set_client = @saved_cs_client;
163
164--
165-- Dumping data for table `kits`
166--
167
168LOCK TABLES `kits` WRITE;
169/*!40000 ALTER TABLE `kits` DISABLE KEYS */;
170/*!40000 ALTER TABLE `kits` ENABLE KEYS */;
171UNLOCK TABLES;
172
173--
174-- Table structure for table `users`
175--
176
177DROP TABLE IF EXISTS `users`;
178SET @saved_cs_client     = @@character_set_client;
179SET character_set_client = utf8;
180CREATE TABLE `users` (
181  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
182  `name` varchar(32) NOT NULL,
183  `groups` varchar(64) NOT NULL,
184  `prefix` varchar(10) NOT NULL DEFAULT '',
185  `commands` LONGTEXT DEFAULT '',
186  `admin` tinyint(1) NOT NULL DEFAULT '0',
187  `canmodifyworld` tinyint(1) NOT NULL DEFAULT '1',
188  `ignoresrestrictions` tinyint(1) NOT NULL DEFAULT '0',
189  `ip` VARCHAR(128) NOT NULL DEFAULT '',
190  PRIMARY KEY (`id`)
191) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
192SET character_set_client = @saved_cs_client;
193
194--
195-- Table structure for table `warps`
196--
197
198DROP TABLE IF EXISTS `warps`;
199SET @saved_cs_client     = @@character_set_client;
200SET character_set_client = utf8;
201CREATE TABLE `warps` (
202  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
203  `name` varchar(45) NOT NULL,
204  `x` double NOT NULL,
205  `y` double NOT NULL,
206  `z` double NOT NULL,
207  `rotX` float NOT NULL,
208  `rotY` float NOT NULL,
209  `group` VARCHAR(64) NOT NULL DEFAULT '',
210  PRIMARY KEY (`id`)
211) ENGINE=InnoDB DEFAULT CHARSET=latin1;
212SET character_set_client = @saved_cs_client;
213
214--
215-- Dumping data for table `warps`
216--
217
218LOCK TABLES `warps` WRITE;
219/*!40000 ALTER TABLE `warps` DISABLE KEYS */;
220/*!40000 ALTER TABLE `warps` ENABLE KEYS */;
221UNLOCK TABLES;
222/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
223
224/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
225/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
226/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
227/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
228/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
229/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
230/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
231
232-- Dump completed on 2010-08-27 17:58:30
233
234CREATE TABLE  `whitelist` (
235  `name` varchar(32) NOT NULL,
236  PRIMARY KEY (`name`)
237) ENGINE=InnoDB DEFAULT CHARSET=latin1;
238CREATE TABLE  `reservelist` (
239  `name` varchar(32) NOT NULL,
240  PRIMARY KEY (`name`)
241) ENGINE=InnoDB DEFAULT CHARSET=latin1;