-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Erstellungszeit: 23. Dez 2025 um 18:48
-- Server-Version: 10.4.32-MariaDB
-- PHP-Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 utf8mb4 */;

--
-- Datenbank: `d044bf8d`
--

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

--
-- Tabellenstruktur für Tabelle `finance_category`
--

CREATE TABLE `finance_category` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `category_code` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `finance_category`
--

INSERT INTO `finance_category` (`id`, `name`, `category_code`) VALUES
(10, 'Player Salary', 'salary_player'),
(20, 'Staff Costs', 'staff_costs'),
(30, 'Ticket League', 'ticket_league'),
(40, 'Ticket Cup', 'ticket_cup'),
(50, 'Ticket Int', 'ticket_int'),
(60, 'Stadium Fixed', 'stadium_costs'),
(70, 'Sponsoring', 'sponsoring'),
(80, 'Bonus League', 'bonuses_league'),
(90, 'Bonus Cup', 'bonuses_cup'),
(100, 'Bonus Int', 'bonuses_int'),
(110, 'Fan Merch', 'fan_merch'),
(120, 'Transfers', 'transfer_market'),
(130, 'Youth Academy', 'youth_academy'),
(140, 'Owner Invest', 'owner_invest'),
(150, 'Others', 'others');

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

--
-- Tabellenstruktur für Tabelle `finance_snapshot_season`
--

CREATE TABLE `finance_snapshot_season` (
  `id` int(10) UNSIGNED NOT NULL,
  `club_id` smallint(5) UNSIGNED NOT NULL,
  `season_id` smallint(5) UNSIGNED NOT NULL,
  `snapshot_date` int(11) NOT NULL,
  `salary_player` int(11) DEFAULT 0,
  `staff_costs` int(11) DEFAULT 0,
  `ticket_league` int(11) DEFAULT 0,
  `ticket_cup` int(11) DEFAULT 0,
  `ticket_int` int(11) DEFAULT 0,
  `stadium_costs` int(11) DEFAULT 0,
  `sponsoring` int(11) DEFAULT 0,
  `bonuses_league` int(11) DEFAULT 0,
  `bonuses_cup` int(11) DEFAULT 0,
  `bonuses_int` int(11) DEFAULT 0,
  `fan_merch` int(11) DEFAULT 0,
  `transfer_market` bigint(20) DEFAULT 0,
  `youth_academy` int(11) DEFAULT 0,
  `owner_invest` bigint(20) DEFAULT 0,
  `others` int(11) DEFAULT 0,
  `result` bigint(20) DEFAULT 0,
  `finance_balance` bigint(20) DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `finance_transactions`
--

CREATE TABLE `finance_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seasonday` tinyint(3) UNSIGNED DEFAULT NULL,
  `season_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `from_type` enum('cpool','club') NOT NULL,
  `from_id` int(11) DEFAULT NULL,
  `to_type` enum('cpool','club') NOT NULL,
  `to_id` int(11) DEFAULT NULL,
  `category_id` smallint(5) UNSIGNED NOT NULL,
  `amount` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `main_script_runtimes`
--

CREATE TABLE `main_script_runtimes` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `date_time` int(10) NOT NULL,
  `runtime_script` double(7,4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `main_script_runtimes`
--

INSERT INTO `main_script_runtimes` (`id`, `name`, `date_time`, `runtime_script`) VALUES
(1, 'Database Reset', 1766512096, 0.0477);

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

--
-- Tabellenstruktur für Tabelle `main_seasonstatus`
--

CREATE TABLE `main_seasonstatus` (
  `id` smallint(5) NOT NULL,
  `now_season` int(10) DEFAULT NULL,
  `now_seasonday` tinyint(4) NOT NULL,
  `now_gameday` tinyint(4) NOT NULL,
  `training_status` tinyint(4) NOT NULL DEFAULT 0,
  `date_start` int(10) NOT NULL,
  `simulate_league` tinyint(3) NOT NULL,
  `simulate_cup` tinyint(3) NOT NULL,
  `simulate_intcups` tinyint(3) NOT NULL,
  `bonus_pay` tinyint(4) NOT NULL,
  `start_team_finance` bigint(20) DEFAULT 0,
  `start_player_values` bigint(20) DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `main_seasonstatus`
--

INSERT INTO `main_seasonstatus` (`id`, `now_season`, `now_seasonday`, `now_gameday`, `training_status`, `date_start`, `simulate_league`, `simulate_cup`, `simulate_intcups`, `bonus_pay`, `start_team_finance`, `start_player_values`) VALUES
(1, 0, 38, 34, 0, 1766480400, 1, 1, 1, 0, 0, 0);

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

--
-- Tabellenstruktur für Tabelle `ws_bonus`
--

CREATE TABLE `ws_bonus` (
  `id` int(10) NOT NULL,
  `game_type` enum('G_League','G_Cup','G_Friendly','G_INTCUP1','G_INTCUP2') NOT NULL DEFAULT 'G_League',
  `type` varchar(15) NOT NULL,
  `round` int(11) NOT NULL,
  `amount` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `ws_bonus`
--

INSERT INTO `ws_bonus` (`id`, `game_type`, `type`, `round`, `amount`) VALUES
(1, 'G_Cup', 'round', 8, 100000),
(2, 'G_Cup', 'round', 7, 100000),
(3, 'G_Cup', 'round', 6, 100000),
(4, 'G_Cup', 'round', 5, 100000),
(5, 'G_Cup', 'round', 4, 100000),
(6, 'G_Cup', 'round', 3, 100000),
(7, 'G_Cup', 'round', 2, 100000),
(8, 'G_Cup', 'round', 1, 100000),
(9, 'G_INTCUP1', 'round', 107, 100000),
(10, 'G_INTCUP1', 'round', 106, 100000),
(11, 'G_INTCUP1', 'round', 105, 100000),
(12, 'G_INTCUP1', 'round', 104, 100000),
(13, 'G_INTCUP1', 'round', 103, 100000),
(14, 'G_INTCUP1', 'round', 102, 100000),
(15, 'G_INTCUP1', 'round', 101, 100000),
(16, 'G_INTCUP1', 'round', 100, 100000),
(17, 'G_INTCUP1', 'round', 99, 100000),
(18, 'G_INTCUP1', 'group_win', 0, 100000),
(19, 'G_INTCUP1', 'group_draw', 0, 100000),
(20, 'G_INTCUP2', 'round', 207, 100000),
(21, 'G_INTCUP2', 'round', 206, 100000),
(22, 'G_INTCUP2', 'round', 205, 100000),
(23, 'G_INTCUP2', 'round', 204, 100000),
(24, 'G_INTCUP2', 'round', 203, 100000),
(25, 'G_INTCUP2', 'round', 202, 100000),
(26, 'G_INTCUP2', 'round', 201, 100000),
(27, 'G_INTCUP2', 'round', 200, 100000),
(28, 'G_INTCUP2', 'round', 199, 100000),
(29, 'G_INTCUP2', 'round', 198, 100000),
(30, 'G_INTCUP2', 'group_win', 0, 100000),
(31, 'G_INTCUP2', 'group_draw', 0, 100000);

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

--
-- Tabellenstruktur für Tabelle `ws_city`
--

CREATE TABLE `ws_city` (
  `id` int(11) NOT NULL,
  `country_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `population` int(11) NOT NULL,
  `is_capital` tinyint(1) DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `ws_city`
--

INSERT INTO `ws_city` (`id`, `country_id`, `name`, `population`, `is_capital`) VALUES
(1, 1001, 'Crownchester', 7200000, 1),
(2, 1001, 'Stormwick', 3600000, 0),
(3, 1001, 'Braveton', 2800000, 0),
(4, 1001, 'Redford', 2600000, 0),
(5, 1001, 'Whitmere', 2000000, 0),
(6, 1001, 'Ashborough', 1800000, 0),
(7, 1001, 'Dunleigh', 1600000, 0),
(8, 1001, 'Ironport', 1500000, 0),
(9, 1001, 'Falkeshire', 1400000, 0),
(10, 1001, 'Thornwall', 1300000, 0),
(11, 1001, 'Greymarch', 1200000, 0),
(12, 1001, 'Norwick', 1100000, 0),
(13, 1001, 'Westgate', 1000000, 0),
(14, 1001, 'Highmere', 950000, 0),
(15, 1001, 'Coldhaven', 900000, 0),
(16, 1001, 'Elmwick', 850000, 0),
(17, 1001, 'Southford', 800000, 0),
(18, 1001, 'Blackharrow', 750000, 0),
(19, 1001, 'Eastmere', 700000, 0),
(20, 1001, 'Riveton', 650000, 0),
(21, 1001, 'Goldwick', 600000, 0),
(22, 1001, 'Northbury', 550000, 0),
(23, 1001, 'Seabridge', 500000, 0),
(24, 1001, 'Oakmarsh', 450000, 0),
(25, 1001, 'Silverhollow', 400000, 0),
(26, 1001, 'Greendale', 380000, 0),
(27, 1001, 'Marbleford', 360000, 0),
(28, 1001, 'Ironhill', 340000, 0),
(29, 1001, 'Briarhaven', 320000, 0),
(30, 1001, 'Wolferton', 300000, 0),
(31, 1002, 'Frostholm', 4200000, 1),
(32, 1002, 'Narvikka', 2200000, 0),
(33, 1002, 'Ostervik', 1600000, 0),
(34, 1002, 'Jarnstad', 1400000, 0),
(35, 1002, 'Vinterfjord', 1200000, 0),
(36, 1002, 'Helsvik', 1000000, 0),
(37, 1002, 'Nordstad', 950000, 0),
(38, 1002, 'Bjorndal', 900000, 0),
(39, 1002, 'Fjellheim', 850000, 0),
(40, 1002, 'Skarnvik', 800000, 0),
(41, 1002, 'Draugstad', 750000, 0),
(42, 1002, 'Eikfjord', 700000, 0),
(43, 1002, 'Solheim', 650000, 0),
(44, 1002, 'Brattvik', 600000, 0),
(45, 1002, 'Kolverud', 550000, 0),
(46, 1002, 'Isfjord', 500000, 0),
(47, 1002, 'Varheim', 480000, 0),
(48, 1002, 'Ulvik', 460000, 0),
(49, 1002, 'Grestad', 440000, 0),
(50, 1002, 'Hammarvik', 420000, 0),
(51, 1002, 'Snovik', 400000, 0),
(52, 1002, 'Arnsfjord', 380000, 0),
(53, 1002, 'Ljosvik', 360000, 0),
(54, 1002, 'Torshamn', 340000, 0),
(55, 1002, 'Kaldvik', 320000, 0),
(56, 1002, 'Brekken', 300000, 0),
(57, 1002, 'Stromvik', 280000, 0),
(58, 1002, 'Knarvik', 260000, 0),
(59, 1002, 'Yttervik', 240000, 0),
(60, 1002, 'Frosvik', 220000, 0),
(61, 1003, 'Tulmhaven', 3000000, 1),
(62, 1003, 'Dijkburg', 1600000, 0),
(63, 1003, 'Veenstad', 1200000, 0),
(64, 1003, 'Oostermeer', 1000000, 0),
(65, 1003, 'Windam', 850000, 0),
(66, 1003, 'Harldam', 800000, 0),
(67, 1003, 'Kaasen', 750000, 0),
(68, 1003, 'Broekfurt', 700000, 0),
(69, 1003, 'Zeedorp', 650000, 0),
(70, 1003, 'Markenstad', 600000, 0),
(71, 1003, 'Lindeveen', 580000, 0),
(72, 1003, 'Houtdam', 560000, 0),
(73, 1003, 'Westerhaven', 540000, 0),
(74, 1003, 'Veldstad', 520000, 0),
(75, 1003, 'Groendam', 500000, 0),
(76, 1003, 'Slootmeer', 480000, 0),
(77, 1003, 'Ambrich', 460000, 0),
(78, 1003, 'Havenrecht', 440000, 0),
(79, 1003, 'Polsdam', 420000, 0),
(80, 1003, 'Korenburg', 400000, 0),
(81, 1003, 'Breemond', 380000, 0),
(82, 1003, 'Zuidhaven', 360000, 0),
(83, 1003, 'Noordmeer', 340000, 0),
(84, 1003, 'Buitenburg', 320000, 0),
(85, 1003, 'Eindveen', 300000, 0),
(86, 1003, 'Waterdam', 280000, 0),
(87, 1003, 'Fjordrecht', 260000, 0),
(88, 1003, 'Nieuwholt', 240000, 0),
(89, 1003, 'Kleindam', 220000, 0),
(90, 1003, 'Moerwijk', 200000, 0),
(91, 1004, 'Eisenburg', 11000000, 1),
(92, 1004, 'Falkenberg', 6000000, 0),
(93, 1004, 'Steinwald', 4800000, 0),
(94, 1004, 'Kronstadt', 4500000, 0),
(95, 1004, 'Altdorf', 4000000, 0),
(96, 1004, 'Schwarzfels', 3500000, 0),
(97, 1004, 'Lindhafen', 3200000, 0),
(98, 1004, 'Hochburg', 3000000, 0),
(99, 1004, 'Drachenfels', 2800000, 0),
(100, 1004, 'Silberthal', 2600000, 0),
(101, 1004, 'Waldkirch', 2400000, 0),
(102, 1004, 'Hohenfurt', 2200000, 0),
(103, 1004, 'Bärenfels', 2000000, 0),
(104, 1004, 'Eisental', 1900000, 0),
(105, 1004, 'Dornstadt', 1800000, 0),
(106, 1004, 'Nordtor', 1700000, 0),
(107, 1004, 'Kaiserdorf', 1600000, 0),
(108, 1004, 'Grünthal', 1500000, 0),
(109, 1004, 'Rotenfels', 1400000, 0),
(110, 1004, 'Sturmwald', 1300000, 0),
(111, 1004, 'Goldfurt', 1200000, 0),
(112, 1004, 'Bergheim', 1100000, 0),
(113, 1004, 'Lichtwald', 1000000, 0),
(114, 1004, 'Talbrück', 950000, 0),
(115, 1004, 'Eberstadt', 900000, 0),
(116, 1004, 'Weissenfels', 850000, 0),
(117, 1004, 'Steintor', 800000, 0),
(118, 1004, 'Rosenfurt', 750000, 0),
(119, 1004, 'Adlersheim', 700000, 0),
(120, 1004, 'Donnersdorf', 650000, 0),
(121, 1005, 'Bellecour', 9500000, 1),
(122, 1005, 'Vionne', 5000000, 0),
(123, 1005, 'Montelac', 4200000, 0),
(124, 1005, 'Chavron', 3800000, 0),
(125, 1005, 'Fleurval', 3400000, 0),
(126, 1005, 'Rosenne', 3000000, 0),
(127, 1005, 'Dorlac', 2800000, 0),
(128, 1005, 'Marvoix', 2600000, 0),
(129, 1005, 'Charvieu', 2400000, 0),
(130, 1005, 'Avrelle', 2200000, 0),
(131, 1005, 'Santenay', 2000000, 0),
(132, 1005, 'Louvière', 1900000, 0),
(133, 1005, 'Quissac', 1800000, 0),
(134, 1005, 'Dornelle', 1700000, 0),
(135, 1005, 'Belmarc', 1600000, 0),
(136, 1005, 'Trellon', 1500000, 0),
(137, 1005, 'Gaubois', 1400000, 0),
(138, 1005, 'Nivrelle', 1300000, 0),
(139, 1005, 'Clarmont', 1200000, 0),
(140, 1005, 'Feuville', 1100000, 0),
(141, 1005, 'Montreval', 1000000, 0),
(142, 1005, 'Portelac', 950000, 0),
(143, 1005, 'Villeneuve', 900000, 0),
(144, 1005, 'Sauveterre', 850000, 0),
(145, 1005, 'Brisac', 800000, 0),
(146, 1005, 'Montclair', 750000, 0),
(147, 1005, 'Duvignon', 700000, 0),
(148, 1005, 'Lavencourt', 650000, 0),
(149, 1005, 'Merivaux', 600000, 0),
(150, 1005, 'Castelroux', 550000, 0),
(151, 1006, 'Solaria', 8500000, 1),
(152, 1006, 'Bravento', 4500000, 0),
(153, 1006, 'Lirona', 3800000, 0),
(154, 1006, 'Castellaro', 3400000, 0),
(155, 1006, 'Ventomar', 3000000, 0),
(156, 1006, 'Orvietto', 2600000, 0),
(157, 1006, 'Almerida', 2400000, 0),
(158, 1006, 'Gravena', 2200000, 0),
(159, 1006, 'Portenio', 2000000, 0),
(160, 1006, 'Firenata', 1900000, 0),
(161, 1006, 'Calviano', 1800000, 0),
(162, 1006, 'Durosta', 1700000, 0),
(163, 1006, 'Amalora', 1600000, 0),
(164, 1006, 'Novessa', 1500000, 0),
(165, 1006, 'Torviano', 1400000, 0),
(166, 1006, 'Crestello', 1300000, 0),
(167, 1006, 'Floranta', 1200000, 0),
(168, 1006, 'Lamistra', 1100000, 0),
(169, 1006, 'Serravalle', 1000000, 0),
(170, 1006, 'Marvento', 950000, 0),
(171, 1006, 'Bellagio', 900000, 0),
(172, 1006, 'Ravenna', 850000, 0),
(173, 1006, 'Olivario', 800000, 0),
(174, 1006, 'Triverno', 750000, 0),
(175, 1006, 'Costarella', 700000, 0),
(176, 1006, 'Montauro', 650000, 0),
(177, 1006, 'Savento', 600000, 0),
(178, 1006, 'Palmiro', 550000, 0),
(179, 1006, 'Ludario', 500000, 0),
(180, 1006, 'Venaro', 450000, 0),
(181, 1007, 'Lusvarra', 7800000, 1),
(182, 1007, 'Castellona', 4200000, 0),
(183, 1007, 'Bravira', 3500000, 0),
(184, 1007, 'Portuvo', 3200000, 0),
(185, 1007, 'Andalecar', 2800000, 0),
(186, 1007, 'Rivora', 2400000, 0),
(187, 1007, 'Tolviera', 2200000, 0),
(188, 1007, 'Mirafonte', 2000000, 0),
(189, 1007, 'Granvico', 1900000, 0),
(190, 1007, 'Sorranda', 1800000, 0),
(191, 1007, 'Cadaval', 1700000, 0),
(192, 1007, 'Lusdora', 1600000, 0),
(193, 1007, 'Almorica', 1500000, 0),
(194, 1007, 'Marvera', 1400000, 0),
(195, 1007, 'Rionda', 1300000, 0),
(196, 1007, 'Castellomar', 1200000, 0),
(197, 1007, 'Beltrona', 1100000, 0),
(198, 1007, 'Segavia', 1000000, 0),
(199, 1007, 'Ponfiera', 950000, 0),
(200, 1007, 'Estavico', 900000, 0),
(201, 1007, 'Orovira', 850000, 0),
(202, 1007, 'Torilva', 800000, 0),
(203, 1007, 'Seranova', 750000, 0),
(204, 1007, 'Villadro', 700000, 0),
(205, 1007, 'Montiero', 650000, 0),
(206, 1007, 'Cartavio', 600000, 0),
(207, 1007, 'Lanzora', 550000, 0),
(208, 1007, 'Benarros', 500000, 0),
(209, 1007, 'Portalejo', 480000, 0),
(210, 1007, 'Castelmar', 460000, 0),
(211, 1008, 'Valmorra', 4800000, 1),
(212, 1008, 'Stravograd', 2600000, 0),
(213, 1008, 'Drakovik', 2200000, 0),
(214, 1008, 'Belmorra', 2000000, 0),
(215, 1008, 'Vostric', 1800000, 0),
(216, 1008, 'Karadun', 1600000, 0),
(217, 1008, 'Zoranik', 1400000, 0),
(218, 1008, 'Milostra', 1300000, 0),
(219, 1008, 'Cravenik', 1200000, 0),
(220, 1008, 'Ostrovia', 1100000, 0),
(221, 1008, 'Gradova', 1000000, 0),
(222, 1008, 'Tarnovik', 950000, 0),
(223, 1008, 'Brastor', 900000, 0),
(224, 1008, 'Domislav', 850000, 0),
(225, 1008, 'Molvenik', 800000, 0),
(226, 1008, 'Petrovra', 750000, 0),
(227, 1008, 'Kresnova', 700000, 0),
(228, 1008, 'Zadovik', 650000, 0),
(229, 1008, 'Stravanik', 600000, 0),
(230, 1008, 'Ulmorra', 580000, 0),
(231, 1008, 'Brelovic', 560000, 0),
(232, 1008, 'Koravnik', 540000, 0),
(233, 1008, 'Marlovic', 520000, 0),
(234, 1008, 'Drovenik', 500000, 0),
(235, 1008, 'Slatovik', 480000, 0),
(236, 1008, 'Velgrad', 460000, 0),
(237, 1008, 'Pristanik', 440000, 0),
(238, 1008, 'Novaric', 420000, 0),
(239, 1008, 'Travoric', 400000, 0),
(240, 1008, 'Branikov', 380000, 0),
(241, 1009, 'Vistagrad', 9000000, 1),
(242, 1009, 'Polnovia', 4800000, 0),
(243, 1009, 'Radomir', 4000000, 0),
(244, 1009, 'Slavinsk', 3600000, 0),
(245, 1009, 'Durnograd', 3200000, 0),
(246, 1009, 'Kovarno', 2800000, 0),
(247, 1009, 'Brestal', 2600000, 0),
(248, 1009, 'Vorotna', 2400000, 0),
(249, 1009, 'Minskova', 2200000, 0),
(250, 1009, 'Petrovia', 2000000, 0),
(251, 1009, 'Zarislav', 1800000, 0),
(252, 1009, 'Kornovia', 1700000, 0),
(253, 1009, 'Strelvak', 1600000, 0),
(254, 1009, 'Lumorsk', 1500000, 0),
(255, 1009, 'Volnava', 1400000, 0),
(256, 1009, 'Bratovik', 1300000, 0),
(257, 1009, 'Tarnava', 1200000, 0),
(258, 1009, 'Novodra', 1100000, 0),
(259, 1009, 'Brisnov', 1000000, 0),
(260, 1009, 'Varnovka', 950000, 0),
(261, 1009, 'Slovarka', 900000, 0),
(262, 1009, 'Dravinsk', 850000, 0),
(263, 1009, 'Poltaren', 800000, 0),
(264, 1009, 'Novaresk', 750000, 0),
(265, 1009, 'Samarov', 700000, 0),
(266, 1009, 'Korislav', 650000, 0),
(267, 1009, 'Urzansk', 600000, 0),
(268, 1009, 'Varoslav', 560000, 0),
(269, 1009, 'Mirnovka', 520000, 0),
(270, 1009, 'Trevinsk', 480000, 0),
(271, 1010, 'Sambora', 18000000, 1),
(272, 1010, 'Tangora', 9500000, 0),
(273, 1010, 'Luminho', 8000000, 0),
(274, 1010, 'Bravados', 7000000, 0),
(275, 1010, 'Floramba', 6000000, 0),
(276, 1010, 'Maracira', 5000000, 0),
(277, 1010, 'Deltano', 4500000, 0),
(278, 1010, 'Corveta', 4200000, 0),
(279, 1010, 'Granito', 4000000, 0),
(280, 1010, 'Riovera', 3800000, 0),
(281, 1010, 'Castamba', 3600000, 0),
(282, 1010, 'Sonvito', 3400000, 0),
(283, 1010, 'Palomira', 3200000, 0),
(284, 1010, 'Ventosa', 3000000, 0),
(285, 1010, 'Juvenco', 2800000, 0),
(286, 1010, 'Flamora', 2600000, 0),
(287, 1010, 'Belenhos', 2400000, 0),
(288, 1010, 'Solmira', 2200000, 0),
(289, 1010, 'Dorados', 2000000, 0),
(290, 1010, 'Pampilla', 1800000, 0),
(291, 1010, 'Torinas', 1600000, 0),
(292, 1010, 'Guavira', 1500000, 0),
(293, 1010, 'Montaral', 1400000, 0),
(294, 1010, 'Serrado', 1300000, 0),
(295, 1010, 'Valmoro', 1200000, 0),
(296, 1010, 'Camorina', 1100000, 0),
(297, 1010, 'Brasillo', 1000000, 0),
(298, 1010, 'Luzamba', 950000, 0),
(299, 1010, 'Puerto Sol', 900000, 0),
(300, 1010, 'Veradona', 850000, 0),
(301, 1011, 'Freedom City', 16000000, 1),
(302, 1011, 'Grandvale', 9000000, 0),
(303, 1011, 'Riverford', 8000000, 0),
(304, 1011, 'Eastmont', 7000000, 0),
(305, 1011, 'New Ashton', 6000000, 0),
(306, 1011, 'Brookfield', 5000000, 0),
(307, 1011, 'Ironridge', 4500000, 0),
(308, 1011, 'Silverdale', 4200000, 0),
(309, 1011, 'Kingston Bay', 4000000, 0),
(310, 1011, 'Westbrook', 3800000, 0),
(311, 1011, 'Highland City', 3600000, 0),
(312, 1011, 'Rockford', 3400000, 0),
(313, 1011, 'Clearwater', 3200000, 0),
(314, 1011, 'Northgate', 3000000, 0),
(315, 1011, 'Springfield', 2800000, 0),
(316, 1011, 'Maple Heights', 2600000, 0),
(317, 1011, 'Stormhill', 2400000, 0),
(318, 1011, 'Oakford', 2200000, 0),
(319, 1011, 'Valleyport', 2000000, 0),
(320, 1011, 'Grandhaven', 1800000, 0),
(321, 1011, 'Lakeshore', 1600000, 0),
(322, 1011, 'Milltown', 1500000, 0),
(323, 1011, 'Riverton', 1400000, 0),
(324, 1011, 'Bayfield', 1300000, 0),
(325, 1011, 'Stonebridge', 1200000, 0),
(326, 1011, 'Greenwood', 1100000, 0),
(327, 1011, 'Hillcrest', 1000000, 0),
(328, 1011, 'Westfield', 950000, 0),
(329, 1011, 'Pinehill', 900000, 0),
(330, 1011, 'Fort Liberty', 850000, 0),
(331, 1012, 'Solmara', 12000000, 1),
(332, 1012, 'Puerto Verde', 6000000, 0),
(333, 1012, 'Calorica', 5000000, 0),
(334, 1012, 'Bravento', 4200000, 0),
(335, 1012, 'Maricuba', 3800000, 0),
(336, 1012, 'San Dorado', 3400000, 0),
(337, 1012, 'Isla Bonita', 3000000, 0),
(338, 1012, 'Palmavera', 2800000, 0),
(339, 1012, 'Ventacruz', 2600000, 0),
(340, 1012, 'Costa Roja', 2400000, 0),
(341, 1012, 'Miravida', 2200000, 0),
(342, 1012, 'Flamenco', 2000000, 0),
(343, 1012, 'Dorado Bay', 1900000, 0),
(344, 1012, 'Port Solano', 1800000, 0),
(345, 1012, 'Santa Vieja', 1700000, 0),
(346, 1012, 'Monteverde', 1600000, 0),
(347, 1012, 'Playa Azul', 1500000, 0),
(348, 1012, 'Corazon', 1400000, 0),
(349, 1012, 'Estrella', 1300000, 0),
(350, 1012, 'Palmarosa', 1200000, 0),
(351, 1012, 'Nuevo Sol', 1100000, 0),
(352, 1012, 'Trinidador', 1000000, 0),
(353, 1012, 'Caravera', 950000, 0),
(354, 1012, 'Luzmarina', 900000, 0),
(355, 1012, 'Santacruz', 850000, 0),
(356, 1012, 'Rivamonte', 800000, 0),
(357, 1012, 'Florencia', 760000, 0),
(358, 1012, 'Puerto Loma', 720000, 0),
(359, 1012, 'Bellavista', 680000, 0),
(360, 1012, 'San Palmar', 640000, 0),
(361, 1013, 'Jambala', 25000000, 1),
(362, 1013, 'Korundu', 15000000, 0),
(363, 1013, 'Zembira', 12000000, 0),
(364, 1013, 'Malondo', 10000000, 0),
(365, 1013, 'Kibasha', 9000000, 0),
(366, 1013, 'Tembura', 8000000, 0),
(367, 1013, 'Dorongo', 7000000, 0),
(368, 1013, 'Asimba', 6500000, 0),
(369, 1013, 'Lubasha', 6000000, 0),
(370, 1013, 'Vurongo', 5600000, 0),
(371, 1013, 'Manziba', 5200000, 0),
(372, 1013, 'Kalora', 4800000, 0),
(373, 1013, 'Simbala', 4400000, 0),
(374, 1013, 'Orendu', 4000000, 0),
(375, 1013, 'Kasamba', 3800000, 0),
(376, 1013, 'Torondo', 3600000, 0),
(377, 1013, 'Nyamira', 3400000, 0),
(378, 1013, 'Zulenga', 3200000, 0),
(379, 1013, 'Kavemba', 3000000, 0),
(380, 1013, 'Luwanda', 2800000, 0),
(381, 1013, 'Borongo', 2600000, 0),
(382, 1013, 'Makunda', 2400000, 0),
(383, 1013, 'Tarimba', 2200000, 0),
(384, 1013, 'Saharubo', 2000000, 0),
(385, 1013, 'Buzandi', 1800000, 0),
(386, 1013, 'Katimbo', 1600000, 0),
(387, 1013, 'Olmara', 1400000, 0),
(388, 1013, 'Furenga', 1200000, 0),
(389, 1013, 'Rivamba', 1000000, 0),
(390, 1013, 'Zumoro', 900000, 0),
(391, 1014, 'Al-Mazar', 12000000, 1),
(392, 1014, 'Zahrim', 7000000, 0),
(393, 1014, 'Qasira', 6000000, 0),
(394, 1014, 'Dufalah', 5200000, 0),
(395, 1014, 'Hamira', 4600000, 0),
(396, 1014, 'Basthar', 4000000, 0),
(397, 1014, 'Mornak', 3600000, 0),
(398, 1014, 'Qarimah', 3300000, 0),
(399, 1014, 'Solthar', 3000000, 0),
(400, 1014, 'Jufarah', 2800000, 0),
(401, 1014, 'Damirah', 2600000, 0),
(402, 1014, 'Haruz', 2400000, 0),
(403, 1014, 'Nufal', 2200000, 0),
(404, 1014, 'Tarimah', 2000000, 0),
(405, 1014, 'Azhara', 1900000, 0),
(406, 1014, 'Khorad', 1800000, 0),
(407, 1014, 'Bastirah', 1700000, 0),
(408, 1014, 'Umirah', 1600000, 0),
(409, 1014, 'Zalima', 1500000, 0),
(410, 1014, 'Faqirah', 1400000, 0),
(411, 1014, 'Amarah', 1300000, 0),
(412, 1014, 'Rashira', 1200000, 0),
(413, 1014, 'Ghantira', 1100000, 0),
(414, 1014, 'Sirhalla', 1000000, 0),
(415, 1014, 'Lubahir', 950000, 0),
(416, 1014, 'Mazirah', 900000, 0),
(417, 1014, 'Orathir', 850000, 0),
(418, 1014, 'Tanirah', 800000, 0),
(419, 1014, 'Fujaira', 750000, 0),
(420, 1014, 'Jabirah', 700000, 0),
(421, 1015, 'Novgorava', 12000000, 1),
(422, 1015, 'Petroska', 7000000, 0),
(423, 1015, 'Volgrinsk', 6000000, 0),
(424, 1015, 'Dorovya', 5200000, 0),
(425, 1015, 'Kazamirsk', 4600000, 0),
(426, 1015, 'Ursavka', 4000000, 0),
(427, 1015, 'Mirnovka', 3600000, 0),
(428, 1015, 'Trovinsk', 3300000, 0),
(429, 1015, 'Krasnova', 3000000, 0),
(430, 1015, 'Belomirsk', 2800000, 0),
(431, 1015, 'Ostrovska', 2600000, 0),
(432, 1015, 'Zarkovsk', 2400000, 0),
(433, 1015, 'Podrovna', 2200000, 0),
(434, 1015, 'Svetlorad', 2000000, 0),
(435, 1015, 'Varnok', 1900000, 0),
(436, 1015, 'Borislavsk', 1800000, 0),
(437, 1015, 'Dumirsk', 1700000, 0),
(438, 1015, 'Trusovka', 1600000, 0),
(439, 1015, 'Kalimorsk', 1500000, 0),
(440, 1015, 'Vostrosk', 1400000, 0),
(441, 1015, 'Marivnya', 1300000, 0),
(442, 1015, 'Strovinsk', 1200000, 0),
(443, 1015, 'Lenivsk', 1100000, 0),
(444, 1015, 'Grudovsk', 1000000, 0),
(445, 1015, 'Tarovsk', 950000, 0),
(446, 1015, 'Zimovka', 900000, 0),
(447, 1015, 'Orlovsk', 850000, 0),
(448, 1015, 'Molensk', 800000, 0),
(449, 1015, 'Petrinsk', 750000, 0),
(450, 1015, 'Sokolovsk', 700000, 0),
(451, 1016, 'Xianhua', 22000000, 1),
(452, 1016, 'Longzhou', 12000000, 0),
(453, 1016, 'Beilin', 10000000, 0),
(454, 1016, 'Nanfang', 9000000, 0),
(455, 1016, 'Zhurong', 8000000, 0),
(456, 1016, 'Kaihua', 7000000, 0),
(457, 1016, 'Songdao', 6500000, 0),
(458, 1016, 'Hanlong', 6000000, 0),
(459, 1016, 'Minguo', 5600000, 0),
(460, 1016, 'Shentao', 5200000, 0),
(461, 1016, 'Jinzhao', 4800000, 0),
(462, 1016, 'Wuyuan', 4400000, 0),
(463, 1016, 'Hongdao', 4200000, 0),
(464, 1016, 'Lianshu', 4000000, 0),
(465, 1016, 'Fengzhi', 3800000, 0),
(466, 1016, 'Taoyang', 3600000, 0),
(467, 1016, 'Qingshu', 3400000, 0),
(468, 1016, 'Xurong', 3200000, 0),
(469, 1016, 'Donghai', 3000000, 0),
(470, 1016, 'Minghua', 2800000, 0),
(471, 1016, 'Yunzhou', 2600000, 0),
(472, 1016, 'Chenzhou', 2400000, 0),
(473, 1016, 'Luohe', 2200000, 0),
(474, 1016, 'Baishu', 2000000, 0),
(475, 1016, 'Zhulin', 1800000, 0),
(476, 1016, 'Tianshu', 1600000, 0),
(477, 1016, 'Huangdao', 1400000, 0),
(478, 1016, 'Lianhua', 1200000, 0),
(479, 1016, 'Shanwei', 1000000, 0),
(480, 1016, 'Guangdao', 900000, 0);

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

--
-- Tabellenstruktur für Tabelle `ws_club`
--

CREATE TABLE `ws_club` (
  `id` int(10) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `country_id` int(5) DEFAULT NULL,
  `city` varchar(30) NOT NULL,
  `team_owner_wallet` varchar(100) NOT NULL,
  `finance_balance` bigint(20) NOT NULL,
  `color_combi` varchar(8) NOT NULL,
  `color_code1` varchar(10) NOT NULL,
  `color_code2` varchar(10) NOT NULL,
  `emblem_no` tinyint(2) DEFAULT 1,
  `stadium_id` smallint(3) NOT NULL,
  `league_level` smallint(2) NOT NULL,
  `league_id` smallint(3) NOT NULL,
  `league_id_intcups` smallint(3) NOT NULL,
  `rank_league` smallint(3) NOT NULL,
  `rank_league_prev` smallint(3) NOT NULL,
  `rank_cup` smallint(3) NOT NULL,
  `rank_intcup1` smallint(3) NOT NULL,
  `rank_intcup2` smallint(3) NOT NULL,
  `rank_intcups_gruppe` smallint(3) NOT NULL,
  `now_league_champion` smallint(1) NOT NULL,
  `now_league_up` smallint(1) NOT NULL,
  `now_league_down` smallint(1) NOT NULL,
  `now_cup_champion` smallint(1) NOT NULL,
  `now_int2_champion` smallint(1) NOT NULL,
  `now_int1_champion` smallint(1) NOT NULL,
  `league_goals` smallint(3) NOT NULL,
  `league_goals_against` smallint(3) NOT NULL,
  `league_games` smallint(3) NOT NULL,
  `league_won` smallint(3) NOT NULL,
  `league_remis` smallint(3) NOT NULL,
  `league_lost` smallint(3) NOT NULL,
  `league_points` smallint(3) NOT NULL,
  `cup_games` smallint(3) NOT NULL,
  `cup_goals` smallint(3) NOT NULL,
  `cup_goals_against` smallint(3) NOT NULL,
  `cup_won` smallint(3) NOT NULL,
  `cup_remis` smallint(5) NOT NULL,
  `cup_lost` smallint(3) NOT NULL,
  `intcups_goals` smallint(3) NOT NULL,
  `intcups_goals_against` smallint(3) NOT NULL,
  `intcups_won` smallint(3) NOT NULL,
  `intcups_remis` smallint(3) NOT NULL,
  `intcups_lost` smallint(3) NOT NULL,
  `intcups_points` smallint(3) NOT NULL,
  `intcups_all_goals` smallint(3) NOT NULL,
  `intcups_all_goals_against` smallint(3) NOT NULL,
  `intcups_all_won` smallint(3) NOT NULL,
  `intcups_all_remis` smallint(3) NOT NULL,
  `intcups_all_lost` smallint(3) NOT NULL,
  `price_league` tinyint(3) NOT NULL DEFAULT 20,
  `price_intcups` tinyint(3) NOT NULL DEFAULT 60,
  `price_cup` tinyint(3) NOT NULL DEFAULT 35
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `ws_country`
--

CREATE TABLE `ws_country` (
  `id` int(10) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `short` varchar(5) DEFAULT NULL,
  `simulate_league` tinyint(1) DEFAULT NULL,
  `simulate_cup` tinyint(1) DEFAULT NULL,
  `rank_pos` tinyint(3) NOT NULL,
  `rank_prev` tinyint(4) NOT NULL,
  `country_coefficient` double(4,3) NOT NULL,
  `population_million` int(11) DEFAULT NULL,
  `area_percent` decimal(4,1) DEFAULT NULL,
  `points_season` double(4,1) NOT NULL DEFAULT 0.0,
  `points_1` double(4,1) NOT NULL DEFAULT 0.0,
  `points_2` double(4,1) NOT NULL DEFAULT 0.0,
  `points_3` double(4,1) NOT NULL DEFAULT 0.0,
  `points_4` double(4,1) NOT NULL DEFAULT 0.0,
  `country_starters_season` tinyint(2) NOT NULL,
  `country_starters_1` tinyint(2) NOT NULL,
  `country_starters_2` tinyint(2) NOT NULL,
  `country_starters_3` tinyint(2) NOT NULL,
  `country_starters_4` tinyint(2) NOT NULL,
  `intcup1_fix` tinyint(1) NOT NULL,
  `intcup1_q1` tinyint(1) NOT NULL,
  `intcup1_q2` tinyint(1) NOT NULL,
  `intcup1_q3` tinyint(1) NOT NULL,
  `intcup2_fix` tinyint(1) NOT NULL,
  `intcup2_q1` tinyint(1) NOT NULL,
  `intcup2_q2` tinyint(1) NOT NULL,
  `intcup2_q3` tinyint(1) NOT NULL,
  `region` varchar(100) DEFAULT NULL,
  `climate` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `ws_country`
--

INSERT INTO `ws_country` (`id`, `name`, `short`, `simulate_league`, `simulate_cup`, `rank_pos`, `rank_prev`, `country_coefficient`, `population_million`, `area_percent`, `points_season`, `points_1`, `points_2`, `points_3`, `points_4`, `country_starters_season`, `country_starters_1`, `country_starters_2`, `country_starters_3`, `country_starters_4`, `intcup1_fix`, `intcup1_q1`, `intcup1_q2`, `intcup1_q3`, `intcup2_fix`, `intcup2_q1`, `intcup2_q2`, `intcup2_q3`, `region`, `climate`) VALUES
(1001, 'Kingstale', 'KT', 1, 1, 1, 0, 0.975, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Britische Inseln', 'Grüne Hügel, kühles Klima'),
(1002, 'Norrvik', 'NV', 1, 1, 2, 0, 0.950, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Skandinavien', 'Fjorde, Schnee, Berge'),
(1003, 'Flatland', 'FL', 1, 1, 3, 0, 0.925, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Niederlande/Dänemark', 'Flaches Küstenland'),
(1004, 'Kaisergard', 'KG', 1, 1, 4, 0, 0.900, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Deutschland/Alpen', 'Wälder, Berge'),
(1005, 'Belvoire', 'BV', 1, 1, 5, 0, 0.875, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Frankreich/Benelux', 'Flüsse, Täler, Weinberge'),
(1006, 'Meditara', 'MT', 1, 1, 6, 0, 0.850, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Italien/Griechenland', 'Mittelmeer'),
(1007, 'Extavora', 'EX', 1, 1, 7, 0, 0.825, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Iberische Halbinsel', 'Sonne, Berge'),
(1008, 'Stonevale', 'SV', 1, 1, 8, 0, 0.800, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Balkan', 'Gebirge'),
(1009, 'Slavora', 'SL', 1, 1, 9, 0, 0.775, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Osteuropa', 'Ebenen'),
(1010, 'Patagonia', 'PG', 1, 1, 10, 0, 0.750, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Südamerika', 'Dschungel'),
(1011, 'Liberty Union', 'LU', 1, 1, 11, 0, 0.725, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'USA/Kanada', 'Ebenen'),
(1012, 'Sunreach', 'SR', 1, 1, 12, 0, 0.700, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Mexiko/Karibik', 'Tropen'),
(1013, 'Ubunda', 'UB', 1, 1, 13, 0, 0.675, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Afrika', 'Savanne'),
(1014, 'Kharifal', 'KH', 1, 1, 14, 0, 0.650, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Arabisch', 'Wüste'),
(1015, 'Ruskara', 'RK', 1, 1, 15, 0, 0.625, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Russland', 'Steppe'),
(1016, 'Orientra', 'OR', 1, 1, 16, 0, 0.600, 100, 5.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ostasien', 'Gebirge');

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

--
-- Tabellenstruktur für Tabelle `ws_game`
--

CREATE TABLE `ws_game` (
  `id` int(10) NOT NULL,
  `game_type` enum('G_League','G_Cup','G_Friendly','G_INTCUP1','G_INTCUP2') NOT NULL DEFAULT 'G_League',
  `penalty` enum('1','0') NOT NULL DEFAULT '0',
  `game_round` varchar(30) DEFAULT NULL,
  `country_id` smallint(5) NOT NULL,
  `league_id` smallint(5) NOT NULL,
  `league_id_intcups` tinyint(5) NOT NULL,
  `season_id` int(10) NOT NULL,
  `gameday` tinyint(3) NOT NULL,
  `gameday_intcups` tinyint(3) NOT NULL,
  `date_time` int(10) NOT NULL,
  `stadium_id` int(10) NOT NULL,
  `attendance` int(6) NOT NULL,
  `duration` tinyint(2) NOT NULL,
  `simulated` tinyint(1) NOT NULL,
  `live` tinyint(1) NOT NULL,
  `GameStatusLast` varchar(3) NOT NULL,
  `home_club` int(10) NOT NULL,
  `away_club` int(10) NOT NULL,
  `home_goals` tinyint(2) NOT NULL,
  `away_goals` tinyint(2) NOT NULL,
  `home_goals_ht` tinyint(2) NOT NULL,
  `away_goals_ht` tinyint(2) NOT NULL,
  `home_goals_90` tinyint(2) NOT NULL,
  `away_goals_90` tinyint(2) NOT NULL,
  `home_goals_penalty` tinyint(2) NOT NULL,
  `away_goals_penalty` tinyint(2) NOT NULL,
  `home_gk_strength` tinyint(3) NOT NULL DEFAULT 0,
  `away_gk_strength` tinyint(3) NOT NULL DEFAULT 0,
  `home_defense_strength` tinyint(3) NOT NULL DEFAULT 0,
  `away_defense_strength` tinyint(3) NOT NULL DEFAULT 0,
  `home_midfield_strength` tinyint(3) NOT NULL DEFAULT 0,
  `away_midfield_strength` tinyint(3) NOT NULL DEFAULT 0,
  `home_striker_strength` tinyint(3) NOT NULL DEFAULT 0,
  `away_striker_strength` tinyint(3) NOT NULL DEFAULT 0,
  `home_count_defense` tinyint(1) NOT NULL DEFAULT 0,
  `away_count_defense` tinyint(1) NOT NULL DEFAULT 0,
  `home_count_midfield` tinyint(1) NOT NULL DEFAULT 0,
  `away_count_midfield` tinyint(1) NOT NULL DEFAULT 0,
  `home_count_striker` tinyint(1) NOT NULL DEFAULT 0,
  `away_count_striker` tinyint(1) NOT NULL DEFAULT 0,
  `stat_home_shots` int(11) DEFAULT 0,
  `stat_away_shots` int(11) DEFAULT 0,
  `stat_home_shots_on` int(11) DEFAULT 0,
  `stat_away_shots_on` int(11) DEFAULT 0,
  `stat_home_passes` int(11) DEFAULT 0,
  `stat_away_passes` int(11) DEFAULT 0,
  `stat_home_passes_success` int(11) DEFAULT 0,
  `stat_away_passes_success` int(11) DEFAULT 0,
  `stat_home_duels_won` int(11) DEFAULT 0,
  `stat_away_duels_won` int(11) DEFAULT 0,
  `stat_home_duels_lost` int(11) DEFAULT 0,
  `stat_away_duels_lost` int(11) DEFAULT 0,
  `stat_home_yellow` int(11) DEFAULT 0,
  `stat_away_yellow` int(11) DEFAULT 0,
  `stat_home_yellowred` int(11) DEFAULT 0,
  `stat_away_yellowred` int(11) DEFAULT 0,
  `stat_home_red` int(11) DEFAULT 0,
  `stat_away_red` int(11) DEFAULT 0,
  `stat_home_chances` int(11) DEFAULT 0,
  `stat_away_chances` int(11) DEFAULT 0,
  `stat_home_possession` int(11) DEFAULT 50,
  `stat_away_possession` int(11) DEFAULT 50,
  `stat_home_substitutions` int(11) DEFAULT 0,
  `stat_away_substitutions` int(11) DEFAULT 0,
  `stat_home_injuries` int(11) DEFAULT 0,
  `stat_away_injuries` int(11) DEFAULT 0,
  `home_tactic` varbinary(6) DEFAULT NULL,
  `away_tactic` varbinary(6) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `ws_game_aktion`
--

CREATE TABLE `ws_game_aktion` (
  `id` int(10) NOT NULL,
  `game_id` int(10) NOT NULL,
  `season_id` smallint(3) NOT NULL,
  `minute` smallint(3) NOT NULL,
  `minuteTime` int(10) NOT NULL,
  `SimStepAktion` tinyint(2) NOT NULL,
  `club_id` int(10) NOT NULL,
  `player_id` int(10) NOT NULL,
  `player2_id` int(10) NOT NULL,
  `aktion` varchar(22) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `ws_game_lineups`
--

CREATE TABLE `ws_game_lineups` (
  `game_id` int(11) NOT NULL,
  `player_id` int(11) NOT NULL,
  `club_id` int(11) NOT NULL,
  `position_formation` enum('GK','LB','CB','RB','LM','CM','RM','RS','CS','LS','Subs') NOT NULL,
  `rating` double(4,2) NOT NULL,
  `minutes_played` tinyint(4) NOT NULL,
  `feld` enum('1','Bench','Out','RedCard','injured','YellowRedCard') NOT NULL,
  `effective_strength` double(4,1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `ws_game_text`
--

CREATE TABLE `ws_game_text` (
  `id` int(10) NOT NULL,
  `aktion` varchar(250) DEFAULT NULL,
  `message` varchar(250) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `ws_game_text`
--

INSERT INTO `ws_game_text` (`id`, `aktion`, `message`) VALUES
(1, 'Anpfiff_1HZ', 'Anpfiff zur ersten Halbzeit!'),
(2, 'Anpfiff_1HZ', 'Das Spiel beginnt.'),
(3, 'Anpfiff_1HZ', 'Der Schiedsrichter pfeift die Partie an.'),
(4, 'Anpfiff_1HZ', 'Los geht’s, die erste Halbzeit läuft!'),
(5, 'Anpfiff_1HZ', 'Der Ball rollt in der ersten Halbzeit.'),
(6, 'Anpfiff_1HZ', 'Startschuss für die erste Hälfte!'),
(7, 'Anpfiff_1HZ', 'Die Partie ist eröffnet.'),
(8, 'Anpfiff_1HZ', 'Anpfiff!'),
(9, 'Anpfiff_1HZ', 'Der Anstoß ist erfolgt.'),
(10, 'Anpfiff_1HZ', 'Die ersten 45 Minuten laufen!'),
(11, 'Abpfiff_1HZ', 'Halbzeit!'),
(12, 'Abpfiff_1HZ', 'Der Schiedsrichter beendet die erste Hälfte.'),
(13, 'Abpfiff_1HZ', 'Pause nach den ersten 45 Minuten.'),
(14, 'Abpfiff_1HZ', 'Der Pausenpfiff ertönt.'),
(15, 'Abpfiff_1HZ', 'Die erste Halbzeit ist vorbei.'),
(16, 'Abpfiff_1HZ', 'Halbzeit – Zeit zum Durchatmen.'),
(17, 'Abpfiff_1HZ', 'Der Schiedsrichter pfeift zur Pause.'),
(18, 'Abpfiff_1HZ', 'Die erste Hälfte ist gespielt.'),
(19, 'Abpfiff_1HZ', 'Pause!'),
(20, 'Abpfiff_1HZ', 'Halbzeit – beide Teams gehen in die Kabine.'),
(21, 'Anpfiff_2HZ', 'Weiter geht’s mit der zweiten Halbzeit!'),
(22, 'Anpfiff_2HZ', 'Anstoß zur zweiten Hälfte.'),
(23, 'Anpfiff_2HZ', 'Die zweite Halbzeit läuft.'),
(24, 'Anpfiff_2HZ', 'Der Ball rollt wieder.'),
(25, 'Anpfiff_2HZ', 'Der Schiedsrichter eröffnet die zweite Halbzeit.'),
(26, 'Anpfiff_2HZ', 'Start der zweiten Hälfte.'),
(27, 'Anpfiff_2HZ', 'Die Partie geht weiter.'),
(28, 'Anpfiff_2HZ', 'Die Spieler sind zurück – es geht weiter.'),
(29, 'Anpfiff_2HZ', 'Los geht’s mit Durchgang zwei.'),
(30, 'Anpfiff_2HZ', 'Die zweiten 45 Minuten laufen!'),
(31, 'Abpfiff_2HZ', 'Schluss!'),
(32, 'Abpfiff_2HZ', 'Der Schiedsrichter beendet die Partie.'),
(33, 'Abpfiff_2HZ', 'Das Spiel ist aus.'),
(34, 'Abpfiff_2HZ', 'Der Abpfiff ertönt.'),
(35, 'Abpfiff_2HZ', 'Ende der regulären Spielzeit.'),
(36, 'Abpfiff_2HZ', 'Die Begegnung ist vorbei.'),
(37, 'Abpfiff_2HZ', 'Der Schlusspfiff ist da.'),
(38, 'Abpfiff_2HZ', 'Das Spiel endet nach 90 Minuten.'),
(39, 'Abpfiff_2HZ', 'Die reguläre Spielzeit ist vorbei.'),
(40, 'Abpfiff_2HZ', 'Schluss, die Partie ist entschieden!'),
(41, 'Anpfiff_1V', 'Die Verlängerung beginnt.'),
(42, 'Anpfiff_1V', 'Es geht in die Verlängerung.'),
(43, 'Anpfiff_1V', 'Anpfiff zur ersten Hälfte der Verlängerung.'),
(44, 'Anpfiff_1V', 'Der Ball rollt wieder – Verlängerung!'),
(45, 'Anpfiff_1V', 'Start der ersten 15 Minuten Verlängerung.'),
(46, 'Anpfiff_1V', 'Die Nachspielzeit beginnt.'),
(47, 'Anpfiff_1V', 'Der Schiedsrichter pfeift die Verlängerung an.'),
(48, 'Anpfiff_1V', 'Anstoß zur Verlängerung.'),
(49, 'Anpfiff_1V', 'Los geht’s in der Verlängerung.'),
(50, 'Anpfiff_1V', 'Die Verlängerung startet.'),
(51, 'Abpfiff_1V', 'Ende der ersten Hälfte der Verlängerung.'),
(52, 'Abpfiff_1V', 'Der Schiedsrichter beendet die erste Hälfte der Verlängerung.'),
(53, 'Abpfiff_1V', '15 Minuten Verlängerung sind gespielt.'),
(54, 'Abpfiff_1V', 'Halbzeit in der Verlängerung.'),
(55, 'Abpfiff_1V', 'Die erste Hälfte der Verlängerung ist vorbei.'),
(56, 'Abpfiff_1V', 'Pause in der Verlängerung.'),
(57, 'Abpfiff_1V', 'Die erste Verlängerungshälfte ist beendet.'),
(58, 'Abpfiff_1V', 'Abpfiff nach 15 Minuten Verlängerung.'),
(59, 'Abpfiff_1V', 'Die Spieler wechseln die Seiten.'),
(60, 'Abpfiff_1V', 'Ende der ersten Verlängerungshälfte.'),
(61, 'Anpfiff_2V', 'Die zweite Hälfte der Verlängerung läuft.'),
(62, 'Anpfiff_2V', 'Anpfiff zur zweiten Verlängerungshälfte.'),
(63, 'Anpfiff_2V', 'Weiter geht’s mit den letzten 15 Minuten.'),
(64, 'Anpfiff_2V', 'Der Ball rollt wieder – zweite Hälfte Verlängerung.'),
(65, 'Anpfiff_2V', 'Start in die zweite Hälfte der Verlängerung.'),
(66, 'Anpfiff_2V', 'Der Schiedsrichter gibt die zweite Hälfte frei.'),
(67, 'Anpfiff_2V', 'Die Teams starten in die letzten Minuten.'),
(68, 'Anpfiff_2V', 'Los geht’s in den finalen Teil der Verlängerung.'),
(69, 'Anpfiff_2V', 'Die zweite Verlängerungshälfte beginnt.'),
(70, 'Anpfiff_2V', 'Der Anstoß zur zweiten Hälfte der Verlängerung ist erfolgt.'),
(71, 'Abpfiff_2V', 'Schluss! Die Verlängerung ist vorbei.'),
(72, 'Abpfiff_2V', 'Der Schiedsrichter beendet die Verlängerung.'),
(73, 'Abpfiff_2V', 'Nach 120 Minuten ist Schluss.'),
(74, 'Abpfiff_2V', 'Ende der Verlängerung.'),
(75, 'Abpfiff_2V', 'Die Verlängerung ist beendet.'),
(76, 'Abpfiff_2V', 'Der Abpfiff nach 120 Minuten ertönt.'),
(77, 'Abpfiff_2V', 'Die Nachspielzeit ist zu Ende.'),
(78, 'Abpfiff_2V', 'Die Verlängerung geht zu Ende.'),
(79, 'Abpfiff_2V', 'Abpfiff nach der Verlängerung.'),
(80, 'Abpfiff_2V', 'Das Spiel ist nach 120 Minuten vorbei.'),
(81, 'Pass_erfolg', '{sp1} spielt einen präzisen Pass im Mittelfeld.'),
(82, 'Pass_erfolg', '{sp1} verteilt den Ball sicher.'),
(83, 'Pass_erfolg', '{sp1} bringt den Ball zu einem Mitspieler.'),
(84, 'Pass_erfolg', 'Guter Pass von {sp1}.'),
(85, 'Pass_erfolg', '{sp1} hält den Ball im Spiel mit einem genauen Zuspiel.'),
(86, 'Pass_erfolg', '{sp1} sieht den Mitspieler und passt erfolgreich.'),
(87, 'Pass_erfolg', '{sp1} kombiniert mit seinen Kollegen.'),
(88, 'Pass_erfolg', '{sp1} schiebt den Ball in die Spitze.'),
(89, 'Pass_erfolg', 'Sauberes Zuspiel von {sp1}.'),
(90, 'Pass_erfolg', '{sp1} hält den Ballbesitz für {team}.'),
(91, 'Pass_daneben', '{sp1} spielt den Ball ins Aus.'),
(92, 'Pass_daneben', 'Unpräziser Pass von {sp1}.'),
(93, 'Pass_daneben', '{sp1} will den Ball nach vorne bringen, aber Fehlpass.'),
(94, 'Pass_daneben', '{sp1} mit einem riskanten Pass – misslungen.'),
(95, 'Pass_daneben', '{sp1} verzieht beim Zuspiel.'),
(96, 'Pass_daneben', '{sp1} verliert den Ball durch einen Fehlpass.'),
(97, 'Pass_daneben', '{sp1} spielt den Ball direkt zum Gegner.'),
(98, 'Pass_daneben', 'Ballverlust: {sp1} spielt ungenau.'),
(99, 'Pass_daneben', '{sp1} passt in die falsche Richtung.'),
(100, 'Pass_daneben', 'Fehlpass von {sp1}, Ballbesitz für den Gegner.'),
(101, 'Zweikampf_gewonnen', '{sp1} setzt sich stark gegen {sp2} durch.'),
(102, 'Zweikampf_gewonnen', '{sp1} erobert den Ball von {sp2}.'),
(103, 'Zweikampf_gewonnen', '{sp1} bleibt Sieger im Duell mit {sp2}.'),
(104, 'Zweikampf_gewonnen', '{sp1} nimmt {sp2} den Ball ab.'),
(105, 'Zweikampf_gewonnen', '{sp1} behauptet den Ball gegen {sp2}.'),
(106, 'Zweikampf_gewonnen', '{sp1} lässt {sp2} keine Chance.'),
(107, 'Zweikampf_gewonnen', '{sp1} gewinnt den Zweikampf gegen {sp2}.'),
(108, 'Zweikampf_gewonnen', '{sp1} blockt {sp2} geschickt ab.'),
(109, 'Zweikampf_gewonnen', '{sp1} bleibt robust und setzt sich gegen {sp2} durch.'),
(110, 'Zweikampf_gewonnen', '{sp1} schnappt sich den Ball von {sp2}.'),
(111, 'Zweikampf_verloren', '{sp1} verliert das Duell gegen {sp2}.'),
(112, 'Zweikampf_verloren', '{sp1} zieht gegen {sp2} den Kürzeren.'),
(113, 'Zweikampf_verloren', '{sp1} verliert den Ball an {sp2}.'),
(114, 'Zweikampf_verloren', '{sp1} bleibt an {sp2} hängen.'),
(115, 'Zweikampf_verloren', '{sp1} scheitert an {sp2}.'),
(116, 'Zweikampf_verloren', '{sp1} wird von {sp2} gestoppt.'),
(117, 'Zweikampf_verloren', '{sp1} setzt sich nicht durch, Ball bei {sp2}.'),
(118, 'Zweikampf_verloren', '{sp1} bleibt im Zweikampf zweiter Sieger.'),
(119, 'Zweikampf_verloren', '{sp1} kommt gegen {sp2} nicht vorbei.'),
(120, 'Zweikampf_verloren', '{sp1} verliert im Dribbling an {sp2}.'),
(121, 'shot_on_goal', '{sp1} schießt – {sp2} pariert stark!'),
(122, 'shot_on_goal', '{sp1} zieht ab, doch {sp2} ist zur Stelle.'),
(123, 'shot_on_goal', '{sp1} versucht es – gehalten von {sp2}.'),
(124, 'shot_on_goal', '{sp1} kommt zum Schuss, aber {sp2} klärt.'),
(125, 'shot_on_goal', '{sp1} prüft {sp2} mit einem Schuss.'),
(126, 'shot_on_goal', '{sp1} zieht ab – {sp2} ist auf dem Posten.'),
(127, 'shot_on_goal', '{sp1} schießt, aber {sp2} verhindert den Treffer.'),
(128, 'shot_on_goal', '{sp1} zwingt {sp2} zu einer Parade.'),
(129, 'shot_on_goal', '{sp1} schießt gefährlich, doch {sp2} hält den Ball.'),
(130, 'shot_on_goal', '{sp1} zieht ab, {sp2} pariert sicher.'),
(131, 'shot_on_goal_miss', '{sp1} schießt – vorbei am Tor von {sp2}.'),
(132, 'shot_on_goal_miss', '{sp1} versucht es, aber am Kasten von {sp2} vorbei.'),
(133, 'shot_on_goal_miss', '{sp1} haut den Ball am Tor von {sp2} vorbei.'),
(134, 'shot_on_goal_miss', '{sp1} mit dem Abschluss – neben das Tor von {sp2}.'),
(135, 'shot_on_goal_miss', '{sp1} schießt, der Ball geht rechts am Tor von {sp2} vorbei.'),
(136, 'shot_on_goal_miss', '{sp1} zieht ab – deutlich am Gehäuse von {sp2} vorbei.'),
(137, 'shot_on_goal_miss', '{sp1} köpft – vorbei am Tor von {sp2}.'),
(138, 'shot_on_goal_miss', '{sp1} probiert es, aber der Ball geht am Tor von {sp2} vorbei.'),
(139, 'shot_on_goal_miss', '{sp1} verzieht, das Tor von {sp2} bleibt unberührt.'),
(140, 'shot_on_goal_miss', '{sp1} mit dem Schuss – links vorbei am Tor von {sp2}.'),
(141, 'GOAL', '<b>TOOOR für {team}! {sp1} bezwingt {sp2}!</b>'),
(142, 'GOAL', '<b>{sp1} trifft ins Netz – {sp2} ohne Chance!</b>'),
(143, 'GOAL', '<b>Tor für {team}! {sp1} überwindet {sp2}!</b>'),
(144, 'GOAL', '<b>{sp1} haut den Ball ins Tor – {sp2} geschlagen!</b>'),
(145, 'GOAL', '<b>{sp1} netzt ein! {sp2} kann nichts machen!</b>'),
(146, 'GOAL', '<b>{sp1} vollendet, {sp2} ist chancenlos!</b>'),
(147, 'GOAL', '<b>Treffer für {team}! {sp1} überlistet {sp2}!</b>'),
(148, 'GOAL', '<b>{sp1} schießt – und der Ball ist drin! {sp2} geschlagen!</b>'),
(149, 'GOAL', '<b>{sp1} erzielt das Tor für {team}, {sp2} ist geschlagen!</b>'),
(150, 'GOAL', '<b>{sp1} trifft – Jubel bei {team}!</b>'),
(151, 'Substitution', '<i>{sp1} kommt für {sp2} ins Spiel.</i>'),
(152, 'Substitution', '<i>Spielwechsel bei {team}: {sp1} ersetzt {sp2}.</i>'),
(153, 'Substitution', '<i>{team} bringt {sp1} – {sp2} verlässt das Feld.</i>'),
(154, 'Substitution', '<i>Neuer Mann auf dem Platz: {sp1} kommt für {sp2}.</i>'),
(155, 'Substitution', '<i>{sp1} betritt den Rasen, {sp2} geht raus.</i>'),
(156, 'Substitution', '<i>{sp1} ersetzt {sp2} bei {team}.</i>'),
(157, 'Substitution', '<i>Spielerwechsel: {sp1} rein, {sp2} raus.</i>'),
(158, 'Substitution', '<i>{team} tauscht: {sp1} kommt ins Spiel für {sp2}.</i>'),
(159, 'Substitution', '<i>Frische Kräfte bei {team}: {sp1} für {sp2}.</i>'),
(160, 'Substitution', '<i>{sp1} kommt ins Spiel, {sp2} hat Feierabend.</i>'),
(161, 'card_yellow', '<i>{sp1} sieht die Gelbe Karte.</i>'),
(162, 'card_yellow', '<i>Gelb für {sp1} nach einem Foul.</i>'),
(163, 'card_yellow', '<i>Der Schiedsrichter verwarnt {sp1}.</i>'),
(164, 'card_yellow', '<i>{sp1} wird mit Gelb bestraft.</i>'),
(165, 'card_yellow', '<i>Unfair von {sp1} – dafür gibt’s Gelb.</i>'),
(166, 'card_yellow', '<i>{sp1} foult und sieht Gelb.</i>'),
(167, 'card_yellow', '<i>{sp1} kassiert die Gelbe Karte.</i>'),
(168, 'card_yellow', '<i>Der Schiedsrichter zückt Gelb für {sp1}.</i>'),
(169, 'card_yellow', '<i>{sp1} wird verwarnt.</i>'),
(170, 'card_yellow', '<i>Gelb für {sp1} – harte Entscheidung!</i>'),
(171, 'card_red', '<i>{sp1} sieht Rot – Platzverweis!</i>'),
(172, 'card_red', '<i>Der Schiedsrichter schickt {sp1} mit Rot vom Feld.</i>'),
(173, 'card_red', '<i>Nach hartem Foul: RedCard für {sp1}.</i>'),
(174, 'card_red', '<i>{sp1} muss mit Rot vom Platz.</i>'),
(175, 'card_red', '<i>Glatt Rot für {sp1}!</i>'),
(176, 'card_red', '<i>{sp1} wird nach einem üblen Foul vom Platz gestellt.</i>'),
(177, 'card_red', '<i>{sp1} kassiert die RedCard.</i>'),
(178, 'card_red', '<i>{sp1} wird vom Schiedsrichter mit Rot bestraft.</i>'),
(179, 'card_red', '<i>{sp1} verlässt das Feld mit Rot.</i>'),
(180, 'card_red', '<i>Der Schiedsrichter zeigt {sp1} die RedCard.</i>'),
(181, 'card_yellow_red', '<i>{sp1} sieht Gelb-Rot – er muss vom Platz.</i>'),
(182, 'card_yellow_red', '<i>Zweite Verwarnung für {sp1} – Gelb-Rot!</i>'),
(183, 'card_yellow_red', '<i>{sp1} fliegt mit Gelb-Rot vom Platz.</i>'),
(184, 'card_yellow_red', '<i>Gelb-Rot für {sp1}, Spiel vorbei für ihn.</i>'),
(185, 'card_yellow_red', '<i>Nach der zweiten Gelben ist Schluss für {sp1}.</i>'),
(186, 'card_yellow_red', '<i>{sp1} sieht die YellowRedCard.</i>'),
(187, 'card_yellow_red', '<i>Doppelbestrafung: Gelb-Rot für {sp1}.</i>'),
(188, 'card_yellow_red', '<i>{sp1} muss nach Gelb-Rot runter.</i>'),
(189, 'card_yellow_red', '<i>{sp1} kassiert die YellowRedCard.</i>'),
(190, 'card_yellow_red', '<i>Der Schiedsrichter zeigt {sp1} Gelb-Rot.</i>'),
(191, 'Injury', '<i>{sp1} bleibt nach einem Zweikampf liegen.</i>'),
(192, 'Injury', '<i>{sp1} muss behandelt werden.</i>'),
(193, 'Injury', '<i>{sp1} hat sich injured und humpelt.</i>'),
(194, 'Injury', '<i>{sp1} muss das Feld wegen Injury verlassen.</i>'),
(195, 'Injury', '<i>{sp1} scheint sich am Bein injured zu haben.</i>'),
(196, 'Injury', '<i>{sp1} liegt am Boden und braucht Hilfe.</i>'),
(197, 'Injury', '<i>{sp1} kann nicht weitermachen.</i>'),
(198, 'Injury', '<i>{sp1} verlässt das Spielfeld injured.</i>'),
(199, 'Injury', '<i>{sp1} ist angeschlagen, das Spiel ist vorbei für ihn.</i>'),
(200, 'Injury', '<i>{sp1} wird injured vom Platz geführt.</i>');

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

--
-- Tabellenstruktur für Tabelle `ws_intcups_starter`
--

CREATE TABLE `ws_intcups_starter` (
  `id` int(10) NOT NULL,
  `starter_rank` tinyint(3) NOT NULL,
  `intcup1_fix` tinyint(2) DEFAULT 0,
  `intcup1_q1` tinyint(2) DEFAULT 0,
  `intcup1_q2` tinyint(2) DEFAULT 0,
  `intcup1_q3` tinyint(2) DEFAULT 0,
  `intcup2_fix` tinyint(2) DEFAULT 0,
  `intcup2_q1` tinyint(2) DEFAULT 0,
  `intcup2_q2` tinyint(2) DEFAULT 0,
  `intcup2_q3` tinyint(2) DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `ws_intcups_starter`
--

INSERT INTO `ws_intcups_starter` (`id`, `starter_rank`, `intcup1_fix`, `intcup1_q1`, `intcup1_q2`, `intcup1_q3`, `intcup2_fix`, `intcup2_q1`, `intcup2_q2`, `intcup2_q3`) VALUES
(1, 1, 3, 1, 1, 2, 1, 0, 0, 0),
(2, 2, 3, 0, 1, 2, 1, 0, 1, 0),
(3, 3, 2, 0, 1, 2, 1, 0, 1, 0),
(4, 4, 2, 1, 1, 2, 1, 0, 1, 0),
(5, 5, 2, 1, 1, 1, 1, 1, 1, 0),
(6, 6, 2, 1, 1, 1, 1, 1, 0, 0),
(7, 7, 2, 0, 1, 1, 0, 2, 0, 1),
(8, 8, 1, 0, 1, 1, 0, 2, 0, 1),
(9, 9, 1, 1, 1, 1, 0, 1, 1, 1),
(10, 10, 1, 1, 1, 1, 0, 1, 1, 1),
(11, 11, 0, 1, 1, 1, 0, 1, 1, 0),
(12, 12, 0, 1, 1, 1, 0, 2, 1, 0),
(13, 13, 0, 1, 1, 0, 0, 2, 1, 0),
(14, 14, 0, 1, 1, 0, 0, 2, 0, 0),
(15, 15, 0, 1, 0, 0, 0, 2, 0, 0),
(16, 16, 0, 1, 0, 0, 0, 1, 0, 0);

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

--
-- Tabellenstruktur für Tabelle `ws_league`
--

CREATE TABLE `ws_league` (
  `id` smallint(5) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `country_id` int(5) NOT NULL,
  `league_level` tinyint(2) NOT NULL,
  `percent_north` tinyint(3) NOT NULL,
  `percent_east` tinyint(3) NOT NULL,
  `percent_south` tinyint(3) NOT NULL,
  `percent_west` tinyint(3) NOT NULL,
  `price_north` tinyint(3) NOT NULL,
  `price_east` tinyint(3) NOT NULL,
  `price_south` tinyint(3) NOT NULL,
  `price_west` tinyint(3) NOT NULL,
  `active` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `ws_league`
--

INSERT INTO `ws_league` (`id`, `name`, `country_id`, `league_level`, `percent_north`, `percent_east`, `percent_south`, `percent_west`, `price_north`, `price_east`, `price_south`, `price_west`, `active`) VALUES
(1, 'Kingstale Liga 1', 1001, 1, 91, 91, 91, 91, 56, 56, 56, 56, 1),
(2, 'Kingstale Liga 2', 1001, 2, 89, 89, 89, 89, 53, 53, 53, 53, 1),
(3, 'Kingstale Liga 3', 1001, 3, 87, 87, 87, 87, 51, 51, 51, 51, 1),
(4, 'Kingstale Liga 4', 1001, 4, 85, 85, 85, 85, 48, 48, 48, 48, 1),
(5, 'Kingstale Liga 5', 1001, 5, 83, 83, 83, 83, 46, 46, 46, 46, 1),
(6, 'Kingstale Liga 6', 1001, 6, 81, 81, 81, 81, 43, 43, 43, 43, 1),
(7, 'Kingstale Liga 7', 1001, 7, 79, 79, 79, 79, 41, 41, 41, 41, 1),
(8, 'Kingstale Liga 8', 1001, 8, 77, 77, 77, 77, 38, 38, 38, 38, 1),
(9, 'Norrvik Liga 1', 1002, 1, 88, 88, 88, 88, 54, 54, 54, 54, 1),
(10, 'Norrvik Liga 2', 1002, 2, 86, 86, 86, 86, 51, 51, 51, 51, 1),
(11, 'Norrvik Liga 3', 1002, 3, 84, 84, 84, 84, 49, 49, 49, 49, 1),
(12, 'Norrvik Liga 4', 1002, 4, 82, 82, 82, 82, 46, 46, 46, 46, 1),
(13, 'Norrvik Liga 5', 1002, 5, 80, 80, 80, 80, 44, 44, 44, 44, 1),
(14, 'Norrvik Liga 6', 1002, 6, 78, 78, 78, 78, 41, 41, 41, 41, 1),
(15, 'Norrvik Liga 7', 1002, 7, 76, 76, 76, 76, 39, 39, 39, 39, 1),
(16, 'Norrvik Liga 8', 1002, 8, 74, 74, 74, 74, 36, 36, 36, 36, 1),
(17, 'Flatland Liga 1', 1003, 1, 85, 85, 85, 85, 52, 52, 52, 52, 1),
(18, 'Flatland Liga 2', 1003, 2, 83, 83, 83, 83, 49, 49, 49, 49, 1),
(19, 'Flatland Liga 3', 1003, 3, 81, 81, 81, 81, 47, 47, 47, 47, 1),
(20, 'Flatland Liga 4', 1003, 4, 79, 79, 79, 79, 44, 44, 44, 44, 1),
(21, 'Flatland Liga 5', 1003, 5, 77, 77, 77, 77, 42, 42, 42, 42, 1),
(22, 'Flatland Liga 6', 1003, 6, 75, 75, 75, 75, 39, 39, 39, 39, 1),
(23, 'Flatland Liga 7', 1003, 7, 73, 73, 73, 73, 37, 37, 37, 37, 1),
(24, 'Flatland Liga 8', 1003, 8, 71, 71, 71, 71, 34, 34, 34, 34, 1),
(25, 'Kaisergard Liga 1', 1004, 1, 82, 82, 82, 82, 50, 50, 50, 50, 1),
(26, 'Kaisergard Liga 2', 1004, 2, 80, 80, 80, 80, 47, 47, 47, 47, 1),
(27, 'Kaisergard Liga 3', 1004, 3, 78, 78, 78, 78, 45, 45, 45, 45, 1),
(28, 'Kaisergard Liga 4', 1004, 4, 76, 76, 76, 76, 42, 42, 42, 42, 1),
(29, 'Kaisergard Liga 5', 1004, 5, 74, 74, 74, 74, 40, 40, 40, 40, 1),
(30, 'Kaisergard Liga 6', 1004, 6, 72, 72, 72, 72, 37, 37, 37, 37, 1),
(31, 'Kaisergard Liga 7', 1004, 7, 70, 70, 70, 70, 35, 35, 35, 35, 1),
(32, 'Kaisergard Liga 8', 1004, 8, 68, 68, 68, 68, 32, 32, 32, 32, 1),
(33, 'Belvoire Liga 1', 1005, 1, 79, 79, 79, 79, 48, 48, 48, 48, 1),
(34, 'Belvoire Liga 2', 1005, 2, 77, 77, 77, 77, 45, 45, 45, 45, 1),
(35, 'Belvoire Liga 3', 1005, 3, 75, 75, 75, 75, 43, 43, 43, 43, 1),
(36, 'Belvoire Liga 4', 1005, 4, 73, 73, 73, 73, 40, 40, 40, 40, 1),
(37, 'Belvoire Liga 5', 1005, 5, 71, 71, 71, 71, 38, 38, 38, 38, 1),
(38, 'Belvoire Liga 6', 1005, 6, 69, 69, 69, 69, 35, 35, 35, 35, 1),
(39, 'Belvoire Liga 7', 1005, 7, 67, 67, 67, 67, 33, 33, 33, 33, 1),
(40, 'Belvoire Liga 8', 1005, 8, 65, 65, 65, 65, 30, 30, 30, 30, 1),
(41, 'Meditara Liga 1', 1006, 1, 76, 76, 76, 76, 46, 46, 46, 46, 1),
(42, 'Meditara Liga 2', 1006, 2, 74, 74, 74, 74, 43, 43, 43, 43, 1),
(43, 'Meditara Liga 3', 1006, 3, 72, 72, 72, 72, 41, 41, 41, 41, 1),
(44, 'Meditara Liga 4', 1006, 4, 70, 70, 70, 70, 38, 38, 38, 38, 1),
(45, 'Meditara Liga 5', 1006, 5, 68, 68, 68, 68, 36, 36, 36, 36, 1),
(46, 'Meditara Liga 6', 1006, 6, 66, 66, 66, 66, 33, 33, 33, 33, 1),
(47, 'Meditara Liga 7', 1006, 7, 64, 64, 64, 64, 31, 31, 31, 31, 1),
(48, 'Meditara Liga 8', 1006, 8, 62, 62, 62, 62, 28, 28, 28, 28, 1),
(49, 'Extavora Liga 1', 1007, 1, 73, 73, 73, 73, 44, 44, 44, 44, 1),
(50, 'Extavora Liga 2', 1007, 2, 71, 71, 71, 71, 41, 41, 41, 41, 1),
(51, 'Extavora Liga 3', 1007, 3, 69, 69, 69, 69, 39, 39, 39, 39, 1),
(52, 'Extavora Liga 4', 1007, 4, 67, 67, 67, 67, 36, 36, 36, 36, 1),
(53, 'Extavora Liga 5', 1007, 5, 65, 65, 65, 65, 34, 34, 34, 34, 1),
(54, 'Extavora Liga 6', 1007, 6, 63, 63, 63, 63, 31, 31, 31, 31, 1),
(55, 'Extavora Liga 7', 1007, 7, 61, 61, 61, 61, 29, 29, 29, 29, 1),
(56, 'Extavora Liga 8', 1007, 8, 59, 59, 59, 59, 26, 26, 26, 26, 1),
(57, 'Stonevale Liga 1', 1008, 1, 70, 70, 70, 70, 42, 42, 42, 42, 1),
(58, 'Stonevale Liga 2', 1008, 2, 68, 68, 68, 68, 39, 39, 39, 39, 1),
(59, 'Stonevale Liga 3', 1008, 3, 66, 66, 66, 66, 37, 37, 37, 37, 1),
(60, 'Stonevale Liga 4', 1008, 4, 64, 64, 64, 64, 34, 34, 34, 34, 1),
(61, 'Stonevale Liga 5', 1008, 5, 62, 62, 62, 62, 32, 32, 32, 32, 1),
(62, 'Stonevale Liga 6', 1008, 6, 60, 60, 60, 60, 29, 29, 29, 29, 1),
(63, 'Stonevale Liga 7', 1008, 7, 58, 58, 58, 58, 27, 27, 27, 27, 1),
(64, 'Stonevale Liga 8', 1008, 8, 56, 56, 56, 56, 24, 24, 24, 24, 1),
(65, 'Slavora Liga 1', 1009, 1, 67, 67, 67, 67, 40, 40, 40, 40, 1),
(66, 'Slavora Liga 2', 1009, 2, 65, 65, 65, 65, 37, 37, 37, 37, 1),
(67, 'Slavora Liga 3', 1009, 3, 63, 63, 63, 63, 35, 35, 35, 35, 1),
(68, 'Slavora Liga 4', 1009, 4, 61, 61, 61, 61, 32, 32, 32, 32, 1),
(69, 'Slavora Liga 5', 1009, 5, 59, 59, 59, 59, 30, 30, 30, 30, 1),
(70, 'Slavora Liga 6', 1009, 6, 57, 57, 57, 57, 27, 27, 27, 27, 1),
(71, 'Slavora Liga 7', 1009, 7, 55, 55, 55, 55, 25, 25, 25, 25, 1),
(72, 'Slavora Liga 8', 1009, 8, 53, 53, 53, 53, 22, 22, 22, 22, 1),
(73, 'Patagonia Liga 1', 1010, 1, 64, 64, 64, 64, 38, 38, 38, 38, 1),
(74, 'Patagonia Liga 2', 1010, 2, 62, 62, 62, 62, 35, 35, 35, 35, 1),
(75, 'Patagonia Liga 3', 1010, 3, 60, 60, 60, 60, 33, 33, 33, 33, 1),
(76, 'Patagonia Liga 4', 1010, 4, 58, 58, 58, 58, 30, 30, 30, 30, 1),
(77, 'Patagonia Liga 5', 1010, 5, 56, 56, 56, 56, 28, 28, 28, 28, 1),
(78, 'Patagonia Liga 6', 1010, 6, 54, 54, 54, 54, 25, 25, 25, 25, 1),
(79, 'Patagonia Liga 7', 1010, 7, 52, 52, 52, 52, 23, 23, 23, 23, 1),
(80, 'Patagonia Liga 8', 1010, 8, 50, 50, 50, 50, 20, 20, 20, 20, 1),
(81, 'Liberty Union Liga 1', 1011, 1, 61, 61, 61, 61, 36, 36, 36, 36, 1),
(82, 'Liberty Union Liga 2', 1011, 2, 59, 59, 59, 59, 33, 33, 33, 33, 1),
(83, 'Liberty Union Liga 3', 1011, 3, 57, 57, 57, 57, 31, 31, 31, 31, 1),
(84, 'Liberty Union Liga 4', 1011, 4, 55, 55, 55, 55, 28, 28, 28, 28, 1),
(85, 'Liberty Union Liga 5', 1011, 5, 53, 53, 53, 53, 26, 26, 26, 26, 1),
(86, 'Liberty Union Liga 6', 1011, 6, 51, 51, 51, 51, 23, 23, 23, 23, 1),
(87, 'Liberty Union Liga 7', 1011, 7, 49, 49, 49, 49, 21, 21, 21, 21, 1),
(88, 'Liberty Union Liga 8', 1011, 8, 47, 47, 47, 47, 18, 18, 18, 18, 1),
(89, 'Sunreach Liga 1', 1012, 1, 58, 58, 58, 58, 34, 34, 34, 34, 1),
(90, 'Sunreach Liga 2', 1012, 2, 56, 56, 56, 56, 31, 31, 31, 31, 1),
(91, 'Sunreach Liga 3', 1012, 3, 54, 54, 54, 54, 29, 29, 29, 29, 1),
(92, 'Sunreach Liga 4', 1012, 4, 52, 52, 52, 52, 26, 26, 26, 26, 1),
(93, 'Sunreach Liga 5', 1012, 5, 50, 50, 50, 50, 24, 24, 24, 24, 1),
(94, 'Sunreach Liga 6', 1012, 6, 48, 48, 48, 48, 21, 21, 21, 21, 1),
(95, 'Sunreach Liga 7', 1012, 7, 46, 46, 46, 46, 19, 19, 19, 19, 1),
(96, 'Sunreach Liga 8', 1012, 8, 44, 44, 44, 44, 16, 16, 16, 16, 1),
(97, 'Ubunda Liga 1', 1013, 1, 55, 55, 55, 55, 32, 32, 32, 32, 1),
(98, 'Ubunda Liga 2', 1013, 2, 53, 53, 53, 53, 29, 29, 29, 29, 1),
(99, 'Ubunda Liga 3', 1013, 3, 51, 51, 51, 51, 27, 27, 27, 27, 1),
(100, 'Ubunda Liga 4', 1013, 4, 49, 49, 49, 49, 24, 24, 24, 24, 1),
(101, 'Ubunda Liga 5', 1013, 5, 47, 47, 47, 47, 22, 22, 22, 22, 1),
(102, 'Ubunda Liga 6', 1013, 6, 45, 45, 45, 45, 19, 19, 19, 19, 1),
(103, 'Ubunda Liga 7', 1013, 7, 43, 43, 43, 43, 17, 17, 17, 17, 1),
(104, 'Ubunda Liga 8', 1013, 8, 41, 41, 41, 41, 14, 14, 14, 14, 1),
(105, 'Kharifal Liga 1', 1014, 1, 52, 52, 52, 52, 30, 30, 30, 30, 1),
(106, 'Kharifal Liga 2', 1014, 2, 50, 50, 50, 50, 27, 27, 27, 27, 1),
(107, 'Kharifal Liga 3', 1014, 3, 48, 48, 48, 48, 25, 25, 25, 25, 1),
(108, 'Kharifal Liga 4', 1014, 4, 46, 46, 46, 46, 22, 22, 22, 22, 1),
(109, 'Kharifal Liga 5', 1014, 5, 44, 44, 44, 44, 20, 20, 20, 20, 1),
(110, 'Kharifal Liga 6', 1014, 6, 42, 42, 42, 42, 17, 17, 17, 17, 1),
(111, 'Kharifal Liga 7', 1014, 7, 40, 40, 40, 40, 15, 15, 15, 15, 1),
(112, 'Kharifal Liga 8', 1014, 8, 38, 38, 38, 38, 12, 12, 12, 12, 1),
(113, 'Ruskara Liga 1', 1015, 1, 49, 49, 49, 49, 28, 28, 28, 28, 1),
(114, 'Ruskara Liga 2', 1015, 2, 47, 47, 47, 47, 25, 25, 25, 25, 1),
(115, 'Ruskara Liga 3', 1015, 3, 45, 45, 45, 45, 23, 23, 23, 23, 1),
(116, 'Ruskara Liga 4', 1015, 4, 43, 43, 43, 43, 20, 20, 20, 20, 1),
(117, 'Ruskara Liga 5', 1015, 5, 41, 41, 41, 41, 18, 18, 18, 18, 1),
(118, 'Ruskara Liga 6', 1015, 6, 39, 39, 39, 39, 15, 15, 15, 15, 1),
(119, 'Ruskara Liga 7', 1015, 7, 37, 37, 37, 37, 13, 13, 13, 13, 1),
(120, 'Ruskara Liga 8', 1015, 8, 35, 35, 35, 35, 10, 10, 10, 10, 1),
(121, 'Orientra Liga 1', 1016, 1, 46, 46, 46, 46, 26, 26, 26, 26, 1),
(122, 'Orientra Liga 2', 1016, 2, 44, 44, 44, 44, 23, 23, 23, 23, 1),
(123, 'Orientra Liga 3', 1016, 3, 42, 42, 42, 42, 21, 21, 21, 21, 1),
(124, 'Orientra Liga 4', 1016, 4, 40, 40, 40, 40, 18, 18, 18, 18, 1),
(125, 'Orientra Liga 5', 1016, 5, 38, 38, 38, 38, 16, 16, 16, 16, 1),
(126, 'Orientra Liga 6', 1016, 6, 36, 36, 36, 36, 13, 13, 13, 13, 1),
(127, 'Orientra Liga 7', 1016, 7, 34, 34, 34, 34, 11, 11, 11, 11, 1),
(128, 'Orientra Liga 8', 1016, 8, 32, 32, 32, 32, 8, 8, 8, 8, 1);

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

--
-- Tabellenstruktur für Tabelle `ws_league_intcups`
--

CREATE TABLE `ws_league_intcups` (
  `id` smallint(5) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `short` varchar(10) NOT NULL,
  `number` tinyint(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `ws_league_intcups`
--

INSERT INTO `ws_league_intcups` (`id`, `name`, `short`, `number`) VALUES
(1, 'Champions League Gruppe A', 'G_INTCUP1', 1),
(2, 'Champions League Gruppe B', 'G_INTCUP1', 2),
(3, 'Champions League Gruppe C', 'G_INTCUP1', 3),
(4, 'Champions League Gruppe D', 'G_INTCUP1', 4),
(5, 'Champions League Gruppe E', 'G_INTCUP1', 5),
(6, 'Champions League Gruppe F', 'G_INTCUP1', 6),
(7, 'Champions League Gruppe G', 'G_INTCUP1', 7),
(8, 'Champions League Gruppe H', 'G_INTCUP1', 8),
(9, 'Europa League Gruppe A', 'G_INTCUP2', 9),
(10, 'Europa League Gruppe B', 'G_INTCUP2', 10),
(11, 'Europa League Gruppe C', 'G_INTCUP2', 11),
(12, 'Europa League Gruppe D', 'G_INTCUP2', 12),
(13, 'Europa League Gruppe E', 'G_INTCUP2', 13),
(14, 'Europa League Gruppe F', 'G_INTCUP2', 14),
(15, 'Europa League Gruppe G', 'G_INTCUP2', 15),
(16, 'Europa League Gruppe H', 'G_INTCUP2', 16);

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

--
-- Tabellenstruktur für Tabelle `ws_livegame_aktion`
--

CREATE TABLE `ws_livegame_aktion` (
  `id` int(10) NOT NULL,
  `game_id` int(10) NOT NULL,
  `season_id` smallint(3) NOT NULL,
  `minute` smallint(3) NOT NULL,
  `minuteTime` int(10) NOT NULL,
  `SimStepAktion` tinyint(2) NOT NULL,
  `club_id` int(10) NOT NULL,
  `player_id` int(10) NOT NULL,
  `player2_id` int(10) NOT NULL,
  `aktion` varchar(22) NOT NULL,
  `text` tinyint(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `ws_livegame_player`
--

CREATE TABLE `ws_livegame_player` (
  `id` int(10) NOT NULL,
  `game_id` int(10) NOT NULL,
  `player_id` int(10) NOT NULL,
  `club_id` int(10) NOT NULL,
  `position_formation` enum('GK','LB','CB','RB','LM','CM','RM','RS','CS','LS','Subs') NOT NULL DEFAULT 'Subs',
  `position_main` enum('GK','LB','CB','RB','LM','CM','RM','RS','CS','LS') NOT NULL DEFAULT 'CM',
  `posx` double(5,2) NOT NULL,
  `posy` double(5,2) NOT NULL,
  `rating` double(4,2) NOT NULL,
  `rating_avg` double(4,2) NOT NULL,
  `minutes_played` tinyint(2) NOT NULL,
  `card_yellow` tinyint(1) NOT NULL,
  `card_red` tinyint(1) NOT NULL,
  `injured` tinyint(2) NOT NULL,
  `suspended` tinyint(2) NOT NULL,
  `goals` tinyint(2) NOT NULL,
  `feld` enum('1','Bench','Out','RedCard','injured','YellowRedCard') NOT NULL DEFAULT '1',
  `effective_strength` double(4,1) NOT NULL,
  `att_overall` tinyint(3) UNSIGNED DEFAULT 0,
  `att_fitness` tinyint(3) UNSIGNED DEFAULT 100,
  `att_satisfaction` tinyint(3) UNSIGNED DEFAULT 100,
  `att_technique` tinyint(3) UNSIGNED DEFAULT 50,
  `att_speed` tinyint(3) UNSIGNED DEFAULT 50,
  `att_passing` tinyint(3) UNSIGNED DEFAULT 50,
  `att_vision` tinyint(3) UNSIGNED DEFAULT 50,
  `att_finishing` tinyint(3) UNSIGNED DEFAULT 50,
  `att_defending` tinyint(3) UNSIGNED DEFAULT 50,
  `att_duel` tinyint(3) UNSIGNED DEFAULT 50
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `ws_livegame_tactic`
--

CREATE TABLE `ws_livegame_tactic` (
  `id` int(11) NOT NULL,
  `game_id` int(11) NOT NULL,
  `club_id` int(11) NOT NULL,
  `tac_attacking` tinyint(3) UNSIGNED NOT NULL DEFAULT 50,
  `tac_defending` tinyint(3) UNSIGNED NOT NULL DEFAULT 50,
  `tac_passing` tinyint(3) UNSIGNED NOT NULL DEFAULT 50,
  `tac_width` tinyint(3) UNSIGNED NOT NULL DEFAULT 50,
  `tac_tempo` tinyint(3) UNSIGNED NOT NULL DEFAULT 50,
  `tac_physical` tinyint(3) UNSIGNED NOT NULL DEFAULT 50
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `ws_livegame_temp`
--

CREATE TABLE `ws_livegame_temp` (
  `id` int(10) NOT NULL,
  `game_id` int(10) NOT NULL,
  `game_type` varchar(20) NOT NULL,
  `penalty` enum('1','0') NOT NULL DEFAULT '0',
  `game_round` varchar(30) DEFAULT NULL,
  `league_id` smallint(5) NOT NULL,
  `league_id_intcups` tinyint(3) NOT NULL,
  `season_id` smallint(3) NOT NULL,
  `gameday` tinyint(2) NOT NULL,
  `gameday_intcups` tinyint(2) NOT NULL,
  `date_time` int(10) NOT NULL,
  `stadium_id` smallint(5) NOT NULL,
  `home_club` int(10) NOT NULL,
  `away_club` int(10) NOT NULL,
  `duration` tinyint(2) NOT NULL,
  `attendance` int(10) NOT NULL,
  `simulated` tinyint(1) NOT NULL,
  `home_substitution` tinyint(2) NOT NULL,
  `away_substitution` tinyint(2) NOT NULL,
  `home_goals` tinyint(2) NOT NULL,
  `away_goals` tinyint(2) NOT NULL,
  `home_goals_ht` tinyint(2) NOT NULL,
  `away_goals_ht` tinyint(2) NOT NULL,
  `home_goals_90` tinyint(2) NOT NULL,
  `away_goals_90` tinyint(2) NOT NULL,
  `home_goals_penalty` tinyint(2) NOT NULL,
  `away_goals_penalty` tinyint(2) NOT NULL,
  `home_intervall` tinyint(4) NOT NULL,
  `away_intervall` tinyint(4) NOT NULL,
  `home_nextAction` tinyint(2) NOT NULL,
  `away_nextAction` tinyint(2) NOT NULL,
  `home_gk_strength` tinyint(3) NOT NULL DEFAULT 0,
  `away_gk_strength` tinyint(3) NOT NULL DEFAULT 0,
  `home_defense_strength` tinyint(3) NOT NULL DEFAULT 0,
  `away_defense_strength` tinyint(3) NOT NULL DEFAULT 0,
  `home_midfield_strength` tinyint(3) NOT NULL DEFAULT 0,
  `away_midfield_strength` tinyint(3) NOT NULL DEFAULT 0,
  `home_striker_strength` tinyint(3) NOT NULL DEFAULT 0,
  `away_striker_strength` tinyint(3) NOT NULL DEFAULT 0,
  `home_count_defense` tinyint(1) NOT NULL DEFAULT 0,
  `away_count_defense` tinyint(1) NOT NULL DEFAULT 0,
  `home_count_midfield` tinyint(1) NOT NULL DEFAULT 0,
  `away_count_midfield` tinyint(1) NOT NULL DEFAULT 0,
  `home_count_striker` tinyint(1) NOT NULL DEFAULT 0,
  `away_count_striker` tinyint(1) NOT NULL DEFAULT 0,
  `SimulationStep` tinyint(3) NOT NULL,
  `MinuteNow` tinyint(4) NOT NULL,
  `GameStatus` varchar(10) DEFAULT NULL,
  `GameStatusLast` varchar(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `ws_player`
--

CREATE TABLE `ws_player` (
  `id` int(10) NOT NULL,
  `firstname` varchar(30) DEFAULT NULL,
  `lastname` varchar(30) DEFAULT NULL,
  `age` tinyint(2) NOT NULL,
  `picture` smallint(2) DEFAULT NULL,
  `club_id` int(10) NOT NULL,
  `position_main` enum('GK','LB','CB','RB','LM','CM','RM','RS','CS','LS') NOT NULL DEFAULT 'CM',
  `country_id` int(8) DEFAULT NULL,
  `injured` tinyint(3) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `talent` tinyint(1) NOT NULL DEFAULT 1,
  `development` float NOT NULL,
  `rating_last` float NOT NULL,
  `rating_avg` float NOT NULL,
  `contract_salary` int(10) NOT NULL,
  `contract_games` smallint(5) NOT NULL,
  `market_value` int(10) DEFAULT NULL,
  `league_games` smallint(3) NOT NULL,
  `league_goals` smallint(3) NOT NULL,
  `liga_suspended` tinyint(3) NOT NULL,
  `league_card_yellow` tinyint(2) NOT NULL,
  `league_card_yellowred` tinyint(2) NOT NULL,
  `league_card_red` tinyint(2) NOT NULL,
  `cup_games` smallint(3) NOT NULL,
  `cup_goals` smallint(3) NOT NULL,
  `cup_suspended` tinyint(2) NOT NULL,
  `cup_card_yellow` tinyint(2) NOT NULL,
  `cup_card_yellowred` tinyint(2) NOT NULL,
  `cup_card_red` tinyint(2) NOT NULL,
  `intcups_spiele` smallint(3) NOT NULL,
  `intcups_goals` smallint(3) NOT NULL,
  `intcups_suspended` tinyint(2) NOT NULL,
  `intcups_card_yellow` tinyint(2) NOT NULL,
  `intcups_card_yellowred` tinyint(2) NOT NULL,
  `intcups_card_red` tinyint(2) NOT NULL,
  `att_overall` tinyint(3) DEFAULT 5,
  `att_fitness` tinyint(3) DEFAULT 100,
  `att_freshness` tinyint(3) DEFAULT 100,
  `att_satisfaction` tinyint(3) DEFAULT 100,
  `att_technique` tinyint(3) DEFAULT 50,
  `att_speed` tinyint(3) DEFAULT 50,
  `att_passing` tinyint(3) DEFAULT 50,
  `att_vision` tinyint(3) DEFAULT 50,
  `att_finishing` tinyint(3) DEFAULT 50,
  `att_defending` tinyint(3) DEFAULT 50,
  `att_duel` tinyint(3) DEFAULT 50
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `ws_stadium`
--

CREATE TABLE `ws_stadium` (
  `id` int(10) NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  `country_id` int(5) NOT NULL,
  `city` varchar(30) DEFAULT NULL,
  `p_north` int(6) NOT NULL,
  `p_east` int(6) NOT NULL,
  `p_south` int(6) NOT NULL,
  `p_west` int(6) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Tabellenstruktur für Tabelle `ws_user`
--

CREATE TABLE `ws_user` (
  `id` int(10) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `wallet_adress` varchar(100) DEFAULT NULL,
  `admin` tinyint(1) NOT NULL,
  `email` varchar(150) DEFAULT NULL,
  `date_time_registry` int(11) NOT NULL,
  `lastonline` int(11) NOT NULL,
  `lastaction` varchar(150) DEFAULT NULL,
  `ip` varchar(25) DEFAULT NULL,
  `ip_time` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Daten für Tabelle `ws_user`
--

INSERT INTO `ws_user` (`id`, `name`, `wallet_adress`, `admin`, `email`, `date_time_registry`, `lastonline`, `lastaction`, `ip`, `ip_time`, `status`) VALUES
(1, 'Christian Desktop', '0x8B857593c46F3824aa0C664B4F696588742157c1', 1, 'online@necj.at', 1343590153, 1416338486, 'Sonstiges', '::1', 1495130132, 1),
(2, 'Christian Mobil', '0x6fc5B1E53b328876C1930939F97131Eef6675C9F', 1, NULL, 0, 0, NULL, NULL, 0, 0),
(3, 'Thomas generic', '0x159C58801B04418971386ED876Bb72a9379C8c0E', 1, NULL, 0, 0, NULL, NULL, 0, 0),
(4, 'Natalie generic', '0x5046D90bFEfc6DAae49D53fA11BdA4810172c938', 1, '', 0, 0, NULL, NULL, 0, 0);

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `finance_category`
--
ALTER TABLE `finance_category`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `finance_snapshot_season`
--
ALTER TABLE `finance_snapshot_season`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_club` (`club_id`),
  ADD KEY `idx_saison` (`season_id`),
  ADD KEY `idx_date` (`snapshot_date`);

--
-- Indizes für die Tabelle `finance_transactions`
--
ALTER TABLE `finance_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_from` (`from_type`,`from_id`),
  ADD KEY `idx_to` (`to_type`,`to_id`),
  ADD KEY `idx_category` (`category_id`);

--
-- Indizes für die Tabelle `main_script_runtimes`
--
ALTER TABLE `main_script_runtimes`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `main_seasonstatus`
--
ALTER TABLE `main_seasonstatus`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `ws_bonus`
--
ALTER TABLE `ws_bonus`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `ws_city`
--
ALTER TABLE `ws_city`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `ws_club`
--
ALTER TABLE `ws_club`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ix_club_id` (`id`),
  ADD KEY `idx_country_league` (`country_id`,`league_level`),
  ADD KEY `idx_stadium_id` (`stadium_id`),
  ADD KEY `idx_league_country` (`league_level`,`country_id`);

--
-- Indizes für die Tabelle `ws_country`
--
ALTER TABLE `ws_country`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`),
  ADD KEY `ix_country_id` (`id`);

--
-- Indizes für die Tabelle `ws_game`
--
ALTER TABLE `ws_game`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_type_round_season` (`game_type`,`game_round`,`season_id`),
  ADD KEY `idx_type_season` (`game_type`,`season_id`),
  ADD KEY `idx_season_gameday` (`season_id`,`gameday_intcups`),
  ADD KEY `idx_season_stadium` (`season_id`,`stadium_id`),
  ADD KEY `idx_season_type` (`season_id`,`game_type`),
  ADD KEY `idx_stadium_season` (`stadium_id`,`season_id`),
  ADD KEY `idx_home_club_season` (`home_club`,`season_id`),
  ADD KEY `idx_away_club_season` (`away_club`,`season_id`);

--
-- Indizes für die Tabelle `ws_game_aktion`
--
ALTER TABLE `ws_game_aktion`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `ws_game_lineups`
--
ALTER TABLE `ws_game_lineups`
  ADD PRIMARY KEY (`game_id`,`player_id`),
  ADD KEY `idx_player` (`player_id`),
  ADD KEY `idx_team` (`club_id`);

--
-- Indizes für die Tabelle `ws_game_text`
--
ALTER TABLE `ws_game_text`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `ws_intcups_starter`
--
ALTER TABLE `ws_intcups_starter`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `ws_league`
--
ALTER TABLE `ws_league`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ix_league_id` (`id`);

--
-- Indizes für die Tabelle `ws_league_intcups`
--
ALTER TABLE `ws_league_intcups`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `ws_livegame_aktion`
--
ALTER TABLE `ws_livegame_aktion`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `ws_livegame_player`
--
ALTER TABLE `ws_livegame_player`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ix_berechnung_spiel_team_feld` (`game_id`,`club_id`,`feld`),
  ADD KEY `idx_spiel_team_feld` (`game_id`,`club_id`,`feld`),
  ADD KEY `idx_team_feld_pos` (`club_id`,`feld`,`position_formation`),
  ADD KEY `idx_spieler_spiel` (`player_id`,`game_id`),
  ADD KEY `idx_team_spiel` (`club_id`,`game_id`);

--
-- Indizes für die Tabelle `ws_livegame_tactic`
--
ALTER TABLE `ws_livegame_tactic`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_game_team` (`game_id`,`club_id`);

--
-- Indizes für die Tabelle `ws_livegame_temp`
--
ALTER TABLE `ws_livegame_temp`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_simulated_status` (`simulated`,`GameStatus`),
  ADD KEY `idx_game_id` (`game_id`),
  ADD KEY `idx_home_gast` (`home_club`,`away_club`);

--
-- Indizes für die Tabelle `ws_player`
--
ALTER TABLE `ws_player`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ix_spieler_club_filter_sort` (`club_id`,`injured`,`liga_suspended`,`cup_suspended`,`intcups_suspended`,`position_main`,`id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_main_filter` (`status`,`club_id`,`att_overall`),
  ADD KEY `idx_sorting` (`market_value`,`contract_salary`),
  ADD KEY `idx_status_club` (`status`,`club_id`),
  ADD KEY `idx_position` (`position_main`),
  ADD KEY `idx_problem_criteria` (`status`,`injured`,`liga_suspended`,`cup_suspended`,`intcups_suspended`,`rating_avg`),
  ADD KEY `idx_club_status` (`club_id`,`status`),
  ADD KEY `idx_age_status` (`age`,`status`),
  ADD KEY `idx_cards` (`league_card_yellow`,`league_card_yellowred`,`league_card_red`,`cup_card_yellow`,`cup_card_yellowred`,`cup_card_red`,`intcups_card_yellow`,`intcups_card_yellowred`,`intcups_card_red`),
  ADD KEY `idx_attitude` (`att_fitness`,`att_freshness`,`att_satisfaction`),
  ADD KEY `idx_contract` (`contract_games`,`contract_salary`);

--
-- Indizes für die Tabelle `ws_stadium`
--
ALTER TABLE `ws_stadium`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ix_stadium_id` (`id`),
  ADD KEY `idx_country_id` (`country_id`);

--
-- Indizes für die Tabelle `ws_user`
--
ALTER TABLE `ws_user`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `finance_category`
--
ALTER TABLE `finance_category`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;

--
-- AUTO_INCREMENT für Tabelle `finance_snapshot_season`
--
ALTER TABLE `finance_snapshot_season`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `finance_transactions`
--
ALTER TABLE `finance_transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `main_script_runtimes`
--
ALTER TABLE `main_script_runtimes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT für Tabelle `main_seasonstatus`
--
ALTER TABLE `main_seasonstatus`
  MODIFY `id` smallint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT für Tabelle `ws_bonus`
--
ALTER TABLE `ws_bonus`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT für Tabelle `ws_city`
--
ALTER TABLE `ws_city`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1482;

--
-- AUTO_INCREMENT für Tabelle `ws_club`
--
ALTER TABLE `ws_club`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `ws_game`
--
ALTER TABLE `ws_game`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `ws_game_aktion`
--
ALTER TABLE `ws_game_aktion`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `ws_game_text`
--
ALTER TABLE `ws_game_text`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=201;

--
-- AUTO_INCREMENT für Tabelle `ws_intcups_starter`
--
ALTER TABLE `ws_intcups_starter`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT für Tabelle `ws_league`
--
ALTER TABLE `ws_league`
  MODIFY `id` smallint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=129;

--
-- AUTO_INCREMENT für Tabelle `ws_league_intcups`
--
ALTER TABLE `ws_league_intcups`
  MODIFY `id` smallint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT für Tabelle `ws_livegame_aktion`
--
ALTER TABLE `ws_livegame_aktion`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `ws_livegame_player`
--
ALTER TABLE `ws_livegame_player`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `ws_livegame_tactic`
--
ALTER TABLE `ws_livegame_tactic`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `ws_livegame_temp`
--
ALTER TABLE `ws_livegame_temp`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `ws_player`
--
ALTER TABLE `ws_player`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `ws_stadium`
--
ALTER TABLE `ws_stadium`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT für Tabelle `ws_user`
--
ALTER TABLE `ws_user`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

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