-- phpMyAdmin SQL Dump -- version 3.3.3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 20. August 2010 um 11:29 -- Server Version: 5.1.48 -- PHP-Version: 5.2.13-0.dotdeb.1 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: `usr_1` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `cs_match` -- CREATE TABLE IF NOT EXISTS `cs_match` ( `mid` int(11) NOT NULL AUTO_INCREMENT, `round` char(1) COLLATE latin1_german1_ci DEFAULT NULL, `spieltag` int(11) NOT NULL, `tid1` varchar(8) COLLATE latin1_german1_ci NOT NULL, `tid2` varchar(8) COLLATE latin1_german1_ci NOT NULL, `location` varchar(80) COLLATE latin1_german1_ci 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=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=371 ; -- -- Daten für Tabelle `cs_match` -- INSERT INTO `cs_match` (`mid`, `round`, `spieltag`, `tid1`, `tid2`, `location`, `matchtime`, `result1`, `result2`, `winner`, `ptid1`, `ptid2`) VALUES (152, 'V', 10, '67', '80', 'Bremen', '2010-10-30 15:30:00', -1, -1, -1, -1, -1), (151, 'V', 10, '82', '74', 'St. Pauli', '2010-10-30 15:30:00', -1, -1, -1, -1, -1), (137, 'V', 9, '70', '82', 'Stuttgart', '2010-10-23 15:30:00', -1, -1, -1, -1, -1), (133, 'V', 8, '77', '69', 'Köln', '2010-10-16 15:30:00', -1, -1, -1, -1, -1), (132, 'V', 8, '81', '74', 'Kaiserslautern', '2010-10-16 15:30:00', -1, -1, -1, -1, -1), (124, 'V', 7, '69', '65', 'Dortmund', '2010-10-02 15:30:00', -1, -1, -1, -1, -1), (165, 'V', 12, '81', '70', 'Kaiserslautern', '2010-11-13 15:30:00', -1, -1, -1, -1, -1), (162, 'V', 11, '71', '75', 'Hamburg', '2010-11-06 15:30:00', -1, -1, -1, -1, -1), (161, 'V', 11, '66', '82', 'Gelsenkirchen', '2010-11-06 15:30:00', -1, -1, -1, -1, -1), (160, 'V', 11, '78', '73', 'Freiburg', '2010-11-06 15:30:00', -1, -1, -1, -1, -1), (158, 'V', 11, '76', '65', 'M''gladbach', '2010-11-06 15:30:00', -1, -1, -1, -1, -1), (157, 'V', 11, '80', '77', 'Nürnberg', '2010-11-06 15:30:00', -1, -1, -1, -1, -1), (155, 'V', 11, '79', '69', 'Hannover', '2010-11-06 15:30:00', -1, -1, -1, -1, -1), (154, 'V', 10, '77', '71', 'Köln', '2010-10-30 15:30:00', -1, -1, -1, -1, -1), (150, 'V', 10, '65', '78', 'München', '2010-10-30 15:30:00', -1, -1, -1, -1, -1), (149, 'V', 10, '66', '68', 'Gelsenkirchen', '2010-10-30 15:30:00', -1, -1, -1, -1, -1), (148, 'V', 10, '81', '76', 'Kaiserslautern', '2010-10-30 15:30:00', -1, -1, -1, -1, -1), (147, 'V', 10, '73', '69', 'Mainz', '2010-10-30 15:30:00', -1, -1, -1, -1, -1), (146, 'V', 10, '75', '79', 'Hoffenheim', '2010-10-30 15:30:00', -1, -1, -1, -1, -1), (145, 'V', 9, '71', '65', 'Hamburg', '2010-10-23 15:30:00', -1, -1, -1, -1, -1), (143, 'V', 9, '76', '67', 'M''gladbach', '2010-10-23 15:30:00', -1, -1, -1, -1, -1), (140, 'V', 9, '74', '66', 'Frankfurt', '2010-10-23 15:30:00', -1, -1, -1, -1, -1), (139, 'V', 9, '79', '77', 'Hannover', '2010-10-23 15:30:00', -1, -1, -1, -1, -1), (138, 'V', 9, '80', '72', 'Nürnberg', '2010-10-23 15:30:00', -1, -1, -1, -1, -1), (136, 'V', 8, '75', '76', 'Hoffenheim', '2010-10-16 15:30:00', -1, -1, -1, -1, -1), (135, 'V', 8, '73', '71', 'Mainz', '2010-10-16 15:30:00', -1, -1, -1, -1, -1), (134, 'V', 8, '65', '79', 'München', '2010-10-16 15:30:00', -1, -1, -1, -1, -1), (131, 'V', 8, '66', '70', 'Gelsenkirchen', '2010-10-16 15:30:00', -1, -1, -1, -1, -1), (130, 'V', 8, '72', '68', 'Wolfsburg', '2010-10-16 15:30:00', -1, -1, -1, -1, -1), (129, 'V', 8, '82', '80', 'St. Pauli', '2010-10-16 15:30:00', -1, -1, -1, -1, -1), (128, 'V', 8, '67', '78', 'Bremen', '2010-10-16 15:30:00', -1, -1, -1, -1, -1), (127, 'V', 7, '71', '81', 'Hamburg', '2010-10-02 15:30:00', -1, -1, -1, -1, -1), (126, 'V', 7, '80', '66', 'Nürnberg', '2010-10-02 15:30:00', -1, -1, -1, -1, -1), (125, 'V', 7, '73', '75', 'Mainz', '2010-10-02 15:30:00', -1, -1, -1, -1, -1), (123, 'V', 7, '70', '74', 'Stuttgart', '2010-10-02 15:30:00', -1, -1, -1, -1, -1), (122, 'V', 7, '76', '72', 'M''gladbach', '2010-10-02 15:30:00', -1, -1, -1, -1, -1), (121, 'V', 7, '68', '67', 'Leverkusen', '2010-10-02 15:30:00', -1, -1, -1, -1, -1), (120, 'V', 7, '79', '82', 'Hannover', '2010-10-02 15:30:00', -1, -1, -1, -1, -1), (80, 'V', 2, '82', '75', 'St. Pauli', '2010-08-28 18:30:00', -1, -1, -1, -1, -1), (79, 'V', 2, '74', '71', 'Frankfurt', '2010-08-28 15:30:00', -1, -1, -1, -1, -1), (78, 'V', 2, '72', '73', 'Wolfsburg', '2010-08-28 15:30:00', -1, -1, -1, -1, -1), (77, 'V', 2, '67', '77', 'Bremen', '2010-08-28 15:30:00', -1, -1, -1, -1, -1), (76, 'V', 2, '80', '78', 'Nürnberg', '2010-08-28 15:30:00', -1, -1, -1, -1, -1), (75, 'V', 2, '66', '79', 'Gelsenkirchen', '2010-08-28 15:30:00', -1, -1, -1, -1, -1), (73, 'V', 1, '69', '68', 'Dortmund', '2010-08-22 17:30:00', -1, -1, -1, -1, -1), (72, 'V', 1, '73', '70', 'Mainz', '2010-08-22 15:30:00', -1, -1, -1, -1, -1), (71, 'V', 1, '71', '66', 'Hamburg', '2010-08-21 18:30:00', -1, -1, -1, -1, -1), (70, 'V', 1, '79', '74', 'Hannover', '2010-08-21 15:30:00', -1, -1, -1, -1, -1), (69, 'V', 1, '78', '82', 'Freiburg', '2010-08-21 15:30:00', -1, -1, -1, -1, -1), (68, 'V', 1, '77', '81', 'Köln', '2010-08-21 15:30:00', -1, -1, -1, -1, -1), (66, 'V', 1, '75', '67', 'Hoffenheim', '2010-08-21 15:30:00', -1, -1, -1, -1, -1), (65, 'V', 1, '65', '72', 'München', '2010-08-20 20:30:00', -1, -1, -1, -1, -1), (164, 'V', 12, '82', '68', 'St. Pauli', '2010-11-13 00:00:00', -1, -1, -1, -1, -1), (163, 'V', 11, '68', '81', 'Leverkusen', '2010-11-06 15:30:00', -1, -1, -1, -1, -1), (159, 'V', 11, '74', '72', 'Frankfurt', '2010-11-06 15:30:00', -1, -1, -1, -1, -1), (156, 'V', 11, '70', '67', 'Stuttgart', '2010-11-06 15:30:00', -1, -1, -1, -1, -1), (153, 'V', 10, '72', '70', 'Wolfsburg', '2010-10-30 15:30:00', -1, -1, -1, -1, -1), (144, 'V', 9, '68', '73', 'Leverkusen', '2010-10-23 15:30:00', -1, -1, -1, -1, -1), (142, 'V', 9, '69', '75', 'Dortmund', '2010-10-23 15:30:00', -1, -1, -1, -1, -1), (141, 'V', 9, '78', '81', 'Freiburg', '2010-10-23 15:30:00', -1, -1, -1, -1, -1), (119, 'V', 7, '78', '77', 'Freiburg', '2010-10-02 15:30:00', -1, -1, -1, -1, -1), (74, 'V', 2, '81', '65', 'Kaiserslautern', '2010-08-27 20:30:00', -1, -1, -1, -1, -1), (67, 'V', 1, '76', '80', 'M''gladbach', '2010-08-21 15:30:00', -1, -1, -1, -1, -1), (81, 'V', 2, '68', '76', 'Leverkusen', '2010-08-29 15:30:00', -1, -1, -1, -1, -1), (82, 'V', 2, '70', '69', 'Stuttgart', '2010-08-29 17:30:00', -1, -1, -1, -1, -1), (83, 'V', 3, '73', '81', 'Mainz', '2010-09-12 15:30:00', -1, -1, -1, -1, -1), (84, 'V', 3, '78', '70', 'Freiburg', '2010-09-11 15:30:00', -1, -1, -1, -1, -1), (85, 'V', 3, '76', '74', 'M''gladbach', '2010-09-11 15:30:00', -1, -1, -1, -1, -1), (86, 'V', 3, '79', '68', 'Hannover', '2010-09-11 15:30:00', -1, -1, -1, -1, -1), (87, 'V', 3, '69', '72', 'Dortmund', '2010-09-11 15:30:00', -1, -1, -1, -1, -1), (88, 'V', 3, '71', '80', 'Hamburg', '2010-09-11 15:30:00', -1, -1, -1, -1, -1), (89, 'V', 3, '65', '67', 'München', '2010-09-11 18:30:00', -1, -1, -1, -1, -1), (90, 'V', 3, '75', '66', 'Hoffenheim', '2010-09-10 20:30:00', -1, -1, -1, -1, -1), (91, 'V', 3, '77', '82', 'Köln', '2010-09-12 17:30:00', -1, -1, -1, -1, -1), (92, 'V', 4, '67', '73', 'Bremen', '2010-09-18 15:30:00', -1, -1, -1, -1, -1), (93, 'V', 4, '65', '77', 'München', '2010-09-18 15:30:00', -1, -1, -1, -1, -1), (94, 'V', 4, '74', '78', 'Frankfurt', '2010-09-18 15:30:00', -1, -1, -1, -1, -1), (95, 'V', 4, '72', '79', 'Wolfsburg', '2010-09-18 15:30:00', -1, -1, -1, -1, -1), (96, 'V', 4, '70', '76', 'Stuttgart', '2010-09-18 15:30:00', -1, -1, -1, -1, -1), (97, 'V', 4, '82', '71', 'St. Pauli', '2010-09-18 15:30:00', -1, -1, -1, -1, -1), (98, 'V', 4, '68', '80', 'Leverkusen', '2010-09-18 15:30:00', -1, -1, -1, -1, -1), (99, 'V', 4, '81', '75', 'Kaiserslautern', '2010-09-18 15:30:00', -1, -1, -1, -1, -1), (100, 'V', 4, '66', '69', 'Gelsenkirchen', '2010-09-18 15:30:00', -1, -1, -1, -1, -1), (101, 'V', 5, '73', '77', 'Mainz', '2010-09-21 15:30:00', -1, -1, -1, -1, -1), (102, 'V', 5, '69', '81', 'Dortmund', '2010-09-21 15:30:00', -1, -1, -1, -1, -1), (103, 'V', 5, '79', '67', 'Hannover', '2010-09-21 15:30:00', -1, -1, -1, -1, -1), (104, 'V', 5, '75', '65', 'Hoffenheim', '2010-09-21 15:30:00', -1, -1, -1, -1, -1), (105, 'V', 5, '80', '70', 'Nürnberg', '2010-09-21 15:30:00', -1, -1, -1, -1, -1), (106, 'V', 5, '76', '82', 'M''gladbach', '2010-09-21 15:30:00', -1, -1, -1, -1, -1), (107, 'V', 5, '71', '72', 'Hamburg', '2010-09-21 15:30:00', -1, -1, -1, -1, -1), (108, 'V', 5, '68', '74', 'Leverkusen', '2010-09-21 15:30:00', -1, -1, -1, -1, -1), (109, 'V', 5, '78', '66', 'Freiburg', '2010-09-21 15:30:00', -1, -1, -1, -1, -1), (110, 'V', 6, '82', '69', 'St. Pauli', '2010-09-25 15:30:00', -1, -1, -1, -1, -1), (111, 'V', 6, '66', '76', 'Gelsenkirchen', '2010-09-25 15:30:00', -1, -1, -1, -1, -1), (112, 'V', 6, '65', '73', 'München', '2010-09-25 00:00:00', -1, -1, -1, -1, -1), (113, 'V', 6, '70', '68', 'Stuttgart', '2010-09-25 15:30:00', -1, -1, -1, -1, -1), (114, 'V', 6, '74', '80', 'Frankfurt', '2010-09-25 15:30:00', -1, -1, -1, -1, -1), (115, 'V', 6, '67', '71', 'Bremen', '2010-09-25 15:30:00', -1, -1, -1, -1, -1), (116, 'V', 6, '77', '75', 'Köln', '2010-09-25 15:30:00', -1, -1, -1, -1, -1), (117, 'V', 6, '72', '78', 'Wolfsburg', '2010-09-25 15:30:00', -1, -1, -1, -1, -1), (118, 'V', 6, '81', '79', 'Kaiserslautern', '2010-09-25 15:30:00', -1, -1, -1, -1, -1), (166, 'V', 12, '69', '71', 'Dortmund', '2010-11-13 15:30:00', -1, -1, -1, -1, -1), (167, 'V', 12, '75', '78', 'Hoffenheim', '2010-11-13 15:30:00', -1, -1, -1, -1, -1), (168, 'V', 12, '67', '74', 'Bremen', '2010-11-13 15:30:00', -1, -1, -1, -1, -1), (169, 'V', 12, '73', '79', 'Mainz', '2010-11-13 15:30:00', -1, -1, -1, -1, -1), (170, 'V', 12, '77', '76', 'Köln', '2010-11-13 15:30:00', -1, -1, -1, -1, -1), (171, 'V', 12, '65', '80', 'München', '2010-11-13 15:30:00', -1, -1, -1, -1, -1), (172, 'V', 12, '72', '66', 'Wolfsburg', '2010-11-13 15:30:00', -1, -1, -1, -1, -1), (173, 'V', 13, '82', '72', 'St. Pauli', '2010-11-20 15:30:00', -1, -1, -1, -1, -1), (174, 'V', 13, '74', '75', 'Frankfurt', '2010-11-20 15:30:00', -1, -1, -1, -1, -1), (175, 'V', 13, '80', '81', 'Nürnberg', '2010-11-20 15:30:00', -1, -1, -1, -1, -1), (176, 'V', 13, '68', '65', 'Leverkusen', '2010-11-20 15:30:00', -1, -1, -1, -1, -1), (177, 'V', 13, '76', '73', 'M''gladbach', '2010-11-20 15:30:00', -1, -1, -1, -1, -1), (178, 'V', 13, '66', '67', 'Gelsenkirchen', '2010-11-20 15:30:00', -1, -1, -1, -1, -1), (179, 'V', 13, '78', '69', 'Freiburg', '2010-11-20 15:30:00', -1, -1, -1, -1, -1), (180, 'V', 13, '70', '77', 'Stuttgart', '2010-11-20 15:30:00', -1, -1, -1, -1, -1), (181, 'V', 13, '79', '71', 'Hannover', '2010-11-20 15:30:00', -1, -1, -1, -1, -1), (182, 'V', 14, '67', '82', 'Bremen', '2010-11-27 15:30:00', -1, -1, -1, -1, -1), (183, 'V', 14, '69', '76', 'Dortmund', '2010-11-27 15:30:00', -1, -1, -1, -1, -1), (184, 'V', 14, '71', '70', 'Hamburg', '2010-11-27 15:30:00', -1, -1, -1, -1, -1), (185, 'V', 14, '77', '72', 'Köln', '2010-11-27 15:30:00', -1, -1, -1, -1, -1), (186, 'V', 14, '81', '66', 'Kaiserslautern', '2010-11-27 15:30:00', -1, -1, -1, -1, -1), (187, 'V', 14, '79', '78', 'Hannover', '2010-11-27 15:30:00', -1, -1, -1, -1, -1), (188, 'V', 14, '73', '80', 'Mainz', '2010-11-27 15:30:00', -1, -1, -1, -1, -1), (189, 'V', 14, '65', '74', 'München', '2010-11-27 15:30:00', -1, -1, -1, -1, -1), (190, 'V', 14, '75', '68', 'Hoffenheim', '2010-11-27 15:30:00', -1, -1, -1, -1, -1), (191, 'V', 15, '66', '65', 'Gelsenkirchen', '2010-12-04 15:30:00', -1, -1, -1, -1, -1), (192, 'V', 15, '80', '69', 'Nürnberg', '2010-12-04 15:30:00', -1, -1, -1, -1, -1), (193, 'V', 15, '70', '75', 'Stuttgart', '2010-12-04 15:30:00', -1, -1, -1, -1, -1), (194, 'V', 15, '82', '81', 'St. Pauli', '2010-12-04 15:30:00', -1, -1, -1, -1, -1), (195, 'V', 15, '72', '67', 'Wolfsburg', '2010-12-04 15:30:00', -1, -1, -1, -1, -1), (196, 'V', 15, '76', '79', 'M''gladbach', '2010-12-04 15:30:00', -1, -1, -1, -1, -1), (197, 'V', 15, '74', '73', 'Frankfurt', '2010-12-04 15:30:00', -1, -1, -1, -1, -1), (198, 'V', 15, '68', '77', 'Leverkusen', '2010-12-04 15:30:00', -1, -1, -1, -1, -1), (199, 'V', 15, '78', '71', 'Freiburg', '2010-12-04 15:30:00', -1, -1, -1, -1, -1), (200, 'V', 16, '79', '70', 'Hannover', '2010-12-11 15:30:00', -1, -1, -1, -1, -1), (201, 'V', 16, '65', '82', 'München', '2010-12-11 15:30:00', -1, -1, -1, -1, -1), (202, 'V', 16, '78', '76', 'Freiburg', '2010-12-11 15:30:00', -1, -1, -1, -1, -1), (203, 'V', 16, '71', '68', 'Hamburg', '2010-12-11 15:30:00', -1, -1, -1, -1, -1), (204, 'V', 16, '69', '67', 'Dortmund', '2010-12-11 15:30:00', -1, -1, -1, -1, -1), (205, 'V', 16, '75', '80', 'Hoffenheim', '2010-12-11 15:30:00', -1, -1, -1, -1, -1), (206, 'V', 16, '81', '72', 'Kaiserslautern', '2010-12-11 15:30:00', -1, -1, -1, -1, -1), (207, 'V', 16, '77', '74', 'Köln', '2010-12-11 15:30:00', -1, -1, -1, -1, -1), (208, 'V', 16, '73', '66', 'Mainz', '2010-12-11 15:30:00', -1, -1, -1, -1, -1), (209, 'V', 17, '68', '78', 'Leverkusen', '2010-12-18 15:30:00', -1, -1, -1, -1, -1), (210, 'V', 17, '76', '71', 'M''gladbach', '2010-12-18 15:30:00', -1, -1, -1, -1, -1), (211, 'V', 17, '80', '79', 'Nürnberg', '2010-12-18 15:30:00', -1, -1, -1, -1, -1), (212, 'V', 17, '70', '65', 'Stuttgart', '2010-12-18 15:30:00', -1, -1, -1, -1, -1), (213, 'V', 17, '67', '81', 'Bremen', '2010-12-18 15:30:00', -1, -1, -1, -1, -1), (214, 'V', 17, '72', '75', 'Wolfsburg', '2010-12-18 15:30:00', -1, -1, -1, -1, -1), (215, 'V', 17, '74', '69', 'Frankfurt', '2010-12-18 15:30:00', -1, -1, -1, -1, -1), (216, 'V', 17, '66', '77', 'Gelsenkirchen', '2010-12-18 15:30:00', -1, -1, -1, -1, -1), (217, 'V', 17, '82', '73', 'St. Pauli', '2010-12-18 15:30:00', -1, -1, -1, -1, -1), (218, 'V', 18, '74', '79', 'Frankfurt', '2011-01-15 15:30:00', -1, -1, -1, -1, -1), (219, 'V', 18, '67', '75', 'Bremen', '2011-01-15 15:30:00', -1, -1, -1, -1, -1), (220, 'V', 18, '80', '76', 'Nürnberg', '2011-01-15 15:30:00', -1, -1, -1, -1, -1), (221, 'V', 18, '81', '77', 'Kaiserslautern', '2011-01-15 15:30:00', -1, -1, -1, -1, -1), (222, 'V', 18, '72', '65', 'Wolfsburg', '2011-01-15 15:30:00', -1, -1, -1, -1, -1), (223, 'V', 18, '68', '69', 'Leverkusen', '2011-01-15 15:30:00', -1, -1, -1, -1, -1), (224, 'V', 18, '82', '78', 'St. Pauli', '2011-01-15 15:30:00', -1, -1, -1, -1, -1), (225, 'V', 18, '70', '73', 'Stuttgart', '2011-01-15 15:30:00', -1, -1, -1, -1, -1), (226, 'V', 18, '66', '71', 'Gelsenkirchen', '2011-01-15 15:30:00', -1, -1, -1, -1, -1), (227, 'V', 19, '78', '80', 'Freiburg', '2011-01-22 15:30:00', -1, -1, -1, -1, -1), (228, 'V', 19, '65', '81', 'München', '2011-01-22 15:30:00', -1, -1, -1, -1, -1), (229, 'V', 19, '73', '72', 'Mainz', '2011-01-22 15:30:00', -1, -1, -1, -1, -1), (230, 'V', 19, '77', '67', 'Köln', '2011-01-22 15:30:00', -1, -1, -1, -1, -1), (231, 'V', 19, '71', '74', 'Hamburg', '2011-01-22 15:30:00', -1, -1, -1, -1, -1), (232, 'V', 19, '69', '74', 'Dortmund', '2011-01-22 15:30:00', -1, -1, -1, -1, -1), (233, 'V', 19, '75', '82', 'Hoffenheim', '2011-01-22 15:30:00', -1, -1, -1, -1, -1), (234, 'V', 19, '76', '68', 'M''gladbach', '2011-01-22 15:30:00', -1, -1, -1, -1, -1), (235, 'V', 19, '79', '66', 'Hannover', '2011-01-22 15:30:00', -1, -1, -1, -1, -1), (236, 'V', 20, '82', '77', 'St. Pauli', '2011-01-29 15:30:00', -1, -1, -1, -1, -1), (237, 'V', 20, '67', '65', 'Bremen', '2011-01-29 15:30:00', -1, -1, -1, -1, -1), (238, 'V', 20, '66', '75', 'Gelsenkirchen', '2011-01-29 15:30:00', -1, -1, -1, -1, -1), (239, 'V', 20, '72', '69', 'Wolfsburg', '2011-01-29 15:30:00', -1, -1, -1, -1, -1), (240, 'V', 20, '81', '73', 'Kaiserslautern', '2011-01-29 15:30:00', -1, -1, -1, -1, -1), (241, 'V', 20, '70', '78', 'Stuttgart', '2011-01-29 15:30:00', -1, -1, -1, -1, -1), (242, 'V', 20, '74', '76', 'Frankfurt', '2011-01-29 15:30:00', -1, -1, -1, -1, -1), (243, 'V', 20, '80', '71', 'Nürnberg', '2011-01-29 15:30:00', -1, -1, -1, -1, -1), (244, 'V', 20, '68', '79', 'Leverkusen', '2011-01-29 15:30:00', -1, -1, -1, -1, -1), (245, 'V', 21, '76', '70', 'M''gladbach', '2011-02-05 15:30:00', -1, -1, -1, -1, -1), (246, 'V', 21, '69', '66', 'Dortmund', '2011-02-05 15:30:00', -1, -1, -1, -1, -1), (247, 'V', 21, '79', '72', 'Hannover', '2011-02-05 15:30:00', -1, -1, -1, -1, -1), (248, 'V', 21, '80', '68', 'Nürnberg', '2011-02-05 15:30:00', -1, -1, -1, -1, -1), (249, 'V', 21, '73', '67', 'Mainz', '2011-02-05 15:30:00', -1, -1, -1, -1, -1), (250, 'V', 21, '77', '65', 'Köln', '2011-02-05 15:30:00', -1, -1, -1, -1, -1), (251, 'V', 21, '78', '74', 'Freiburg', '2011-02-05 15:30:00', -1, -1, -1, -1, -1), (252, 'V', 21, '75', '81', 'Hoffenheim', '2011-02-05 15:30:00', -1, -1, -1, -1, -1), (253, 'V', 21, '71', '82', 'Hamburg', '2011-02-05 15:30:00', -1, -1, -1, -1, -1), (254, 'V', 22, '65', '75', 'München', '2011-02-12 15:30:00', -1, -1, -1, -1, -1), (255, 'V', 22, '70', '80', 'Stuttgart', '2011-02-12 15:30:00', -1, -1, -1, -1, -1), (256, 'V', 22, '74', '68', 'Frankfurt', '2011-02-12 15:30:00', -1, -1, -1, -1, -1), (257, 'V', 22, '72', '71', 'Wolfsburg', '2011-02-12 15:30:00', -1, -1, -1, -1, -1), (258, 'V', 22, '77', '73', 'Köln', '2011-02-12 15:30:00', -1, -1, -1, -1, -1), (259, 'V', 22, '82', '76', 'St. Pauli', '2011-02-12 15:30:00', -1, -1, -1, -1, -1), (260, 'V', 22, '67', '79', 'Bremen', '2011-02-12 15:30:00', -1, -1, -1, -1, -1), (261, 'V', 22, '66', '78', 'Gelsenkirchen', '2011-02-12 15:30:00', -1, -1, -1, -1, -1), (262, 'V', 22, '81', '69', 'Kaiserslautern', '2011-02-12 15:30:00', -1, -1, -1, -1, -1), (263, 'V', 23, '69', '82', 'Dortmund', '2011-02-19 15:30:00', -1, -1, -1, -1, -1), (264, 'V', 23, '76', '66', 'M''gladbach', '2011-02-19 15:30:00', -1, -1, -1, -1, -1), (265, 'V', 23, '68', '70', 'Leverkusen', '2011-02-19 15:30:00', -1, -1, -1, -1, -1), (266, 'V', 23, '80', '74', 'Nürnberg', '2011-02-19 15:30:00', -1, -1, -1, -1, -1), (267, 'V', 23, '73', '65', 'Mainz', '2011-02-19 15:30:00', -1, -1, -1, -1, -1), (268, 'V', 23, '79', '81', 'Hannover', '2011-02-19 15:30:00', -1, -1, -1, -1, -1), (269, 'V', 23, '75', '77', 'Hoffenheim', '2011-02-19 15:30:00', -1, -1, -1, -1, -1), (270, 'V', 23, '78', '72', 'Freiburg', '2011-02-19 15:30:00', -1, -1, -1, -1, -1), (271, 'V', 23, '71', '67', 'Hamburg', '2011-02-19 15:30:00', -1, -1, -1, -1, -1), (272, 'V', 24, '72', '76', 'Wolfsburg', '2011-02-26 15:30:00', -1, -1, -1, -1, -1), (273, 'V', 24, '67', '68', 'Bremen', '2011-02-26 15:30:00', -1, -1, -1, -1, -1), (274, 'V', 24, '81', '71', 'Kaiserslautern', '2011-02-26 15:30:00', -1, -1, -1, -1, -1), (275, 'V', 24, '66', '80', 'Gelsenkirchen', '2011-02-26 15:30:00', -1, -1, -1, -1, -1), (276, 'V', 24, '77', '78', 'Köln', '2011-02-26 15:30:00', -1, -1, -1, -1, -1), (277, 'V', 24, '65', '69', 'München', '2011-02-26 15:30:00', -1, -1, -1, -1, -1), (278, 'V', 24, '75', '73', 'Hoffenheim', '2011-02-26 15:30:00', -1, -1, -1, -1, -1), (279, 'V', 24, '82', '79', 'St. Pauli', '2011-02-26 15:30:00', -1, -1, -1, -1, -1), (280, 'V', 24, '74', '70', 'Frankfurt', '2011-02-26 15:30:00', -1, -1, -1, -1, -1), (281, 'V', 25, '74', '81', 'Frankfurt', '2011-03-05 15:30:00', -1, -1, -1, -1, -1), (282, 'V', 25, '79', '65', 'Hannover', '2011-03-05 15:30:00', -1, -1, -1, -1, -1), (283, 'V', 25, '71', '73', 'Hamburg', '2011-03-05 15:30:00', -1, -1, -1, -1, -1), (284, 'V', 25, '78', '67', 'Freiburg', '2011-03-05 15:30:00', -1, -1, -1, -1, -1), (285, 'V', 25, '68', '72', 'Leverkusen', '2011-03-05 15:30:00', -1, -1, -1, -1, -1), (286, 'V', 25, '80', '82', 'Nürnberg', '2011-03-05 15:30:00', -1, -1, -1, -1, -1), (287, 'V', 25, '76', '75', 'M''gladbach', '2011-03-05 15:30:00', -1, -1, -1, -1, -1), (288, 'V', 25, '69', '77', 'Dortmund', '2011-03-05 15:30:00', -1, -1, -1, -1, -1), (289, 'V', 25, '70', '66', 'Stuttgart', '2011-03-05 15:30:00', -1, -1, -1, -1, -1), (290, 'V', 26, '73', '68', 'Mainz', '2011-03-12 15:30:00', -1, -1, -1, -1, -1), (291, 'V', 26, '81', '78', 'Kaiserslautern', '2011-03-12 15:30:00', -1, -1, -1, -1, -1), (292, 'V', 26, '65', '71', 'München', '2011-03-12 15:30:00', -1, -1, -1, -1, -1), (293, 'V', 26, '77', '79', 'Köln', '2011-03-12 15:30:00', -1, -1, -1, -1, -1), (294, 'V', 26, '66', '74', 'Gelsenkirchen', '2011-03-12 15:30:00', -1, -1, -1, -1, -1), (295, 'V', 26, '75', '69', 'Hoffenheim', '2011-03-12 15:30:00', -1, -1, -1, -1, -1), (296, 'V', 26, '67', '76', 'Bremen', '2011-03-12 15:30:00', -1, -1, -1, -1, -1), (297, 'V', 26, '72', '80', 'Wolfsburg', '2011-03-12 15:30:00', -1, -1, -1, -1, -1), (298, 'V', 26, '82', '70', 'St. Pauli', '2011-03-12 15:30:00', -1, -1, -1, -1, -1), (299, 'V', 27, '76', '81', 'M''gladbach', '2011-03-19 15:30:00', -1, -1, -1, -1, -1), (300, 'V', 27, '71', '77', 'Hamburg', '2011-03-19 15:30:00', -1, -1, -1, -1, -1), (301, 'V', 27, '70', '72', 'Stuttgart', '2011-03-19 15:30:00', -1, -1, -1, -1, -1), (302, 'V', 27, '80', '67', 'Nürnberg', '2011-03-19 15:30:00', -1, -1, -1, -1, -1), (303, 'V', 27, '74', '82', 'Frankfurt', '2011-03-19 15:30:00', -1, -1, -1, -1, -1), (304, 'V', 27, '69', '73', 'Dortmund', '2011-03-19 15:30:00', -1, -1, -1, -1, -1), (305, 'V', 27, '79', '75', 'Hannover', '2011-03-19 15:30:00', -1, -1, -1, -1, -1), (306, 'V', 27, '68', '66', 'Leverkusen', '2011-03-19 15:30:00', -1, -1, -1, -1, -1), (307, 'V', 27, '78', '65', 'Freiburg', '2011-03-19 15:30:00', -1, -1, -1, -1, -1), (308, 'V', 28, '77', '80', 'Köln', '2011-04-02 15:30:00', -1, -1, -1, -1, -1), (309, 'V', 28, '73', '78', 'Mainz', '2011-04-02 15:30:00', -1, -1, -1, -1, -1), (310, 'V', 28, '82', '66', 'St. Pauli', '2011-04-02 15:30:00', -1, -1, -1, -1, -1), (311, 'V', 28, '81', '68', 'Kaiserslautern', '2011-04-02 15:30:00', -1, -1, -1, -1, -1), (312, 'V', 28, '69', '79', 'Dortmund', '2011-04-02 15:30:00', -1, -1, -1, -1, -1), (313, 'V', 28, '67', '70', 'Bremen', '2011-04-02 15:30:00', -1, -1, -1, -1, -1), (314, 'V', 28, '65', '76', 'München', '2011-04-02 15:30:00', -1, -1, -1, -1, -1), (315, 'V', 28, '75', '71', 'Hoffenheim', '2011-04-02 15:30:00', -1, -1, -1, -1, -1), (316, 'V', 28, '72', '74', 'Wolfsburg', '2011-04-02 15:30:00', -1, -1, -1, -1, -1), (317, 'V', 29, '74', '67', 'Frankfurt', '2011-04-09 15:30:00', -1, -1, -1, -1, -1), (318, 'V', 29, '68', '82', 'Leverkusen', '2011-04-09 15:30:00', -1, -1, -1, -1, -1), (319, 'V', 29, '79', '73', 'Hannover', '2011-04-09 15:30:00', -1, -1, -1, -1, -1), (320, 'V', 29, '78', '75', 'Freiburg', '2011-04-09 15:30:00', -1, -1, -1, -1, -1), (321, 'V', 29, '80', '65', 'Nürnberg', '2011-04-09 15:30:00', -1, -1, -1, -1, -1), (322, 'V', 29, '66', '72', 'Gelsenkirchen', '2011-04-09 15:30:00', -1, -1, -1, -1, -1), (323, 'V', 29, '76', '77', 'M''gladbach', '2011-04-09 15:30:00', -1, -1, -1, -1, -1), (324, 'V', 29, '71', '69', 'Hamburg', '2011-04-09 15:30:00', -1, -1, -1, -1, -1), (325, 'V', 29, '70', '81', 'Stuttgart', '2011-04-09 15:30:00', -1, -1, -1, -1, -1), (326, 'V', 30, '71', '79', 'Hamburg', '2011-04-16 15:30:00', -1, -1, -1, -1, -1), (327, 'V', 30, '75', '74', 'Hoffenheim', '2011-04-16 15:30:00', -1, -1, -1, -1, -1), (328, 'V', 30, '72', '82', 'Wolfsburg', '2011-04-16 15:30:00', -1, -1, -1, -1, -1), (329, 'V', 30, '73', '76', 'Mainz', '2011-04-16 15:30:00', -1, -1, -1, -1, -1), (330, 'V', 30, '65', '68', 'München', '2011-04-16 15:30:00', -1, -1, -1, -1, -1), (331, 'V', 30, '81', '80', 'Kaiserslautern', '2011-04-16 15:30:00', -1, -1, -1, -1, -1), (332, 'V', 30, '69', '78', 'Dortmund', '2011-04-16 15:30:00', -1, -1, -1, -1, -1), (333, 'V', 30, '67', '66', 'Bremen', '2011-04-16 15:30:00', -1, -1, -1, -1, -1), (334, 'V', 30, '77', '70', 'Köln', '2011-04-16 15:30:00', -1, -1, -1, -1, -1), (335, 'V', 31, '68', '75', 'Leverkusen', '2011-04-23 15:30:00', -1, -1, -1, -1, -1), (336, 'V', 31, '66', '81', 'Gelsenkirchen', '2011-04-23 15:30:00', -1, -1, -1, -1, -1), (337, 'V', 31, '76', '69', 'M''gladbach', '2011-04-23 15:30:00', -1, -1, -1, -1, -1), (338, 'V', 31, '78', '79', 'Feiburg', '2011-04-23 15:30:00', -1, -1, -1, -1, -1), (339, 'V', 31, '82', '67', 'St. Pauli', '2011-04-23 15:30:00', -1, -1, -1, -1, -1), (340, 'V', 31, '72', '77', 'Wolfsburg', '2011-04-23 15:30:00', -1, -1, -1, -1, -1), (341, 'V', 31, '74', '65', 'Frankfurt', '2011-04-23 15:30:00', -1, -1, -1, -1, -1), (342, 'V', 31, '80', '73', 'Nürnberg', '2011-04-23 15:30:00', -1, -1, -1, -1, -1), (343, 'V', 31, '70', '71', 'Stuttgart', '2011-04-23 15:30:00', -1, -1, -1, -1, -1), (344, 'V', 32, '79', '76', 'Hannover', '2011-04-30 15:30:00', -1, -1, -1, -1, -1), (345, 'V', 32, '67', '72', 'Bremen', '2011-04-30 15:30:00', -1, -1, -1, -1, -1), (346, 'V', 32, '77', '68', 'Köln', '2011-04-30 15:30:00', -1, -1, -1, -1, -1), (347, 'V', 32, '81', '82', 'Kaiserslautern', '2011-04-30 15:30:00', -1, -1, -1, -1, -1), (348, 'V', 32, '69', '80', 'Dortmund', '2011-04-30 15:30:00', -1, -1, -1, -1, -1), (349, 'V', 32, '73', '74', 'Mainz', '2011-04-30 15:30:00', -1, -1, -1, -1, -1), (350, 'V', 32, '71', '78', 'Hamburg', '2011-04-30 15:30:00', -1, -1, -1, -1, -1), (351, 'V', 32, '75', '70', 'Hoffenheim', '2011-04-30 15:30:00', -1, -1, -1, -1, -1), (352, 'V', 32, '65', '66', 'München', '2011-04-30 15:30:00', -1, -1, -1, -1, -1), (353, 'V', 33, '66', '73', 'Gelsenkirchen', '2011-05-07 15:30:00', -1, -1, -1, -1, -1), (354, 'V', 33, '67', '69', 'Bremen', '2011-05-07 15:30:00', -1, -1, -1, -1, -1), (355, 'V', 33, '72', '81', 'Wolfsburg', '2011-05-07 15:30:00', -1, -1, -1, -1, -1), (356, 'V', 33, '80', '75', 'Nürnberg', '2011-05-07 15:30:00', -1, -1, -1, -1, -1), (357, 'V', 33, '82', '65', 'St. Pauli', '2011-05-07 15:30:00', -1, -1, -1, -1, -1), (358, 'V', 33, '74', '77', 'Frankfurt', '2011-05-07 15:30:00', -1, -1, -1, -1, -1), (359, 'V', 33, '76', '78', 'M''gladbach', '2011-05-07 15:30:00', -1, -1, -1, -1, -1), (360, 'V', 33, '70', '79', 'Stuttgart', '2011-05-07 15:30:00', -1, -1, -1, -1, -1), (361, 'V', 33, '68', '71', 'Leverkusen', '2011-05-07 15:30:00', -1, -1, -1, -1, -1), (362, 'V', 34, '77', '66', 'Köln', '2011-05-14 15:30:00', -1, -1, -1, -1, -1), (363, 'V', 34, '78', '68', 'Freiburg', '2011-05-14 15:30:00', -1, -1, -1, -1, -1), (364, 'V', 34, '71', '76', 'Hamburg', '2011-05-14 15:30:00', -1, -1, -1, -1, -1), (365, 'V', 34, '65', '70', 'München', '2011-05-14 15:30:00', -1, -1, -1, -1, -1), (366, 'V', 34, '73', '82', 'Mainz', '2011-05-14 15:30:00', -1, -1, -1, -1, -1), (367, 'V', 34, '79', '80', 'Hannover', '2011-05-14 15:30:00', -1, -1, -1, -1, -1), (368, 'V', 34, '75', '72', 'Hoffenheim', '2011-05-14 15:30:00', -1, -1, -1, -1, -1), (369, 'V', 34, '69', '74', 'Dortmund', '2011-05-14 15:30:00', -1, -1, -1, -1, -1), (370, 'V', 34, '81', '67', 'Kaiserslautern', '2011-05-14 15:30:00', -1, -1, -1, -1, -1); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `cs_team` -- CREATE TABLE IF NOT EXISTS `cs_team` ( `tid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(40) COLLATE latin1_german1_ci NOT NULL, `icon` varchar(40) COLLATE latin1_german1_ci NOT NULL, `groupid` varchar(2) COLLATE latin1_german1_ci NOT NULL, `qualified` tinyint(1) NOT NULL, PRIMARY KEY (`tid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=83 ; -- -- Daten für Tabelle `cs_team` -- INSERT INTO `cs_team` (`tid`, `name`, `icon`, `groupid`, `qualified`) VALUES (78, 'SC Freiburg', 'SCFreiburg.gif', 'A', 0), (77, '1. FC Köln', '1FCKoeln.gif', 'A', 0), (76, 'Borussia M''gladbach', 'BorMoenchengladbach.gif', 'A', 0), (75, '1899 Hoffenheim', '1899Hoffenheim.gif', 'A', 0), (74, 'Eintracht Frankfurt', 'EintrachtFrankfurt.gif', 'A', 0), (73, '1. FSV Mainz 05', 'FSVMainz05.gif', 'A', 0), (72, 'VfL Wolfsburg', 'VfLWolfsburg.gif', 'A', 0), (71, 'Hamburger SV', 'HamburgerSV.gif', 'A', 0), (70, 'VfB Stuttgart', 'VfBStuttgart.gif', 'A', 0), (69, 'Borussia Dortmund', 'BVB.gif', 'A', 0), (68, 'Bayer 04 Leverkusen', 'BayerLeverkusen.gif', 'A', 0), (67, 'Werder Bremen', 'WerderBremen.gif', 'A', 0), (66, 'FC Schalke 04', 'FCSchalke.gif', 'A', 0), (65, 'FC Bayern München', 'BayernMuenchen.gif', 'A', 0), (79, 'Hannover 96', 'Hannover96.gif', 'A', 0), (80, '1. FC Nürnberg', '1FCNuernberg.gif', 'A', 0), (81, '1. FC Kaiserslautern', '1FCKaiserslautern.gif', 'A', 0), (82, 'FC St. Pauli', 'FCStPauli.gif', 'A', 0); /*!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 */;