-- phpMyAdmin SQL Dump
-- version 3.3.7deb5build0.10.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 10. Februar 2012 um 19:36
-- Server Version: 5.1.49
-- PHP-Version: 5.3.3-1ubuntu9.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `wordpress`
--

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

--
-- Tabellenstruktur für Tabelle `cs_match`
--

CREATE TABLE IF NOT EXISTS `cs_match` (
  `mid` int(11) NOT NULL AUTO_INCREMENT,
  `round` char(1) DEFAULT NULL,
  `spieltag` int(11) NOT NULL,
  `tid1` varchar(8) NOT NULL,
  `tid2` varchar(8) NOT NULL,
  `location` varchar(80) NOT NULL,
  `matchtime` datetime NOT NULL,
  `result1` int(11) NOT NULL,
  `result2` int(11) NOT NULL,
  `winner` tinyint(1) NOT NULL,
  `ptid1` int(11) NOT NULL,
  `ptid2` int(11) NOT NULL,
  PRIMARY KEY (`mid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;

--
-- Daten für Tabelle `cs_match`
--

INSERT INTO `cs_match` (`mid`, `round`, `spieltag`, `tid1`, `tid2`, `location`, `matchtime`, `result1`, `result2`, `winner`, `ptid1`, `ptid2`) VALUES
(1, 'V', 0, '2', '3', 'Saint-Denis ', '2016-06-10 21:00:00', -1, -1, -1, -1, -1),
(2, 'V', 0, '1', '4', 'Lens', '2016-06-11 15:00:00', -1, -1, -1, -1, -1),
(3, 'V', 0, '8', '7', 'Bordeaux', '2016-06-11 18:00:00', -1, -1, -1, -1, -1),
(4, 'V', 0, '5', '6', 'Marseille', '2016-06-11 21:00:00', -1, -1, -1, -1, -1),
(5, 'V', 0, '16', '13', 'Paris', '2016-06-12 15:00:00', -1, -1, -1, -1, -1),
(6, 'V', 0, '11', '10', 'Nizza', '2016-06-12 18:00:00', -1, -1, -1, -1, -1),
(7, 'V', 0, '9', '12', 'Lille', '2016-06-12 21:00:00', -1, -1, -1, -1, -1),
(8, 'V', 0, '15', '14', 'Toulouse', '2016-06-13 15:00:00', -1, -1, -1, -1, -1),
(9, 'V', 0, '19', '20', 'Saint-Denis', '2016-06-13 18:00:00', -1, -1, -1, -1, -1),
(10, 'V', 0, '17', '18', 'Lyon', '2016-06-13 21:00:00', -1, -1, -1, -1, -1),
(11, 'V', 0, '21', '22', 'Bordeaux', '2016-06-14 18:00:00', -1, -1, -1, -1, -1),
(12, 'V', 0, '24', '23', 'Saint-Etienne', '2016-06-14 21:00:00', -1, -1, -1, -1, -1),
(13, 'V', 0, '6', '7', 'Lille', '2016-06-15 15:00:00', -1, -1, -1, -1, -1),
(14, 'V', 0, '3', '4', 'Paris', '2016-06-15 18:00:00', -1, -1, -1, -1, -1),
(15, 'V', 0, '2', '1', 'Marseille', '2016-06-15 21:00:00', -1, -1, -1, -1, -1),
(16, 'V', 0, '5', '8', 'Lens', '2016-06-16 15:00:00', -1, -1, -1, -1, -1),
(17, 'V', 0, '12', '10', 'Lyon', '2016-06-16 18:00:00', -1, -1, -1, -1, -1),
(18, 'V', 0, '9', '11', 'Saint-Denis', '2016-06-16 21:00:00', -1, -1, -1, -1, -1),
(19, 'V', 0, '18', '20', 'Toulouse', '2016-06-17 15:00:00', -1, -1, -1, -1, -1),
(20, 'V', 0, '14', '13', 'Saint-Etienne', '2016-06-17 18:00:00', -1, -1, -1, -1, -1),
(21, 'V', 0, '15', '16', 'Nizza', '2016-06-17 21:00:00', -1, -1, -1, -1, -1),
(22, 'V', 0, '17', '19', 'Bordeaux', '2016-06-18 15:00:00', -1, -1, -1, -1, -1),
(23, 'V', 0, '23', '22', 'Marseille', '2016-06-18 18:00:00', -1, -1, -1, -1, -1),
(24, 'V', 0, '24', '21', 'Paris', '2016-06-18 21:00:00', -1, -1, -1, -1, -1),
(25, 'V', 0, '4', '2', 'Lille', '2016-06-19 21:00:00', -1, -1, -1, -1, -1),
(26, 'V', 0, '3', '1', 'Lyon', '2016-06-19 21:00:00', -1, -1, -1, -1, -1),
(27, 'V', 0, '7', '5', 'Saint-Etienne', '2016-06-20 21:00:00', -1, -1, -1, -1, -1),
(28, 'V', 0, '6', '8', 'Toulouse', '2016-06-20 21:00:00', -1, -1, -1, -1, -1),
(29, 'V', 0, '10', '9', 'Paris', '2016-06-21 18:00:00', -1, -1, -1, -1, -1),
(30, 'V', 0, '27', '28', 'Marseille', '2016-06-21 18:00:00', -1, -1, -1, -1, -1),
(31, 'V', 0, '13', '15', 'Bordeaux', '2016-06-21 21:00:00', -1, -1, -1, -1, -1),
(32, 'V', 0, '14', '16', 'Lens', '2016-06-21 21:00:00', -1, -1, -1, -1, -1),
(33, 'V', 0, '23', '21', 'Saint-Denis', '2016-06-22 18:00:00', -1, -1, -1, -1, -1),
(34, 'V', 0, '22', '24', 'Lyon', '2016-06-22 18:00:00', -1, -1, -1, -1, -1),
(35, 'V', 0, '20', '17', 'Nizza', '2016-06-22 21:00:00', -1, -1, -1, -1, -1),
(36, 'V', 0, '18', '19', 'Lille', '2016-06-22 21:00:00', -1, -1, -1, -1, -1),
(37, 'F', -1, '25', '26', 'Saint-Etienne', '2016-06-25 15:00:00', -1, -1, -1, 25, 26),
(38, 'F', -1, '27', '28', 'Paris', '2016-06-25 18:00:00', -1, -1, -1, 27, 28),
(39, 'F', -1, '29', '30', 'Lens', '2016-06-25 21:00:00', -1, -1, -1, 29, 30),
(40, 'F', -1, '31', '32', 'Lyon', '2016-06-26 15:00:00', -1, -1, -1, 31, 32),
(41, 'F', -1, '33', '34', 'Lille', '2016-06-26 18:00:00', -1, -1, -1, 33, 34),
(42, 'F', -1, '35', '36', 'Toulouse', '2016-06-26 21:00:00', -1, -1, -1, 35, 36),
(43, 'F', -1, '37', '38', 'Saint-Denis', '2016-06-27 18:00:00', -1, -1, -1, 37, 38),
(44, 'F', -1, '39', '40', 'Nizza', '2016-06-27 21:00:00', -1, -1, -1, 39, 40),
(45, 'F', -1, '41', '42', 'Marseille', '2016-06-30 21:00:00', -1, -1, -1, 41, 42),
(46, 'F', -1, '43', '44', 'Lille', '2016-07-01 21:00:00', -1, -1, -1, 43, 44),
(47, 'F', -1, '45', '46', 'Bordeaux', '2016-07-02 21:00:00', -1, -1, -1, 45, 46),
(48, 'F', -1, '47', '48', 'Saint-Denis', '2016-07-03 21:00:00', -1, -1, -1, 47, 48),
(49, 'F', -1, '49', '50', 'Lyon', '2016-07-06 21:00:00', -1, -1, -1, 49, 50),
(50, 'F', -1, '51', '52', 'Marseille', '2016-07-07 21:00:00', -1, -1, -1, 51, 52),
(51, 'F', -1, '53', '54', 'Saint-Denis', '2016-07-10 21:00:00', -1, -1, -1, 53, 54);


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

--
-- Tabellenstruktur für Tabelle `cs_team`
--

CREATE TABLE IF NOT EXISTS `cs_team` (
  `tid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `shortname` varchar(5) NOT NULL,
  `icon` varchar(40) NOT NULL,
  `groupid` varchar(2) NOT NULL,
  `qualified` tinyint(1) NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;

--
-- Daten für Tabelle `cs_team`
--

INSERT INTO `cs_team` (`tid`, `name`, `shortname`, `icon`, `groupid`, `qualified`) VALUES
(1, 'Albanien', 'ALB', 'AL.png', 'A', 0),
(2, 'Frankreich', 'FRA', 'FR.png', 'A', 0),
(3, 'Rumänien', 'ROU', 'RO.png', 'A', 0),
(4, 'Schweiz', 'CHE', 'CH.png', 'A', 0),
(5, 'England', 'ENG', 'EN.png', 'B', 0),
(6, 'Russland', 'RUS', 'RU.png', 'B', 0),
(7, 'Slowakei', 'SVK', 'SL.png', 'B', 0),
(8, 'Wales', 'WAL', 'WA.png', 'B', 0),
(9, 'Deutschland', 'DEU', 'DE.png', 'C', 0),
(10, 'Nordirland', 'NIR', 'NI.png', 'C', 0),
(11, 'Polen', 'POL', 'PL.png', 'C', 0),
(12, 'Ukraine', 'UKR', 'UA.png', 'C', 0),
(13, 'Kroatien', 'HRV', 'HR.png', 'D', 0),
(14, 'Tschechien', 'CZE', 'CZ.png', 'D', 0),
(15, 'Spanien', 'ESP', 'ES.png', 'D', 0),
(16, 'Türkei', 'TUR', 'TR.png', 'D', 0),
(17, 'Belgien', 'BEL', 'BE.png', 'E', 0),
(18, 'Italien', 'ITA', 'IT.png', 'E', 0),
(19, 'Irland', 'IRL', 'IR.png', 'E', 0),
(20, 'Schweden', 'SWE', 'SE.png', 'E', 0),
(21, 'Österreich', 'AUS', 'AT.png', 'F', 0),
(22, 'Ungarn', 'HUN', 'HU.png', 'F', 0),
(23, 'Island', 'ICE', 'IS.png', 'F', 0),
(24, 'Portugal', 'POR', 'PT.png', 'F', 0),
(25, '#A2', '', '', '', 1),
(26, '#C2', '', '', '', 1),
(27, '#B1', '', '', '', 1),
(28, '#ACD3', '', '', '', 1),
(29, '#D1', '', '', '', 1),
(30, '#BEF3', '', '', '', 1),
(31, '#A1', '', '', '', 1),
(32, '#CDE3', '', '', '', 1),
(33, '#C1', '', '', '', 1),
(34, '#ABF3', '', '', '', 1),
(35, '#F1', '', '', '', 1),
(36, '#E2', '', '', '', 1),
(37, '#E1', '', '', '', 1),
(38, '#D2', '', '', '', 1),
(39, '#B2', '', '', '', 1),
(40, '#F2', '', '', '', 1),
(41, '#W37', '', '', '', 1),
(42, '#W39', '', '', '', 1),
(43, '#W38', '', '', '', 1),
(44, '#W42', '', '', '', 1),
(45, '#W41', '', '', '', 1),
(46, '#W43', '', '', '', 1),
(47, '#W40', '', '', '', 1),
(48, '#W44', '', '', '', 1),
(49, '#W45', '', '', '', 1),
(50, '#W46', '', '', '', 1),
(51, '#W47', '', '', '', 1),
(52, '#W48', '', '', '', 1),
(53, '#W49', '', '', '', 1),
(54, '#W50', '', '', '', 1);
