-- phpMyAdmin SQL Dump
-- version 4.0.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 13. Apr 2014 um 15:29
-- Server Version: 5.5.33a-MariaDB
-- PHP-Version: 5.5.5

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: `wordpresstable`
--

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

--
-- 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=65 ;

--
-- 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, '1', '2', 'São Paulo', '2014-06-12 22:00:00', -1, -1, -1, -1, -1),
(2, 'V', 0, '3', '4', 'Natal ', '2014-06-13 18:00:00', -1, -1, -1, -1, -1),
(3, 'V', 0, '5', '6', 'Salvador', '2014-06-13 21:00:00', -1, -1, -1, -1, -1),
(4, 'V', 0, '7', '8', 'Cuiabá', '2014-06-14 00:00:00', -1, -1, -1, -1, -1),
(5, 'V', 0, '9', '10', 'Belo Horizonte', '2014-06-14 18:00:00', -1, -1, -1, -1, -1),
(6, 'V', 0, '11', '12', 'Recife', '2014-06-15 03:00:00', -1, -1, -1, -1, -1),
(7, 'V', 0, '13', '14', 'Fortaleza', '2014-06-14 21:00:00', -1, -1, -1, -1, -1),
(8, 'V', 0, '15', '16', 'Manaus', '2014-06-15 00:00:00', -1, -1, -1, -1, -1),
(9, 'V', 0, '17', '18', 'Brasília', '2014-06-15 18:00:00', -1, -1, -1, -1, -1),
(10, 'V', 0, '19', '20', 'Porto Alegre', '2014-06-15 21:00:00', -1, -1, -1, -1, -1),
(11, 'V', 0, '21', '22', 'Rio De Janeiro', '2014-06-16 00:00:00', -1, -1, -1, -1, -1),
(12, 'V', 0, '23', '24', 'Curitiba', '2014-06-16 21:00:00', -1, -1, -1, -1, -1),
(13, 'V', 0, '25', '26', 'Salvador', '2014-06-16 18:00:00', -1, -1, -1, -1, -1),
(14, 'V', 0, '27', '28', 'Natal', '2014-06-17 00:00:00', -1, -1, -1, -1, -1),
(15, 'V', 0, '29', '30', 'Belo Horizonte', '2014-06-17 18:00:00', -1, -1, -1, -1, -1),
(16, 'V', 0, '31', '32', 'Cuiabá', '2014-06-18 00:00:00', -1, -1, -1, -1, -1),
(17, 'V', 0, '1', '3', 'Fortaleza', '2014-06-17 21:00:00', -1, -1, -1, -1, -1),
(18, 'V', 0, '4', '2', 'Manaus', '2014-06-19 00:00:00', -1, -1, -1, -1, -1),
(19, 'V', 0, '5', '7', 'Rio De Janeiro', '2014-06-18 21:00:00', -1, -1, -1, -1, -1),
(20, 'V', 0, '8', '6', 'Porto Alegre', '2014-06-18 18:00:00', -1, -1, -1, -1, -1),
(21, 'V', 0, '9', '11', 'Brasília', '2014-06-19 18:00:00', -1, -1, -1, -1, -1),
(22, 'V', 0, '12', '10', 'Natal', '2014-06-20 00:00:00', -1, -1, -1, -1, -1),
(23, 'V', 0, '13', '15', 'São Paulo', '2014-06-19 21:00:00', -1, -1, -1, -1, -1),
(24, 'V', 0, '16', '14', 'Recife', '2014-06-20 18:00:00', -1, -1, -1, -1, -1),
(25, 'V', 0, '17', '19', 'Salvador', '2014-06-20 21:00:00', -1, -1, -1, -1, -1),
(26, 'V', 0, '20', '18', 'Curitiba', '2014-06-21 00:00:00', -1, -1, -1, -1, -1),
(27, 'V', 0, '21', '23', 'Belo Horizonte', '2014-06-21 18:00:00', -1, -1, -1, -1, -1),
(28, 'V', 0, '24', '22', 'Cuiabá', '2014-06-22 00:00:00', -1, -1, -1, -1, -1),
(29, 'V', 0, '25', '27', 'Fortaleza', '2014-06-21 21:00:00', -1, -1, -1, -1, -1),
(30, 'V', 0, '28', '26', 'Manaus', '2014-06-23 00:00:00', -1, -1, -1, -1, -1),
(31, 'V', 0, '29', '31', 'Rio De Janeiro', '2014-06-22 18:00:00', -1, -1, -1, -1, -1),
(32, 'V', 0, '32', '30', 'Porto Alegre', '2014-06-22 21:00:00', -1, -1, -1, -1, -1),
(33, 'V', 0, '4', '1', 'Brasília', '2014-06-23 22:00:00', -1, -1, -1, -1, -1),
(34, 'V', 0, '2', '3', 'Recife', '2014-06-23 22:00:00', -1, -1, -1, -1, -1),
(35, 'V', 0, '8', '5', 'Curitiba', '2014-06-23 18:00:00', -1, -1, -1, -1, -1),
(36, 'V', 0, '6', '7', 'São Paulo', '2014-06-23 18:00:00', -1, -1, -1, -1, -1),
(37, 'V', 0, '12', '9', 'Cuiabá', '2014-06-24 22:00:00', -1, -1, -1, -1, -1),
(38, 'V', 0, '10', '11', 'Fortaleza', '2014-06-24 22:00:00', -1, -1, -1, -1, -1),
(39, 'V', 0, '16', '13', 'Natal', '2014-06-24 18:00:00', -1, -1, -1, -1, -1),
(40, 'V', 0, '14', '15', 'Belo Horizonte', '2014-06-24 18:00:00', -1, -1, -1, -1, -1),
(41, 'V', 0, '20', '17', 'Manaus', '2014-06-25 22:00:00', -1, -1, -1, -1, -1),
(42, 'V', 0, '18', '19', 'Rio De Janeiro', '2014-06-25 22:00:00', -1, -1, -1, -1, -1),
(43, 'V', 0, '24', '21', 'Porto Alegre', '2014-06-25 18:00:00', -1, -1, -1, -1, -1),
(44, 'V', 0, '22', '23', 'Salvador', '2014-06-25 18:00:00', -1, -1, -1, -1, -1),
(45, 'V', 0, '28', '25', 'Recife', '2014-06-26 18:00:00', -1, -1, -1, -1, -1),
(46, 'V', 0, '26', '27', 'Brasília', '2014-06-26 18:00:00', -1, -1, -1, -1, -1),
(47, 'V', 0, '32', '29', 'São Paulo', '2014-06-26 22:00:00', -1, -1, -1, -1, -1),
(48, 'V', 0, '30', '31', 'Curitiba', '2014-06-26 22:00:00', -1, -1, -1, -1, -1),
(49, 'F', -1, '33', '34', 'Belo Horizonte', '2014-06-28 18:00:00', -1, -1, -1, 33, 34),
(50, 'F', -1, '35', '36', 'Rio De Janeiro', '2014-06-28 22:00:00', -1, -1, -1, 35, 36),
(51, 'F', -1, '37', '38', 'Fortaleza', '2014-06-29 18:00:00', -1, -1, -1, 37, 38),
(52, 'F', -1, '39', '40', 'Recife', '2014-06-29 22:00:00', -1, -1, -1, 39, 40),
(53, 'F', -1, '41', '42', 'Brasília', '2014-06-30 18:00:00', -1, -1, -1, 41, 42),
(54, 'F', -1, '43', '45', 'Porto Alegre', '2014-06-30 22:00:00', -1, -1, -1, 43, 45),
(55, 'F', -1, '46', '47', 'São Paulo', '2014-07-01 18:00:00', -1, -1, -1, 46, 47),
(56, 'F', -1, '44', '48', 'Salvador', '2014-07-01 22:00:00', -1, -1, -1, 44, 48),
(57, 'F', -1, '49', '50', 'Fortaleza', '2014-07-04 22:00:00', -1, -1, -1, 49, 50),
(58, 'F', -1, '51', '52', 'Rio De Janeiro', '2014-07-04 18:00:00', -1, -1, -1, 51, 52),
(59, 'F', -1, '64', '53', 'Salvador', '2014-07-05 22:00:00', -1, -1, -1, 64, 53),
(60, 'F', -1, '54', '55', 'Brasília', '2014-07-05 18:00:00', -1, -1, -1, 54, 55),
(61, 'F', -1, '56', '57', 'Belo Horizonte', '2014-07-08 22:00:00', -1, -1, -1, 56, 57),
(62, 'F', -1, '58', '59', 'São Paulo', '2014-07-09 22:00:00', -1, -1, -1, 58, 59),
(63, 'F', -1, '60', '61', 'Brasília', '2014-07-12 22:00:00', -1, -1, -1, 60, 61),
(64, 'F', -1, '62', '63', 'Rio De Janeiro', '2014-07-13 21:00:00', -1, -1, -1, 62, 63);

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