-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 15. Aug 2012 um 23:46
-- Server Version: 5.5.16
-- PHP-Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `_mca`
--

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

--
-- Tabellenstruktur für Tabelle `accounts`
--

CREATE TABLE IF NOT EXISTS `accounts` (
  `account_user` varchar(200) NOT NULL,
  `account_pass` varchar(200) NOT NULL,
  `account_status` varchar(200) NOT NULL,
  `account_auktion` varchar(200) NOT NULL,
  `account_language` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Tabellenstruktur für Tabelle `auktion`
--

CREATE TABLE IF NOT EXISTS `auktion` (
  `User` varchar(200) NOT NULL,
  `ItemID` varchar(200) NOT NULL,
  `ItemStack` int(11) NOT NULL,
  `ItemPrice` double NOT NULL,
  `AuktionsID` int(11) NOT NULL AUTO_INCREMENT,
  `ItemBytes` varchar(200) NOT NULL,
  `EnchString` varchar(400) NOT NULL,
  `EnchInt` varchar(200) NOT NULL,
  `Damage` varchar(200) NOT NULL,
  KEY `AuktionsID` (`AuktionsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `itemimage`
--

CREATE TABLE IF NOT EXISTS `itemimage` (
  `ItemID` int(11) NOT NULL,
  `ItemValue` varchar(100) NOT NULL,
  `ItemName` varchar(200) NOT NULL,
  `ItemImage` varchar(400) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `itemimage`
--

INSERT INTO `itemimage` (`ItemID`, `ItemValue`, `ItemName`, `ItemImage`) VALUES
(1, '0', 'Stone', 'http://www.minecraftwiki.net/images/a/a6/Grid_Stone.png'),
(2, '0', 'Grass', 'http://www.minecraftwiki.net/images/6/6f/Grid_Grass.png'),
(3, '0', 'Dirt', 'http://www.minecraftwiki.net/images/b/bd/Grid_Dirt.png'),
(4, '0', 'Cobblestone', 'http://www.minecraftwiki.net/images/0/03/Grid_Cobblestone.png'),
(5, '0', 'Wooden_Plank', 'http://www.minecraftwiki.net/images/9/9f/Grid_Wooden_Plank.png'),
(6, '0', 'Sapling', 'http://www.minecraftwiki.net/images/b/b5/Grid_Sapling.png'),
(6, '1', 'Sapling_Spruce', 'http://www.minecraftwiki.net/images/c/c6/Grid_Sapling_Spruce.png'),
(6, '2', 'Sapling_Birch', 'http://www.minecraftwiki.net/images/b/b4/Grid_Sapling_Birch.png'),
(7, '0', 'Bedrock', 'http://www.minecraftwiki.net/images/e/e0/Grid_Bedrock.png'),
(8, '0', 'Water', 'http://www.minecraftwiki.net/images/1/13/Grid_Water.png'),
(9, '0', 'Stationary Water', 'http://www.minecraftwiki.net/images/1/13/Grid_Water.png'),
(10, '0', 'Lava', 'http://www.minecraftwiki.net/images/6/61/Grid_Lava.png'),
(11, '0', 'Stationary Water', 'http://www.minecraftwiki.net/images/6/61/Grid_Lava.png'),
(12, '0', 'Sand', 'http://www.minecraftwiki.net/images/b/bb/Grid_Sand.png'),
(13, '0', 'Gravel', 'http://www.minecraftwiki.net/images/0/03/Grid_Gravel.png'),
(14, '0', 'Gold', 'http://www.minecraftwiki.net/images/5/5c/Grid_Gold_%28Ore%29.png'),
(15, '0', 'Iron', 'http://www.minecraftwiki.net/images/7/74/Grid_Iron_%28Ore%29.png'),
(16, '0', 'Coal Ore', 'http://www.minecraftwiki.net/images/8/8c/Grid_Coal_%28Ore%29.png'),
(17, '0', 'Wood', 'http://www.minecraftwiki.net/images/b/bf/Grid_Wood.png'),
(17, '1', 'Wood Pine', 'http://www.minecraftwiki.net/images/d/db/Grid_Wood_%28Pine%29.png'),
(17, '2', 'Wood Birch', 'http://www.minecraftwiki.net/images/8/81/Grid_Wood_%28Birch%29.png'),
(18, '4', 'Leaves', 'http://www.minecraftwiki.net/images/3/30/Grid_Leaves.png'),
(18, '5', 'Leaves Pine', 'http://www.minecraftwiki.net/images/0/08/Grid_Leaves_%28Pine%29.png'),
(18, '6', 'Leaves Birch', 'http://www.minecraftwiki.net/images/0/0a/Grid_Leaves_%28Birch%29.png'),
(19, '0', 'Sponge', 'http://www.minecraftwiki.net/images/5/56/Grid_Sponge.png'),
(20, '0', 'Glass', 'http://www.minecraftwiki.net/images/0/00/Grid_Glass.png'),
(21, '0', 'Lapis Lazuli Ore', 'http://www.minecraftwiki.net/images/d/d2/Grid_Lapis_Lazuli_%28Ore%29.png'),
(22, '0', 'Lapis Lazuli Block', 'http://www.minecraftwiki.net/images/5/58/Grid_Lapis_Lazuli_%28Block%29.png'),
(23, '0', 'Dispenser', 'http://www.minecraftwiki.net/images/c/cc/Grid_Dispenser.png'),
(24, '0', 'Sandstone', 'http://www.minecraftwiki.net/images/1/12/Grid_Sandstone.png'),
(25, '0', 'Note Block', 'http://www.minecraftwiki.net/images/1/1d/Grid_Note_Block.png'),
(26, '0', 'Bed', 'http://media-mcw.cursecdn.com/a/a3/Grid_Bed.png'),
(27, '0', 'Powered Rail', 'http://www.minecraftwiki.net/images/9/9d/Grid_Powered_Rail.png'),
(28, '0', 'Detector Rail', 'http://www.minecraftwiki.net/images/a/a2/Grid_Detector_Rail.png'),
(29, '7', 'Sticky Piston', 'http://media-mcw.cursecdn.com/3/32/Grid_Sticky_Piston.png'),
(30, '0', 'Web', 'http://www.minecraftwiki.net/images/3/36/Grid_Cobweb.png'),
(31, '0', 'Dead Shrub', 'http://www.minecraftwiki.net/images/5/5f/Grid_Tall_Grass1.png'),
(31, '1', 'Tall Grass', 'http://www.minecraftwiki.net/images/c/c1/Grid_Tall_Grass2.png'),
(31, '2', 'Live Shrub', '0'),
(32, '0', 'Dead Shrub', 'http://www.minecraftwiki.net/images/5/5f/Grid_Tall_Grass1.png'),
(33, '7', 'Piston', 'http://media-mcw.cursecdn.com/3/3c/Grid_Piston.png'),
(34, '0', 'Piston Head', '0'),
(35, '0', 'White Wool', 'http://www.minecraftwiki.net/images/f/fa/Grid_White_Wool.png'),
(35, '1', 'Orange Wool', 'http://www.minecraftwiki.net/images/0/07/Grid_Orange_Wool.png'),
(35, '2', 'Magenta Wool', 'http://www.minecraftwiki.net/images/f/fd/Grid_Magenta_Wool.png'),
(35, '3', 'Light Blue Wool', 'http://www.minecraftwiki.net/images/f/fb/Grid_Light_Blue_Wool.png'),
(35, '4', 'Yellow Wool', 'http://www.minecraftwiki.net/images/e/ed/Grid_Yellow_Wool.png'),
(35, '5', 'Lime Wool', 'http://www.minecraftwiki.net/images/a/a2/Grid_Lime_Wool.png'),
(35, '6', 'Pink Wool', 'http://www.minecraftwiki.net/images/b/b3/Grid_Pink_Wool.png'),
(35, '7', 'Gray Wool', 'http://www.minecraftwiki.net/images/d/d3/Grid_Gray_Wool.png'),
(35, '8', 'Light Gray Wool', 'http://www.minecraftwiki.net/images/e/e5/Grid_Light_Gray_Wool.png'),
(35, '9', 'Cyan Wool', 'http://www.minecraftwiki.net/images/c/cd/Grid_Cyan_Wool.png'),
(35, '10', 'Purple Wool', 'http://www.minecraftwiki.net/images/5/51/Grid_Purple_Wool.png'),
(35, '11', 'Blue Wool', 'http://www.minecraftwiki.net/images/4/40/Grid_Blue_Wool.png'),
(35, '12', 'Brown Wool', 'http://www.minecraftwiki.net/images/2/2a/Grid_Brown_Wool.png'),
(35, '13', 'Green Wool', 'http://www.minecraftwiki.net/images/f/fa/Grid_Green_Wool.png'),
(35, '14', 'Red Wool', 'http://www.minecraftwiki.net/images/2/2a/Grid_Red_Wool.png'),
(35, '15', 'Black Wool', 'http://www.minecraftwiki.net/images/4/45/Grid_Black_Wool.png'),
(37, '0', 'Dandelion', 'http://www.minecraftwiki.net/images/4/49/Grid_Dandelion.png'),
(38, '0', 'Rose', 'http://www.minecraftwiki.net/images/4/49/Grid_Rose.png'),
(39, '0', 'Brown Mushroom', 'http://www.minecraftwiki.net/images/d/d8/Grid_Brown_Mushroom.png'),
(40, '0', 'Red Mushroom', 'http://www.minecraftwiki.net/images/0/01/Grid_Red_Mushroom.png'),
(41, '0', 'Gold Block', 'http://www.minecraftwiki.net/images/b/b6/Grid_Gold_%28Block%29.png'),
(42, '0', 'Iron Block', 'http://www.minecraftwiki.net/images/5/5a/Grid_Iron_%28Block%29.png'),
(43, '0', 'Double Stone Slab', '0'),
(43, '1', 'Double Sandstone Slab', '0'),
(43, '2', 'Double Wooden Slab', '0'),
(43, '3', 'Double Cobblestone Slab', '0'),
(44, '0', 'Stone Slab', 'http://www.minecraftwiki.net/images/2/29/Grid_Stone_Slab.png'),
(44, '1', 'Sandstone Slap', 'http://www.minecraftwiki.net/images/2/2a/Grid_Sandstone_Slab.png'),
(44, '2', 'Wooden Slab', 'http://www.minecraftwiki.net/images/4/4e/Grid_Wooden_Slab.png'),
(44, '3', 'Cobblestone Slab', 'http://www.minecraftwiki.net/images/f/f7/Grid_Cobblestone_Slab.png'),
(45, '0', 'Brick Block', 'http://www.minecraftwiki.net/images/6/64/Grid_Brick_%28Block%29.png'),
(46, '0', 'TNT', 'http://www.minecraftwiki.net/images/2/2b/Grid_TNT.png'),
(47, '0', 'Bookshelf', 'http://www.minecraftwiki.net/images/b/bc/Grid_Bookshelf.png'),
(48, '0', 'Moss Stone', 'http://www.minecraftwiki.net/images/7/7d/Grid_Moss_Stone.png'),
(49, '0', 'Obsidian', 'http://www.minecraftwiki.net/images/5/5d/Grid_Obsidian.png'),
(50, '0', 'Torch', 'http://www.minecraftwiki.net/images/3/32/Grid_Torch.png'),
(51, '0', 'Fire', '0'),
(52, '0', 'Monster Spawner', 'http://www.minecraftwiki.net/images/3/3b/Grid_Monster_Spawner.png'),
(53, '0', 'Wooden Stairs', 'http://www.minecraftwiki.net/images/3/3b/Grid_Wooden_Stairs.png'),
(54, '0', 'Chest', 'http://www.minecraftwiki.net/images/c/c1/Grid_Chest.png'),
(55, '0', 'Redstone Dust', 'http://www.minecraftwiki.net/images/c/c3/Grid_Redstone_%28Dust%29.png'),
(56, '0', 'Diamond Ore', 'http://www.minecraftwiki.net/images/e/ef/Grid_Diamond_%28Ore%29.png'),
(57, '0', 'Diamond Block', 'http://www.minecraftwiki.net/images/7/73/Grid_Diamond_%28Block%29.png'),
(58, '0', 'Crafting Table', 'http://www.minecraftwiki.net/images/7/79/Grid_Crafting_Table.png'),
(59, '0', 'Crops', 'http://www.minecraftwiki.net/images/6/68/Grid_Seeds.png'),
(60, '0', 'Soil', 'http://www.minecraftwiki.net/images/6/6a/Grid_Farmland.png'),
(61, '0', 'Furnace', 'http://www.minecraftwiki.net/images/2/2e/Grid_Furnace.png'),
(62, '0', 'Furnace', 'http://www.minecraftwiki.net/images/2/2e/Grid_Furnace.png'),
(63, '0', 'Sign', 'http://www.minecraftwiki.net/images/0/06/Grid_Sign.png'),
(64, '0', 'Wooden Door', 'http://www.minecraftwiki.net/images/c/cd/Grid_Wooden_Door.png'),
(65, '0', 'Ladders', 'http://www.minecraftwiki.net/images/9/99/Grid_Ladders.png'),
(66, '0', 'Rails', 'http://www.minecraftwiki.net/images/7/7a/Grid_Rails.png'),
(67, '0', 'Cooblestone Stairs', 'http://www.minecraftwiki.net/images/7/7f/Grid_Cobblestone_Stairs.png'),
(68, '0', 'Sign', 'http://www.minecraftwiki.net/images/0/06/Grid_Sign.png'),
(69, '0', 'Lever', 'http://www.minecraftwiki.net/images/3/33/Grid_Lever.png'),
(70, '0', 'Stone Pressure Plate', 'http://www.minecraftwiki.net/images/4/46/Grid_Stone_Pressure_Plate.png'),
(71, '0', 'Iron Door', 'http://www.minecraftwiki.net/images/2/27/Grid_Iron_Door.png'),
(72, '0', 'Wooden Pressure Plate', 'http://www.minecraftwiki.net/images/d/d4/Grid_Wooden_Pressure_Plate.png'),
(73, '0', 'Redstone Ore', 'http://www.minecraftwiki.net/images/b/b8/Grid_Redstone_%28Ore%29.png'),
(74, '0', 'Glowing Redstone Ore', 'http://www.minecraftwiki.net/images/b/b8/Grid_Redstone_%28Ore%29.png'),
(75, '0', 'Redstone Torch', 'http://www.minecraftwiki.net/images/6/66/Grid_Redstone_%28Torch%29.png'),
(76, '0', 'Redstone Torch', 'http://www.minecraftwiki.net/images/6/66/Grid_Redstone_%28Torch%29.png'),
(77, '0', 'Stone Button', 'http://www.minecraftwiki.net/images/8/81/Grid_Stone_Button.png'),
(78, '0', 'Snow Block', 'http://www.minecraftwiki.net/images/6/66/Grid_Snow_%28Block%29.png'),
(79, '0', 'Ice', 'http://www.minecraftwiki.net/images/2/2e/Grid_Ice.png'),
(80, '0', 'Snow Block', 'http://www.minecraftwiki.net/images/6/66/Grid_Snow_%28Block%29.png'),
(81, '0', 'Cactus', 'http://www.minecraftwiki.net/images/f/fb/Grid_Cactus.png'),
(82, '0', 'Clay Block', 'http://www.minecraftwiki.net/images/a/a6/Grid_Clay_%28Block%29.png'),
(83, '0', 'Sugar Cane', 'http://www.minecraftwiki.net/images/d/d3/Grid_Sugar_Cane.png'),
(84, '0', 'Jukebox', 'http://www.minecraftwiki.net/images/1/10/Grid_Jukebox.png'),
(85, '0', 'Fence', 'http://www.minecraftwiki.net/images/c/c8/Grid_Fence.png'),
(86, '0', 'Pumpkin', 'http://www.minecraftwiki.net/images/b/be/Grid_Pumpkin.png'),
(87, '0', 'Netherrack', 'http://www.minecraftwiki.net/images/8/86/Grid_Netherrack.png";'),
(88, '0', 'Soul Sand', 'http://www.minecraftwiki.net/images/e/e4/Grid_Soul_Sand.png'),
(89, '0', 'Glowstone Block', 'http://www.minecraftwiki.net/images/f/fd/Grid_Glowstone_%28Block%29.png'),
(90, '0', 'Portal', 'http://www.minecraftwiki.net/images/8/8f/Grid_Portal.png'),
(91, '0', 'Jack O Lantern', 'http://www.minecraftwiki.net/images/a/ac/Grid_Jack-O-Lantern.png'),
(92, '0', 'Cake', 'http://www.minecraftwiki.net/images/2/28/Grid_Cake.png'),
(93, '0', 'Redstone Repeater', 'http://www.minecraftwiki.net/images/b/b0/Grid_Redstone_%28Repeater%29.png'),
(94, '0', 'Redstone Repeater', 'http://www.minecraftwiki.net/images/b/b0/Grid_Redstone_%28Repeater%29.png'),
(95, '0', 'Locked Chest', 'http://www.minecraftwiki.net/images/5/56/Grid_Locked_Chest.png'),
(96, '0', 'Trapdoor', 'http://www.minecraftwiki.net/images/b/b2/Grid_Trapdoor.png'),
(97, '0', 'Silverfish Stone', 'http://media-mcw.cursecdn.com/thumb/d/d4/Stone.png/25px-Stone.png'),
(98, '0', 'Strone Brick', 'http://www.minecraftwiki.net/images/1/1c/Grid_Stone_Brick.png'),
(99, '0', 'Brown Mushroom Cap', 'http://www.minecraftwiki.net/images/0/07/Grid_Huge_Brown_Mushroom.png'),
(100, '0', 'Red Mushroom Cap', 'http://www.minecraftwiki.net/images/3/33/Grid_Huge_Red_Mushroom.png'),
(101, '0', 'Iron Bars', 'http://www.minecraftwiki.net/images/0/00/Grid_Iron_Bars.png'),
(102, '0', 'Glass Pane', 'http://www.minecraftwiki.net/images/3/30/Grid_Glass_Pane.png'),
(103, '0', 'Melon Block ', 'http://www.minecraftwiki.net/images/0/09/Grid_Melon_%28Block%29.png'),
(104, '0', 'Pumpkin Stem', 'http://www.minecraftwiki.net/images/thumb/7/7c/Seed_Stem.png/25px-Seed_Stem.png'),
(105, '0', 'Melon Stem', 'http://www.minecraftwiki.net/images/thumb/7/7c/Seed_Stem.png/25px-Seed_Stem.png'),
(106, '0', 'Vines', 'http://www.minecraftwiki.net/images/2/29/Grid_Vines.png'),
(107, '0', 'Fence Gate', 'http://www.minecraftwiki.net/images/c/c2/Grid_Fence_Gate.png'),
(108, '0', 'Brick Stairs', 'http://www.minecraftwiki.net/images/3/3c/Grid_Brick_Stairs.png'),
(109, '0', 'Stone Brick Stairs', 'http://www.minecraftwiki.net/images/a/af/Grid_Stone_Brick_Stairs.png'),
(256, '0', 'Iron Shovel', 'http://www.minecraftwiki.net/images/0/01/Grid_Iron_Shovel.png'),
(257, '0', 'Iron Pickaxe', 'http://www.minecraftwiki.net/images/1/1d/Grid_Iron_Pickaxe.png'),
(258, '0', 'Iron Axe', 'http://www.minecraftwiki.net/images/1/1d/Grid_Iron_Axe.png'),
(259, '0', 'Flint and Steel', 'http://www.minecraftwiki.net/images/f/fb/Grid_Flint_and_Steel.png'),
(260, '0', 'Red Apple', 'http://www.minecraftwiki.net/images/3/39/Grid_Red_Apple.png'),
(261, '0', 'Bow', 'http://www.minecraftwiki.net/images/4/49/Grid_Bow.png'),
(262, '0', 'Arrow', 'http://www.minecraftwiki.net/images/c/cc/Grid_Arrow.png'),
(263, '0', 'Coal Item', 'http://www.minecraftwiki.net/images/1/1c/Grid_Coal_%28Item%29.png'),
(263, '1', 'Charcoal Item', 'http://www.minecraftwiki.net/images/5/54/Grid_Charcoal_%28Item%29.png'),
(264, '0', 'Diamond Gem', 'http://www.minecraftwiki.net/images/c/cf/Grid_Diamond_%28Gem%29.png'),
(265, '0', 'Iron Ingot', 'http://www.minecraftwiki.net/images/c/c6/Grid_Iron_%28Ingot%29.png'),
(266, '0', 'Gold Ingot', 'http://www.minecraftwiki.net/images/6/62/Grid_Gold_%28Ingot%29.png'),
(267, '0', 'Iron Sword', 'http://www.minecraftwiki.net/images/d/d5/Grid_Iron_Sword.png'),
(268, '0', 'Wooden Sword', 'http://www.minecraftwiki.net/images/c/cf/Grid_Wooden_Sword.png'),
(269, '0', 'Wooden Shovel', 'http://www.minecraftwiki.net/images/2/21/Grid_Wooden_Shovel.png'),
(270, '0', 'Wooden Pickaxe', 'http://www.minecraftwiki.net/images/3/3d/Grid_Wooden_Pickaxe.png'),
(271, '0', 'Wooden Axe', 'http://www.minecraftwiki.net/images/2/2a/Grid_Wooden_Axe.png'),
(272, '0', 'Stone Sword', 'http://www.minecraftwiki.net/images/e/e1/Grid_Stone_Sword.png'),
(273, '0', 'Stone Shovel', 'http://www.minecraftwiki.net/images/f/ff/Grid_Stone_Shovel.png'),
(274, '0', 'Stone Pickaxe', 'http://www.minecraftwiki.net/images/d/d2/Grid_Stone_Pickaxe.png'),
(275, '0', 'Stone Axe', 'http://www.minecraftwiki.net/images/5/55/Grid_Stone_Axe.png'),
(276, '0', 'Diamond Sword', 'http://www.minecraftwiki.net/images/8/81/Grid_Diamond_Sword.png'),
(277, '0', 'Diamond Shovel', 'http://www.minecraftwiki.net/images/8/8e/Grid_Diamond_Shovel.png'),
(278, '0', 'Diamond Pickaxe', 'http://www.minecraftwiki.net/images/c/ce/Grid_Diamond_Pickaxe.png'),
(279, '0', 'Diamond Axe', 'http://www.minecraftwiki.net/images/8/8d/Grid_Diamond_Axe.png'),
(280, '0', 'Stick', 'http://www.minecraftwiki.net/images/e/e9/Grid_Stick.png'),
(281, '0', 'Bowl', 'http://www.minecraftwiki.net/images/f/f1/Grid_Bowl.png'),
(282, '0', 'Mushroom Stew', 'http://www.minecraftwiki.net/images/f/fd/Grid_Mushroom_Stew.png'),
(283, '0', 'Gold Sword', 'http://www.minecraftwiki.net/images/1/1f/Grid_Gold_Sword.png'),
(284, '0', 'Gold Shovel', 'http://www.minecraftwiki.net/images/8/85/Grid_Gold_Shovel.png'),
(285, '0', 'Gold Pickaxe', 'http://www.minecraftwiki.net/images/9/95/Grid_Gold_Pickaxe.png'),
(286, '0', 'Axe', 'http://www.minecraftwiki.net/images/9/99/Grid_Gold_Axe.png'),
(287, '0', 'String', 'http://www.minecraftwiki.net/images/f/fa/Grid_String.png'),
(288, '0', 'Feather', 'http://www.minecraftwiki.net/images/a/a7/Grid_Feather.png'),
(289, '0', 'Gunpowder', 'http://www.minecraftwiki.net/images/7/7a/Grid_Gunpowder.png'),
(290, '0', 'Wooden Hoe', 'http://www.minecraftwiki.net/images/e/ea/Grid_Wooden_Hoe.png'),
(291, '0', 'Stone Hoe', 'http://www.minecraftwiki.net/images/b/ba/Grid_Stone_Hoe.png'),
(292, '0', 'Iron Hoe', 'http://www.minecraftwiki.net/images/f/f8/Grid_Iron_Hoe.png'),
(293, '0', 'Daimond Hoe', 'http://www.minecraftwiki.net/images/c/c9/Grid_Diamond_Hoe.png'),
(294, '0', 'Gold Hoe', 'http://www.minecraftwiki.net/images/7/77/Grid_Gold_Hoe.png'),
(295, '0', 'Seeds', 'http://www.minecraftwiki.net/images/6/68/Grid_Seeds.png'),
(296, '0', 'Wheat', 'http://media-mcw.cursecdn.com/c/c4/Grid_Wheat.png'),
(297, '0', 'Bread', 'http://media-mcw.cursecdn.com/d/d4/Grid_Bread.png'),
(298, '0', 'Leather Cap', 'http://www.minecraftwiki.net/images/2/24/Grid_Leather_Cap.png'),
(299, '0', 'Leather Tunic', 'http://www.minecraftwiki.net/images/e/ed/Grid_Leather_Tunic.png'),
(300, '0', 'Leather Pants', 'http://www.minecraftwiki.net/images/c/ce/Grid_Leather_Pants.png'),
(301, '0', 'Leather Boots', 'http://www.minecraftwiki.net/images/0/06/Grid_Leather_Boots.png'),
(302, '0', 'Chain Armor Helmet', 'http://www.minecraftwiki.net/images/c/cf/Grid_Chain_Armor_Helmet.png'),
(303, '0', 'Chain Armor Chestplate', 'http://www.minecraftwiki.net/images/f/f4/Grid_Chain_Armor_Chestplate.png'),
(304, '0', 'Chain Armor Leggings', 'http://www.minecraftwiki.net/images/1/1b/Grid_Chain_Armor_Leggings.png'),
(305, '0', 'Chain Armor Boots', 'http://www.minecraftwiki.net/images/7/74/Grid_Chain_Armor_Boots.png'),
(306, '0', 'Iron Helmet', 'http://www.minecraftwiki.net/images/e/ec/Grid_Iron_Helmet.png'),
(307, '0', 'Iron Chestplate', 'http://www.minecraftwiki.net/images/8/8d/Grid_Iron_Chestplate.png'),
(308, '0', 'Iron Leggings', 'http://www.minecraftwiki.net/images/9/99/Grid_Iron_Leggings.png'),
(309, '0', 'Iron Boots', 'http://www.minecraftwiki.net/images/f/f5/Grid_Iron_Boots.png'),
(310, '0', 'Diamond Helmet', 'http://www.minecraftwiki.net/images/b/bd/Grid_Diamond_Helmet.png'),
(311, '0', 'Diamond Chestplate', 'http://www.minecraftwiki.net/images/e/e7/Grid_Diamond_Chestplate.png'),
(312, '0', 'Diamond Leggings', 'http://www.minecraftwiki.net/images/e/e3/Grid_Diamond_Leggings.png'),
(313, '0', 'Diamond Boots', 'http://www.minecraftwiki.net/images/d/d1/Grid_Diamond_Boots.png'),
(314, '0', 'Gold Helmet', 'http://www.minecraftwiki.net/images/3/3a/Grid_Gold_Helmet.png'),
(315, '0', 'Gold Chestplate', 'http://www.minecraftwiki.net/images/7/7b/Grid_Gold_Chestplate.png'),
(316, '0', 'Gold Leggings', 'http://www.minecraftwiki.net/images/f/f5/Grid_Gold_Leggings.png'),
(317, '0', 'Gold Boots', 'http://www.minecraftwiki.net/images/0/00/Grid_Gold_Boots.png'),
(318, '0', 'Flint', 'http://www.minecraftwiki.net/images/8/82/Grid_Flint.png'),
(319, '0', 'Raw Porkchop', 'http://media-mcw.cursecdn.com/e/ec/Grid_Raw_Porkchop.png'),
(320, '0', 'Cooked Porkchop', 'http://media-mcw.cursecdn.com/b/bd/Grid_Cooked_Porkchop.png'),
(321, '0', 'Painting', 'http://www.minecraftwiki.net/images/c/cc/Grid_Painting.png'),
(322, '0', 'Golden Apple', 'http://media-mcw.cursecdn.com/4/4e/Grid_Golden_Apple.png'),
(323, '0', 'Sign', 'http://www.minecraftwiki.net/images/0/06/Grid_Sign.png'),
(324, '0', 'Wooden Door', 'http://www.minecraftwiki.net/images/c/cd/Grid_Wooden_Door.png'),
(325, '0', 'Bucket', 'http://www.minecraftwiki.net/images/2/2a/Grid_Bucket.png'),
(326, '0', 'Water Bucket', 'http://www.minecraftwiki.net/images/b/bf/Grid_Water_Bucket.png'),
(327, '0', 'Lava Bucket', 'http://www.minecraftwiki.net/images/c/cf/Grid_Lava_Bucket.png'),
(328, '0', 'Minecart', 'http://www.minecraftwiki.net/images/5/58/Grid_Minecart.png'),
(329, '0', 'Saddle', 'http://www.minecraftwiki.net/images/0/09/Grid_Saddle.png'),
(330, '0', 'Iron Door', 'http://www.minecraftwiki.net/images/2/27/Grid_Iron_Door.png'),
(331, '0', 'Redstone Dust', 'http://www.minecraftwiki.net/images/c/c3/Grid_Redstone_%28Dust%29.png'),
(332, '0', 'Snowball', 'http://www.minecraftwiki.net/images/6/67/Grid_Snowball.png'),
(333, '0', 'Boat', 'http://www.minecraftwiki.net/images/5/59/Grid_Boat.png'),
(334, '0', 'Leather', 'http://www.minecraftwiki.net/images/6/66/Grid_Leather.png'),
(335, '0', 'Milk', 'http://media-mcw.cursecdn.com/6/63/Grid_Milk_Bucket.png'),
(336, '0', 'Clay Brick', 'http://www.minecraftwiki.net/images/e/ed/Grid_Clay_%28Brick%29.png'),
(337, '0', 'Clay Item', 'http://www.minecraftwiki.net/images/3/38/Grid_Clay_%28Item%29.png'),
(338, '0', 'Sugar Cane', 'http://www.minecraftwiki.net/images/d/d3/Grid_Sugar_Cane.png'),
(339, '0', 'Paper', 'http://www.minecraftwiki.net/images/6/6c/Grid_Paper.png'),
(340, '0', 'Book', 'http://www.minecraftwiki.net/images/e/ec/Grid_Book.png'),
(341, '0', 'Slimeball', 'http://www.minecraftwiki.net/images/c/c9/Grid_Slimeball.png'),
(342, '0', 'Minecart with Chest', 'http://www.minecraftwiki.net/images/f/f0/Grid_Minecart_with_Chest.png'),
(343, '0', 'Minecart with Furnace', 'http://www.minecraftwiki.net/images/3/36/Grid_Minecart_with_Furnace.png'),
(344, '0', 'Egg', 'http://media-mcw.cursecdn.com/2/27/Grid_Egg.png'),
(345, '0', 'Compass', 'http://www.minecraftwiki.net/images/f/f2/Grid_Compass.png'),
(346, '0', 'Fishing Rod', 'http://www.minecraftwiki.net/images/c/c7/Grid_Fishing_Rod.png'),
(347, '0', 'Clock', 'http://www.minecraftwiki.net/images/3/32/Grid_Clock.png'),
(348, '0', 'Glowstone Dust', 'http://www.minecraftwiki.net/images/2/2c/Grid_Glowstone_%28Dust%29.png'),
(349, '0', 'Raw Fish', '0'),
(350, '0', 'Cooked Fish', 'http://media-mcw.cursecdn.com/2/29/Grid_Cooked_Fish.png'),
(351, '0', 'Ink Sac', 'http://www.minecraftwiki.net/images/d/d6/Grid_Ink_Sac.png'),
(351, '1', 'Rose Red', 'http://www.minecraftwiki.net/images/0/0d/Grid_Rose_Red.png'),
(351, '2', 'Cactus Green', 'http://www.minecraftwiki.net/images/f/fd/Grid_Cactus_Green.png'),
(351, '3', 'Cocoa Beans', 'http://www.minecraftwiki.net/images/7/7d/Grid_Cocoa_Beans.png'),
(351, '4', 'Lapis Lazuli Dye', 'http://www.minecraftwiki.net/images/a/a8/Grid_Lapis_Lazuli_%28Dye%29.png'),
(351, '5', 'Purple Dye', 'http://www.minecraftwiki.net/images/a/a0/Grid_Purple_Dye.png'),
(351, '6', 'Cyan Dye', 'http://www.minecraftwiki.net/images/c/ca/Grid_Cyan_Dye.png'),
(351, '7', 'Light Gray Dye', 'http://www.minecraftwiki.net/images/1/16/Grid_Light_Gray_Dye.png'),
(351, '8', 'Gray Dye', 'http://www.minecraftwiki.net/images/5/54/Grid_Gray_Dye.png'),
(351, '9', 'Pink Dye', 'http://www.minecraftwiki.net/images/b/bb/Grid_Pink_Dye.png'),
(351, '10', 'Lime Dye', 'http://www.minecraftwiki.net/images/a/a6/Grid_Lime_Dye.png'),
(351, '11', 'Dandelion Yellow', 'http://www.minecraftwiki.net/images/d/df/Grid_Dandelion_Yellow.png'),
(351, '12', 'Light Blue Dye', 'http://www.minecraftwiki.net/images/a/ae/Grid_Light_Blue_Dye.png'),
(351, '13', 'Magenta Dye', 'http://www.minecraftwiki.net/images/8/8f/Grid_Magenta_Dye.png'),
(351, '14', 'Orange Dye', 'http://www.minecraftwiki.net/images/b/b2/Grid_Orange_Dye.png'),
(351, '15', 'Bone Meal', 'http://www.minecraftwiki.net/images/c/c0/Grid_Bone_Meal.png'),
(352, '0', 'Bone', 'http://www.minecraftwiki.net/images/e/e8/Grid_Bone.png'),
(353, '0', 'Sugar', 'http://www.minecraftwiki.net/images/9/96/Grid_Sugar.png'),
(354, '0', 'Cake', 'http://www.minecraftwiki.net/images/2/28/Grid_Cake.png'),
(355, '0', 'Bed', 'http://www.minecraftwiki.net/images/a/a3/Grid_Bed.png'),
(356, '0', 'Redstone Repeater', 'http://www.minecraftwiki.net/images/b/b0/Grid_Redstone_%28Repeater%29.png'),
(357, '0', 'Cookie', 'http://www.minecraftwiki.net/images/9/95/Grid_Cookie.png'),
(358, '0', 'Map Item', 'http://www.minecraftwiki.net/images/3/33/Grid_Map_%28Item%29.png'),
(359, '0', 'Shears', 'http://www.minecraftwiki.net/images/1/13/Grid_Shears.png'),
(360, '0', 'Melon Slice', 'http://www.minecraftwiki.net/images/e/ee/Grid_Melon_%28Slice%29.png'),
(361, '0', 'Pumpkin Seeds', 'http://www.minecraftwiki.net/images/7/72/Grid_Pumpkin_Seeds.png'),
(362, '0', 'Melon Seeds', 'http://www.minecraftwiki.net/images/7/75/Grid_Melon_Seeds.png'),
(363, '0', 'Raw Beef', 'http://www.minecraftwiki.net/images/6/61/Grid_Raw_Beef.png'),
(364, '0', 'Steak', 'http://www.minecraftwiki.net/images/d/da/Grid_Steak.png'),
(365, '0', 'Raw Chicken', 'http://www.minecraftwiki.net/images/e/e5/Grid_Raw_Chicken.png'),
(366, '0', 'Cooked Chicken', 'http://www.minecraftwiki.net/images/2/2e/Grid_Cooked_Chicken.png'),
(367, '0', 'Rotten Flesh', 'http://www.minecraftwiki.net/images/3/33/Grid_Rotten_Flesh.png'),
(368, '0', 'Ender Pearl', 'http://www.minecraftwiki.net/images/1/13/Grid_Ender_Pearl.png'),
(2256, '0', 'Gold Disc', 'http://www.minecraftwiki.net/images/5/55/Grid_Gold_Disc.png'),
(2257, '0', 'Green Disc', 'http://www.minecraftwiki.net/images/c/c4/Grid_Green_Disc.png'),
(116, '0', 'Enchantment Table', 'http://www.minecraftwiki.net/images/0/00/Grid_Enchantment_Table.png'),
(379, '0', 'Brewing Stand', 'http://www.minecraftwiki.net/images/7/70/Grid_Brewing_Stand.png'),
(44, '4', 'Brick Slab', 'http://www.minecraftwiki.net/images/0/01/Grid_Brick_Slab.png'),
(44, '5', 'Stone Bricks Slab', 'http://www.minecraftwiki.net/images/4/46/Grid_Stone_Bricks_Slab.png'),
(44, '6', 'Oak Wood Slab', 'http://www.minecraftwiki.net/images/5/5c/Grid_Oak_Wood_Slab.png'),
(44, '7', 'Spruce Wood Slab', 'http://www.minecraftwiki.net/images/6/60/Grid_Spruce_Wood_Slab.png'),
(44, '8', 'Birch Wood Slab', 'http://www.minecraftwiki.net/images/b/bc/Grid_Birch_Wood_Slab.png'),
(381, '0', 'Eye of Ender', 'http://www.minecraftwiki.net/images/0/0e/Grid_Eye_of_Ender.png'),
(380, '0', 'Cauldron', 'http://www.minecraftwiki.net/images/c/ca/Grid_Cauldron.png'),
(382, '0', 'Glistering Melon', 'http://www.minecraftwiki.net/images/1/11/Grid_Glistering_Melon.png'),
(378, '0', 'Magma Cream', 'http://www.minecraftwiki.net/images/e/e8/Grid_Magma_Cream.png'),
(374, '0', 'Glass Bottle', 'http://www.minecraftwiki.net/images/2/22/Grid_Glass_Bottle.png'),
(98, '0', 'Stone Brick', 'http://www.minecraftwiki.net/images/1/1c/Grid_Stone_Brick.png'),
(98, '1', 'Mossy Stone Brick', 'http://www.minecraftwiki.net/images/2/23/Grid_Mossy_Stone_Brick.png'),
(98, '2', 'Cracked Stone Brick', 'http://www.minecraftwiki.net/images/8/85/Grid_Cracked_Stone_Brick.png'),
(98, '3', 'Chiseled Stone Brick', 'http://www.minecraftwiki.net/images/7/7b/Grid_Chiseled_Stone_Brick.png'),
(24, '0', 'Sandstone', 'http://www.minecraftwiki.net/images/1/12/Grid_Sandstone.png'),
(24, '1', 'Decorative Sandstone', 'http://www.minecraftwiki.net/images/1/1b/Grid_Decorative_Sandstone.png'),
(24, '2', 'Smooth Sandstone', 'http://www.minecraftwiki.net/images/2/22/Grid_Smooth_Sandstone.png'),
(5, '1', 'Wooden Plank Pine', 'http://www.minecraftwiki.net/images/b/bb/Grid_Wooden_Plank_%28Pine%29.png'),
(5, '2', 'Wooden Plank Birch', 'http://www.minecraftwiki.net/images/0/01/Grid_Wooden_Plank_%28Birch%29.png'),
(5, '3', 'Wooden Plank Jungle', 'http://www.minecraftwiki.net/images/2/2a/Grid_Wooden_Plank_%28Jungle%29.png'),
(6, '3', 'Sapling Jungle', 'http://www.minecraftwiki.net/images/7/7f/Grid_Sapling_Jungle.png'),
(112, '0', 'Nether Brick', 'http://www.minecraftwiki.net/images/6/62/Grid_Nether_Brick.png'),
(113, '0', 'Nether Brick Fence', 'http://www.minecraftwiki.net/images/5/59/Grid_Nether_Brick_Fence.png'),
(114, '0', 'Nether Brick Stairs', 'http://www.minecraftwiki.net/images/6/68/Grid_Nether_Brick_Stairs.png'),
(17, '3', 'Wood Jungle', 'http://www.minecraftwiki.net/images/5/5e/Grid_Wood_%28Jungle%29.png'),
(18, '7', 'Leaves Jungle', 'http://www.minecraftwiki.net/images/1/1b/Grid_Leaves_%28Jungle%29.png'),
(126, '0', 'Stone Slab', 'http://media-mcw.cursecdn.com/2/29/Grid_Stone_Slab.png'),
(126, '1', 'Sandstone Slab', 'http://media-mcw.cursecdn.com/2/2a/Grid_Sandstone_Slab.png'),
(126, '3', 'Cobblestone Slab', 'http://media-mcw.cursecdn.com/f/f7/Grid_Cobblestone_Slab.png'),
(126, '4', 'Brick Slab', 'http://media-mcw.cursecdn.com/0/01/Grid_Brick_Slab.png'),
(126, '5', 'Stone Bricks Slab', 'http://media-mcw.cursecdn.com/4/46/Grid_Stone_Bricks_Slab.png'),
(135, '0', 'Birch Wood Stairs', 'http://media-mcw.cursecdn.com/d/de/Grid_Birch_Wood_Stairs.png'),
(110, '0', 'Mycelium', 'http://media-mcw.cursecdn.com/a/aa/Grid_Mycelium.png'),
(136, '0', 'Jungle Wood Stairs', 'http://media-mcw.cursecdn.com/b/b9/Grid_Jungle_Wood_Stairs.png'),
(128, '0', 'Sandstone Stairs', 'http://media-mcw.cursecdn.com/0/0d/Grid_Sandstone_Stairs.png'),
(130, '0', 'Ender Chest', 'http://media-mcw.cursecdn.com/5/56/Grid_Ender_Chest.png'),
(120, '0', 'End Portal Frame', 'http://media-mcw.cursecdn.com/thumb/5/56/End_Portal_Frame.png/25px-End_Portal_Frame.png'),
(111, '0', 'Lily Pad', 'http://media-mcw.cursecdn.com/4/49/Grid_Lily_Pad.png'),
(123, '0', 'Redstone Lamp', 'http://media-mcw.cursecdn.com/f/fa/Grid_Redstone_Lamp.png'),
(131, '0', 'Tripwire Hook', 'http://media-mcw.cursecdn.com/9/90/Grid_Tripwire_Hook.png'),
(383, '50', 'Spawn Creeper', 'http://media-mcw.cursecdn.com/f/fc/Grid_Spawn_Creeper.png'),
(383, '51', 'Spawn Skeleton', 'http://media-mcw.cursecdn.com/3/35/Grid_Spawn_Skeleton.png'),
(383, '52', 'Spawn Spider', 'http://media-mcw.cursecdn.com/5/50/Grid_Spawn_Spider.png'),
(383, '54', 'Spawn Zombie', 'http://media-mcw.cursecdn.com/3/30/Grid_Spawn_Zombie.png'),
(383, '55', 'Spawn Slime', 'http://media-mcw.cursecdn.com/1/11/Grid_Spawn_Slime.png'),
(383, '56', 'Spawn Ghast', 'http://media-mcw.cursecdn.com/3/3f/Grid_Spawn_Ghast.png'),
(383, '57', 'Spawn Pig Zombie', 'http://media-mcw.cursecdn.com/7/7b/Grid_Spawn_Pig_Zombie.png'),
(383, '58', 'Spawn Enderman', 'http://media-mcw.cursecdn.com/6/62/Grid_Spawn_Enderman.png'),
(383, '59', 'Spawn Cave Spider', 'http://media-mcw.cursecdn.com/e/ee/Grid_Spawn_Cave_Spider.png'),
(383, '60', 'Spawn Silverfish', 'http://media-mcw.cursecdn.com/1/11/Grid_Spawn_Silverfish.png'),
(383, '61', 'Spawn Blaze', 'http://media-mcw.cursecdn.com/f/ff/Grid_Spawn_Blaze.png'),
(383, '62', 'Spawn Magma Cube', 'http://media-mcw.cursecdn.com/2/25/Grid_Spawn_Magma_Cube.png'),
(383, '90', 'Spawn Pig', 'http://media-mcw.cursecdn.com/0/09/Grid_Spawn_Pig.png'),
(383, '91', 'Spawn Sheep', 'http://media-mcw.cursecdn.com/f/f8/Grid_Spawn_Sheep.png'),
(383, '92', 'Spawn Cow', 'http://media-mcw.cursecdn.com/8/80/Grid_Spawn_Cow.png'),
(383, '93', 'Spawn Chicken', 'http://media-mcw.cursecdn.com/b/b0/Grid_Spawn_Chicken.png'),
(383, '94', 'Spawn Squid', 'http://media-mcw.cursecdn.com/5/58/Grid_Spawn_Squid.png'),
(383, '95', 'Spawn Wolf', 'http://media-mcw.cursecdn.com/4/4b/Grid_Spawn_Wolf.png'),
(383, '96', 'Spawn Mooshroom', 'http://media-mcw.cursecdn.com/9/91/Grid_Spawn_Mooshroom.png'),
(383, '97', 'Snow Golem', '0'),
(383, '53', 'Spawn Gigant', '0'),
(383, '63', 'Spawn Ender Dragon', '0'),
(383, '98', 'Spawn Ocelot', 'http://media-mcw.cursecdn.com/e/e8/Grid_Spawn_Ocelot.png'),
(383, '99', 'Spawn Iron Golem', '0'),
(383, '120', 'Spawn Villager', 'http://media-mcw.cursecdn.com/0/02/Grid_Spawn_Villager.png'),
(384, '0', 'Bottle Enchanting', 'http://media-mcw.cursecdn.com/b/bf/Grid_Bottle_o%27_Enchanting.png'),
(385, '0', 'Fire Charge', 'http://media-mcw.cursecdn.com/e/e1/Grid_Fire_Charge.png'),
(386, '0', 'Book and Quill', 'http://media-mcw.cursecdn.com/e/eb/Grid_Book_and_Quill.png'),
(2258, '0', 'Blocks Disc', 'http://media-mcw.cursecdn.com/4/4d/Grid_Blocks_Disc.png'),
(2259, '0', 'Chirp Disc', 'http://media-mcw.cursecdn.com/b/be/Grid_Chirp_Disc.png'),
(2260, '0', 'Far Disc', 'http://media-mcw.cursecdn.com/9/9e/Grid_Far_Disc.png'),
(2261, '0', 'Mall Disc', 'http://media-mcw.cursecdn.com/b/b8/Grid_Mall_Disc.png'),
(2263, '0', 'Stal Disc', 'http://media-mcw.cursecdn.com/1/1d/Grid_Stal_Disc.png'),
(2262, '0', 'Mellohi Disc', 'http://media-mcw.cursecdn.com/7/7a/Grid_Mellohi_Disc.png'),
(2264, '0', 'Strad Disc', 'http://media-mcw.cursecdn.com/a/aa/Grid_Strad_Disc.png'),
(2265, '0', 'Ward Disc', 'http://media-mcw.cursecdn.com/d/da/Grid_Ward_Disc.png'),
(2266, '0', '11 Disc', 'http://media-mcw.cursecdn.com/e/e4/Grid_11_Disc.png'),
(375, '0', 'Spider Eye', 'http://media-mcw.cursecdn.com/0/03/Grid_Spider_Eye.png'),
(377, '0', 'Blaze Powder', 'http://media-mcw.cursecdn.com/0/09/Grid_Blaze_Powder.png'),
(369, '0', 'Blaze Rod', 'http://media-mcw.cursecdn.com/1/18/Grid_Blaze_Rod.png'),
(372, '0', 'Nether Wart Seeds', 'http://media-mcw.cursecdn.com/f/f2/Grid_Nether_Wart_Seeds.png'),
(388, '0', 'Emerald', 'http://media-mcw.cursecdn.com/8/87/Grid_Emerald.png'),
(371, '0', 'Gold Nugget', 'http://media-mcw.cursecdn.com/1/1d/Grid_Gold_Nugget.png'),
(97, '1', 'Cobblestone Monster Egg', 'http://media-mcw.cursecdn.com/0/03/Grid_Cobblestone.png'),
(97, '2', 'Stron Brick Monster Egg', 'http://media-mcw.cursecdn.com/1/1c/Grid_Stone_Brick.png'),
(0, '0', '0', '0'),
(0, '0', '0', '0'),
(322, '1', 'Golden Apple (spezial)', 'http://media-mcw.cursecdn.com/4/4e/Grid_Golden_Apple.png'),
(126, '2', 'Birch Wood Slab', 'http://media-mcw.cursecdn.com/b/bc/Grid_Birch_Wood_Slab.png');

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

--
-- Tabellenstruktur für Tabelle `lagerhaus`
--

CREATE TABLE IF NOT EXISTS `lagerhaus` (
  `User` varchar(200) NOT NULL,
  `ItemID` varchar(200) NOT NULL,
  `ItemStack` int(11) NOT NULL,
  `ItemPrice` double NOT NULL,
  `AuktionsID` int(11) NOT NULL AUTO_INCREMENT,
  `ItemBytes` varchar(200) NOT NULL,
  `EnchString` varchar(400) NOT NULL,
  `EnchInt` varchar(200) NOT NULL,
  `Damage` varchar(200) NOT NULL,
  KEY `AuktionsID` (`AuktionsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `language`
--

CREATE TABLE IF NOT EXISTS `language` (
  `holder` varchar(200) NOT NULL,
  `de` varchar(200) NOT NULL,
  `en` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `language`
--

INSERT INTO `language` (`holder`, `de`, `en`) VALUES
('#menu1', 'Startseite', 'Home'),
('#menu2', 'Deine Auktionen', 'Your Auctions'),
('#menu3', 'Dein Lagerhaus', 'Your StoreHouse'),
('#menu4', 'Dein Postfach', 'Your Post Box'),
('#menu5', 'Profil Einstellungen', 'Profil Settings'),
('#menu6', 'Statistik', 'Statistics'),
('#menu7', 'Feedback / Bug Report', 'Feedback / Bug Report'),
('#menu8', 'Ausloggen', 'Logout'),
('#nav_titel', 'Auktions Menü', 'Auctions Menue'),
('#nav_search', 'Item Suchen', 'Item Search'),
('#nav_all', 'Alle Items', 'All Items'),
('#nav_wood', 'Holz', 'Wood'),
('#nav_lether', 'Leder', 'Lether'),
('#nav_iron', 'Eisen', 'Iron'),
('#nav_diamond', 'Diamand', 'Diamond'),
('#nav_gold', 'Gold', 'Gold'),
('#nav_stone_blocks', 'Stein Blöcke', 'Stone Blocks'),
('#nav_wood_blocks', 'Holz Blöcke', 'Wood Blocks'),
('#nav_ore_blocks', 'Erz Blöcke', 'Ore Blocks'),
('#nav_wool', 'Wolle', 'Wool'),
('#nav_w_t', 'Waffen & Werkzeug', 'Weapons & Tools'),
('#nav_armor', 'Rüstung', 'Armor'),
('#nav_food', 'Nahrungsmittel', 'Food'),
('#nav_drinks', 'Tränke', 'Drinks'),
('#nav_something', 'Sonstiges', 'Something'),
('#nav_cart', 'Warenkorb', 'Cart List'),
('#mc_titel', 'Minecraft Auktionen', 'Minecraft Auctions'),
('#list_id', 'Item ID', 'Item ID'),
('#list_stack', 'Item Stack', 'Item Stack'),
('#list_price', 'Preis', 'Price'),
('#list_solo_price', 'Einzelpreis', 'Solo Price'),
('#list_ench', 'Verzauberung', 'Enchantments'),
('#list_seller', 'Verkäufer', 'Seller'),
('#list_aid', 'Auktions ID', 'Auctions ID'),
('#list_action', 'Aktionen', 'Actions'),
('#profil_select_action', '[Aktion Auswählen]', '[Selected Action]'),
('#pofil_items_sell', 'Item(s) verkaufen', 'Item(s) sell'),
('#profil_items_delete', 'Item(s) löschen', 'Items(s) delete'),
('#profil_move_post', 'ins Postfach stupsen', 'poke into Post Box'),
('#profil_move_store', 'ins Lagerhaus stupsen', 'poke into StoreHouse'),
('#profil_select_all_items', 'Alle Items selektieren', 'select all  Items'),
('#profil_deselect_all_items', 'selektierung entfernen', 'remove selected Items'),
('#profil_title', 'Profil von', 'Profil by'),
('#profil_break', 'abbrechen', 'Cancel'),
('#profil_list', 'Aktionsliste', 'Actionlist'),
('#profil_input_price', 'Preis eingeben:', 'Input Price:'),
('#profil_stats_money', 'Kontostand:', 'Money:'),
('#profil_stats_auctions', 'Aktuelle Auktionen', 'Your Auctions'),
('#profil_stats_post', 'Postfach:', 'Post Box:'),
('#profil_stats_store', 'Lagerhaus:', 'Storehouse:'),
('#profil_stats_sell_items', 'Items verkauft:', 'Selled Items:'),
('#list_break', 'Abbrechen', 'Cancel'),
('#list_enchantments', 'keine Verzauberung', 'No Enchantments'),
('#profil_settings_changepw', 'Passwort ändern:', 'Change Password:'),
('#profil_settings_confirm', 'Bestätigen', 'Confirm'),
('#profil_settings_changelanguage', 'Sprache wechseln:', 'Change Language:');

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

--
-- Tabellenstruktur für Tabelle `language_list`
--

CREATE TABLE IF NOT EXISTS `language_list` (
  `index` int(11) NOT NULL,
  `shortcuts` varchar(200) NOT NULL,
  `language` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `language_list`
--

INSERT INTO `language_list` (`index`, `shortcuts`, `language`) VALUES
(1, 'de', 'German'),
(2, 'en', 'English');

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

--
-- Tabellenstruktur für Tabelle `money`
--

CREATE TABLE IF NOT EXISTS `money` (
  `User` varchar(200) NOT NULL,
  `Money` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Tabellenstruktur für Tabelle `placeholder`
--

CREATE TABLE IF NOT EXISTS `placeholder` (
  `variable` varchar(200) NOT NULL,
  `value` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `placeholder`
--

INSERT INTO `placeholder` (`variable`, `value`) VALUES
('{css}', 'DEVIT_TEMPcss/'),
('{action}', '?overlay='),
('{images}', 'DEVIT_TEMPimages/'),
('{js}', 'DEVIT_TEMPjs/'),
('ä', '&auml;'),
('ö', '&ouml;'),
('Ö', '&Ouml;'),
('ü', '&uuml;'),
('Ü', '&Uuml;'),
('©', '&copy;'),
('ß', '&szlig;');

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

--
-- Tabellenstruktur für Tabelle `postfach`
--

CREATE TABLE IF NOT EXISTS `postfach` (
  `User` varchar(200) NOT NULL,
  `ItemID` varchar(200) NOT NULL,
  `ItemStack` int(11) NOT NULL,
  `ItemPrice` double NOT NULL,
  `AuktionsID` int(200) NOT NULL AUTO_INCREMENT,
  `ItemBytes` varchar(200) NOT NULL,
  `EnchString` varchar(400) NOT NULL,
  `EnchInt` varchar(200) NOT NULL,
  `Damage` varchar(200) NOT NULL,
  KEY `AuktionsID` (`AuktionsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
