-- https://www.phpmyadmin.net/
--
-- Erstellungszeit: 04. Mai 2017 um 14:48
-- Server-Version: 10.1.21-MariaDB
-- PHP-Version: 5.6.30




--
-- Datenbank: `chess4u`
--

DELIMITER $$
--
-- Prozeduren
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `insertSpielzug` (`altesFeld` VARCHAR(20), `feld` VARCHAR(20), `figurId` INT(11))  BEGIN

    DECLARE zugNr INT;
    DECLARE spielId INT;
    DECLARE spieler INT;
    DECLARE spielerW INT;
    DECLARE spielerS INT;
    DECLARE setSpieler INT;

    SELECT schachspiel.schachspiel_id INTO spielId FROM `schachspiel` ORDER BY `schachspiel_id` DESC LIMIT 1;
    SELECT FLOOR(COUNT(spielzuege.zugnummer)/2)+1 INTO zugNr FROM spielzuege WHERE spielzuege.spiel_id = spielId;
    SELECT COUNT(spielzuege.zugnummer)%2 INTO setSpieler FROM spielzuege WHERE spielzuege.spiel_id = spielId;
    SELECT schachspiel.spieler_weiß INTO spielerW FROM `schachspiel` ORDER BY `schachspiel_id` DESC LIMIT 1;
    SELECT schachspiel.spieler_schwarz INTO spielerS FROM `schachspiel` ORDER BY `schachspiel_id` DESC LIMIT 1;

    IF setSpieler = 0 THEN
      SET spieler = spielerW;
    ELSEIF setSpieler = 1 THEN
      SET spieler = spielerS;
    END IF;

    INSERT INTO `spielzuege`(`spiel_id`, `zugnummer`, `spieler_id`, `alte_position`, `neue_position`, `figur_id`) VALUES (spielId,zugNr,spieler, altesFeld, feld,figurId);

  END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `insertStartfelder` (`feld` VARCHAR(20), `figurId` INT(11))  BEGIN
    DECLARE spielId INT;

    SELECT schachspiel.schachspiel_id INTO spielId FROM `schachspiel` ORDER BY `schachspiel_id` DESC LIMIT 1;
    
    INSERT INTO `spielerfassung`(`id_schachspiel`, `id_schachfigur`, `position`) VALUES (spielId, figurId, feld);
  END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `insertZeiten` (`spielId` INT(11))  BEGIN

    DECLARE zeitGesamt TIME;
    DECLARE zeitW TIME;
    DECLARE zeitS TIME;

    DECLARE done INT DEFAULT FALSE;
    DECLARE a TIME;
    DECLARE b TIME;
    DECLARE c INT;
    DECLARE d INT DEFAULT 0;
    DECLARE cur1 CURSOR FOR SELECT zeitpunkt FROM `spielzuege` WHERE `spiel_id` = spielId GROUP BY zugnummer DESC ORDER BY zeitpunkt;
    DECLARE cur2 CURSOR FOR SELECT zeitpunkt FROM `spielzuege` WHERE `spiel_id` = spielId GROUP BY zugnummer ORDER BY zeitpunkt;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur1;
    OPEN cur2;

    read_loop: LOOP
      FETCH cur1 INTO a;
      FETCH cur2 INTO b;
      IF done THEN
        LEAVE read_loop;
      END IF;
      SET c = a-b;
      SET d = d+c;
    END LOOP;

    CLOSE cur1;
    CLOSE cur2;


    SET zeitS = TIME_TO_SEC(d);
    SET zeitW = zeitGesamt - zeitS;

    UPDATE schachspiel SET schachspiel.zeit_gesamt = zeitGesamt, schachspiel.zeit_spielerweiß = zeitW, schachspiel.zeit_spielerschwarz = zeitS WHERE schachspiel.schachspiel_id = spielId;

  END$$

--
-- Funktionen
--
CREATE DEFINER=`root`@`localhost` FUNCTION `setSpieler` (`spielerWeissId` INT, `spielerSchwarzId` INT, `spielId` INT) RETURNS INT(11) BEGIN
    
    DECLARE x INT;
    DECLARE r INT;
    
    SELECT COUNT(spielzuege.zugnummer)%2 INTO x FROM spielzuege WHERE spielzuege.spiel_id = spielId;
    
    IF x = 0 THEN 
      SET r = spielerWeissId;
    ELSEIF x = 1 THEN 
      SET r = spielerSchwarzId;
    END IF;
    
    RETURN r;
    
  END$$

CREATE DEFINER=`root`@`localhost` FUNCTION `setZugNummer` (`spielId` INT) RETURNS INT(11) BEGIN

    DECLARE x INT;

    SELECT FLOOR(COUNT(spielzuege.zugnummer)/2)+1 INTO x FROM spielzuege WHERE spielzuege.spiel_id = spielId;

    RETURN x;

  END$$

DELIMITER ;

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

--
-- Tabellenstruktur für Tabelle `schachfigur`
--

CREATE TABLE `schachfigur` (
  `farbe` enum('weiss','schwarz') COLLATE latin1_german1_ci NOT NULL,
  `id` int(11) NOT NULL,
  `name` varchar(30) COLLATE latin1_german1_ci NOT NULL,
  `position` enum('A8','B8','C8','D8','E8','F8','G8','H8','A7','B7','C7','D7','E7','F7','G7','H7','A6','B6','C6','D6','E6','F6','G6','H6','A5','B5','C5','D5','E5','F5','G5','H5','A4','B4','C4','D4','E4','F4','G4','H4','A3','B3','C3','D3','E3','F3','G3','H3','A2','B2','C2','D2','E2','F2','G2','H2','A1','B1','C1','D1','E1','F1','G1','H1') COLLATE latin1_german1_ci NOT NULL,
  `code` varchar(30) COLLATE latin1_german1_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `schachfigur`
--

INSERT INTO `schachfigur` (`farbe`, `id`, `name`, `position`, `code`) VALUES
('weiss', 1, 'Koenig', 'E1', ''),
('weiss', 2, 'Dame', 'D1', ''),
('schwarz', 3, 'Koenig', 'E8', ''),
('schwarz', 4, 'Dame', 'D8', ''),
('weiss', 5, 'Laeufer1', 'C1', ''),
('weiss', 6, 'Laeufer2', 'F1', ''),
('weiss', 7, 'Springer1', 'B1', ''),
('weiss', 8, 'Springer2', 'G1', ''),
('weiss', 9, 'Turm1', 'A1', ''),
('weiss', 10, 'Turm2', 'H1', ''),
('weiss', 11, 'Bauer1', 'A2', ''),
('weiss', 12, 'Bauer2', 'B2', ''),
('weiss', 13, 'Bauer3', 'C2', ''),
('weiss', 14, 'Bauer4', 'D2', ''),
('weiss', 15, 'Bauer5', 'E2', ''),
('weiss', 16, 'Bauer6', 'F2', ''),
('weiss', 17, 'Bauer7', 'G2', ''),
('weiss', 18, 'Bauer8', 'H2', ''),
('schwarz', 19, 'Laeufer1', 'C8', ''),
('schwarz', 20, 'Laeufer2', 'F8', ''),
('schwarz', 21, 'Springer1', 'B8', ''),
('schwarz', 22, 'Springer2', 'G8', ''),
('schwarz', 23, 'Turm1', 'A8', ''),
('schwarz', 24, 'Turm2', 'H8', ''),
('schwarz', 25, 'Bauer1', 'A7', ''),
('schwarz', 26, 'Bauer2', 'B7', ''),
('schwarz', 27, 'Bauer3', 'C7', ''),
('schwarz', 28, 'Bauer4', 'D7', ''),
('schwarz', 29, 'Bauer5', 'E7', ''),
('schwarz', 30, 'Bauer6', 'F7', ''),
('schwarz', 31, 'Bauer7', 'G7', ''),
('schwarz', 32, 'Bauer8', 'H7', '');

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

--
-- Tabellenstruktur für Tabelle `schachspiel`
--

CREATE TABLE `schachspiel` (
  `schachspiel_id` int(11) NOT NULL,
  `spieler_schwarz` int(11) DEFAULT NULL,
  `spieler_weiß` int(11) DEFAULT NULL,
  `spielbeginn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `zeit_gesamt` time DEFAULT NULL,
  `zeit_spielerweiß` time DEFAULT NULL,
  `zeit_spielerschwarz` time DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `schachspiel`
--

INSERT INTO `schachspiel` (`schachspiel_id`, `spieler_schwarz`, `spieler_weiß`, `spielbeginn`, `zeit_gesamt`, `zeit_spielerweiß`, `zeit_spielerschwarz`) VALUES
(1, 2, 1, '2017-02-27 13:14:48', '00:00:12', '00:15:03', '00:11:08'),
(3, 1, 3, '2017-02-28 10:21:34', '00:00:12', NULL, NULL),
(9, 1, 2, '2017-03-02 16:27:13', '00:00:12', NULL, NULL),
(10, 5, 4, '2017-02-27 13:14:48', '00:00:21', NULL, NULL),
(11, 5, 4, '2017-02-27 13:25:47', '00:01:11', '00:01:02', '00:00:09'),
(12, 1, 4, '2017-03-03 12:27:59', NULL, NULL, NULL),
(13, 5, 4, '2017-03-03 22:36:01', NULL, NULL, NULL),
(14, 5, 2, '2017-03-03 22:45:50', NULL, NULL, NULL),
(16, 2, 1, '2017-03-05 14:44:09', NULL, NULL, NULL),
(19, 2, 5, '2017-03-11 16:58:48', NULL, NULL, NULL),
(22, 4, 3, '2017-03-26 21:00:17', NULL, NULL, NULL),
(23, 3, 1, '2017-03-27 14:00:43', NULL, NULL, NULL),
(24, 3, 1, '2017-03-31 10:32:22', NULL, NULL, NULL),
(25, 4, 5, '2017-04-07 07:18:46', NULL, NULL, NULL),
(26, 3, 1, '2017-04-08 13:26:28', NULL, NULL, NULL),
(27, 4, 3, '2017-04-10 13:01:04', NULL, NULL, NULL),
(28, 4, 3, '2017-04-10 13:01:13', NULL, NULL, NULL),
(29, 2, 1, '2017-04-10 13:01:21', NULL, NULL, NULL),
(30, 4, 3, '2017-04-10 13:02:18', NULL, NULL, NULL),
(31, 3, 1, '2017-04-10 13:02:29', NULL, NULL, NULL),
(32, 2, 1, '2017-04-10 13:08:47', NULL, NULL, NULL),
(33, 4, 1, '2017-04-10 13:13:23', NULL, NULL, NULL),
(34, 3, 1, '2017-04-13 16:58:43', NULL, NULL, NULL),
(35, 4, 1, '2017-04-13 17:05:09', NULL, NULL, NULL),
(36, 2, 1, '2017-04-13 17:12:10', NULL, NULL, NULL),
(37, 3, 1, '2017-04-13 19:07:53', NULL, NULL, NULL),
(38, 4, 1, '2017-04-17 09:41:28', NULL, NULL, NULL),
(39, 2, 3, '2017-04-20 12:22:05', NULL, NULL, NULL),
(40, 2, 1, '2017-04-20 12:26:01', NULL, NULL, NULL),
(41, 2, 1, '2017-04-20 12:59:26', NULL, NULL, NULL),
(42, 1, 1, '2017-04-21 17:14:06', NULL, NULL, NULL),
(43, 2, 1, '2017-04-21 17:51:52', NULL, NULL, NULL),
(44, 2, 1, '2017-04-24 10:28:45', NULL, NULL, NULL),
(45, 2, 1, '2017-04-26 06:39:06', NULL, NULL, NULL),
(46, 2, 1, '2017-04-26 06:57:58', NULL, NULL, NULL),
(47, 2, 1, '2017-04-26 07:09:13', NULL, NULL, NULL),
(48, 4, 1, '2017-04-26 07:13:32', NULL, NULL, NULL),
(49, 4, 1, '2017-04-26 07:16:03', NULL, NULL, NULL),
(50, 4, 1, '2017-04-26 07:19:17', NULL, NULL, NULL),
(51, 3, 1, '2017-04-26 07:20:54', NULL, NULL, NULL),
(52, 4, 1, '2017-04-26 07:24:56', NULL, NULL, NULL),
(53, 4, 3, '2017-04-26 07:32:18', NULL, NULL, NULL),
(54, 4, 1, '2017-04-26 07:37:58', NULL, NULL, NULL),
(55, 3, 1, '2017-04-26 07:41:09', NULL, NULL, NULL),
(56, 2, 1, '2017-04-26 07:42:47', NULL, NULL, NULL),
(57, 2, 1, '2017-04-26 07:45:13', NULL, NULL, NULL),
(58, 2, 1, '2017-04-26 07:49:46', NULL, NULL, NULL),
(59, 2, 1, '2017-04-26 07:54:14', NULL, NULL, NULL),
(60, 1, 3, '2017-04-26 07:57:00', NULL, NULL, NULL),
(61, 2, 1, '2017-04-26 08:00:27', NULL, NULL, NULL),
(62, 2, 1, '2017-04-26 08:03:20', NULL, NULL, NULL),
(63, 2, 1, '2017-04-26 08:21:44', NULL, NULL, NULL),
(64, 2, 1, '2017-04-26 08:23:20', NULL, NULL, NULL),
(65, 2, 1, '2017-05-03 13:34:09', NULL, NULL, NULL);

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

--
-- Tabellenstruktur für Tabelle `spielerfassung`
--

CREATE TABLE `spielerfassung` (
  `id_schachspiel` int(11) NOT NULL,
  `id_schachfigur` int(11) NOT NULL,
  `position` enum('A1','A2','B1','B2','C1','C2','D1','D2','E1','E2','F1','F2','G1','G2','H1','H2','A8','A7','B8','B7','C8','C7','D8','D7','E8','E7','F8','F7','G8','G7','H8','H7') NOT NULL,
  `zeitpunkt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `spielerfassung`
--

INSERT INTO `spielerfassung` (`id_schachspiel`, `id_schachfigur`, `position`, `zeitpunkt`) VALUES
(11, 1, 'D1', '2017-03-03 00:29:57'),
(11, 2, 'E1', '2017-03-03 00:30:03'),
(11, 3, 'E8', '2017-02-28 14:17:45'),
(11, 4, 'D8', '2017-02-28 14:17:45'),
(11, 5, 'C1', '2017-02-28 14:17:44'),
(11, 6, 'F1', '2017-02-28 14:17:44'),
(11, 7, 'B1', '2017-02-28 14:17:44'),
(11, 8, 'G1', '2017-02-28 14:17:44'),
(11, 9, 'A1', '2017-02-28 14:17:44'),
(11, 10, 'H1', '2017-02-28 14:17:44'),
(11, 11, 'A2', '2017-02-28 14:17:44'),
(11, 12, 'B2', '2017-02-28 14:17:44'),
(11, 13, 'C2', '2017-02-28 14:17:44'),
(11, 14, 'D2', '2017-02-28 14:17:44'),
(11, 15, 'E2', '2017-02-28 14:17:44'),
(11, 16, 'F2', '2017-02-28 14:17:44'),
(11, 17, 'G2', '2017-02-28 14:17:44'),
(11, 18, 'H2', '2017-02-28 14:17:44'),
(11, 19, 'C8', '2017-02-28 14:17:45'),
(11, 20, 'F8', '2017-02-28 14:17:45'),
(11, 21, 'B8', '2017-02-28 14:17:44'),
(11, 22, 'G8', '2017-02-28 14:17:45'),
(11, 23, 'A8', '2017-02-28 14:17:44'),
(11, 24, 'H8', '2017-02-28 14:17:45'),
(11, 25, 'A7', '2017-02-28 14:17:44'),
(11, 26, 'B7', '2017-02-28 14:17:44'),
(11, 27, 'C7', '2017-02-28 14:17:45'),
(11, 28, 'D7', '2017-02-28 14:17:45'),
(11, 29, 'E7', '2017-02-28 14:17:45'),
(11, 30, 'F7', '2017-02-28 14:17:45'),
(11, 31, 'G7', '2017-02-28 14:17:45'),
(11, 32, 'H7', '2017-02-28 14:17:45'),
(12, 1, 'D1', '2017-03-03 12:29:19'),
(12, 2, 'E1', '2017-03-03 12:29:19'),
(12, 3, 'E8', '2017-03-03 12:29:20'),
(12, 4, 'D8', '2017-03-03 12:29:20'),
(12, 5, 'C1', '2017-03-03 12:29:19'),
(12, 6, 'F1', '2017-03-03 12:29:20'),
(12, 7, 'B1', '2017-03-03 12:29:19'),
(12, 8, 'G1', '2017-03-03 12:29:20'),
(12, 9, 'A1', '2017-03-03 12:29:19'),
(12, 10, 'H1', '2017-03-03 12:29:20'),
(12, 11, 'A2', '2017-03-03 12:29:19'),
(12, 12, 'B2', '2017-03-03 12:29:19'),
(12, 13, 'C2', '2017-03-03 12:29:19'),
(12, 14, 'D2', '2017-03-03 12:29:19'),
(12, 15, 'E2', '2017-03-03 12:29:20'),
(12, 16, 'F2', '2017-03-03 12:29:20'),
(12, 17, 'G2', '2017-03-03 12:29:20'),
(12, 18, 'H2', '2017-03-03 12:29:20'),
(12, 19, 'C8', '2017-03-03 12:29:20'),
(12, 20, 'F8', '2017-03-03 12:29:20'),
(12, 21, 'B8', '2017-03-03 12:29:20'),
(12, 22, 'G8', '2017-03-03 12:29:20'),
(12, 23, 'A8', '2017-03-03 12:29:20'),
(12, 24, 'H8', '2017-03-03 12:29:20'),
(12, 25, 'A7', '2017-03-03 12:29:20'),
(12, 26, 'B7', '2017-03-03 12:29:20'),
(12, 27, 'C7', '2017-03-03 12:29:20'),
(12, 28, 'D7', '2017-03-03 12:29:20'),
(12, 29, 'E7', '2017-03-03 12:29:20'),
(12, 30, 'F7', '2017-03-03 12:29:20'),
(12, 31, 'G7', '2017-03-03 12:29:20'),
(12, 32, 'H7', '2017-03-03 12:29:20'),
(13, 1, 'E1', '2017-03-03 22:42:24'),
(13, 2, 'D1', '2017-03-03 22:42:24'),
(13, 3, 'E8', '2017-03-03 22:42:25'),
(13, 4, 'D8', '2017-03-03 22:42:24'),
(13, 5, 'C1', '2017-03-03 22:42:23'),
(13, 6, 'F1', '2017-03-03 22:42:24'),
(13, 7, 'B1', '2017-03-03 22:42:23'),
(13, 8, 'G1', '2017-03-03 22:42:24'),
(13, 9, 'A1', '2017-03-03 22:42:23'),
(13, 10, 'H1', '2017-03-03 22:42:24'),
(13, 11, 'A2', '2017-03-03 22:42:23'),
(13, 12, 'B2', '2017-03-03 22:42:23'),
(13, 13, 'C2', '2017-03-03 22:42:24'),
(13, 14, 'D2', '2017-03-03 22:42:24'),
(13, 15, 'E2', '2017-03-03 22:42:24'),
(13, 16, 'F2', '2017-03-03 22:42:24'),
(13, 17, 'G2', '2017-03-03 22:42:24'),
(13, 18, 'H2', '2017-03-03 22:42:24'),
(13, 19, 'C8', '2017-03-03 22:42:24'),
(13, 20, 'F8', '2017-03-03 22:42:25'),
(13, 21, 'B8', '2017-03-03 22:42:24'),
(13, 22, 'G8', '2017-03-03 22:42:25'),
(13, 23, 'A8', '2017-03-03 22:42:24'),
(13, 24, 'H8', '2017-03-03 22:42:25'),
(13, 25, 'A7', '2017-03-03 22:42:24'),
(13, 26, 'B7', '2017-03-03 22:42:24'),
(13, 27, 'C7', '2017-03-03 22:42:24'),
(13, 28, 'D7', '2017-03-03 22:42:25'),
(13, 29, 'E7', '2017-03-03 22:42:25'),
(13, 30, 'F7', '2017-03-03 22:42:25'),
(13, 31, 'G7', '2017-03-03 22:42:25'),
(13, 32, 'H7', '2017-03-03 22:42:25'),
(14, 1, 'E1', '2017-03-03 22:46:07'),
(14, 2, 'D1', '2017-03-03 22:46:07'),
(14, 3, 'E8', '2017-03-03 22:46:08'),
(14, 4, 'D8', '2017-03-03 22:46:08'),
(14, 5, 'C1', '2017-03-03 22:46:07'),
(14, 6, 'F1', '2017-03-03 22:46:07'),
(14, 7, 'B1', '2017-03-03 22:46:07'),
(14, 8, 'G1', '2017-03-03 22:46:07'),
(14, 9, 'A1', '2017-03-03 22:46:06'),
(14, 10, 'H1', '2017-03-03 22:46:07'),
(14, 11, 'A2', '2017-03-03 22:46:07'),
(14, 12, 'B2', '2017-03-03 22:46:07'),
(14, 13, 'C2', '2017-03-03 22:46:07'),
(14, 14, 'D2', '2017-03-03 22:46:07'),
(14, 15, 'E2', '2017-03-03 22:46:07'),
(14, 16, 'F2', '2017-03-03 22:46:07'),
(14, 17, 'G2', '2017-03-03 22:46:07'),
(14, 18, 'H2', '2017-03-03 22:46:07'),
(14, 19, 'C8', '2017-03-03 22:46:08'),
(14, 20, 'F8', '2017-03-03 22:46:08'),
(14, 21, 'B8', '2017-03-03 22:46:07'),
(14, 22, 'G8', '2017-03-03 22:46:08'),
(14, 23, 'A8', '2017-03-03 22:46:07'),
(14, 24, 'H8', '2017-03-03 22:46:08'),
(14, 25, 'A7', '2017-03-03 22:46:07'),
(14, 26, 'B7', '2017-03-03 22:46:07'),
(14, 27, 'C7', '2017-03-03 22:46:08'),
(14, 28, 'D7', '2017-03-03 22:46:08'),
(14, 29, 'E7', '2017-03-03 22:46:08'),
(14, 30, 'F7', '2017-03-03 22:46:08'),
(14, 31, 'G7', '2017-03-03 22:46:08'),
(14, 32, 'H7', '2017-03-03 22:46:08'),
(22, 1, 'E1', '2017-03-26 21:13:44'),
(22, 2, 'D1', '2017-03-26 21:13:44'),
(22, 3, 'E8', '2017-03-26 21:13:45'),
(22, 4, 'D8', '2017-03-26 21:13:45'),
(22, 5, 'C1', '2017-03-26 21:13:44'),
(22, 6, 'F1', '2017-03-26 21:13:44'),
(22, 7, 'B1', '2017-03-26 21:13:44'),
(22, 8, 'G1', '2017-03-26 21:13:44'),
(22, 9, 'A1', '2017-03-26 21:13:44'),
(22, 10, 'H1', '2017-03-26 21:13:44'),
(22, 11, 'A2', '2017-03-26 21:13:44'),
(22, 12, 'B2', '2017-03-26 21:13:44'),
(22, 13, 'C2', '2017-03-26 21:13:44'),
(22, 14, 'D2', '2017-03-26 21:13:44'),
(22, 15, 'E2', '2017-03-26 21:13:44'),
(22, 16, 'F2', '2017-03-26 21:13:44'),
(22, 17, 'G2', '2017-03-26 21:13:44'),
(22, 18, 'H2', '2017-03-26 21:13:44'),
(22, 19, 'C8', '2017-03-26 21:13:45'),
(22, 20, 'F8', '2017-03-26 21:13:45'),
(22, 21, 'B8', '2017-03-26 21:13:45'),
(22, 22, 'G8', '2017-03-26 21:13:45'),
(22, 23, 'A8', '2017-03-26 21:13:44'),
(22, 24, 'H8', '2017-03-26 21:13:45'),
(22, 25, 'A7', '2017-03-26 21:13:45'),
(22, 26, 'B7', '2017-03-26 21:13:45'),
(22, 27, 'C7', '2017-03-26 21:13:45'),
(22, 28, 'D7', '2017-03-26 21:13:45'),
(22, 29, 'E7', '2017-03-26 21:13:45'),
(22, 30, 'F7', '2017-03-26 21:13:45'),
(22, 31, 'G7', '2017-03-26 21:13:45'),
(22, 32, 'H7', '2017-03-26 21:13:45'),
(33, 2, 'E1', '2017-04-10 13:22:34'),
(34, 1, 'E1', '2017-04-13 17:00:15'),
(34, 2, 'D1', '2017-04-13 17:00:15'),
(34, 3, 'E8', '2017-04-13 17:00:15'),
(34, 4, 'D8', '2017-04-13 17:00:15'),
(34, 5, 'C1', '2017-04-13 17:00:15'),
(34, 6, 'F1', '2017-04-13 17:00:15'),
(34, 7, 'B1', '2017-04-13 17:00:14'),
(34, 8, 'G1', '2017-04-13 17:00:15'),
(34, 9, 'A1', '2017-04-13 17:00:14'),
(34, 10, 'H1', '2017-04-13 17:00:15'),
(34, 11, 'A2', '2017-04-13 17:00:14'),
(34, 12, 'B2', '2017-04-13 17:00:14'),
(34, 13, 'C2', '2017-04-13 17:00:15'),
(34, 14, 'D2', '2017-04-13 17:00:15'),
(34, 15, 'E2', '2017-04-13 17:00:15'),
(34, 16, 'F2', '2017-04-13 17:00:15'),
(34, 17, 'G2', '2017-04-13 17:00:15'),
(34, 18, 'H2', '2017-04-13 17:00:16'),
(34, 19, 'C8', '2017-04-13 17:00:15'),
(34, 20, 'F8', '2017-04-13 17:00:15'),
(34, 21, 'B8', '2017-04-13 17:00:15'),
(34, 22, 'G8', '2017-04-13 17:00:15'),
(34, 23, 'A8', '2017-04-13 17:00:14'),
(34, 24, 'H8', '2017-04-13 17:00:16'),
(34, 25, 'A7', '2017-04-13 17:00:14'),
(34, 26, 'B7', '2017-04-13 17:00:14'),
(34, 27, 'C7', '2017-04-13 17:00:15'),
(34, 28, 'D7', '2017-04-13 17:00:15'),
(34, 29, 'E7', '2017-04-13 17:00:15'),
(34, 30, 'F7', '2017-04-13 17:00:15'),
(34, 31, 'G7', '2017-04-13 17:00:15'),
(34, 32, 'H7', '2017-04-13 17:00:16'),
(35, 1, 'E1', '2017-04-13 17:06:55'),
(35, 2, 'D1', '2017-04-13 17:06:55'),
(35, 3, 'E8', '2017-04-13 17:06:55'),
(35, 4, 'D8', '2017-04-13 17:06:55'),
(35, 5, 'C1', '2017-04-13 17:06:55'),
(35, 6, 'F1', '2017-04-13 17:06:55'),
(35, 7, 'B1', '2017-04-13 17:06:54'),
(35, 8, 'G1', '2017-04-13 17:06:56'),
(35, 9, 'A1', '2017-04-13 17:06:54'),
(35, 10, 'H1', '2017-04-13 17:06:56'),
(35, 11, 'A2', '2017-04-13 17:06:54'),
(35, 12, 'B2', '2017-04-13 17:06:54'),
(35, 13, 'C2', '2017-04-13 17:06:55'),
(35, 14, 'D2', '2017-04-13 17:06:55'),
(35, 15, 'E2', '2017-04-13 17:06:55'),
(35, 16, 'F2', '2017-04-13 17:06:55'),
(35, 17, 'G2', '2017-04-13 17:06:56'),
(35, 18, 'H2', '2017-04-13 17:06:56'),
(35, 19, 'C8', '2017-04-13 17:06:55'),
(35, 20, 'F8', '2017-04-13 17:06:56'),
(35, 21, 'B8', '2017-04-13 17:06:54'),
(35, 22, 'G8', '2017-04-13 17:06:56'),
(35, 23, 'A8', '2017-04-13 17:06:54'),
(35, 24, 'H8', '2017-04-13 17:06:56'),
(35, 25, 'A7', '2017-04-13 17:06:54'),
(35, 26, 'B7', '2017-04-13 17:06:54'),
(35, 27, 'C7', '2017-04-13 17:06:55'),
(35, 28, 'D7', '2017-04-13 17:06:55'),
(35, 29, 'E7', '2017-04-13 17:06:55'),
(35, 30, 'F7', '2017-04-13 17:06:55'),
(35, 31, 'G7', '2017-04-13 17:06:56'),
(35, 32, 'H7', '2017-04-13 17:06:56'),
(36, 1, 'E1', '2017-04-13 17:12:21'),
(36, 2, 'D1', '2017-04-13 17:12:21'),
(36, 3, 'E8', '2017-04-13 17:12:21'),
(36, 4, 'D8', '2017-04-13 17:12:21'),
(36, 5, 'C1', '2017-04-13 17:12:20'),
(36, 6, 'F1', '2017-04-13 17:12:21'),
(36, 7, 'B1', '2017-04-13 17:12:20'),
(36, 8, 'G1', '2017-04-13 17:12:21'),
(36, 9, 'A1', '2017-04-13 17:12:20'),
(36, 10, 'H1', '2017-04-13 17:12:22'),
(36, 11, 'A2', '2017-04-13 17:12:20'),
(36, 12, 'B2', '2017-04-13 17:12:20'),
(36, 13, 'C2', '2017-04-13 17:12:21'),
(36, 14, 'D2', '2017-04-13 17:12:21'),
(36, 15, 'E2', '2017-04-13 17:12:21'),
(36, 16, 'F2', '2017-04-13 17:12:21'),
(36, 17, 'G2', '2017-04-13 17:12:21'),
(36, 18, 'H2', '2017-04-13 17:12:22'),
(36, 19, 'C8', '2017-04-13 17:12:21'),
(36, 20, 'F8', '2017-04-13 17:12:21'),
(36, 21, 'B8', '2017-04-13 17:12:20'),
(36, 22, 'G8', '2017-04-13 17:12:22'),
(36, 23, 'A8', '2017-04-13 17:12:20'),
(36, 24, 'H8', '2017-04-13 17:12:22'),
(36, 25, 'A7', '2017-04-13 17:12:20'),
(36, 26, 'B7', '2017-04-13 17:12:20'),
(36, 27, 'C7', '2017-04-13 17:12:21'),
(36, 28, 'D7', '2017-04-13 17:12:21'),
(36, 29, 'E7', '2017-04-13 17:12:21'),
(36, 30, 'F7', '2017-04-13 17:12:21'),
(36, 31, 'G7', '2017-04-13 17:12:22'),
(36, 32, 'H7', '2017-04-13 17:12:22'),
(37, 1, 'E1', '2017-04-13 19:25:33'),
(37, 2, 'D1', '2017-04-13 19:25:33'),
(37, 3, 'E8', '2017-04-13 19:25:33'),
(37, 4, 'D8', '2017-04-13 19:25:33'),
(37, 5, 'C1', '2017-04-13 19:25:33'),
(37, 6, 'F1', '2017-04-13 19:25:33'),
(37, 7, 'B1', '2017-04-13 19:25:32'),
(37, 8, 'G1', '2017-04-13 19:25:34'),
(37, 9, 'A1', '2017-04-13 19:25:32'),
(37, 10, 'H1', '2017-04-13 19:25:34'),
(37, 11, 'A2', '2017-04-13 19:25:32'),
(37, 12, 'B2', '2017-04-13 19:25:32'),
(37, 13, 'C2', '2017-04-13 19:25:33'),
(37, 14, 'D2', '2017-04-13 19:25:33'),
(37, 15, 'E2', '2017-04-13 19:25:33'),
(37, 16, 'F2', '2017-04-13 19:25:33'),
(37, 17, 'G2', '2017-04-13 19:25:34'),
(37, 18, 'H2', '2017-04-13 19:25:34'),
(37, 19, 'C8', '2017-04-13 19:25:33'),
(37, 20, 'F8', '2017-04-13 19:25:33'),
(37, 21, 'B8', '2017-04-13 19:25:33'),
(37, 22, 'G8', '2017-04-13 19:25:34'),
(37, 23, 'A8', '2017-04-13 19:25:32'),
(37, 24, 'H8', '2017-04-13 19:25:34'),
(37, 25, 'A7', '2017-04-13 19:25:32'),
(37, 26, 'B7', '2017-04-13 19:25:32'),
(37, 27, 'C7', '2017-04-13 19:25:33'),
(37, 28, 'D7', '2017-04-13 19:25:33'),
(37, 29, 'E7', '2017-04-13 19:25:33'),
(37, 30, 'F7', '2017-04-13 19:25:33'),
(37, 31, 'G7', '2017-04-13 19:25:34'),
(37, 32, 'H7', '2017-04-13 19:25:34'),
(38, 1, 'E1', '2017-04-17 09:48:11'),
(38, 2, 'D1', '2017-04-17 09:48:10'),
(38, 3, 'E8', '2017-04-17 09:48:11'),
(38, 4, 'D8', '2017-04-17 09:48:11'),
(38, 5, 'C1', '2017-04-17 09:48:10'),
(38, 6, 'F1', '2017-04-17 09:48:11'),
(38, 7, 'B1', '2017-04-17 09:48:10'),
(38, 8, 'G1', '2017-04-17 09:48:11'),
(38, 9, 'A1', '2017-04-17 09:48:09'),
(38, 10, 'H1', '2017-04-17 09:48:11'),
(38, 11, 'A2', '2017-04-17 09:48:09'),
(38, 12, 'B2', '2017-04-17 09:48:10'),
(38, 13, 'C2', '2017-04-17 09:48:10'),
(38, 14, 'D2', '2017-04-17 09:48:10'),
(38, 15, 'E2', '2017-04-17 09:48:11'),
(38, 16, 'F2', '2017-04-17 09:48:11'),
(38, 17, 'G2', '2017-04-17 09:48:11'),
(38, 18, 'H2', '2017-04-17 09:48:11'),
(38, 19, 'C8', '2017-04-17 09:48:10'),
(38, 20, 'F8', '2017-04-17 09:48:11'),
(38, 21, 'B8', '2017-04-17 09:48:10'),
(38, 22, 'G8', '2017-04-17 09:48:11'),
(38, 23, 'A8', '2017-04-17 09:48:09'),
(38, 24, 'H8', '2017-04-17 09:48:11'),
(38, 25, 'A7', '2017-04-17 09:48:09'),
(38, 26, 'B7', '2017-04-17 09:48:10'),
(38, 27, 'C7', '2017-04-17 09:48:10'),
(38, 28, 'D7', '2017-04-17 09:48:10'),
(38, 29, 'E7', '2017-04-17 09:48:11'),
(38, 30, 'F7', '2017-04-17 09:48:11'),
(38, 31, 'G7', '2017-04-17 09:48:11'),
(38, 32, 'H7', '2017-04-17 09:48:11'),
(39, 1, 'E1', '2017-04-20 12:23:55'),
(39, 2, 'D1', '2017-04-20 12:23:55'),
(39, 3, 'E8', '2017-04-20 12:23:56'),
(39, 4, 'D8', '2017-04-20 12:23:55'),
(39, 5, 'C1', '2017-04-20 12:23:55'),
(39, 6, 'F1', '2017-04-20 12:23:56'),
(39, 7, 'B1', '2017-04-20 12:23:55'),
(39, 8, 'G1', '2017-04-20 12:23:56'),
(39, 9, 'A1', '2017-04-20 12:23:55'),
(39, 10, 'H1', '2017-04-20 12:23:56'),
(39, 11, 'A2', '2017-04-20 12:23:55'),
(39, 12, 'B2', '2017-04-20 12:23:55'),
(39, 13, 'C2', '2017-04-20 12:23:55'),
(39, 14, 'D2', '2017-04-20 12:23:55'),
(39, 15, 'E2', '2017-04-20 12:23:55'),
(39, 16, 'F2', '2017-04-20 12:23:56'),
(39, 17, 'G2', '2017-04-20 12:23:56'),
(39, 18, 'H2', '2017-04-20 12:23:56'),
(39, 19, 'C8', '2017-04-20 12:23:55'),
(39, 20, 'F8', '2017-04-20 12:23:56'),
(39, 21, 'B8', '2017-04-20 12:23:55'),
(39, 22, 'G8', '2017-04-20 12:23:56'),
(39, 23, 'A8', '2017-04-20 12:23:55'),
(39, 24, 'H8', '2017-04-20 12:23:56'),
(39, 25, 'A7', '2017-04-20 12:23:55'),
(39, 26, 'B7', '2017-04-20 12:23:55'),
(39, 27, 'C7', '2017-04-20 12:23:55'),
(39, 28, 'D7', '2017-04-20 12:23:55'),
(39, 29, 'E7', '2017-04-20 12:23:56'),
(39, 30, 'F7', '2017-04-20 12:23:56'),
(39, 31, 'G7', '2017-04-20 12:23:56'),
(39, 32, 'H7', '2017-04-20 12:23:56'),
(40, 9, 'A1', '2017-04-20 12:58:35'),
(40, 11, 'B2', '2017-04-20 12:58:35'),
(40, 23, 'H8', '2017-04-20 12:58:35'),
(40, 25, 'G7', '2017-04-20 12:58:35'),
(41, 1, 'E1', '2017-04-20 20:08:29'),
(41, 2, 'D1', '2017-04-20 20:08:28'),
(41, 3, 'E8', '2017-04-20 20:08:30'),
(41, 4, 'D8', '2017-04-20 20:08:29'),
(41, 5, 'C1', '2017-04-20 20:08:28'),
(41, 6, 'F1', '2017-04-20 20:08:30'),
(41, 7, 'B1', '2017-04-20 20:08:27'),
(41, 8, 'G1', '2017-04-20 20:08:30'),
(41, 9, 'A1', '2017-04-20 20:08:27'),
(41, 10, 'H1', '2017-04-20 20:08:30'),
(41, 11, 'A2', '2017-04-20 20:08:27'),
(41, 12, 'B2', '2017-04-20 20:08:27'),
(41, 13, 'C2', '2017-04-20 20:08:28'),
(41, 14, 'D2', '2017-04-20 20:08:28'),
(41, 15, 'E2', '2017-04-20 20:08:29'),
(41, 16, 'F2', '2017-04-20 20:08:30'),
(41, 17, 'G2', '2017-04-20 20:08:30'),
(41, 18, 'H2', '2017-04-20 20:08:30'),
(41, 19, 'C8', '2017-04-20 20:08:28'),
(41, 20, 'F8', '2017-04-20 20:08:30'),
(41, 21, 'B8', '2017-04-20 20:08:28'),
(41, 22, 'G8', '2017-04-20 20:08:30'),
(41, 23, 'A8', '2017-04-20 20:08:27'),
(41, 24, 'H8', '2017-04-20 20:08:30'),
(41, 25, 'A7', '2017-04-20 20:08:27'),
(41, 26, 'B7', '2017-04-20 20:08:28'),
(41, 27, 'C7', '2017-04-20 20:08:28'),
(41, 28, 'D7', '2017-04-20 20:08:28'),
(41, 29, 'E7', '2017-04-20 20:08:29'),
(41, 30, 'F7', '2017-04-20 20:08:30'),
(41, 31, 'G7', '2017-04-20 20:08:30'),
(41, 32, 'H7', '2017-04-20 20:08:30'),
(42, 1, 'E1', '2017-04-21 17:27:48'),
(42, 2, 'D1', '2017-04-21 17:27:48'),
(42, 3, 'E8', '2017-04-21 17:27:49'),
(42, 4, 'D8', '2017-04-21 17:27:48'),
(42, 5, 'C1', '2017-04-21 17:27:47'),
(42, 6, 'F1', '2017-04-21 17:27:49'),
(42, 7, 'B1', '2017-04-21 17:27:47'),
(42, 8, 'G1', '2017-04-21 17:27:49'),
(42, 9, 'A1', '2017-04-21 17:27:46'),
(42, 10, 'H1', '2017-04-21 17:27:50'),
(42, 11, 'A2', '2017-04-21 17:27:46'),
(42, 12, 'B2', '2017-04-21 17:27:47'),
(42, 13, 'C2', '2017-04-21 17:27:48'),
(42, 14, 'D2', '2017-04-21 17:27:48'),
(42, 15, 'E2', '2017-04-21 17:27:48'),
(42, 16, 'F2', '2017-04-21 17:27:49'),
(42, 17, 'G2', '2017-04-21 17:27:49'),
(42, 18, 'H2', '2017-04-21 17:27:50'),
(42, 19, 'C8', '2017-04-21 17:27:48'),
(42, 20, 'F8', '2017-04-21 17:27:49'),
(42, 21, 'B8', '2017-04-21 17:27:47'),
(42, 22, 'G8', '2017-04-21 17:27:49'),
(42, 23, 'A8', '2017-04-21 17:27:47'),
(42, 24, 'H8', '2017-04-21 17:27:50'),
(42, 25, 'A7', '2017-04-21 17:27:46'),
(42, 26, 'B7', '2017-04-21 17:27:47'),
(42, 27, 'C7', '2017-04-21 17:27:48'),
(42, 28, 'D7', '2017-04-21 17:27:48'),
(42, 29, 'E7', '2017-04-21 17:27:49'),
(42, 30, 'F7', '2017-04-21 17:27:49'),
(42, 31, 'G7', '2017-04-21 17:27:49'),
(42, 32, 'H7', '2017-04-21 17:27:50'),
(43, 1, 'E1', '2017-04-21 18:03:20'),
(43, 2, 'D1', '2017-04-21 18:03:20'),
(43, 3, 'E8', '2017-04-21 18:03:21'),
(43, 4, 'D8', '2017-04-21 18:03:20'),
(43, 5, 'C1', '2017-04-21 18:03:20'),
(43, 6, 'F1', '2017-04-21 18:03:21'),
(43, 7, 'B1', '2017-04-21 18:03:20'),
(43, 8, 'G1', '2017-04-21 18:03:21'),
(43, 9, 'A1', '2017-04-21 18:03:20'),
(43, 10, 'H1', '2017-04-21 18:03:21'),
(43, 11, 'A2', '2017-04-21 18:03:20'),
(43, 12, 'B2', '2017-04-21 18:03:20'),
(43, 13, 'C2', '2017-04-21 18:03:20'),
(43, 14, 'D2', '2017-04-21 18:03:20'),
(43, 15, 'E2', '2017-04-21 18:03:21'),
(43, 16, 'F2', '2017-04-21 18:03:21'),
(43, 17, 'G2', '2017-04-21 18:03:21'),
(43, 18, 'H2', '2017-04-21 18:03:21'),
(43, 19, 'C8', '2017-04-21 18:03:20'),
(43, 20, 'F8', '2017-04-21 18:03:21'),
(43, 21, 'B8', '2017-04-21 18:03:20'),
(43, 22, 'G8', '2017-04-21 18:03:21'),
(43, 23, 'A8', '2017-04-21 18:03:20'),
(43, 24, 'H8', '2017-04-21 18:03:21'),
(43, 25, 'A7', '2017-04-21 18:03:20'),
(43, 26, 'B7', '2017-04-21 18:03:20'),
(43, 27, 'C7', '2017-04-21 18:03:20'),
(43, 28, 'D7', '2017-04-21 18:03:20'),
(43, 29, 'E7', '2017-04-21 18:03:21'),
(43, 30, 'F7', '2017-04-21 18:03:21'),
(43, 31, 'G7', '2017-04-21 18:03:21'),
(43, 32, 'H7', '2017-04-21 18:03:21'),
(44, 1, 'E1', '2017-04-24 10:32:21'),
(44, 2, 'D1', '2017-04-24 10:32:21'),
(44, 3, 'E8', '2017-04-24 10:32:21'),
(44, 4, 'D8', '2017-04-24 10:32:21'),
(44, 5, 'C1', '2017-04-24 10:32:21'),
(44, 6, 'F1', '2017-04-24 10:32:22'),
(44, 7, 'B1', '2017-04-24 10:32:21'),
(44, 8, 'G1', '2017-04-24 10:32:22'),
(44, 9, 'A1', '2017-04-24 10:32:21'),
(44, 10, 'H1', '2017-04-24 10:32:22'),
(44, 11, 'A2', '2017-04-24 10:32:21'),
(44, 12, 'B2', '2017-04-24 10:32:21'),
(44, 13, 'C2', '2017-04-24 10:32:21'),
(44, 14, 'D2', '2017-04-24 10:32:21'),
(44, 15, 'E2', '2017-04-24 10:32:21'),
(44, 16, 'F2', '2017-04-24 10:32:22'),
(44, 17, 'G2', '2017-04-24 10:32:22'),
(44, 18, 'H2', '2017-04-24 10:32:22'),
(44, 19, 'C8', '2017-04-24 10:32:21'),
(44, 20, 'F8', '2017-04-24 10:32:22'),
(44, 21, 'B8', '2017-04-24 10:32:21'),
(44, 22, 'G8', '2017-04-24 10:32:22'),
(44, 23, 'A8', '2017-04-24 10:32:21'),
(44, 24, 'H8', '2017-04-24 10:32:22'),
(44, 25, 'A7', '2017-04-24 10:32:21'),
(44, 26, 'B7', '2017-04-24 10:32:21'),
(44, 27, 'C7', '2017-04-24 10:32:21'),
(44, 28, 'D7', '2017-04-24 10:32:21'),
(44, 29, 'E7', '2017-04-24 10:32:21'),
(44, 30, 'F7', '2017-04-24 10:32:22'),
(44, 31, 'G7', '2017-04-24 10:32:22'),
(44, 32, 'H7', '2017-04-24 10:32:22'),
(45, 1, 'E1', '2017-04-26 06:53:24'),
(45, 2, 'D1', '2017-04-26 06:53:24'),
(45, 3, 'E8', '2017-04-26 06:53:24'),
(45, 4, 'D8', '2017-04-26 06:53:24'),
(45, 5, 'C1', '2017-04-26 06:53:23'),
(45, 6, 'F1', '2017-04-26 06:53:24'),
(45, 7, 'B1', '2017-04-26 06:53:23'),
(45, 8, 'G1', '2017-04-26 06:53:24'),
(45, 9, 'A1', '2017-04-26 06:53:23'),
(45, 10, 'H1', '2017-04-26 06:53:25'),
(45, 11, 'A2', '2017-04-26 06:53:23'),
(45, 12, 'B2', '2017-04-26 06:53:23'),
(45, 13, 'C2', '2017-04-26 06:53:23'),
(45, 14, 'D2', '2017-04-26 06:53:24'),
(45, 15, 'E2', '2017-04-26 06:53:24'),
(45, 16, 'F2', '2017-04-26 06:53:24'),
(45, 17, 'G2', '2017-04-26 06:53:24'),
(45, 18, 'H2', '2017-04-26 06:53:25'),
(45, 19, 'C8', '2017-04-26 06:53:24'),
(45, 20, 'F8', '2017-04-26 06:53:24'),
(45, 21, 'B8', '2017-04-26 06:53:23'),
(45, 22, 'G8', '2017-04-26 06:53:25'),
(45, 23, 'A8', '2017-04-26 06:53:23'),
(45, 24, 'H8', '2017-04-26 06:53:25'),
(45, 25, 'A7', '2017-04-26 06:53:23'),
(45, 26, 'B7', '2017-04-26 06:53:23'),
(45, 27, 'C7', '2017-04-26 06:53:23'),
(45, 28, 'D7', '2017-04-26 06:53:24'),
(45, 29, 'E7', '2017-04-26 06:53:24'),
(45, 30, 'F7', '2017-04-26 06:53:24'),
(45, 31, 'G7', '2017-04-26 06:53:25'),
(45, 32, 'H7', '2017-04-26 06:53:25'),
(46, 1, 'E1', '2017-04-26 06:58:05'),
(46, 2, 'D1', '2017-04-26 06:58:05'),
(46, 3, 'E8', '2017-04-26 06:58:05'),
(46, 4, 'D8', '2017-04-26 06:58:05'),
(46, 5, 'C1', '2017-04-26 06:58:04'),
(46, 6, 'F1', '2017-04-26 06:58:05'),
(46, 7, 'B1', '2017-04-26 06:58:04'),
(46, 8, 'G1', '2017-04-26 06:58:06'),
(46, 9, 'A1', '2017-04-26 06:58:04'),
(46, 10, 'H1', '2017-04-26 06:58:06'),
(46, 11, 'A2', '2017-04-26 06:58:04'),
(46, 12, 'B2', '2017-04-26 06:58:04'),
(46, 13, 'C2', '2017-04-26 06:58:05'),
(46, 14, 'D2', '2017-04-26 06:58:05'),
(46, 15, 'E2', '2017-04-26 06:58:05'),
(46, 16, 'F2', '2017-04-26 06:58:05'),
(46, 17, 'G2', '2017-04-26 06:58:06'),
(46, 18, 'H2', '2017-04-26 06:58:06'),
(46, 19, 'C8', '2017-04-26 06:58:05'),
(46, 20, 'F8', '2017-04-26 06:58:06'),
(46, 21, 'B8', '2017-04-26 06:58:04'),
(46, 22, 'G8', '2017-04-26 06:58:06'),
(46, 23, 'A8', '2017-04-26 06:58:04'),
(46, 24, 'H8', '2017-04-26 06:58:06'),
(46, 25, 'A7', '2017-04-26 06:58:04'),
(46, 26, 'B7', '2017-04-26 06:58:04'),
(46, 27, 'C7', '2017-04-26 06:58:05'),
(46, 28, 'D7', '2017-04-26 06:58:05'),
(46, 29, 'E7', '2017-04-26 06:58:05'),
(46, 30, 'F7', '2017-04-26 06:58:05'),
(46, 31, 'G7', '2017-04-26 06:58:06'),
(46, 32, 'H7', '2017-04-26 06:58:06'),
(47, 1, 'E1', '2017-04-26 07:09:55'),
(47, 2, 'D1', '2017-04-26 07:09:54'),
(47, 3, 'E8', '2017-04-26 07:09:55'),
(47, 4, 'D8', '2017-04-26 07:09:55'),
(47, 5, 'C1', '2017-04-26 07:09:54'),
(47, 6, 'F1', '2017-04-26 07:09:55'),
(47, 7, 'B1', '2017-04-26 07:09:54'),
(47, 8, 'G1', '2017-04-26 07:09:55'),
(47, 9, 'A1', '2017-04-26 07:09:54'),
(47, 10, 'H1', '2017-04-26 07:09:55'),
(47, 11, 'A2', '2017-04-26 07:09:54'),
(47, 12, 'B2', '2017-04-26 07:09:54'),
(47, 13, 'C2', '2017-04-26 07:09:54'),
(47, 14, 'D2', '2017-04-26 07:09:55'),
(47, 15, 'E2', '2017-04-26 07:09:55'),
(47, 16, 'F2', '2017-04-26 07:09:55'),
(47, 17, 'G2', '2017-04-26 07:09:55'),
(47, 18, 'H2', '2017-04-26 07:09:55'),
(47, 19, 'C8', '2017-04-26 07:09:54'),
(47, 20, 'F8', '2017-04-26 07:09:55'),
(47, 21, 'B8', '2017-04-26 07:09:54'),
(47, 22, 'G8', '2017-04-26 07:09:55'),
(47, 23, 'A8', '2017-04-26 07:09:54'),
(47, 24, 'H8', '2017-04-26 07:09:55'),
(47, 25, 'A7', '2017-04-26 07:09:54'),
(47, 26, 'B7', '2017-04-26 07:09:54'),
(47, 27, 'C7', '2017-04-26 07:09:54'),
(47, 28, 'D7', '2017-04-26 07:09:55'),
(47, 29, 'E7', '2017-04-26 07:09:55'),
(47, 30, 'F7', '2017-04-26 07:09:55'),
(47, 31, 'G7', '2017-04-26 07:09:55'),
(47, 32, 'H7', '2017-04-26 07:09:55'),
(48, 1, 'E1', '2017-04-26 07:13:43'),
(48, 2, 'D1', '2017-04-26 07:13:43'),
(48, 3, 'E8', '2017-04-26 07:13:44'),
(48, 4, 'D8', '2017-04-26 07:13:43'),
(48, 5, 'C1', '2017-04-26 07:13:43'),
(48, 6, 'F1', '2017-04-26 07:13:44'),
(48, 7, 'B1', '2017-04-26 07:13:43'),
(48, 8, 'G1', '2017-04-26 07:13:44'),
(48, 9, 'A1', '2017-04-26 07:13:42'),
(48, 10, 'H1', '2017-04-26 07:13:44'),
(48, 11, 'A2', '2017-04-26 07:13:42'),
(48, 12, 'B2', '2017-04-26 07:13:43'),
(48, 13, 'C2', '2017-04-26 07:13:43'),
(48, 14, 'D2', '2017-04-26 07:13:43'),
(48, 15, 'E2', '2017-04-26 07:13:43'),
(48, 16, 'F2', '2017-04-26 07:13:44'),
(48, 17, 'G2', '2017-04-26 07:13:44'),
(48, 18, 'H2', '2017-04-26 07:13:44'),
(48, 19, 'C8', '2017-04-26 07:13:43'),
(48, 20, 'F8', '2017-04-26 07:13:44'),
(48, 21, 'B8', '2017-04-26 07:13:43'),
(48, 22, 'G8', '2017-04-26 07:13:44'),
(48, 23, 'A8', '2017-04-26 07:13:43'),
(48, 24, 'H8', '2017-04-26 07:13:44'),
(48, 25, 'A7', '2017-04-26 07:13:43'),
(48, 26, 'B7', '2017-04-26 07:13:43'),
(48, 27, 'C7', '2017-04-26 07:13:43'),
(48, 28, 'D7', '2017-04-26 07:13:43'),
(48, 29, 'E7', '2017-04-26 07:13:44'),
(48, 30, 'F7', '2017-04-26 07:13:44'),
(48, 31, 'G7', '2017-04-26 07:13:44'),
(48, 32, 'H7', '2017-04-26 07:13:44'),
(49, 1, 'E1', '2017-04-26 07:16:12'),
(49, 2, 'D1', '2017-04-26 07:16:12'),
(49, 3, 'E8', '2017-04-26 07:16:12'),
(49, 4, 'D8', '2017-04-26 07:16:12'),
(49, 5, 'C1', '2017-04-26 07:16:12'),
(49, 6, 'F1', '2017-04-26 07:16:12'),
(49, 7, 'B1', '2017-04-26 07:16:11'),
(49, 8, 'G1', '2017-04-26 07:16:13'),
(49, 9, 'A1', '2017-04-26 07:16:11'),
(49, 10, 'H1', '2017-04-26 07:16:13'),
(49, 11, 'A2', '2017-04-26 07:16:11'),
(49, 12, 'B2', '2017-04-26 07:16:11'),
(49, 13, 'C2', '2017-04-26 07:16:12'),
(49, 14, 'D2', '2017-04-26 07:16:12'),
(49, 15, 'E2', '2017-04-26 07:16:12'),
(49, 16, 'F2', '2017-04-26 07:16:12'),
(49, 17, 'G2', '2017-04-26 07:16:13'),
(49, 18, 'H2', '2017-04-26 07:16:13'),
(49, 19, 'C8', '2017-04-26 07:16:12'),
(49, 20, 'F8', '2017-04-26 07:16:13'),
(49, 21, 'B8', '2017-04-26 07:16:12'),
(49, 22, 'G8', '2017-04-26 07:16:13'),
(49, 23, 'A8', '2017-04-26 07:16:11'),
(49, 24, 'H8', '2017-04-26 07:16:13'),
(49, 25, 'A7', '2017-04-26 07:16:11'),
(49, 26, 'B7', '2017-04-26 07:16:12'),
(49, 27, 'C7', '2017-04-26 07:16:12'),
(49, 28, 'D7', '2017-04-26 07:16:12'),
(49, 29, 'E7', '2017-04-26 07:16:12'),
(49, 30, 'F7', '2017-04-26 07:16:13'),
(49, 31, 'G7', '2017-04-26 07:16:13'),
(49, 32, 'H7', '2017-04-26 07:16:13'),
(50, 1, 'E1', '2017-04-26 07:19:21'),
(50, 2, 'D1', '2017-04-26 07:19:21'),
(50, 3, 'E8', '2017-04-26 07:19:21'),
(50, 4, 'D8', '2017-04-26 07:19:21'),
(50, 5, 'C1', '2017-04-26 07:19:20'),
(50, 6, 'F1', '2017-04-26 07:19:21'),
(50, 7, 'B1', '2017-04-26 07:19:20'),
(50, 8, 'G1', '2017-04-26 07:19:21'),
(50, 9, 'A1', '2017-04-26 07:19:20'),
(50, 10, 'H1', '2017-04-26 07:19:21'),
(50, 11, 'A2', '2017-04-26 07:19:20'),
(50, 12, 'B2', '2017-04-26 07:19:20'),
(50, 13, 'C2', '2017-04-26 07:19:20'),
(50, 14, 'D2', '2017-04-26 07:19:21'),
(50, 15, 'E2', '2017-04-26 07:19:21'),
(50, 16, 'F2', '2017-04-26 07:19:21'),
(50, 17, 'G2', '2017-04-26 07:19:21'),
(50, 18, 'H2', '2017-04-26 07:19:22'),
(50, 19, 'C8', '2017-04-26 07:19:21'),
(50, 20, 'F8', '2017-04-26 07:19:21'),
(50, 21, 'B8', '2017-04-26 07:19:20'),
(50, 22, 'G8', '2017-04-26 07:19:21'),
(50, 23, 'A8', '2017-04-26 07:19:20'),
(50, 24, 'H8', '2017-04-26 07:19:22'),
(50, 25, 'A7', '2017-04-26 07:19:20'),
(50, 26, 'B7', '2017-04-26 07:19:20'),
(50, 27, 'C7', '2017-04-26 07:19:21'),
(50, 28, 'D7', '2017-04-26 07:19:21'),
(50, 29, 'E7', '2017-04-26 07:19:21'),
(50, 30, 'F7', '2017-04-26 07:19:21'),
(50, 31, 'G7', '2017-04-26 07:19:21'),
(50, 32, 'H7', '2017-04-26 07:19:22'),
(51, 1, 'E1', '2017-04-26 07:21:03'),
(51, 2, 'D1', '2017-04-26 07:21:02'),
(51, 3, 'E8', '2017-04-26 07:21:03'),
(51, 4, 'D8', '2017-04-26 07:21:03'),
(51, 5, 'C1', '2017-04-26 07:21:02'),
(51, 6, 'F1', '2017-04-26 07:21:03'),
(51, 7, 'B1', '2017-04-26 07:21:02'),
(51, 8, 'G1', '2017-04-26 07:21:03'),
(51, 9, 'A1', '2017-04-26 07:21:02'),
(51, 10, 'H1', '2017-04-26 07:21:03'),
(51, 11, 'A2', '2017-04-26 07:21:02'),
(51, 12, 'B2', '2017-04-26 07:21:02'),
(51, 13, 'C2', '2017-04-26 07:21:02'),
(51, 14, 'D2', '2017-04-26 07:21:03'),
(51, 15, 'E2', '2017-04-26 07:21:03'),
(51, 16, 'F2', '2017-04-26 07:21:03'),
(51, 17, 'G2', '2017-04-26 07:21:03'),
(51, 18, 'H2', '2017-04-26 07:21:03'),
(51, 19, 'C8', '2017-04-26 07:21:02'),
(51, 20, 'F8', '2017-04-26 07:21:03'),
(51, 21, 'B8', '2017-04-26 07:21:02'),
(51, 22, 'G8', '2017-04-26 07:21:03'),
(51, 23, 'A8', '2017-04-26 07:21:02'),
(51, 24, 'H8', '2017-04-26 07:21:03'),
(51, 25, 'A7', '2017-04-26 07:21:02'),
(51, 26, 'B7', '2017-04-26 07:21:02'),
(51, 27, 'C7', '2017-04-26 07:21:02'),
(51, 28, 'D7', '2017-04-26 07:21:03'),
(51, 29, 'E7', '2017-04-26 07:21:03'),
(51, 30, 'F7', '2017-04-26 07:21:03'),
(51, 31, 'G7', '2017-04-26 07:21:03'),
(51, 32, 'H7', '2017-04-26 07:21:03'),
(52, 1, 'E1', '2017-04-26 07:25:06'),
(52, 2, 'D1', '2017-04-26 07:25:06'),
(52, 3, 'E8', '2017-04-26 07:25:06'),
(52, 4, 'D8', '2017-04-26 07:25:06'),
(52, 5, 'C1', '2017-04-26 07:25:06'),
(52, 6, 'F1', '2017-04-26 07:25:06'),
(52, 7, 'B1', '2017-04-26 07:25:06'),
(52, 8, 'G1', '2017-04-26 07:25:07'),
(52, 9, 'A1', '2017-04-26 07:25:06'),
(52, 10, 'H1', '2017-04-26 07:25:07'),
(52, 11, 'A2', '2017-04-26 07:25:06'),
(52, 12, 'B2', '2017-04-26 07:25:06'),
(52, 13, 'C2', '2017-04-26 07:25:06'),
(52, 14, 'D2', '2017-04-26 07:25:06'),
(52, 15, 'E2', '2017-04-26 07:25:06'),
(52, 16, 'F2', '2017-04-26 07:25:06'),
(52, 17, 'G2', '2017-04-26 07:25:07'),
(52, 18, 'H2', '2017-04-26 07:25:07'),
(52, 19, 'C8', '2017-04-26 07:25:06'),
(52, 20, 'F8', '2017-04-26 07:25:07'),
(52, 21, 'B8', '2017-04-26 07:25:06'),
(52, 22, 'G8', '2017-04-26 07:25:07'),
(52, 23, 'A8', '2017-04-26 07:25:06'),
(52, 24, 'H8', '2017-04-26 07:25:07'),
(52, 25, 'A7', '2017-04-26 07:25:06'),
(52, 26, 'B7', '2017-04-26 07:25:06'),
(52, 27, 'C7', '2017-04-26 07:25:06'),
(52, 28, 'D7', '2017-04-26 07:25:06'),
(52, 29, 'E7', '2017-04-26 07:25:06'),
(52, 30, 'F7', '2017-04-26 07:25:06'),
(52, 31, 'G7', '2017-04-26 07:25:07'),
(52, 32, 'H7', '2017-04-26 07:25:07'),
(53, 1, 'E1', '2017-04-26 07:32:25'),
(53, 2, 'D1', '2017-04-26 07:32:25'),
(53, 3, 'E8', '2017-04-26 07:32:25'),
(53, 4, 'D8', '2017-04-26 07:32:25'),
(53, 5, 'C1', '2017-04-26 07:32:24'),
(53, 6, 'F1', '2017-04-26 07:32:25'),
(53, 7, 'B1', '2017-04-26 07:32:24'),
(53, 8, 'G1', '2017-04-26 07:32:25'),
(53, 9, 'A1', '2017-04-26 07:32:24'),
(53, 10, 'H1', '2017-04-26 07:32:25'),
(53, 11, 'A2', '2017-04-26 07:32:24'),
(53, 12, 'B2', '2017-04-26 07:32:24'),
(53, 13, 'C2', '2017-04-26 07:32:24'),
(53, 14, 'D2', '2017-04-26 07:32:25'),
(53, 15, 'E2', '2017-04-26 07:32:25'),
(53, 16, 'F2', '2017-04-26 07:32:25'),
(53, 17, 'G2', '2017-04-26 07:32:25'),
(53, 18, 'H2', '2017-04-26 07:32:25'),
(53, 19, 'C8', '2017-04-26 07:32:24'),
(53, 20, 'F8', '2017-04-26 07:32:25'),
(53, 21, 'B8', '2017-04-26 07:32:24'),
(53, 22, 'G8', '2017-04-26 07:32:25'),
(53, 23, 'A8', '2017-04-26 07:32:24'),
(53, 24, 'H8', '2017-04-26 07:32:25'),
(53, 25, 'A7', '2017-04-26 07:32:24'),
(53, 26, 'B7', '2017-04-26 07:32:24'),
(53, 27, 'C7', '2017-04-26 07:32:24'),
(53, 28, 'D7', '2017-04-26 07:32:25'),
(53, 29, 'E7', '2017-04-26 07:32:25'),
(53, 30, 'F7', '2017-04-26 07:32:25'),
(53, 31, 'G7', '2017-04-26 07:32:25'),
(53, 32, 'H7', '2017-04-26 07:32:25'),
(54, 1, 'E1', '2017-04-26 07:38:04'),
(54, 2, 'D1', '2017-04-26 07:38:04'),
(54, 3, 'E8', '2017-04-26 07:38:04'),
(54, 4, 'D8', '2017-04-26 07:38:04'),
(54, 5, 'C1', '2017-04-26 07:38:04'),
(54, 6, 'F1', '2017-04-26 07:38:04'),
(54, 7, 'B1', '2017-04-26 07:38:03'),
(54, 8, 'G1', '2017-04-26 07:38:04'),
(54, 9, 'A1', '2017-04-26 07:38:03'),
(54, 10, 'H1', '2017-04-26 07:38:04'),
(54, 11, 'A2', '2017-04-26 07:38:03'),
(54, 12, 'B2', '2017-04-26 07:38:03'),
(54, 13, 'C2', '2017-04-26 07:38:04'),
(54, 14, 'D2', '2017-04-26 07:38:04'),
(54, 15, 'E2', '2017-04-26 07:38:04'),
(54, 16, 'F2', '2017-04-26 07:38:04'),
(54, 17, 'G2', '2017-04-26 07:38:04'),
(54, 18, 'H2', '2017-04-26 07:38:04'),
(54, 19, 'C8', '2017-04-26 07:38:04'),
(54, 20, 'F8', '2017-04-26 07:38:04'),
(54, 21, 'B8', '2017-04-26 07:38:04'),
(54, 22, 'G8', '2017-04-26 07:38:04'),
(54, 23, 'A8', '2017-04-26 07:38:03'),
(54, 24, 'H8', '2017-04-26 07:38:04'),
(54, 25, 'A7', '2017-04-26 07:38:03'),
(54, 26, 'B7', '2017-04-26 07:38:03'),
(54, 27, 'C7', '2017-04-26 07:38:04'),
(54, 28, 'D7', '2017-04-26 07:38:04'),
(54, 29, 'E7', '2017-04-26 07:38:04'),
(54, 30, 'F7', '2017-04-26 07:38:04'),
(54, 31, 'G7', '2017-04-26 07:38:04'),
(54, 32, 'H7', '2017-04-26 07:38:04'),
(55, 1, 'E1', '2017-04-26 07:41:15'),
(55, 2, 'D1', '2017-04-26 07:41:15'),
(55, 3, 'E8', '2017-04-26 07:41:15'),
(55, 4, 'D8', '2017-04-26 07:41:15'),
(55, 5, 'C1', '2017-04-26 07:41:14'),
(55, 6, 'F1', '2017-04-26 07:41:15'),
(55, 7, 'B1', '2017-04-26 07:41:14'),
(55, 8, 'G1', '2017-04-26 07:41:15'),
(55, 9, 'A1', '2017-04-26 07:41:14'),
(55, 10, 'H1', '2017-04-26 07:41:16'),
(55, 11, 'A2', '2017-04-26 07:41:14'),
(55, 12, 'B2', '2017-04-26 07:41:14'),
(55, 13, 'C2', '2017-04-26 07:41:14'),
(55, 14, 'D2', '2017-04-26 07:41:15'),
(55, 15, 'E2', '2017-04-26 07:41:15'),
(55, 16, 'F2', '2017-04-26 07:41:15'),
(55, 17, 'G2', '2017-04-26 07:41:15'),
(55, 18, 'H2', '2017-04-26 07:41:16'),
(55, 19, 'C8', '2017-04-26 07:41:15'),
(55, 20, 'F8', '2017-04-26 07:41:15'),
(55, 21, 'B8', '2017-04-26 07:41:14'),
(55, 22, 'G8', '2017-04-26 07:41:15'),
(55, 23, 'A8', '2017-04-26 07:41:14'),
(55, 24, 'H8', '2017-04-26 07:41:16'),
(55, 25, 'A7', '2017-04-26 07:41:14'),
(55, 26, 'B7', '2017-04-26 07:41:14'),
(55, 27, 'C7', '2017-04-26 07:41:15'),
(55, 28, 'D7', '2017-04-26 07:41:15'),
(55, 29, 'E7', '2017-04-26 07:41:15'),
(55, 30, 'F7', '2017-04-26 07:41:15'),
(55, 31, 'G7', '2017-04-26 07:41:15'),
(55, 32, 'H7', '2017-04-26 07:41:16'),
(56, 1, 'E1', '2017-04-26 07:42:55'),
(56, 2, 'D1', '2017-04-26 07:42:54'),
(56, 3, 'E8', '2017-04-26 07:42:55'),
(56, 4, 'D8', '2017-04-26 07:42:54'),
(56, 5, 'C1', '2017-04-26 07:42:54'),
(56, 6, 'F1', '2017-04-26 07:42:55'),
(56, 7, 'B1', '2017-04-26 07:42:54'),
(56, 8, 'G1', '2017-04-26 07:42:55'),
(56, 9, 'A1', '2017-04-26 07:42:54'),
(56, 10, 'H1', '2017-04-26 07:42:55'),
(56, 11, 'A2', '2017-04-26 07:42:54'),
(56, 12, 'B2', '2017-04-26 07:42:54'),
(56, 13, 'C2', '2017-04-26 07:42:54'),
(56, 14, 'D2', '2017-04-26 07:42:54'),
(56, 15, 'E2', '2017-04-26 07:42:55'),
(56, 16, 'F2', '2017-04-26 07:42:55'),
(56, 17, 'G2', '2017-04-26 07:42:55'),
(56, 18, 'H2', '2017-04-26 07:42:55'),
(56, 19, 'C8', '2017-04-26 07:42:54'),
(56, 20, 'F8', '2017-04-26 07:42:55'),
(56, 21, 'B8', '2017-04-26 07:42:54'),
(56, 22, 'G8', '2017-04-26 07:42:55'),
(56, 23, 'A8', '2017-04-26 07:42:54'),
(56, 24, 'H8', '2017-04-26 07:42:55'),
(56, 25, 'A7', '2017-04-26 07:42:54'),
(56, 26, 'B7', '2017-04-26 07:42:54'),
(56, 27, 'C7', '2017-04-26 07:42:54'),
(56, 28, 'D7', '2017-04-26 07:42:54'),
(56, 29, 'E7', '2017-04-26 07:42:55'),
(56, 30, 'F7', '2017-04-26 07:42:55'),
(56, 31, 'G7', '2017-04-26 07:42:55'),
(56, 32, 'H7', '2017-04-26 07:42:55'),
(57, 1, 'E1', '2017-04-26 07:45:17'),
(57, 2, 'D1', '2017-04-26 07:45:17'),
(57, 3, 'E8', '2017-04-26 07:45:17'),
(57, 4, 'D8', '2017-04-26 07:45:17'),
(57, 5, 'C1', '2017-04-26 07:45:17'),
(57, 6, 'F1', '2017-04-26 07:45:17'),
(57, 7, 'B1', '2017-04-26 07:45:16'),
(57, 8, 'G1', '2017-04-26 07:45:17'),
(57, 9, 'A1', '2017-04-26 07:45:16'),
(57, 10, 'H1', '2017-04-26 07:45:18'),
(57, 11, 'A2', '2017-04-26 07:45:16'),
(57, 12, 'B2', '2017-04-26 07:45:17'),
(57, 13, 'C2', '2017-04-26 07:45:17'),
(57, 14, 'D2', '2017-04-26 07:45:17'),
(57, 15, 'E2', '2017-04-26 07:45:17'),
(57, 16, 'F2', '2017-04-26 07:45:17'),
(57, 17, 'G2', '2017-04-26 07:45:17'),
(57, 18, 'H2', '2017-04-26 07:45:18'),
(57, 19, 'C8', '2017-04-26 07:45:17'),
(57, 20, 'F8', '2017-04-26 07:45:17'),
(57, 21, 'B8', '2017-04-26 07:45:17'),
(57, 22, 'G8', '2017-04-26 07:45:17'),
(57, 23, 'A8', '2017-04-26 07:45:16'),
(57, 24, 'H8', '2017-04-26 07:45:18'),
(57, 25, 'A7', '2017-04-26 07:45:16'),
(57, 26, 'B7', '2017-04-26 07:45:17'),
(57, 27, 'C7', '2017-04-26 07:45:17'),
(57, 28, 'D7', '2017-04-26 07:45:17'),
(57, 29, 'E7', '2017-04-26 07:45:17'),
(57, 30, 'F7', '2017-04-26 07:45:17'),
(57, 31, 'G7', '2017-04-26 07:45:17'),
(57, 32, 'H7', '2017-04-26 07:45:18'),
(58, 1, 'E1', '2017-04-26 07:49:56'),
(58, 2, 'D1', '2017-04-26 07:49:55'),
(58, 3, 'E8', '2017-04-26 07:49:56'),
(58, 4, 'D8', '2017-04-26 07:49:56'),
(58, 5, 'C1', '2017-04-26 07:49:55'),
(58, 6, 'F1', '2017-04-26 07:49:56'),
(58, 7, 'B1', '2017-04-26 07:49:55'),
(58, 8, 'G1', '2017-04-26 07:49:56'),
(58, 9, 'A1', '2017-04-26 07:49:55'),
(58, 10, 'H1', '2017-04-26 07:49:56'),
(58, 11, 'A2', '2017-04-26 07:49:55'),
(58, 12, 'B2', '2017-04-26 07:49:55'),
(58, 13, 'C2', '2017-04-26 07:49:55'),
(58, 14, 'D2', '2017-04-26 07:49:55'),
(58, 15, 'E2', '2017-04-26 07:49:56'),
(58, 16, 'F2', '2017-04-26 07:49:56'),
(58, 17, 'G2', '2017-04-26 07:49:56'),
(58, 18, 'H2', '2017-04-26 07:49:56'),
(58, 19, 'C8', '2017-04-26 07:49:55'),
(58, 20, 'F8', '2017-04-26 07:49:56'),
(58, 21, 'B8', '2017-04-26 07:49:55'),
(58, 22, 'G8', '2017-04-26 07:49:56'),
(58, 23, 'A8', '2017-04-26 07:49:55'),
(58, 24, 'H8', '2017-04-26 07:49:56'),
(58, 25, 'A7', '2017-04-26 07:49:55'),
(58, 26, 'B7', '2017-04-26 07:49:55'),
(58, 27, 'C7', '2017-04-26 07:49:55'),
(58, 28, 'D7', '2017-04-26 07:49:56'),
(58, 29, 'E7', '2017-04-26 07:49:56'),
(58, 30, 'F7', '2017-04-26 07:49:56'),
(58, 31, 'G7', '2017-04-26 07:49:56'),
(58, 32, 'H7', '2017-04-26 07:49:56'),
(59, 1, 'E1', '2017-04-26 07:54:23'),
(59, 2, 'D1', '2017-04-26 07:54:23'),
(59, 3, 'E8', '2017-04-26 07:54:23'),
(59, 4, 'D8', '2017-04-26 07:54:23'),
(59, 5, 'C1', '2017-04-26 07:54:22'),
(59, 6, 'F1', '2017-04-26 07:54:23'),
(59, 7, 'B1', '2017-04-26 07:54:22'),
(59, 8, 'G1', '2017-04-26 07:54:23'),
(59, 9, 'A1', '2017-04-26 07:54:22'),
(59, 10, 'H1', '2017-04-26 07:54:23'),
(59, 11, 'A2', '2017-04-26 07:54:22'),
(59, 12, 'B2', '2017-04-26 07:54:22'),
(59, 13, 'C2', '2017-04-26 07:54:22'),
(59, 14, 'D2', '2017-04-26 07:54:23'),
(59, 15, 'E2', '2017-04-26 07:54:23'),
(59, 16, 'F2', '2017-04-26 07:54:23'),
(59, 17, 'G2', '2017-04-26 07:54:23'),
(59, 18, 'H2', '2017-04-26 07:54:24'),
(59, 19, 'C8', '2017-04-26 07:54:22'),
(59, 20, 'F8', '2017-04-26 07:54:23'),
(59, 21, 'B8', '2017-04-26 07:54:22'),
(59, 22, 'G8', '2017-04-26 07:54:23'),
(59, 23, 'A8', '2017-04-26 07:54:22'),
(59, 24, 'H8', '2017-04-26 07:54:24'),
(59, 25, 'A7', '2017-04-26 07:54:22'),
(59, 26, 'B7', '2017-04-26 07:54:22'),
(59, 27, 'C7', '2017-04-26 07:54:22'),
(59, 28, 'D7', '2017-04-26 07:54:23'),
(59, 29, 'E7', '2017-04-26 07:54:23'),
(59, 30, 'F7', '2017-04-26 07:54:23'),
(59, 31, 'G7', '2017-04-26 07:54:23'),
(59, 32, 'H7', '2017-04-26 07:54:24'),
(60, 1, 'E1', '2017-04-26 07:57:10'),
(60, 2, 'D1', '2017-04-26 07:57:09'),
(60, 3, 'E8', '2017-04-26 07:57:10'),
(60, 4, 'D8', '2017-04-26 07:57:10'),
(60, 5, 'C1', '2017-04-26 07:57:09'),
(60, 6, 'F1', '2017-04-26 07:57:10'),
(60, 7, 'B1', '2017-04-26 07:57:09'),
(60, 8, 'G1', '2017-04-26 07:57:10'),
(60, 9, 'A1', '2017-04-26 07:57:09'),
(60, 10, 'H1', '2017-04-26 07:57:10'),
(60, 11, 'A2', '2017-04-26 07:57:09'),
(60, 12, 'B2', '2017-04-26 07:57:09'),
(60, 13, 'C2', '2017-04-26 07:57:09'),
(60, 14, 'D2', '2017-04-26 07:57:10'),
(60, 15, 'E2', '2017-04-26 07:57:10'),
(60, 16, 'F2', '2017-04-26 07:57:10'),
(60, 17, 'G2', '2017-04-26 07:57:10'),
(60, 18, 'H2', '2017-04-26 07:57:10'),
(60, 19, 'C8', '2017-04-26 07:57:09'),
(60, 20, 'F8', '2017-04-26 07:57:10'),
(60, 21, 'B8', '2017-04-26 07:57:09'),
(60, 22, 'G8', '2017-04-26 07:57:10'),
(60, 23, 'A8', '2017-04-26 07:57:09'),
(60, 24, 'H8', '2017-04-26 07:57:10'),
(60, 25, 'A7', '2017-04-26 07:57:09'),
(60, 26, 'B7', '2017-04-26 07:57:09'),
(60, 27, 'C7', '2017-04-26 07:57:09'),
(60, 28, 'D7', '2017-04-26 07:57:10'),
(60, 29, 'E7', '2017-04-26 07:57:10'),
(60, 30, 'F7', '2017-04-26 07:57:10'),
(60, 31, 'G7', '2017-04-26 07:57:10'),
(60, 32, 'H7', '2017-04-26 07:57:10'),
(61, 1, 'E1', '2017-04-26 08:00:34'),
(61, 2, 'D1', '2017-04-26 08:00:33'),
(61, 3, 'E8', '2017-04-26 08:00:34'),
(61, 4, 'D8', '2017-04-26 08:00:33'),
(61, 5, 'C1', '2017-04-26 08:00:33'),
(61, 6, 'F1', '2017-04-26 08:00:34'),
(61, 7, 'B1', '2017-04-26 08:00:33'),
(61, 8, 'G1', '2017-04-26 08:00:34'),
(61, 9, 'A1', '2017-04-26 08:00:33'),
(61, 10, 'H1', '2017-04-26 08:00:34'),
(61, 11, 'A2', '2017-04-26 08:00:33'),
(61, 12, 'B2', '2017-04-26 08:00:33'),
(61, 13, 'C2', '2017-04-26 08:00:33'),
(61, 14, 'D2', '2017-04-26 08:00:33'),
(61, 15, 'E2', '2017-04-26 08:00:34'),
(61, 16, 'F2', '2017-04-26 08:00:34'),
(61, 17, 'G2', '2017-04-26 08:00:34'),
(61, 18, 'H2', '2017-04-26 08:00:34'),
(61, 19, 'C8', '2017-04-26 08:00:33'),
(61, 20, 'F8', '2017-04-26 08:00:34'),
(61, 21, 'B8', '2017-04-26 08:00:33'),
(61, 22, 'G8', '2017-04-26 08:00:34'),
(61, 23, 'A8', '2017-04-26 08:00:33'),
(61, 24, 'H8', '2017-04-26 08:00:34'),
(61, 25, 'A7', '2017-04-26 08:00:33'),
(61, 26, 'B7', '2017-04-26 08:00:33'),
(61, 27, 'C7', '2017-04-26 08:00:33'),
(61, 28, 'D7', '2017-04-26 08:00:33'),
(61, 29, 'E7', '2017-04-26 08:00:34'),
(61, 30, 'F7', '2017-04-26 08:00:34'),
(61, 31, 'G7', '2017-04-26 08:00:34'),
(61, 32, 'H7', '2017-04-26 08:00:34'),
(62, 1, 'E1', '2017-04-26 08:03:27'),
(62, 2, 'D1', '2017-04-26 08:03:26'),
(62, 3, 'E8', '2017-04-26 08:03:27'),
(62, 4, 'D8', '2017-04-26 08:03:26'),
(62, 5, 'C1', '2017-04-26 08:03:26'),
(62, 6, 'F1', '2017-04-26 08:03:27'),
(62, 7, 'B1', '2017-04-26 08:03:26'),
(62, 8, 'G1', '2017-04-26 08:03:27'),
(62, 9, 'A1', '2017-04-26 08:03:25'),
(62, 10, 'H1', '2017-04-26 08:03:27'),
(62, 11, 'A2', '2017-04-26 08:03:26'),
(62, 12, 'B2', '2017-04-26 08:03:26'),
(62, 13, 'C2', '2017-04-26 08:03:26'),
(62, 14, 'D2', '2017-04-26 08:03:26'),
(62, 15, 'E2', '2017-04-26 08:03:27'),
(62, 16, 'F2', '2017-04-26 08:03:27'),
(62, 17, 'G2', '2017-04-26 08:03:27'),
(62, 18, 'H2', '2017-04-26 08:03:27'),
(62, 19, 'C8', '2017-04-26 08:03:26'),
(62, 20, 'F8', '2017-04-26 08:03:27'),
(62, 21, 'B8', '2017-04-26 08:03:26'),
(62, 22, 'G8', '2017-04-26 08:03:27'),
(62, 23, 'A8', '2017-04-26 08:03:26'),
(62, 24, 'H8', '2017-04-26 08:03:27'),
(62, 25, 'A7', '2017-04-26 08:03:26'),
(62, 26, 'B7', '2017-04-26 08:03:26'),
(62, 27, 'C7', '2017-04-26 08:03:26'),
(62, 28, 'D7', '2017-04-26 08:03:26'),
(62, 29, 'E7', '2017-04-26 08:03:27'),
(62, 30, 'F7', '2017-04-26 08:03:27'),
(62, 31, 'G7', '2017-04-26 08:03:27'),
(62, 32, 'H7', '2017-04-26 08:03:27'),
(63, 1, 'E1', '2017-04-26 08:21:50'),
(63, 2, 'D1', '2017-04-26 08:21:50'),
(63, 3, 'E8', '2017-04-26 08:21:50'),
(63, 4, 'D8', '2017-04-26 08:21:50'),
(63, 5, 'C1', '2017-04-26 08:21:49'),
(63, 6, 'F1', '2017-04-26 08:21:50'),
(63, 7, 'B1', '2017-04-26 08:21:49'),
(63, 8, 'G1', '2017-04-26 08:21:50'),
(63, 9, 'A1', '2017-04-26 08:21:49'),
(63, 10, 'H1', '2017-04-26 08:21:50'),
(63, 11, 'A2', '2017-04-26 08:21:49'),
(63, 12, 'B2', '2017-04-26 08:21:49'),
(63, 13, 'C2', '2017-04-26 08:21:50'),
(63, 14, 'D2', '2017-04-26 08:21:50'),
(63, 15, 'E2', '2017-04-26 08:21:50'),
(63, 16, 'F2', '2017-04-26 08:21:50'),
(63, 17, 'G2', '2017-04-26 08:21:50'),
(63, 18, 'H2', '2017-04-26 08:21:50'),
(63, 19, 'C8', '2017-04-26 08:21:50'),
(63, 20, 'F8', '2017-04-26 08:21:50'),
(63, 21, 'B8', '2017-04-26 08:21:49'),
(63, 22, 'G8', '2017-04-26 08:21:50'),
(63, 23, 'A8', '2017-04-26 08:21:49'),
(63, 24, 'H8', '2017-04-26 08:21:51'),
(63, 25, 'A7', '2017-04-26 08:21:49'),
(63, 26, 'B7', '2017-04-26 08:21:49'),
(63, 27, 'C7', '2017-04-26 08:21:50'),
(63, 28, 'D7', '2017-04-26 08:21:50'),
(63, 29, 'E7', '2017-04-26 08:21:50'),
(63, 30, 'F7', '2017-04-26 08:21:50'),
(63, 31, 'G7', '2017-04-26 08:21:50'),
(63, 32, 'H7', '2017-04-26 08:21:51'),
(64, 1, 'E1', '2017-04-26 08:23:27'),
(64, 2, 'D1', '2017-04-26 08:23:27'),
(64, 3, 'E8', '2017-04-26 08:23:27'),
(64, 4, 'D8', '2017-04-26 08:23:27'),
(64, 5, 'C1', '2017-04-26 08:23:27'),
(64, 6, 'F1', '2017-04-26 08:23:27'),
(64, 7, 'B1', '2017-04-26 08:23:26'),
(64, 8, 'G1', '2017-04-26 08:23:28'),
(64, 9, 'A1', '2017-04-26 08:23:26'),
(64, 10, 'H1', '2017-04-26 08:23:28'),
(64, 11, 'A2', '2017-04-26 08:23:26'),
(64, 12, 'B2', '2017-04-26 08:23:27'),
(64, 13, 'C2', '2017-04-26 08:23:27'),
(64, 14, 'D2', '2017-04-26 08:23:27'),
(64, 15, 'E2', '2017-04-26 08:23:27'),
(64, 16, 'F2', '2017-04-26 08:23:27'),
(64, 17, 'G2', '2017-04-26 08:23:28'),
(64, 18, 'H2', '2017-04-26 08:23:28'),
(64, 19, 'C8', '2017-04-26 08:23:27'),
(64, 20, 'F8', '2017-04-26 08:23:27'),
(64, 21, 'B8', '2017-04-26 08:23:27'),
(64, 22, 'G8', '2017-04-26 08:23:28'),
(64, 23, 'A8', '2017-04-26 08:23:26'),
(64, 24, 'H8', '2017-04-26 08:23:28'),
(64, 25, 'A7', '2017-04-26 08:23:26'),
(64, 26, 'B7', '2017-04-26 08:23:27'),
(64, 27, 'C7', '2017-04-26 08:23:27'),
(64, 28, 'D7', '2017-04-26 08:23:27'),
(64, 29, 'E7', '2017-04-26 08:23:27'),
(64, 30, 'F7', '2017-04-26 08:23:27'),
(64, 31, 'G7', '2017-04-26 08:23:28'),
(64, 32, 'H7', '2017-04-26 08:23:28'),
(65, 1, 'E1', '2017-05-03 13:36:52'),
(65, 2, 'D1', '2017-05-03 13:36:52'),
(65, 3, 'E8', '2017-05-03 13:36:52'),
(65, 4, 'D8', '2017-05-03 13:36:52'),
(65, 5, 'C1', '2017-05-03 13:36:51'),
(65, 6, 'F1', '2017-05-03 13:36:52'),
(65, 7, 'B1', '2017-05-03 13:36:51'),
(65, 8, 'G1', '2017-05-03 13:36:52'),
(65, 9, 'A1', '2017-05-03 13:36:51'),
(65, 10, 'H1', '2017-05-03 13:36:53'),
(65, 11, 'A2', '2017-05-03 13:36:51'),
(65, 12, 'B2', '2017-05-03 13:36:51'),
(65, 13, 'C2', '2017-05-03 13:36:51'),
(65, 14, 'D2', '2017-05-03 13:36:52'),
(65, 15, 'E2', '2017-05-03 13:36:52'),
(65, 16, 'F2', '2017-05-03 13:36:52'),
(65, 17, 'G2', '2017-05-03 13:36:52'),
(65, 18, 'H2', '2017-05-03 13:36:53'),
(65, 19, 'C8', '2017-05-03 13:36:52'),
(65, 20, 'F8', '2017-05-03 13:36:52'),
(65, 21, 'B8', '2017-05-03 13:36:51'),
(65, 22, 'G8', '2017-05-03 13:36:53'),
(65, 23, 'A8', '2017-05-03 13:36:51'),
(65, 24, 'H8', '2017-05-03 13:36:53'),
(65, 25, 'A7', '2017-05-03 13:36:51'),
(65, 26, 'B7', '2017-05-03 13:36:51'),
(65, 27, 'C7', '2017-05-03 13:36:51'),
(65, 28, 'D7', '2017-05-03 13:36:52'),
(65, 29, 'E7', '2017-05-03 13:36:52'),
(65, 30, 'F7', '2017-05-03 13:36:52'),
(65, 31, 'G7', '2017-05-03 13:36:53'),
(65, 32, 'H7', '2017-05-03 13:36:53');

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

--
-- Tabellenstruktur für Tabelle `spielzuege`
--

CREATE TABLE `spielzuege` (
  `spiel_id` int(11) NOT NULL,
  `zugnummer` int(11) NOT NULL,
  `spieler_id` int(11) NOT NULL,
  `alte_position` varchar(20) COLLATE latin1_german1_ci NOT NULL,
  `neue_position` varchar(20) COLLATE latin1_german1_ci NOT NULL,
  `figur_id` int(11) NOT NULL,
  `zeitpunkt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `spielzuege`
--

INSERT INTO `spielzuege` (`spiel_id`, `zugnummer`, `spieler_id`, `alte_position`, `neue_position`, `figur_id`, `zeitpunkt`) VALUES
(9, 1, 1, 'E7', 'E5', 29, '2017-03-03 16:08:22'),
(9, 1, 2, 'E2', 'E4', 15, '2017-03-03 16:08:03'),
(9, 2, 1, 'B8', 'C6', 21, '2017-03-03 16:08:49'),
(9, 2, 2, 'F1', 'C4', 6, '2017-03-03 16:08:36'),
(9, 3, 1, 'F8', 'C5', 19, '2017-03-03 16:09:12'),
(9, 3, 2, 'D1', 'F3', 2, '2017-03-03 16:08:59'),
(9, 4, 2, 'F3', 'F7', 2, '2017-03-03 16:09:24'),
(10, 1, 4, 'E2', 'E4', 15, '2017-03-03 16:08:03'),
(10, 1, 5, 'E7', 'E5', 29, '2017-03-03 16:08:22'),
(10, 2, 4, 'F1', 'C4', 6, '2017-03-03 16:08:36'),
(10, 2, 5, 'B8', 'C6', 21, '2017-03-03 16:08:49'),
(10, 3, 4, 'D1', 'F3', 2, '2017-03-03 16:08:59'),
(10, 3, 5, 'F8', 'C5', 19, '2017-03-03 16:09:12'),
(10, 4, 4, 'F3', 'F7', 2, '2017-03-03 16:09:24'),
(11, 1, 4, 'E2', 'E4', 15, '2017-03-03 16:08:03'),
(11, 1, 5, 'E7', 'E5', 29, '2017-03-03 16:08:22'),
(11, 2, 4, 'F1', 'C4', 6, '2017-03-03 16:08:36'),
(11, 2, 5, 'B8', 'C6', 21, '2017-03-03 16:08:49'),
(11, 3, 4, 'D1', 'F3', 2, '2017-03-03 16:08:59'),
(11, 3, 5, 'F8', 'C5', 19, '2017-03-03 16:09:12'),
(11, 4, 4, 'F3', 'F7', 2, '2017-03-03 16:09:24'),
(12, 1, 1, 'E7', 'E5', 29, '2017-03-03 16:08:22'),
(12, 1, 4, 'E2', 'E4', 15, '2017-03-03 16:08:03'),
(12, 2, 1, 'B8', 'C6', 21, '2017-03-03 16:08:49'),
(12, 2, 4, 'F1', 'C4', 6, '2017-03-03 16:08:36'),
(12, 3, 1, 'D1', 'F3', 2, '2017-03-03 16:09:12'),
(12, 3, 4, 'F8', 'C5', 19, '2017-03-03 16:08:59'),
(12, 4, 1, 'F3', 'F7', 2, '2017-03-03 16:09:24'),
(13, 1, 4, 'E2', 'E4', 15, '2017-03-03 22:42:28'),
(13, 1, 5, 'E7', 'E5', 29, '2017-03-03 22:42:31'),
(13, 2, 4, 'F1', 'C4', 6, '2017-03-03 22:42:34'),
(13, 2, 5, 'B8', 'C6', 21, '2017-03-03 22:42:37'),
(13, 3, 4, 'D1', 'F3', 2, '2017-03-03 22:42:40'),
(13, 3, 5, 'F8', 'C5', 19, '2017-03-03 22:42:43'),
(13, 4, 4, 'F3', 'F7', 2, '2017-03-03 22:42:46'),
(14, 1, 2, 'E2', 'E4', 15, '2017-03-03 22:46:11'),
(14, 1, 5, 'E7', 'E5', 29, '2017-03-03 22:46:14'),
(14, 2, 2, 'F1', 'C4', 6, '2017-03-03 22:46:17'),
(14, 2, 5, 'B8', 'C6', 21, '2017-03-03 22:46:20'),
(14, 3, 2, 'D1', 'F3', 2, '2017-03-03 22:46:23'),
(14, 3, 5, 'F8', 'C5', 19, '2017-03-03 22:46:26'),
(14, 4, 2, 'F3', 'F7', 2, '2017-03-03 22:46:29'),
(22, 1, 3, 'E2', 'E4', 15, '2017-03-26 21:13:48'),
(22, 1, 4, 'E7', 'E5', 29, '2017-03-26 21:13:51'),
(22, 2, 3, 'F1', 'C4', 6, '2017-03-26 21:13:54'),
(22, 2, 4, 'B8', 'C6', 21, '2017-03-26 21:13:57'),
(22, 3, 3, 'D1', 'F3', 2, '2017-03-26 21:14:00'),
(22, 3, 4, 'F8', 'C5', 19, '2017-03-26 21:14:03'),
(22, 4, 3, 'F3', 'F7', 2, '2017-03-26 21:14:06'),
(24, 1, 1, 'B2', 'A1', 3, '2017-03-31 10:56:02'),
(24, 1, 3, 'B2', 'A1', 3, '2017-03-31 10:56:06'),
(24, 2, 1, 'B2', 'A1', 3, '2017-03-31 10:56:10'),
(24, 2, 3, 'A1', 'B2', 3, '2017-03-31 10:56:12'),
(24, 3, 1, 'B2', 'A1', 3, '2017-03-31 10:56:18'),
(24, 3, 3, 'A1', 'B2', 3, '2017-03-31 10:57:25'),
(24, 4, 1, 'A1', 'B2', 3, '2017-03-31 10:57:29'),
(24, 4, 3, 'B2', 'A1', 3, '2017-03-31 10:57:35'),
(24, 5, 1, 'A1', 'B2', 3, '2017-03-31 10:57:49'),
(33, 1, 1, 'A1', 'B3', 2, '2017-04-10 13:25:35'),
(33, 1, 4, 'A1', 'A3', 2, '2017-04-10 13:25:39'),
(33, 2, 1, 'A1', 'A3', 2, '2017-04-10 13:25:42'),
(33, 2, 4, 'A1', 'A3', 2, '2017-04-10 13:25:44'),
(33, 3, 1, 'A1', 'A3', 2, '2017-04-10 13:25:47'),
(33, 3, 4, 'A1', 'A3', 2, '2017-04-10 13:25:49'),
(33, 4, 1, 'A1', 'A3', 2, '2017-04-10 13:25:51'),
(33, 4, 4, 'A1', 'A3', 2, '2017-04-10 13:25:54'),
(33, 5, 1, 'A1', 'A3', 2, '2017-04-10 13:25:56'),
(33, 5, 4, 'A1', 'A3', 2, '2017-04-10 13:25:59'),
(33, 6, 1, 'A1', 'A3', 2, '2017-04-10 13:26:01'),
(33, 6, 4, 'A1', 'A3', 2, '2017-04-10 13:26:03'),
(33, 7, 1, 'A1', 'A3', 2, '2017-04-10 13:26:06'),
(33, 7, 4, 'A1', 'A3', 2, '2017-04-10 13:26:08'),
(33, 8, 1, 'A1', 'A3', 2, '2017-04-10 13:26:10'),
(33, 8, 4, 'A1', 'A3', 2, '2017-04-10 13:26:13'),
(33, 9, 1, 'A1', 'A3', 2, '2017-04-10 13:26:15'),
(33, 9, 4, 'A1', 'A3', 2, '2017-04-10 13:26:18'),
(33, 10, 1, 'A1', 'A3', 2, '2017-04-10 13:26:20'),
(33, 10, 4, 'A1', 'A3', 2, '2017-04-10 13:26:22'),
(33, 11, 1, 'A1', 'A3', 2, '2017-04-10 13:26:25'),
(33, 11, 4, 'A1', 'A3', 2, '2017-04-10 13:26:27'),
(33, 12, 1, 'A1', 'A3', 2, '2017-04-10 13:26:30'),
(33, 12, 4, 'A1', 'A3', 2, '2017-04-10 13:26:32'),
(33, 13, 1, 'A1', 'A3', 2, '2017-04-10 13:26:34'),
(33, 13, 4, 'A1', 'A3', 2, '2017-04-10 13:26:37'),
(33, 14, 1, 'A1', 'A3', 2, '2017-04-10 13:26:39'),
(33, 14, 4, 'A1', 'A3', 2, '2017-04-10 13:26:42'),
(33, 15, 1, 'A1', 'A3', 2, '2017-04-10 13:26:44'),
(33, 15, 4, 'A1', 'A3', 2, '2017-04-10 13:26:46'),
(33, 16, 1, 'A1', 'A3', 2, '2017-04-10 13:26:49'),
(33, 16, 4, 'A1', 'A3', 2, '2017-04-10 13:26:51'),
(33, 17, 1, 'A1', 'A3', 2, '2017-04-10 13:26:53'),
(33, 17, 4, 'A1', 'A3', 2, '2017-04-10 13:26:56'),
(33, 18, 1, 'A1', 'A3', 2, '2017-04-10 13:26:58'),
(33, 18, 4, 'A1', 'A3', 2, '2017-04-10 13:27:01'),
(33, 19, 1, 'A1', 'A3', 2, '2017-04-10 13:27:03'),
(33, 19, 4, 'A1', 'F3', 2, '2017-04-10 13:30:52'),
(33, 20, 1, 'A1', 'F3', 2, '2017-04-10 13:30:54'),
(33, 20, 4, 'A1', 'F1', 2, '2017-04-10 13:30:56'),
(33, 21, 1, 'A1', 'F1', 2, '2017-04-10 13:30:59'),
(33, 21, 4, 'A1', 'B3', 2, '2017-04-10 13:31:01'),
(33, 22, 1, 'A1', 'B3', 2, '2017-04-10 13:31:03'),
(33, 22, 4, 'A1', 'B3', 2, '2017-04-10 13:31:05'),
(33, 23, 1, 'A1', 'B3', 2, '2017-04-10 13:31:08'),
(33, 23, 4, 'A1', 'E1', 2, '2017-04-10 13:31:18'),
(33, 24, 1, 'A1', 'B3', 2, '2017-04-10 13:31:23'),
(33, 24, 4, 'A1', 'B3', 2, '2017-04-10 13:31:25'),
(33, 25, 1, 'A1', 'B3', 2, '2017-04-10 13:31:28'),
(33, 25, 4, 'A1', 'B3', 2, '2017-04-10 13:31:30'),
(33, 26, 1, 'A1', 'B3', 2, '2017-04-10 13:31:33'),
(33, 26, 4, 'A1', 'B3', 2, '2017-04-10 13:31:35'),
(33, 27, 1, 'A1', 'B3', 2, '2017-04-10 13:31:37'),
(33, 27, 4, 'A1', 'B3', 2, '2017-04-10 13:31:40'),
(33, 28, 1, 'A1', 'B3', 2, '2017-04-10 13:31:42'),
(33, 28, 4, 'A1', 'B3', 2, '2017-04-10 13:31:45'),
(33, 29, 1, 'A1', 'B3', 2, '2017-04-10 13:31:47'),
(33, 29, 4, 'A1', 'B3', 2, '2017-04-10 13:31:49'),
(33, 30, 1, 'A1', 'B1', 2, '2017-04-10 13:31:56'),
(33, 30, 4, 'A1', 'A3', 2, '2017-04-10 13:32:11'),
(33, 31, 1, 'A1', 'A3', 2, '2017-04-10 13:32:13'),
(33, 31, 4, 'A1', 'A1', 2, '2017-04-10 13:32:17'),
(33, 32, 1, 'A1', 'A1', 2, '2017-04-10 14:03:04'),
(33, 32, 4, 'A1', 'A1', 2, '2017-04-10 14:04:42'),
(33, 33, 1, 'A1', 'A1', 2, '2017-04-10 14:04:48'),
(33, 33, 4, 'A1', 'A1', 2, '2017-04-10 14:55:46'),
(33, 34, 1, 'A1', 'C5', 2, '2017-04-10 14:56:18'),
(33, 34, 4, 'A1', 'C5', 2, '2017-04-10 14:56:21'),
(33, 35, 1, 'A1', 'F5', 2, '2017-04-10 14:56:41'),
(33, 35, 4, 'A1', 'E5', 2, '2017-04-10 14:56:45'),
(33, 36, 1, 'A1', 'G1', 2, '2017-04-10 14:56:48'),
(33, 36, 4, 'A1', 'B1', 2, '2017-04-10 14:56:53'),
(33, 37, 1, 'A1', 'B1', 2, '2017-04-10 14:56:56'),
(33, 37, 4, 'A1', 'B5', 2, '2017-04-10 14:57:00'),
(33, 38, 1, 'A1', 'E1', 2, '2017-04-10 14:57:04'),
(33, 38, 4, 'A1', 'F1', 2, '2017-04-10 14:57:07'),
(33, 39, 1, 'A1', 'C1', 2, '2017-04-10 14:57:10'),
(33, 39, 4, 'A1', 'A5', 2, '2017-04-10 14:57:13'),
(33, 40, 1, 'A1', 'D1', 2, '2017-04-10 14:57:17'),
(33, 40, 4, 'A1', 'D5', 2, '2017-04-10 14:57:35'),
(33, 41, 1, 'A1', 'D5', 2, '2017-04-10 14:57:38'),
(33, 41, 4, 'A1', 'A1', 2, '2017-04-10 14:57:43'),
(33, 42, 1, 'A1', 'C5', 2, '2017-04-10 14:57:47'),
(33, 42, 4, 'A1', 'D5', 2, '2017-04-10 14:57:51'),
(34, 1, 1, 'D2', 'E4', 14, '2017-04-13 17:00:17'),
(34, 1, 3, 'E7', 'E5', 29, '2017-04-13 17:00:17'),
(34, 2, 1, 'F1', 'C4', 6, '2017-04-13 17:00:17'),
(34, 2, 3, 'B8', 'C6', 21, '2017-04-13 17:00:17'),
(34, 3, 1, 'D1', 'F3', 2, '2017-04-13 17:00:17'),
(34, 3, 3, 'C8', 'C5', 19, '2017-04-13 17:00:17'),
(34, 4, 1, 'F3', 'F7', 2, '2017-04-13 17:00:17'),
(35, 1, 1, 'E2', 'E4', 15, '2017-04-13 17:06:59'),
(35, 1, 4, 'E7', 'E5', 29, '2017-04-13 17:07:01'),
(35, 2, 1, 'F1', 'C4', 6, '2017-04-13 17:07:03'),
(35, 2, 4, 'B8', 'C6', 21, '2017-04-13 17:07:05'),
(35, 3, 1, 'D1', 'F3', 2, '2017-04-13 17:07:07'),
(35, 3, 4, 'F8', 'C5', 20, '2017-04-13 17:07:09'),
(35, 4, 1, 'F3', 'F7', 2, '2017-04-13 17:07:11'),
(36, 1, 1, 'E2', 'E4', 15, '2017-04-13 17:12:25'),
(36, 1, 2, 'E7', 'E5', 29, '2017-04-13 17:12:27'),
(36, 2, 1, 'F1', 'C4', 6, '2017-04-13 17:12:29'),
(36, 2, 2, 'B8', 'C6', 21, '2017-04-13 17:12:31'),
(36, 3, 1, 'D1', 'F3', 2, '2017-04-13 17:12:33'),
(36, 3, 2, 'F8', 'C5', 20, '2017-04-13 17:12:35'),
(36, 4, 1, 'F3', 'F7', 2, '2017-04-13 17:12:37'),
(37, 1, 1, 'E2', 'E4', 15, '2017-04-13 19:25:37'),
(37, 1, 3, 'E7', 'E5', 29, '2017-04-13 19:25:39'),
(37, 2, 1, 'F1', 'C4', 6, '2017-04-13 19:25:41'),
(37, 2, 3, 'B8', 'C6', 21, '2017-04-13 19:25:43'),
(37, 3, 1, 'D1', 'F3', 2, '2017-04-13 19:25:45'),
(37, 3, 3, 'F8', 'C5', 20, '2017-04-13 19:25:47'),
(37, 4, 1, 'F3', 'F7', 2, '2017-04-13 19:25:49'),
(37, 4, 3, 'E2', 'E4', 15, '2017-04-13 19:29:47'),
(37, 5, 1, 'E7', 'E5', 29, '2017-04-13 19:29:49'),
(37, 5, 3, 'F1', 'C4', 6, '2017-04-13 19:29:51'),
(37, 6, 1, 'B8', 'C6', 21, '2017-04-13 19:29:53'),
(37, 6, 3, 'D1', 'F3', 2, '2017-04-13 19:29:55'),
(37, 7, 1, 'F8', 'C5', 20, '2017-04-13 19:29:57'),
(37, 7, 3, 'F3', 'F7', 2, '2017-04-13 19:29:59'),
(37, 8, 1, 'E2', 'E4', 15, '2017-04-13 19:31:26'),
(37, 8, 3, 'E7', 'E5', 29, '2017-04-13 19:31:28'),
(37, 9, 1, 'F1', 'C4', 6, '2017-04-13 19:31:30'),
(37, 9, 3, 'B8', 'C6', 21, '2017-04-13 19:31:33'),
(37, 10, 1, 'D1', 'F3', 2, '2017-04-13 19:31:35'),
(37, 10, 3, 'F8', 'C5', 20, '2017-04-13 19:31:37'),
(37, 11, 1, 'F3', 'F7', 2, '2017-04-13 19:31:39'),
(37, 11, 3, 'E2', 'E4', 15, '2017-04-13 19:32:45'),
(37, 12, 1, 'E7', 'E5', 29, '2017-04-13 19:32:48'),
(37, 12, 3, 'F1', 'C4', 6, '2017-04-13 19:32:50'),
(37, 13, 1, 'B8', 'C6', 21, '2017-04-13 19:32:52'),
(37, 13, 3, 'D1', 'F3', 2, '2017-04-13 19:32:54'),
(37, 14, 1, 'F8', 'C5', 20, '2017-04-13 19:32:56'),
(37, 14, 3, 'F3', 'F7', 2, '2017-04-13 19:32:58'),
(37, 15, 1, 'E2', 'E4', 15, '2017-04-13 19:33:40'),
(37, 15, 3, 'E7', 'E5', 29, '2017-04-13 19:33:42'),
(37, 16, 1, 'F1', 'C4', 6, '2017-04-13 19:33:44'),
(37, 16, 3, 'B8', 'C6', 21, '2017-04-13 19:33:46'),
(37, 17, 1, 'D1', 'F3', 2, '2017-04-13 19:33:48'),
(37, 17, 3, 'F8', 'C5', 20, '2017-04-13 19:33:50'),
(37, 18, 1, 'F3', 'F7', 2, '2017-04-13 19:33:52'),
(37, 18, 3, 'E2', 'E4', 15, '2017-04-13 19:37:37'),
(37, 19, 1, 'E7', 'E5', 29, '2017-04-13 19:37:38'),
(37, 19, 3, 'F1', 'C4', 6, '2017-04-13 19:37:39'),
(37, 20, 1, 'B8', 'C6', 21, '2017-04-13 19:37:40'),
(37, 20, 3, 'D1', 'F3', 2, '2017-04-13 19:37:41'),
(37, 21, 1, 'F8', 'C5', 20, '2017-04-13 19:37:42'),
(37, 21, 3, 'F3', 'F7', 2, '2017-04-13 19:37:43'),
(37, 22, 1, 'E2', 'E4', 15, '2017-04-13 19:38:06'),
(37, 22, 3, 'E7', 'E5', 29, '2017-04-13 19:38:07'),
(37, 23, 1, 'F1', 'C4', 6, '2017-04-13 19:38:08'),
(37, 23, 3, 'B8', 'C6', 21, '2017-04-13 19:38:09'),
(37, 24, 1, 'D1', 'F3', 2, '2017-04-13 19:38:10'),
(37, 24, 3, 'F8', 'C5', 20, '2017-04-13 19:38:11'),
(37, 25, 1, 'F3', 'F7', 2, '2017-04-13 19:38:12'),
(37, 25, 3, 'E2', 'E4', 15, '2017-04-13 19:39:28'),
(37, 26, 1, 'E7', 'E5', 29, '2017-04-13 19:39:29'),
(37, 26, 3, 'F1', 'C4', 6, '2017-04-13 19:39:30'),
(37, 27, 1, 'B8', 'C6', 21, '2017-04-13 19:39:31'),
(37, 27, 3, 'D1', 'F3', 2, '2017-04-13 19:39:32'),
(37, 28, 1, 'F8', 'C5', 20, '2017-04-13 19:39:33'),
(37, 28, 3, 'F3', 'F7', 2, '2017-04-13 19:39:34'),
(37, 29, 1, 'E2', 'E4', 15, '2017-04-13 19:54:13'),
(37, 29, 3, 'E7', 'E5', 29, '2017-04-13 19:54:14'),
(37, 30, 1, 'F1', 'C4', 6, '2017-04-13 19:54:15'),
(37, 30, 3, 'B8', 'C6', 21, '2017-04-13 19:54:16'),
(37, 31, 1, 'D1', 'F3', 2, '2017-04-13 19:54:17'),
(37, 31, 3, 'F8', 'C5', 20, '2017-04-13 19:54:18'),
(37, 32, 1, 'F3', 'F7', 2, '2017-04-13 19:54:19'),
(37, 32, 3, 'E2', 'E4', 15, '2017-04-13 19:56:33'),
(37, 33, 1, 'E7', 'E5', 29, '2017-04-13 19:56:34'),
(37, 33, 3, 'F1', 'C4', 6, '2017-04-13 19:56:35'),
(37, 34, 1, 'B8', 'C6', 21, '2017-04-13 19:56:36'),
(37, 34, 3, 'D1', 'F3', 2, '2017-04-13 19:56:37'),
(37, 35, 1, 'F8', 'C5', 20, '2017-04-13 19:56:38'),
(37, 35, 3, 'F3', 'F7', 2, '2017-04-13 19:56:39'),
(37, 36, 1, 'E2', 'E4', 15, '2017-04-13 19:57:34'),
(37, 36, 3, 'E7', 'E5', 29, '2017-04-13 19:57:36'),
(37, 37, 1, 'F1', 'C4', 6, '2017-04-13 19:57:37'),
(37, 37, 3, 'B8', 'C6', 21, '2017-04-13 19:57:38'),
(37, 38, 1, 'D1', 'F3', 2, '2017-04-13 19:57:39'),
(37, 38, 3, 'F8', 'C5', 20, '2017-04-13 19:57:40'),
(37, 39, 1, 'F3', 'F7', 2, '2017-04-13 19:57:41'),
(37, 39, 3, 'E2', 'E4', 15, '2017-04-13 20:01:48'),
(37, 40, 1, 'E7', 'E5', 29, '2017-04-13 20:01:49'),
(37, 40, 3, 'F1', 'C4', 6, '2017-04-13 20:01:50'),
(37, 41, 1, 'B8', 'C6', 21, '2017-04-13 20:01:51'),
(37, 41, 3, 'D1', 'F3', 2, '2017-04-13 20:01:52'),
(37, 42, 1, 'F8', 'C5', 20, '2017-04-13 20:01:53'),
(37, 42, 3, 'F3', 'F7', 2, '2017-04-13 20:01:54'),
(37, 43, 1, 'E2', 'E4', 15, '2017-04-13 20:06:04'),
(37, 43, 3, 'E7', 'E5', 29, '2017-04-13 20:06:05'),
(37, 44, 1, 'F1', 'C4', 6, '2017-04-13 20:06:06'),
(37, 44, 3, 'B8', 'C6', 21, '2017-04-13 20:06:07'),
(37, 45, 1, 'D1', 'F3', 2, '2017-04-13 20:06:08'),
(37, 45, 3, 'F8', 'C5', 20, '2017-04-13 20:06:09'),
(37, 46, 1, 'F3', 'F7', 2, '2017-04-13 20:06:10'),
(37, 46, 3, 'E2', 'E4', 15, '2017-04-13 20:07:36'),
(37, 47, 1, 'E7', 'E5', 29, '2017-04-13 20:07:37'),
(37, 47, 3, 'F1', 'C4', 6, '2017-04-13 20:07:38'),
(37, 48, 1, 'B8', 'C6', 21, '2017-04-13 20:07:39'),
(37, 48, 3, 'D1', 'F3', 2, '2017-04-13 20:07:40'),
(37, 49, 1, 'F8', 'C5', 20, '2017-04-13 20:07:41'),
(37, 49, 3, 'F3', 'F7', 2, '2017-04-13 20:07:42'),
(37, 50, 1, 'E2', 'E4', 15, '2017-04-13 20:13:24'),
(37, 50, 3, 'E7', 'E5', 29, '2017-04-13 20:13:25'),
(37, 51, 1, 'F1', 'C4', 6, '2017-04-13 20:13:27'),
(37, 51, 3, 'B8', 'C6', 21, '2017-04-13 20:13:28'),
(37, 52, 1, 'D1', 'F3', 2, '2017-04-13 20:13:29'),
(37, 52, 3, 'F8', 'C5', 20, '2017-04-13 20:13:30'),
(37, 53, 1, 'F3', 'F7', 2, '2017-04-13 20:13:31'),
(37, 53, 3, 'E2', 'E4', 15, '2017-04-13 21:25:54'),
(37, 54, 1, 'E7', 'E5', 29, '2017-04-13 21:25:55'),
(37, 54, 3, 'F1', 'C4', 6, '2017-04-13 21:25:56'),
(37, 55, 1, 'B8', 'C6', 21, '2017-04-13 21:25:57'),
(37, 55, 3, 'D1', 'F3', 2, '2017-04-13 21:25:58'),
(37, 56, 1, 'F8', 'C5', 20, '2017-04-13 21:25:59'),
(37, 56, 3, 'F3', 'F7', 2, '2017-04-13 21:26:00'),
(37, 57, 1, 'E2', 'E4', 15, '2017-04-13 21:30:39'),
(37, 57, 3, 'E7', 'E5', 29, '2017-04-13 21:30:40'),
(37, 58, 1, 'F1', 'C4', 6, '2017-04-13 21:30:41'),
(37, 58, 3, 'B8', 'C6', 21, '2017-04-13 21:30:42'),
(37, 59, 1, 'D1', 'F3', 2, '2017-04-13 21:30:43'),
(37, 59, 3, 'F8', 'C5', 20, '2017-04-13 21:30:44'),
(37, 60, 1, 'F3', 'F7', 2, '2017-04-13 21:30:45'),
(38, 1, 1, 'E2', 'E4', 15, '2017-04-17 09:48:12'),
(38, 1, 4, 'E7', 'E5', 29, '2017-04-17 09:48:14'),
(38, 2, 1, 'F1', 'C4', 6, '2017-04-17 09:48:15'),
(38, 2, 4, 'B8', 'C6', 21, '2017-04-17 09:48:16'),
(38, 3, 1, 'D1', 'F3', 2, '2017-04-17 09:48:17'),
(38, 3, 4, 'F8', 'C5', 20, '2017-04-17 09:48:19'),
(38, 4, 1, 'E2', 'E4', 15, '2017-04-17 09:51:20'),
(38, 4, 4, 'E7', 'E5', 29, '2017-04-17 09:51:22'),
(38, 5, 1, 'F1', 'C4', 6, '2017-04-17 09:51:24'),
(38, 5, 4, 'B8', 'C6', 21, '2017-04-17 09:51:25'),
(38, 6, 1, 'D1', 'F3', 2, '2017-04-17 09:51:26'),
(38, 6, 4, 'F8', 'C5', 20, '2017-04-17 09:51:27'),
(38, 7, 1, 'F3', 'F7', 2, '2017-04-17 09:51:28'),
(38, 7, 4, 'E2', 'E4', 15, '2017-04-17 09:55:03'),
(38, 8, 1, 'E7', 'E5', 29, '2017-04-17 09:55:05'),
(38, 8, 4, 'F1', 'C4', 6, '2017-04-17 09:55:06'),
(38, 9, 1, 'B8', 'C6', 21, '2017-04-17 09:55:07'),
(38, 9, 4, 'D1', 'F3', 2, '2017-04-17 09:55:08'),
(38, 10, 1, 'F8', 'C5', 20, '2017-04-17 09:55:09'),
(38, 10, 4, 'F3', 'F7', 2, '2017-04-17 09:55:11'),
(38, 11, 1, 'E2', 'E4', 15, '2017-04-17 10:04:52'),
(38, 11, 4, 'E7', 'E5', 29, '2017-04-17 10:04:54'),
(38, 12, 1, 'F1', 'C4', 6, '2017-04-17 10:04:55'),
(38, 12, 4, 'B8', 'C6', 21, '2017-04-17 10:04:56'),
(38, 13, 1, 'D1', 'F3', 2, '2017-04-17 10:04:57'),
(38, 13, 4, 'F8', 'C5', 20, '2017-04-17 10:04:58'),
(38, 14, 1, 'F3', 'F7', 2, '2017-04-17 10:04:59'),
(38, 14, 4, 'E2', 'E4', 15, '2017-04-17 10:07:02'),
(38, 15, 1, 'E7', 'E5', 29, '2017-04-17 10:07:04'),
(38, 15, 4, 'F1', 'C4', 6, '2017-04-17 10:07:05'),
(38, 16, 1, 'B8', 'C6', 21, '2017-04-17 10:07:06'),
(38, 16, 4, 'D1', 'F3', 2, '2017-04-17 10:07:07'),
(38, 17, 1, 'F8', 'C5', 20, '2017-04-17 10:07:08'),
(38, 17, 4, 'F3', 'F7', 2, '2017-04-17 10:07:09'),
(38, 18, 1, 'E2', 'E4', 15, '2017-04-17 10:07:49'),
(38, 18, 4, 'E7', 'E5', 29, '2017-04-17 10:07:53'),
(38, 19, 1, 'F1', 'C4', 6, '2017-04-17 10:07:56'),
(38, 19, 4, 'B8', 'C6', 21, '2017-04-17 10:07:59'),
(38, 20, 1, 'D1', 'F3', 2, '2017-04-17 10:08:02'),
(38, 20, 4, 'F8', 'C5', 20, '2017-04-17 10:08:05'),
(38, 21, 1, 'F3', 'F7', 2, '2017-04-17 10:08:09'),
(38, 21, 4, 'E2', 'E4', 15, '2017-04-17 10:08:34'),
(38, 22, 1, 'E7', 'E5', 29, '2017-04-17 10:08:38'),
(38, 22, 4, 'F1', 'C4', 6, '2017-04-17 10:08:41'),
(38, 23, 1, 'B8', 'C6', 21, '2017-04-17 10:08:44'),
(38, 23, 4, 'D1', 'F3', 2, '2017-04-17 10:08:47'),
(38, 24, 1, 'F8', 'C5', 20, '2017-04-17 10:08:50'),
(38, 24, 4, 'F3', 'F7', 2, '2017-04-17 10:08:53'),
(38, 25, 1, 'E2', 'E4', 15, '2017-04-17 10:11:42'),
(38, 25, 4, 'E7', 'E5', 29, '2017-04-17 10:11:44'),
(38, 26, 1, 'F1', 'C4', 6, '2017-04-17 10:11:45'),
(38, 26, 4, 'B8', 'C6', 21, '2017-04-17 10:11:46'),
(38, 27, 1, 'D1', 'F3', 2, '2017-04-17 10:11:48'),
(38, 27, 4, 'F8', 'C5', 20, '2017-04-17 10:11:49'),
(38, 28, 1, 'F3', 'F7', 2, '2017-04-17 10:11:50'),
(38, 28, 4, 'E2', 'E4', 15, '2017-04-17 10:13:38'),
(38, 29, 1, 'E7', 'E5', 29, '2017-04-17 10:13:40'),
(38, 29, 4, 'F1', 'C4', 6, '2017-04-17 10:13:42'),
(38, 30, 1, 'B8', 'C6', 21, '2017-04-17 10:13:43'),
(38, 30, 4, 'D1', 'F3', 2, '2017-04-17 10:13:44'),
(38, 31, 1, 'F8', 'C5', 20, '2017-04-17 10:13:45'),
(38, 31, 4, 'F3', 'F7', 2, '2017-04-17 10:13:46'),
(41, 1, 1, 'D2', 'E3', 14, '2017-04-20 20:13:33'),
(41, 1, 2, 'E2', 'D4', 15, '2017-04-20 20:13:51'),
(41, 2, 1, 'D4', 'E3', 15, '2017-04-20 20:13:57'),
(41, 2, 2, 'E3', 'C3', 15, '2017-04-20 20:14:00'),
(41, 3, 1, 'C3', 'E3', 15, '2017-04-20 20:14:01'),
(41, 3, 2, 'E3', 'C3', 15, '2017-04-20 20:14:10'),
(41, 4, 1, 'C3', 'E3', 15, '2017-04-20 20:14:11'),
(41, 4, 2, 'E3', 'C3', 15, '2017-04-20 20:14:20'),
(41, 5, 1, 'C3', 'E3', 15, '2017-04-20 20:14:21'),
(41, 5, 2, 'D7', 'F6', 28, '2017-04-20 20:16:24'),
(41, 6, 1, 'E2', 'F6', 15, '2017-04-20 20:16:42'),
(41, 6, 2, 'E7', 'E3', 29, '2017-04-20 20:17:39'),
(41, 7, 1, 'D1', 'D4', 2, '2017-04-20 20:17:49'),
(42, 1, 1, 'C3', 'E3', 2, '2017-04-21 17:36:27'),
(43, 1, 1, 'D2', 'E3', 14, '2017-04-21 18:03:39'),
(43, 1, 2, 'D7', 'F6', 28, '2017-04-21 18:03:48'),
(43, 2, 1, 'F6', 'G1', 28, '2017-04-21 18:03:49'),
(43, 2, 2, 'E3', 'D4', 14, '2017-04-21 18:03:57'),
(44, 1, 1, 'D2', 'B6', 14, '2017-04-24 10:32:36'),
(44, 1, 2, 'B6', 'C5', 14, '2017-04-24 10:32:55'),
(44, 2, 1, 'C5', 'D6', 14, '2017-04-24 10:33:02'),
(44, 2, 2, 'D6', 'E5', 14, '2017-04-24 10:33:08'),
(44, 3, 1, 'E5', 'F6', 14, '2017-04-24 10:33:14'),
(44, 3, 2, 'F6', 'G5', 14, '2017-04-24 10:33:36'),
(44, 4, 1, 'G5', 'H6', 14, '2017-04-24 10:33:58'),
(44, 4, 2, 'H6', 'H4', 14, '2017-04-24 10:34:12'),
(44, 5, 1, 'H4', 'G3', 14, '2017-04-24 10:34:18'),
(44, 5, 2, 'G3', 'F6', 14, '2017-04-24 10:34:46'),
(44, 6, 1, 'D2', 'E3', 14, '2017-04-24 10:36:00'),
(44, 6, 2, 'E3', 'D4', 14, '2017-04-24 10:36:11'),
(44, 7, 1, 'D4', 'C3', 14, '2017-04-24 10:36:17'),
(44, 7, 2, 'C3', 'A4', 14, '2017-04-24 10:36:39'),
(44, 8, 1, 'A4', 'F6', 14, '2017-04-24 10:36:59'),
(44, 8, 2, 'F6', 'E3', 14, '2017-04-24 10:37:44'),
(44, 9, 1, 'E3', 'G3', 14, '2017-04-24 10:37:54'),
(44, 9, 2, 'D2', 'H4', 14, '2017-04-24 10:39:08'),
(44, 10, 1, 'H4', 'F6', 14, '2017-04-24 10:39:20'),
(44, 10, 2, 'D2', 'F1', 14, '2017-04-24 10:41:16'),
(44, 11, 1, 'D2', 'E1', 14, '2017-04-24 10:42:57'),
(44, 11, 2, 'D2', 'G3', 14, '2017-04-24 10:43:29'),
(44, 12, 1, 'G3', 'E1', 14, '2017-04-24 10:43:43'),
(44, 12, 2, 'D2', 'F1', 14, '2017-04-24 10:44:15'),
(44, 13, 1, 'D7', 'H6', 28, '2017-04-24 10:46:24'),
(44, 13, 2, 'E2', 'G5', 15, '2017-04-24 10:46:36'),
(44, 14, 1, 'E7', 'F4', 29, '2017-04-24 10:46:50'),
(44, 14, 2, 'E7', 'F4', 29, '2017-04-24 10:49:19'),
(44, 15, 1, 'E7', 'H6', 29, '2017-04-24 10:53:04'),
(44, 15, 2, 'E2', 'H6', 15, '2017-04-24 10:54:48'),
(44, 16, 1, 'D2', 'H6', 14, '2017-04-24 10:55:24'),
(44, 16, 2, 'E7', 'H6', 29, '2017-04-24 10:55:35'),
(44, 17, 1, 'D7', 'H6', 28, '2017-04-24 10:55:50'),
(45, 1, 1, 'D7', 'D6', 28, '2017-04-26 06:54:15'),
(45, 1, 2, 'D2', 'D4', 14, '2017-04-26 06:55:07'),
(45, 2, 1, 'E7', 'E5', 29, '2017-04-26 06:55:35'),
(45, 2, 2, 'C1', 'E3', 5, '2017-04-26 06:56:50'),
(46, 1, 1, 'D2', 'D4', 14, '2017-04-26 07:01:00'),
(46, 1, 2, 'D7', 'D6', 28, '2017-04-26 07:01:20'),
(46, 2, 1, 'C1', 'E3', 5, '2017-04-26 07:08:15'),
(46, 2, 2, 'E2', 'E3', 15, '2017-04-26 07:08:27'),
(47, 1, 1, 'E7', 'E5', 29, '2017-04-26 07:09:16'),
(47, 1, 2, 'E7', 'E5', 29, '2017-04-26 07:10:14'),
(47, 2, 1, 'D7', 'D6', 28, '2017-04-26 07:10:35'),
(47, 2, 2, 'D2', 'D4', 14, '2017-04-26 07:10:55'),
(47, 3, 1, 'E5', 'D4', 29, '2017-04-26 07:11:34'),
(47, 3, 2, 'B1', 'C3', 7, '2017-04-26 07:12:11'),
(48, 1, 1, 'E7', 'E5', 29, '2017-04-26 07:14:03'),
(48, 1, 4, 'B1', 'C3', 7, '2017-04-26 07:14:09'),
(49, 1, 1, 'D7', 'D6', 28, '2017-04-26 07:16:26'),
(49, 1, 4, 'D2', 'D4', 14, '2017-04-26 07:17:00'),
(49, 2, 1, 'D7', 'D6', 28, '2017-04-26 07:18:04'),
(49, 2, 4, 'D2', 'E5', 14, '2017-04-26 07:18:54'),
(50, 1, 1, 'E7', 'E5', 29, '2017-04-26 07:19:44'),
(50, 1, 4, 'D2', 'D4', 14, '2017-04-26 07:19:59'),
(50, 2, 1, 'E5', 'D4', 29, '2017-04-26 07:20:13'),
(51, 1, 1, 'D2', 'D4', 14, '2017-04-26 07:23:15'),
(51, 1, 3, 'E7', 'E5', 29, '2017-04-26 07:23:25'),
(51, 2, 1, 'D4', 'E5', 14, '2017-04-26 07:23:32'),
(52, 1, 1, 'E7', 'E5', 29, '2017-04-26 07:28:58'),
(52, 1, 4, 'D2', 'D4', 14, '2017-04-26 07:29:10'),
(52, 2, 1, 'D4', 'E5', 14, '2017-04-26 07:29:28'),
(52, 2, 4, 'D7', 'D6', 28, '2017-04-26 07:31:53'),
(53, 1, 3, 'D2', 'D4', 14, '2017-04-26 07:33:05'),
(53, 1, 4, 'E7', 'E5', 29, '2017-04-26 07:33:20'),
(53, 2, 3, 'D7', 'D6', 28, '2017-04-26 07:33:44'),
(53, 2, 4, 'E5', 'D4', 29, '2017-04-26 07:33:54'),
(53, 3, 3, 'B1', 'D4', 7, '2017-04-26 07:35:38'),
(54, 1, 1, 'D4', 'C3', 7, '2017-04-26 07:38:42'),
(55, 1, 1, 'D4', 'E5', 29, '2017-04-26 07:42:23'),
(56, 1, 1, 'E7', 'E5', 29, '2017-04-26 07:43:07'),
(56, 1, 2, 'D2', 'D4', 14, '2017-04-26 07:43:26'),
(56, 2, 1, 'D4', 'E5', 14, '2017-04-26 07:43:36'),
(57, 1, 1, 'E7', 'E5', 29, '2017-04-26 07:45:44'),
(57, 1, 2, 'D2', 'D4', 14, '2017-04-26 07:46:00'),
(57, 2, 1, 'E5', 'D4', 29, '2017-04-26 07:46:08'),
(57, 2, 2, 'B1', 'C3', 7, '2017-04-26 07:46:35'),
(57, 3, 1, 'D4', 'C3', 29, '2017-04-26 07:47:41'),
(57, 3, 2, 'C3', 'D4', 29, '2017-04-26 07:48:00'),
(59, 1, 1, 'B1', 'C3', 7, '2017-04-26 07:54:31'),
(59, 1, 2, 'D2', 'D4', 14, '2017-04-26 07:55:01'),
(59, 2, 1, 'E7', 'E5', 29, '2017-04-26 07:55:11'),
(59, 2, 2, 'D4', 'E5', 14, '2017-04-26 07:55:19'),
(59, 3, 1, 'E5', 'D4', 14, '2017-04-26 07:56:14'),
(60, 1, 1, 'E7', 'E5', 29, '2017-04-26 07:57:38'),
(60, 1, 3, 'D2', 'D4', 14, '2017-04-26 07:57:19'),
(60, 2, 1, 'D7', 'D6', 28, '2017-04-26 07:58:09'),
(60, 2, 3, 'D4', 'E5', 14, '2017-04-26 07:57:50'),
(60, 3, 1, 'D6', 'E5', 14, '2017-04-26 07:58:23'),
(60, 3, 3, 'E5', 'D6', 14, '2017-04-26 07:58:16'),
(60, 4, 1, 'D6', 'E5', 14, '2017-04-26 07:58:42'),
(60, 4, 3, 'E5', 'D6', 14, '2017-04-26 07:58:27'),
(60, 5, 3, 'E5', 'D6', 14, '2017-04-26 07:58:52'),
(61, 1, 1, 'D2', 'D4', 14, '2017-04-26 08:01:45'),
(61, 1, 2, 'E2', 'E3', 15, '2017-04-26 08:02:01'),
(61, 2, 1, 'D1', 'C3', 2, '2017-04-26 08:02:15'),
(61, 2, 2, 'E3', 'F6', 15, '2017-04-26 08:02:28'),
(61, 3, 1, 'C3', 'D4', 2, '2017-04-26 08:02:42'),
(61, 3, 2, 'D4', 'E5', 14, '2017-04-26 08:02:45'),
(62, 1, 1, 'E2', 'E5', 15, '2017-04-26 08:03:34'),
(62, 1, 2, 'E7', 'D4', 29, '2017-04-26 08:03:45'),
(62, 2, 1, 'D7', 'D6', 28, '2017-04-26 08:05:35'),
(62, 2, 2, 'D2', 'D4', 14, '2017-04-26 08:05:49'),
(62, 3, 1, 'B1', 'C3', 7, '2017-04-26 08:14:56'),
(62, 3, 2, 'C1', 'F4', 5, '2017-04-26 08:15:35'),
(62, 4, 1, 'B8', 'F6', 21, '2017-04-26 08:16:28'),
(62, 4, 2, 'D8', 'D6', 4, '2017-04-26 08:16:54'),
(63, 1, 1, 'D2', 'E3', 14, '2017-04-26 08:22:16'),
(63, 1, 2, 'E2', 'D4', 15, '2017-04-26 08:22:42'),
(64, 1, 1, 'D7', 'E5', 28, '2017-04-26 08:23:42');

--
-- Indizes der exportierten Tabellen
--

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

--
-- Indizes für die Tabelle `schachspiel`
--
ALTER TABLE `schachspiel`
  ADD PRIMARY KEY (`schachspiel_id`),
  ADD KEY `spieler_weiß` (`spieler_weiß`),
  ADD KEY `spieler_schwarz` (`spieler_schwarz`);

--
-- Indizes für die Tabelle `spielerfassung`
--
ALTER TABLE `spielerfassung`
  ADD PRIMARY KEY (`id_schachspiel`,`id_schachfigur`),
  ADD KEY `id_schachfigur` (`id_schachfigur`);

--
-- Indizes für die Tabelle `spielzuege`
--
ALTER TABLE `spielzuege`
  ADD PRIMARY KEY (`spiel_id`,`zugnummer`,`spieler_id`),
  ADD KEY `figur` (`figur_id`),
  ADD KEY `spieler_id` (`spieler_id`);

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

--
-- AUTO_INCREMENT für Tabelle `schachfigur`
--
ALTER TABLE `schachfigur`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
--
-- AUTO_INCREMENT für Tabelle `schachspiel`
--
ALTER TABLE `schachspiel`
  MODIFY `schachspiel_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;
--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `schachspiel`
--
ALTER TABLE `schachspiel`
  ADD CONSTRAINT `schachspiel_ibfk_1` FOREIGN KEY (`spieler_weiß`) REFERENCES `spieler` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `schachspiel_ibfk_2` FOREIGN KEY (`spieler_schwarz`) REFERENCES `spieler` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints der Tabelle `spielerfassung`
--
ALTER TABLE `spielerfassung`
  ADD CONSTRAINT `spielerfassung_ibfk_1` FOREIGN KEY (`id_schachspiel`) REFERENCES `schachspiel` (`schachspiel_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `spielerfassung_ibfk_2` FOREIGN KEY (`id_schachfigur`) REFERENCES `schachfigur` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints der Tabelle `spielzuege`
--
ALTER TABLE `spielzuege`
  ADD CONSTRAINT `spielzuege_ibfk_1` FOREIGN KEY (`spiel_id`) REFERENCES `schachspiel` (`schachspiel_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `spielzuege_ibfk_2` FOREIGN KEY (`figur_id`) REFERENCES `schachfigur` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `spielzuege_ibfk_3` FOREIGN KEY (`spieler_id`) REFERENCES `spieler` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

