Canary SQL DB

-- phpMyAdmin SQL Dump
-- version 3.3.7deb5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 11, 2011 at 06:47 PM
-- Server version: 5.1.49
-- PHP Version: 5.3.3-7+squeeze1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `canary`
--

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

--
-- Table structure for table `groups`
--

CREATE TABLE IF NOT EXISTS `groups` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(32) NOT NULL,
  `prefix` VARCHAR(16) NOT NULL,
  `commands` longtext,
  `inheritedgroups` VARCHAR(64) NOT NULL DEFAULT '',
  `defaultgroup` tinyint(1) NOT NULL DEFAULT '0',
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `canmodifyworld` tinyint(1) NOT NULL DEFAULT '1',
  `ignoresrestrictions` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `groups`
--

UPDATE `groups` SET `id` = 1,`name` = 'default',`prefix` = 'f',`commands` = '/help,/sethome,/home,/spawn,/me,/msg,/kit,/playerlist,/warp,/motd,/compass,/tell,/m,/who',`inheritedgroups` = '',`defaultgroup` = 1,`admin` = 0,`canmodifyworld` = 1,`ignoresrestrictions` = 0 WHERE `groups`.`id` = 1;
UPDATE `groups` SET `id` = 2,`name` = 'vip',`prefix` = 'a',`commands` = '',`inheritedgroups` = 'default',`defaultgroup` = 0,`admin` = 0,`canmodifyworld` = 1,`ignoresrestrictions` = 0 WHERE `groups`.`id` = 2;
UPDATE `groups` SET `id` = 3,`name` = 'mods',`prefix` = 'b',`commands` = '/ban,/kick,/item,/tp,/tphere,/s,/i,/give',`inheritedgroups` = 'vip',`defaultgroup` = 0,`admin` = 0,`canmodifyworld` = 1,`ignoresrestrictions` = 1 WHERE `groups`.`id` = 3;
UPDATE `groups` SET `id` = 4,`name` = 'admins',`prefix` = 'c',`commands` = '*',`inheritedgroups` = 'mods',`defaultgroup` = 0,`admin` = 1,`canmodifyworld` = 1,`ignoresrestrictions` = 1 WHERE `groups`.`id` = 4;

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

--
-- Table structure for table `homes`
--

CREATE TABLE IF NOT EXISTS `homes` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  `x` DOUBLE NOT NULL,
  `y` DOUBLE NOT NULL,
  `z` DOUBLE NOT NULL,
  `rotX` FLOAT NOT NULL,
  `rotY` FLOAT NOT NULL,
  `group` VARCHAR(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `homes`
--


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

--
-- Table structure for table `items`
--

CREATE TABLE IF NOT EXISTS `items` (
  `name` VARCHAR(64) NOT NULL,
  `itemid` INT(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--

UPDATE `items` SET `name` = 'adminium',`itemid` = 7 WHERE `items`.`name` = 'adminium';
UPDATE `items` SET `name` = 'air',`itemid` = 0 WHERE `items`.`name` = 'air';
UPDATE `items` SET `name` = 'apple',`itemid` = 260 WHERE `items`.`name` = 'apple';
UPDATE `items` SET `name` = 'arrow',`itemid` = 262 WHERE `items`.`name` = 'arrow';
UPDATE `items` SET `name` = 'bed',`itemid` = 355 WHERE `items`.`name` = 'bed';
UPDATE `items` SET `name` = 'bedblock',`itemid` = 26 WHERE `items`.`name` = 'bedblock';
UPDATE `items` SET `name` = 'bedrock',`itemid` = 7 WHERE `items`.`name` = 'bedrock';
UPDATE `items` SET `name` = 'boat',`itemid` = 333 WHERE `items`.`name` = 'boat';
UPDATE `items` SET `name` = 'bone',`itemid` = 352 WHERE `items`.`name` = 'bone';
UPDATE `items` SET `name` = 'book',`itemid` = 340 WHERE `items`.`name` = 'book';
UPDATE `items` SET `name` = 'bookshelf',`itemid` = 47 WHERE `items`.`name` = 'bookshelf';
UPDATE `items` SET `name` = 'bow',`itemid` = 261 WHERE `items`.`name` = 'bow';
UPDATE `items` SET `name` = 'bowl',`itemid` = 281 WHERE `items`.`name` = 'bowl';
UPDATE `items` SET `name` = 'bowlwithsoup',`itemid` = 282 WHERE `items`.`name` = 'bowlwithsoup';
UPDATE `items` SET `name` = 'bread',`itemid` = 297 WHERE `items`.`name` = 'bread';
UPDATE `items` SET `name` = 'brick',`itemid` = 336 WHERE `items`.`name` = 'brick';
UPDATE `items` SET `name` = 'brickblock',`itemid` = 45 WHERE `items`.`name` = 'brickblock';
UPDATE `items` SET `name` = 'brickwall',`itemid` = 45 WHERE `items`.`name` = 'brickwall';
UPDATE `items` SET `name` = 'brownmushroom',`itemid` = 39 WHERE `items`.`name` = 'brownmushroom';
UPDATE `items` SET `name` = 'bucket',`itemid` = 325 WHERE `items`.`name` = 'bucket';
UPDATE `items` SET `name` = 'button',`itemid` = 77 WHERE `items`.`name` = 'button';
UPDATE `items` SET `name` = 'cactus',`itemid` = 81 WHERE `items`.`name` = 'cactus';
UPDATE `items` SET `name` = 'cake',`itemid` = 354 WHERE `items`.`name` = 'cake';
UPDATE `items` SET `name` = 'cakeblock',`itemid` = 92 WHERE `items`.`name` = 'cakeblock';
UPDATE `items` SET `name` = 'chainmailboots',`itemid` = 305 WHERE `items`.`name` = 'chainmailboots';
UPDATE `items` SET `name` = 'chainmailchestplate',`itemid` = 303 WHERE `items`.`name` = 'chainmailchestplate';
UPDATE `items` SET `name` = 'chainmailhelmet',`itemid` = 302 WHERE `items`.`name` = 'chainmailhelmet';
UPDATE `items` SET `name` = 'chainmailpants',`itemid` = 304 WHERE `items`.`name` = 'chainmailpants';
UPDATE `items` SET `name` = 'chest',`itemid` = 54 WHERE `items`.`name` = 'chest';
UPDATE `items` SET `name` = 'clay',`itemid` = 337 WHERE `items`.`name` = 'clay';
UPDATE `items` SET `name` = 'clayblock',`itemid` = 82 WHERE `items`.`name` = 'clayblock';
UPDATE `items` SET `name` = 'cloth',`itemid` = 35 WHERE `items`.`name` = 'cloth';
UPDATE `items` SET `name` = 'coal',`itemid` = 263 WHERE `items`.`name` = 'coal';
UPDATE `items` SET `name` = 'coalore',`itemid` = 16 WHERE `items`.`name` = 'coalore';
UPDATE `items` SET `name` = 'cobble',`itemid` = 4 WHERE `items`.`name` = 'cobble';
UPDATE `items` SET `name` = 'cobblestone',`itemid` = 4 WHERE `items`.`name` = 'cobblestone';
UPDATE `items` SET `name` = 'cobblestonestairs',`itemid` = 67 WHERE `items`.`name` = 'cobblestonestairs';
UPDATE `items` SET `name` = 'compass',`itemid` = 345 WHERE `items`.`name` = 'compass';
UPDATE `items` SET `name` = 'cookedfish',`itemid` = 350 WHERE `items`.`name` = 'cookedfish';
UPDATE `items` SET `name` = 'cookedmeat',`itemid` = 320 WHERE `items`.`name` = 'cookedmeat';
UPDATE `items` SET `name` = 'cookedpork',`itemid` = 320 WHERE `items`.`name` = 'cookedpork';
UPDATE `items` SET `name` = 'cookfish',`itemid` = 350 WHERE `items`.`name` = 'cookfish';
UPDATE `items` SET `name` = 'cookie',`itemid` = 357 WHERE `items`.`name` = 'cookie';
UPDATE `items` SET `name` = 'crop',`itemid` = 59 WHERE `items`.`name` = 'crop';
UPDATE `items` SET `name` = 'crops',`itemid` = 59 WHERE `items`.`name` = 'crops';
UPDATE `items` SET `name` = 'detectorrail',`itemid` = 28 WHERE `items`.`name` = 'detectorrail';
UPDATE `items` SET `name` = 'diamond',`itemid` = 264 WHERE `items`.`name` = 'diamond';
UPDATE `items` SET `name` = 'diamondaxe',`itemid` = 279 WHERE `items`.`name` = 'diamondaxe';
UPDATE `items` SET `name` = 'diamondblock',`itemid` = 57 WHERE `items`.`name` = 'diamondblock';
UPDATE `items` SET `name` = 'diamondboots',`itemid` = 313 WHERE `items`.`name` = 'diamondboots';
UPDATE `items` SET `name` = 'diamondchestplate',`itemid` = 311 WHERE `items`.`name` = 'diamondchestplate';
UPDATE `items` SET `name` = 'diamondhelmets',`itemid` = 310 WHERE `items`.`name` = 'diamondhelmets';
UPDATE `items` SET `name` = 'diamondhoe',`itemid` = 293 WHERE `items`.`name` = 'diamondhoe';
UPDATE `items` SET `name` = 'diamondore',`itemid` = 56 WHERE `items`.`name` = 'diamondore';
UPDATE `items` SET `name` = 'diamondpants',`itemid` = 312 WHERE `items`.`name` = 'diamondpants';
UPDATE `items` SET `name` = 'diamondpick',`itemid` = 278 WHERE `items`.`name` = 'diamondpick';
UPDATE `items` SET `name` = 'diamondpickaxe',`itemid` = 278 WHERE `items`.`name` = 'diamondpickaxe';
UPDATE `items` SET `name` = 'diamondshovel',`itemid` = 277 WHERE `items`.`name` = 'diamondshovel';
UPDATE `items` SET `name` = 'diamondspade',`itemid` = 277 WHERE `items`.`name` = 'diamondspade';
UPDATE `items` SET `name` = 'diamondsword',`itemid` = 276 WHERE `items`.`name` = 'diamondsword';
UPDATE `items` SET `name` = 'dirt',`itemid` = 3 WHERE `items`.`name` = 'dirt';
UPDATE `items` SET `name` = 'dispenser',`itemid` = 23 WHERE `items`.`name` = 'dispenser';
UPDATE `items` SET `name` = 'doublestair',`itemid` = 43 WHERE `items`.`name` = 'doublestair';
UPDATE `items` SET `name` = 'dye',`itemid` = 351 WHERE `items`.`name` = 'dye';
UPDATE `items` SET `name` = 'eggs',`itemid` = 344 WHERE `items`.`name` = 'eggs';
UPDATE `items` SET `name` = 'feather',`itemid` = 288 WHERE `items`.`name` = 'feather';
UPDATE `items` SET `name` = 'fence',`itemid` = 85 WHERE `items`.`name` = 'fence';
UPDATE `items` SET `name` = 'fire',`itemid` = 51 WHERE `items`.`name` = 'fire';
UPDATE `items` SET `name` = 'fish',`itemid` = 349 WHERE `items`.`name` = 'fish';
UPDATE `items` SET `name` = 'fishingrod',`itemid` = 346 WHERE `items`.`name` = 'fishingrod';
UPDATE `items` SET `name` = 'flint',`itemid` = 318 WHERE `items`.`name` = 'flint';
UPDATE `items` SET `name` = 'flintandsteel',`itemid` = 259 WHERE `items`.`name` = 'flintandsteel';
UPDATE `items` SET `name` = 'flower',`itemid` = 37 WHERE `items`.`name` = 'flower';
UPDATE `items` SET `name` = 'furnace',`itemid` = 61 WHERE `items`.`name` = 'furnace';
UPDATE `items` SET `name` = 'glass',`itemid` = 20 WHERE `items`.`name` = 'glass';
UPDATE `items` SET `name` = 'gold',`itemid` = 41 WHERE `items`.`name` = 'gold';
UPDATE `items` SET `name` = 'goldaxe',`itemid` = 286 WHERE `items`.`name` = 'goldaxe';
UPDATE `items` SET `name` = 'goldbar',`itemid` = 266 WHERE `items`.`name` = 'goldbar';
UPDATE `items` SET `name` = 'goldblock',`itemid` = 41 WHERE `items`.`name` = 'goldblock';
UPDATE `items` SET `name` = 'goldboots',`itemid` = 317 WHERE `items`.`name` = 'goldboots';
UPDATE `items` SET `name` = 'goldchestplate',`itemid` = 315 WHERE `items`.`name` = 'goldchestplate';
UPDATE `items` SET `name` = 'goldenapple',`itemid` = 322 WHERE `items`.`name` = 'goldenapple';
UPDATE `items` SET `name` = 'goldhelmet',`itemid` = 314 WHERE `items`.`name` = 'goldhelmet';
UPDATE `items` SET `name` = 'goldhoe',`itemid` = 294 WHERE `items`.`name` = 'goldhoe';
UPDATE `items` SET `name` = 'goldore',`itemid` = 14 WHERE `items`.`name` = 'goldore';
UPDATE `items` SET `name` = 'goldpants',`itemid` = 316 WHERE `items`.`name` = 'goldpants';
UPDATE `items` SET `name` = 'goldpick',`itemid` = 285 WHERE `items`.`name` = 'goldpick';
UPDATE `items` SET `name` = 'goldpickaxe',`itemid` = 285 WHERE `items`.`name` = 'goldpickaxe';
UPDATE `items` SET `name` = 'goldrecord',`itemid` = 2256 WHERE `items`.`name` = 'goldrecord';
UPDATE `items` SET `name` = 'goldshovel',`itemid` = 284 WHERE `items`.`name` = 'goldshovel';
UPDATE `items` SET `name` = 'goldspade',`itemid` = 284 WHERE `items`.`name` = 'goldspade';
UPDATE `items` SET `name` = 'goldsword',`itemid` = 283 WHERE `items`.`name` = 'goldsword';
UPDATE `items` SET `name` = 'grass',`itemid` = 2 WHERE `items`.`name` = 'grass';
UPDATE `items` SET `name` = 'gravel',`itemid` = 13 WHERE `items`.`name` = 'gravel';
UPDATE `items` SET `name` = 'greenrecord',`itemid` = 2257 WHERE `items`.`name` = 'greenrecord';
UPDATE `items` SET `name` = 'gunpowder',`itemid` = 289 WHERE `items`.`name` = 'gunpowder';
UPDATE `items` SET `name` = 'ice',`itemid` = 79 WHERE `items`.`name` = 'ice';
UPDATE `items` SET `name` = 'inksack',`itemid` = 351 WHERE `items`.`name` = 'inksack';
UPDATE `items` SET `name` = 'iron',`itemid` = 42 WHERE `items`.`name` = 'iron';
UPDATE `items` SET `name` = 'ironaxe',`itemid` = 258 WHERE `items`.`name` = 'ironaxe';
UPDATE `items` SET `name` = 'ironbar',`itemid` = 265 WHERE `items`.`name` = 'ironbar';
UPDATE `items` SET `name` = 'ironblock',`itemid` = 42 WHERE `items`.`name` = 'ironblock';
UPDATE `items` SET `name` = 'ironboots',`itemid` = 309 WHERE `items`.`name` = 'ironboots';
UPDATE `items` SET `name` = 'ironchestplate',`itemid` = 307 WHERE `items`.`name` = 'ironchestplate';
UPDATE `items` SET `name` = 'irondoor',`itemid` = 330 WHERE `items`.`name` = 'irondoor';
UPDATE `items` SET `name` = 'irondoorblock',`itemid` = 71 WHERE `items`.`name` = 'irondoorblock';
UPDATE `items` SET `name` = 'ironhelmet',`itemid` = 306 WHERE `items`.`name` = 'ironhelmet';
UPDATE `items` SET `name` = 'ironhore',`itemid` = 292 WHERE `items`.`name` = 'ironhore';
UPDATE `items` SET `name` = 'ironore',`itemid` = 15 WHERE `items`.`name` = 'ironore';
UPDATE `items` SET `name` = 'ironpants',`itemid` = 308 WHERE `items`.`name` = 'ironpants';
UPDATE `items` SET `name` = 'ironpick',`itemid` = 257 WHERE `items`.`name` = 'ironpick';
UPDATE `items` SET `name` = 'ironpickaxe',`itemid` = 257 WHERE `items`.`name` = 'ironpickaxe';
UPDATE `items` SET `name` = 'ironshovel',`itemid` = 256 WHERE `items`.`name` = 'ironshovel';
UPDATE `items` SET `name` = 'ironspade',`itemid` = 256 WHERE `items`.`name` = 'ironspade';
UPDATE `items` SET `name` = 'ironsword',`itemid` = 267 WHERE `items`.`name` = 'ironsword';
UPDATE `items` SET `name` = 'jackolantern',`itemid` = 91 WHERE `items`.`name` = 'jackolantern';
UPDATE `items` SET `name` = 'jukebox',`itemid` = 84 WHERE `items`.`name` = 'jukebox';
UPDATE `items` SET `name` = 'ladder',`itemid` = 65 WHERE `items`.`name` = 'ladder';
UPDATE `items` SET `name` = 'lapislazuliblock',`itemid` = 22 WHERE `items`.`name` = 'lapislazuliblock';
UPDATE `items` SET `name` = 'lapislazuliore',`itemid` = 21 WHERE `items`.`name` = 'lapislazuliore';
UPDATE `items` SET `name` = 'lava',`itemid` = 10 WHERE `items`.`name` = 'lava';
UPDATE `items` SET `name` = 'lavabucket',`itemid` = 327 WHERE `items`.`name` = 'lavabucket';
UPDATE `items` SET `name` = 'leather',`itemid` = 334 WHERE `items`.`name` = 'leather';
UPDATE `items` SET `name` = 'leatherboots',`itemid` = 301 WHERE `items`.`name` = 'leatherboots';
UPDATE `items` SET `name` = 'leatherchestplate',`itemid` = 299 WHERE `items`.`name` = 'leatherchestplate';
UPDATE `items` SET `name` = 'leatherhelmet',`itemid` = 298 WHERE `items`.`name` = 'leatherhelmet';
UPDATE `items` SET `name` = 'leatherpants',`itemid` = 300 WHERE `items`.`name` = 'leatherpants';
UPDATE `items` SET `name` = 'leaves',`itemid` = 18 WHERE `items`.`name` = 'leaves';
UPDATE `items` SET `name` = 'lever',`itemid` = 69 WHERE `items`.`name` = 'lever';
UPDATE `items` SET `name` = 'lightdust',`itemid` = 348 WHERE `items`.`name` = 'lightdust';
UPDATE `items` SET `name` = 'lighter',`itemid` = 259 WHERE `items`.`name` = 'lighter';
UPDATE `items` SET `name` = 'lightstone',`itemid` = 89 WHERE `items`.`name` = 'lightstone';
UPDATE `items` SET `name` = 'lightstonedust',`itemid` = 348 WHERE `items`.`name` = 'lightstonedust';
UPDATE `items` SET `name` = 'litfurnace',`itemid` = 62 WHERE `items`.`name` = 'litfurnace';
UPDATE `items` SET `name` = 'lockedchest',`itemid` = 95 WHERE `items`.`name` = 'lockedchest';
UPDATE `items` SET `name` = 'log',`itemid` = 17 WHERE `items`.`name` = 'log';
UPDATE `items` SET `name` = 'meat',`itemid` = 319 WHERE `items`.`name` = 'meat';
UPDATE `items` SET `name` = 'milkbucket',`itemid` = 335 WHERE `items`.`name` = 'milkbucket';
UPDATE `items` SET `name` = 'minecart',`itemid` = 328 WHERE `items`.`name` = 'minecart';
UPDATE `items` SET `name` = 'mobspawner',`itemid` = 52 WHERE `items`.`name` = 'mobspawner';
UPDATE `items` SET `name` = 'mossy',`itemid` = 48 WHERE `items`.`name` = 'mossy';
UPDATE `items` SET `name` = 'mossycobblestone',`itemid` = 48 WHERE `items`.`name` = 'mossycobblestone';
UPDATE `items` SET `name` = 'netherstone',`itemid` = 87 WHERE `items`.`name` = 'netherstone';
UPDATE `items` SET `name` = 'noteblock',`itemid` = 25 WHERE `items`.`name` = 'noteblock';
UPDATE `items` SET `name` = 'obsidian',`itemid` = 49 WHERE `items`.`name` = 'obsidian';
UPDATE `items` SET `name` = 'painting',`itemid` = 321 WHERE `items`.`name` = 'painting';
UPDATE `items` SET `name` = 'paintings',`itemid` = 321 WHERE `items`.`name` = 'paintings';
UPDATE `items` SET `name` = 'paper',`itemid` = 339 WHERE `items`.`name` = 'paper';
UPDATE `items` SET `name` = 'pork',`itemid` = 319 WHERE `items`.`name` = 'pork';
UPDATE `items` SET `name` = 'portal',`itemid` = 90 WHERE `items`.`name` = 'portal';
UPDATE `items` SET `name` = 'poweredminecart',`itemid` = 343 WHERE `items`.`name` = 'poweredminecart';
UPDATE `items` SET `name` = 'poweredrail',`itemid` = 27 WHERE `items`.`name` = 'poweredrail';
UPDATE `items` SET `name` = 'pumpkin',`itemid` = 86 WHERE `items`.`name` = 'pumpkin';
UPDATE `items` SET `name` = 'rail',`itemid` = 66 WHERE `items`.`name` = 'rail';
UPDATE `items` SET `name` = 'rails',`itemid` = 66 WHERE `items`.`name` = 'rails';
UPDATE `items` SET `name` = 'rawfish',`itemid` = 349 WHERE `items`.`name` = 'rawfish';
UPDATE `items` SET `name` = 'redmushroom',`itemid` = 40 WHERE `items`.`name` = 'redmushroom';
UPDATE `items` SET `name` = 'redstonedust',`itemid` = 331 WHERE `items`.`name` = 'redstonedust';
UPDATE `items` SET `name` = 'redstoneore',`itemid` = 73 WHERE `items`.`name` = 'redstoneore';
UPDATE `items` SET `name` = 'redstoneorealt',`itemid` = 74 WHERE `items`.`name` = 'redstoneorealt';
UPDATE `items` SET `name` = 'redstonerepeater',`itemid` = 356 WHERE `items`.`name` = 'redstonerepeater';
UPDATE `items` SET `name` = 'redstonerepeateroff',`itemid` = 93 WHERE `items`.`name` = 'redstonerepeateroff';
UPDATE `items` SET `name` = 'redstonerepeateron',`itemid` = 94 WHERE `items`.`name` = 'redstonerepeateron';
UPDATE `items` SET `name` = 'redstonetorchoff',`itemid` = 75 WHERE `items`.`name` = 'redstonetorchoff';
UPDATE `items` SET `name` = 'redstonetorchon',`itemid` = 76 WHERE `items`.`name` = 'redstonetorchon';
UPDATE `items` SET `name` = 'redstonewire',`itemid` = 55 WHERE `items`.`name` = 'redstonewire';
UPDATE `items` SET `name` = 'reed',`itemid` = 338 WHERE `items`.`name` = 'reed';
UPDATE `items` SET `name` = 'reedblock',`itemid` = 83 WHERE `items`.`name` = 'reedblock';
UPDATE `items` SET `name` = 'rock',`itemid` = 1 WHERE `items`.`name` = 'rock';
UPDATE `items` SET `name` = 'rockplate',`itemid` = 70 WHERE `items`.`name` = 'rockplate';
UPDATE `items` SET `name` = 'rose',`itemid` = 38 WHERE `items`.`name` = 'rose';
UPDATE `items` SET `name` = 'saddle',`itemid` = 329 WHERE `items`.`name` = 'saddle';
UPDATE `items` SET `name` = 'sand',`itemid` = 12 WHERE `items`.`name` = 'sand';
UPDATE `items` SET `name` = 'sandstone',`itemid` = 24 WHERE `items`.`name` = 'sandstone';
UPDATE `items` SET `name` = 'sapling',`itemid` = 6 WHERE `items`.`name` = 'sapling';
UPDATE `items` SET `name` = 'seeds',`itemid` = 295 WHERE `items`.`name` = 'seeds';
UPDATE `items` SET `name` = 'sign',`itemid` = 323 WHERE `items`.`name` = 'sign';
UPDATE `items` SET `name` = 'signblock',`itemid` = 63 WHERE `items`.`name` = 'signblock';
UPDATE `items` SET `name` = 'signblocktop',`itemid` = 68 WHERE `items`.`name` = 'signblocktop';
UPDATE `items` SET `name` = 'slava',`itemid` = 11 WHERE `items`.`name` = 'slava';
UPDATE `items` SET `name` = 'slimeorb',`itemid` = 341 WHERE `items`.`name` = 'slimeorb';
UPDATE `items` SET `name` = 'slowsand',`itemid` = 88 WHERE `items`.`name` = 'slowsand';
UPDATE `items` SET `name` = 'snow',`itemid` = 78 WHERE `items`.`name` = 'snow';
UPDATE `items` SET `name` = 'snowball',`itemid` = 332 WHERE `items`.`name` = 'snowball';
UPDATE `items` SET `name` = 'snowblock',`itemid` = 80 WHERE `items`.`name` = 'snowblock';
UPDATE `items` SET `name` = 'soil',`itemid` = 60 WHERE `items`.`name` = 'soil';
UPDATE `items` SET `name` = 'soup',`itemid` = 282 WHERE `items`.`name` = 'soup';
UPDATE `items` SET `name` = 'soupbowl',`itemid` = 282 WHERE `items`.`name` = 'soupbowl';
UPDATE `items` SET `name` = 'sponge',`itemid` = 19 WHERE `items`.`name` = 'sponge';
UPDATE `items` SET `name` = 'stair',`itemid` = 44 WHERE `items`.`name` = 'stair';
UPDATE `items` SET `name` = 'stairs',`itemid` = 67 WHERE `items`.`name` = 'stairs';
UPDATE `items` SET `name` = 'step',`itemid` = 44 WHERE `items`.`name` = 'step';
UPDATE `items` SET `name` = 'stick',`itemid` = 280 WHERE `items`.`name` = 'stick';
UPDATE `items` SET `name` = 'stilllava',`itemid` = 11 WHERE `items`.`name` = 'stilllava';
UPDATE `items` SET `name` = 'stillwater',`itemid` = 9 WHERE `items`.`name` = 'stillwater';
UPDATE `items` SET `name` = 'stone',`itemid` = 1 WHERE `items`.`name` = 'stone';
UPDATE `items` SET `name` = 'stoneaxe',`itemid` = 275 WHERE `items`.`name` = 'stoneaxe';
UPDATE `items` SET `name` = 'stonehoe',`itemid` = 291 WHERE `items`.`name` = 'stonehoe';
UPDATE `items` SET `name` = 'stonepick',`itemid` = 274 WHERE `items`.`name` = 'stonepick';
UPDATE `items` SET `name` = 'stonepickaxe',`itemid` = 274 WHERE `items`.`name` = 'stonepickaxe';
UPDATE `items` SET `name` = 'stoneplate',`itemid` = 70 WHERE `items`.`name` = 'stoneplate';
UPDATE `items` SET `name` = 'stoneshovel',`itemid` = 273 WHERE `items`.`name` = 'stoneshovel';
UPDATE `items` SET `name` = 'stonespade',`itemid` = 273 WHERE `items`.`name` = 'stonespade';
UPDATE `items` SET `name` = 'stonesword',`itemid` = 272 WHERE `items`.`name` = 'stonesword';
UPDATE `items` SET `name` = 'storageminecart',`itemid` = 342 WHERE `items`.`name` = 'storageminecart';
UPDATE `items` SET `name` = 'string',`itemid` = 287 WHERE `items`.`name` = 'string';
UPDATE `items` SET `name` = 'sugar',`itemid` = 353 WHERE `items`.`name` = 'sugar';
UPDATE `items` SET `name` = 'tnt',`itemid` = 46 WHERE `items`.`name` = 'tnt';
UPDATE `items` SET `name` = 'torch',`itemid` = 50 WHERE `items`.`name` = 'torch';
UPDATE `items` SET `name` = 'track',`itemid` = 66 WHERE `items`.`name` = 'track';
UPDATE `items` SET `name` = 'tracks',`itemid` = 66 WHERE `items`.`name` = 'tracks';
UPDATE `items` SET `name` = 'tree',`itemid` = 17 WHERE `items`.`name` = 'tree';
UPDATE `items` SET `name` = 'wallsign',`itemid` = 68 WHERE `items`.`name` = 'wallsign';
UPDATE `items` SET `name` = 'watch',`itemid` = 347 WHERE `items`.`name` = 'watch';
UPDATE `items` SET `name` = 'water',`itemid` = 8 WHERE `items`.`name` = 'water';
UPDATE `items` SET `name` = 'waterbucket',`itemid` = 326 WHERE `items`.`name` = 'waterbucket';
UPDATE `items` SET `name` = 'web',`itemid` = 30 WHERE `items`.`name` = 'web';
UPDATE `items` SET `name` = 'wheat',`itemid` = 296 WHERE `items`.`name` = 'wheat';
UPDATE `items` SET `name` = 'wodpick',`itemid` = 270 WHERE `items`.`name` = 'wodpick';
UPDATE `items` SET `name` = 'wood',`itemid` = 5 WHERE `items`.`name` = 'wood';
UPDATE `items` SET `name` = 'woodaxe',`itemid` = 271 WHERE `items`.`name` = 'woodaxe';
UPDATE `items` SET `name` = 'wooddoor',`itemid` = 324 WHERE `items`.`name` = 'wooddoor';
UPDATE `items` SET `name` = 'wooddoorblock',`itemid` = 64 WHERE `items`.`name` = 'wooddoorblock';
UPDATE `items` SET `name` = 'woodhoe',`itemid` = 290 WHERE `items`.`name` = 'woodhoe';
UPDATE `items` SET `name` = 'woodpickaxe',`itemid` = 270 WHERE `items`.`name` = 'woodpickaxe';
UPDATE `items` SET `name` = 'woodplate',`itemid` = 72 WHERE `items`.`name` = 'woodplate';
UPDATE `items` SET `name` = 'woodshovel',`itemid` = 269 WHERE `items`.`name` = 'woodshovel';
UPDATE `items` SET `name` = 'woodspade',`itemid` = 269 WHERE `items`.`name` = 'woodspade';
UPDATE `items` SET `name` = 'woodstairs',`itemid` = 53 WHERE `items`.`name` = 'woodstairs';
UPDATE `items` SET `name` = 'woodsword',`itemid` = 268 WHERE `items`.`name` = 'woodsword';
UPDATE `items` SET `name` = 'workbench',`itemid` = 58 WHERE `items`.`name` = 'workbench';

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

--
-- Table structure for table `kits`
--

CREATE TABLE IF NOT EXISTS `kits` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(32) NOT NULL,
  `items` VARCHAR(512) NOT NULL,
  `delay` INT(10) UNSIGNED NOT NULL,
  `group` VARCHAR(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `kits`
--


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

--
-- Table structure for table `reservelist`
--

CREATE TABLE IF NOT EXISTS `reservelist` (
  `name` VARCHAR(32) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reservelist`
--


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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(32) NOT NULL,
  `groups` VARCHAR(64) NOT NULL,
  `prefix` VARCHAR(10) NOT NULL DEFAULT '',
  `commands` longtext,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `canmodifyworld` tinyint(1) NOT NULL DEFAULT '1',
  `ignoresrestrictions` tinyint(1) NOT NULL DEFAULT '0',
  `ip` VARCHAR(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `users`
--

UPDATE `users` SET `id` = 1,`name` = 'ellisgeek',`groups` = 'admin',`prefix` = '',`commands` = NULL,`admin` = 0,`canmodifyworld` = 0,`ignoresrestrictions` = 0,`ip` = '' WHERE `users`.`id` = 1;

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

--
-- Table structure for table `warps`
--

CREATE TABLE IF NOT EXISTS `warps` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  `x` DOUBLE NOT NULL,
  `y` DOUBLE NOT NULL,
  `z` DOUBLE NOT NULL,
  `rotX` FLOAT NOT NULL,
  `rotY` FLOAT NOT NULL,
  `group` VARCHAR(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `warps`
--


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

--
-- Table structure for table `whitelist`
--

CREATE TABLE IF NOT EXISTS `whitelist` (
  `name` VARCHAR(32) NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `whitelist`
--