CREATE TABLE IF NOT EXISTS `wetten_wetten` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kategorie` int(11) NOT NULL DEFAULT '0',
  `spezialart` int(11) NOT NULL DEFAULT '0',
  `spezial_oberwette` int(11) NOT NULL DEFAULT '0',
  `spezial_anzahl` int(11) NOT NULL DEFAULT '0',
  `top` int(11) NOT NULL DEFAULT '0',
  `text` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `zeit_wettende` int(11) NOT NULL DEFAULT '0',
  `aktiv` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `zeit_wettende` (`zeit_wettende`),
  KEY `kategorie` (`kategorie`),
  KEY `spezialart` (`spezialart`),
  KEY `spezial_oberwette` (`spezial_oberwette`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

--
-- Daten für Tabelle `wetten_wetten`
--

INSERT INTO `wetten_wetten` (`id`, `kategorie`, `spezialart`, `spezial_oberwette`, `spezial_anzahl`, `top`, `text`, `zeit_wettende`, `aktiv`) VALUES
(1, 1, 0, 0, 0, 0, '', 1310040000, 1),
(2, 1, 0, 0, 0, 0, '', 1310040000, 1),
(3, 1, 0, 0, 0, 0, '', 1310040000, 1),
(4, 1, 0, 0, 0, 0, '', 1310040000, 1),
(5, 1, 0, 0, 0, 0, '', 1310040000, 1),
(6, 1, 0, 0, 0, 0, '', 1310040000, 1),
(7, 1, 0, 0, 0, 0, '', 1310040000, 1),
(8, 1, 0, 0, 0, 0, '', 1310040000, 1),
(10, 1, 0, 0, 0, 0, '', 1310040000, 1),
(11, 1, 0, 0, 0, 0, '', 1310040000, 1),
(12, 1, 0, 0, 0, 0, '', 1310040000, 1),
(13, 1, 0, 0, 0, 0, '', 1310040000, 1),
(14, 1, 0, 0, 0, 0, '', 1310040000, 1),
(15, 1, 0, 0, 0, 0, '', 1310040000, 1),
(16, 1, 0, 0, 0, 0, '', 1310040000, 1),
(17, 1, 0, 0, 0, 0, '', 1310040000, 1),
(21, 1, 0, 0, 0, 0, '', 1310040000, 1),
(22, 1, 0, 0, 0, 0, '', 1310040000, 1),
(23, 1, 0, 0, 0, 0, '', 1310040000, 1),
(24, 1, 0, 0, 0, 0, '', 1310040000, 1),
(25, 1, 0, 0, 0, 0, '', 1310040000, 1),
(26, 1, 0, 0, 0, 0, '', 1310040000, 1),
(27, 1, 0, 0, 0, 0, '', 1310040000, 1),
(28, 1, 0, 0, 0, 0, '', 1310040000, 1),
(33, 1, 0, 0, 0, 0, '', 1310040000, 1),
(34, 1, 0, 0, 0, 0, '', 1310040000, 1),
(35, 1, 0, 0, 0, 0, '', 1310040000, 1),
(36, 1, 0, 0, 0, 0, '', 1310040000, 1),
(37, 1, 0, 0, 0, 0, '', 1310040000, 1),
(38, 1, 0, 0, 0, 0, '', 1310040000, 1),
(39, 1, 0, 0, 0, 0, '', 1310040000, 1),
(40, 1, 0, 0, 0, 0, '', 1310040000, 1);

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

--
-- Tabellenstruktur für Tabelle `wetten_wetten_teams`
--

CREATE TABLE IF NOT EXISTS `wetten_wetten_teams` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wette` int(11) NOT NULL,
  `position` set('home','away','') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `team` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `wette` (`wette`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=65 ;

--
-- Daten für Tabelle `wetten_wetten_teams`
--

INSERT INTO `wetten_wetten_teams` (`id`, `wette`, `position`, `team`) VALUES
(1, 1, 'home', 1),
(2, 1, 'away', 2),
(3, 2, 'home', 3),
(4, 2, 'away', 4),
(5, 3, 'home', 5),
(6, 3, 'away', 6),
(7, 4, 'home', 7),
(8, 4, 'away', 8),
(9, 5, 'home', 9),
(10, 5, 'away', 10),
(11, 6, 'home', 11),
(12, 6, 'away', 12),
(13, 7, 'home', 13),
(14, 7, 'away', 14),
(15, 8, 'home', 15),
(16, 8, 'away', 16),
(17, 10, 'home', 17),
(18, 10, 'away', 18),
(19, 11, 'home', 19),
(20, 11, 'away', 20),
(21, 12, 'home', 21),
(22, 12, 'away', 22),
(23, 13, 'home', 23),
(24, 13, 'away', 24),
(25, 14, 'home', 25),
(26, 14, 'away', 26),
(27, 15, 'home', 27),
(28, 15, 'away', 28),
(29, 16, 'home', 29),
(30, 16, 'away', 30),
(31, 17, 'home', 31),
(32, 17, 'away', 32),
(33, 21, 'home', 33),
(34, 21, 'away', 34),
(35, 22, 'home', 35),
(36, 22, 'away', 36),
(37, 23, 'home', 37),
(38, 23, 'away', 38),
(39, 24, 'home', 39),
(40, 24, 'away', 40),
(41, 25, 'home', 41),
(42, 25, 'away', 42),
(43, 26, 'home', 43),
(44, 26, 'away', 44),
(45, 27, 'home', 45),
(46, 27, 'away', 46),
(47, 28, 'home', 47),
(48, 28, 'away', 48),
(49, 33, 'home', 49),
(50, 33, 'away', 50),
(51, 34, 'home', 51),
(52, 34, 'away', 52),
(53, 35, 'home', 53),
(54, 35, 'away', 54),
(55, 36, 'home', 55),
(56, 36, 'away', 56),
(57, 37, 'home', 57),
(58, 37, 'away', 58),
(59, 38, 'home', 59),
(60, 38, 'away', 60),
(61, 39, 'home', 61),
(62, 39, 'away', 62),
(63, 40, 'home', 63),
(64, 40, 'away', 64);