OGARNIECIE? :D

-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost:3066
-- Czas wygenerowania: 30 Sty 2014, 21:32
-- Wersja serwera: 5.5.29
-- Wersja PHP: 5.3.10-1ubuntu3.6

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 */;

--
-- Baza danych: `Guilds`
--

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

--
-- Struktura tabeli dla  `Gildie`
--

CREATE TABLE IF NOT EXISTS `Gildie` (
  `gildiaID` INT(11) NOT NULL AUTO_INCREMENT,
  `liderID` INT(11) NOT NULL,
  `tag` VARCHAR(6) NOT NULL,
  `nazwa` VARCHAR(64) NOT NULL,
  `opis` VARCHAR(256) DEFAULT NULL,
  `bazaworld` VARCHAR(16) DEFAULT NULL,
  `bazaX` INT(11) DEFAULT NULL,
  `bazaY` INT(11) DEFAULT NULL,
  `bazaZ` INT(11) DEFAULT NULL,
  `zalozono` BIGINT(20) NOT NULL,
  `promienCuboid` BIGINT(20) DEFAULT NULL,
  `friendlyFire` INT(11) DEFAULT NULL,
  `zastepcaID` INT(11) DEFAULT NULL,
  PRIMARY KEY (`gildiaID`),
  UNIQUE KEY `liderID` (`liderID`),
  UNIQUE KEY `tag` (`tag`),
  UNIQUE KEY `nazwa` (`nazwa`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla  `Gracze`
--

CREATE TABLE IF NOT EXISTS `Gracze` (
  `graczID` INT(11) NOT NULL AUTO_INCREMENT,
  `gildiaID` INT(11) DEFAULT NULL,
  `nick` VARCHAR(16) NOT NULL,
  `ranking` INT(11) NOT NULL,
  PRIMARY KEY (`graczID`),
  UNIQUE KEY `nick` (`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla  `Sojusze`
--

CREATE TABLE IF NOT EXISTS `Sojusze` (
  `sojuszID` INT(11) NOT NULL AUTO_INCREMENT,
  `gildiaID1` INT(11) NOT NULL,
  `gildiaID2` INT(11) NOT NULL,
  `propozycjaSojuszu` tinyint(4) NOT NULL,
  PRIMARY KEY (`sojuszID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla  `Zaproszenia`
--

CREATE TABLE IF NOT EXISTS `Zaproszenia` (
  `zaproszenieID` INT(11) NOT NULL AUTO_INCREMENT,
  `graczID` INT(11) NOT NULL,
  `gildiaID` INT(11) NOT NULL,
  PRIMARY KEY (`zaproszenieID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla  `Zgony`
--

CREATE TABLE IF NOT EXISTS `Zgony` (
  `zgonID` INT(11) NOT NULL AUTO_INCREMENT,
  `powod` VARCHAR(16) NOT NULL,
  `zabityID` INT(11) NOT NULL,
  `zabijajacyID` INT(11) DEFAULT NULL,
  PRIMARY KEY (`zgonID`)
) 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 */;