sad

-- phpMyAdmin SQL Dump
-- version 4.2.8
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:3306
-- Generation Time: Sep 02, 2014 at 09:03 PM
-- Server version: 5.6.20
-- PHP Version: 5.5.9-1ubuntu4.3

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

--
-- Database: `rarlon`
--

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

--
-- Table structure for table `Block`
--

CREATE TABLE `Block` (
  `Number` int(11) NOT NULL,
  `Location` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `czlonkowie`
--

CREATE TABLE `czlonkowie` (
  `nick` char(50) DEFAULT NULL,
  `gildia` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `enderchest`
--

CREATE TABLE `enderchest` (
`id` int(11) NOT NULL,
  `playerID` int(11) NOT NULL,
  `content` blob,
  `server` char(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `Gracze`
--

CREATE TABLE `Gracze` (
  `Nick` text NOT NULL,
  `Haslo` text NOT NULL,
  `ip` text NOT NULL,
  `premium` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `inventory`
--

CREATE TABLE `inventory` (
`id` int(11) NOT NULL,
  `playerID` int(11) NOT NULL,
  `content` blob,
  `armor` blob,
  `server` char(32) DEFAULT NULL,
  `min_health` double NOT NULL,
  `max_health` double NOT NULL,
  `food` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `player`
--

CREATE TABLE `player` (
`id` int(11) NOT NULL,
  `playername` varchar(16) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `player`
--

INSERT INTO `player` (`id`, `playername`) VALUES
(1, 'Omegs');

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

--
-- Table structure for table `sojusze`
--

CREATE TABLE `sojusze` (
  `g0` char(50) DEFAULT NULL,
  `g1` char(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `statystyki`
--

CREATE TABLE `statystyki` (
  `nick` text,
  `punkty` int(10) DEFAULT NULL,
  `zabojstwa` int(10) DEFAULT NULL,
  `smierci` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `enderchest`
--
ALTER TABLE `enderchest`
 ADD PRIMARY KEY (`id`,`playerID`), ADD UNIQUE KEY `adf` (`playerID`,`server`) USING BTREE, ADD KEY `fk_enderchest_player_idx` (`playerID`);

--
-- Indexes for table `inventory`
--
ALTER TABLE `inventory`
 ADD PRIMARY KEY (`id`,`playerID`), ADD UNIQUE KEY `adf` (`playerID`,`server`) USING BTREE, ADD KEY `fk_inventories_player_idx` (`playerID`);

--
-- Indexes for table `player`
--
ALTER TABLE `player`
 ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `enderchest`
--
ALTER TABLE `enderchest`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `inventory`
--
ALTER TABLE `inventory`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `player`
--
ALTER TABLE `player`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `inventory`
--
ALTER TABLE `inventory`
ADD CONSTRAINT `fk_inventories_player` FOREIGN KEY (`playerID`) REFERENCES `player` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;