-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             8.0.0.4513
-- --------------------------------------------------------


-- Dumping database structure for makabi2
CREATE DATABASE IF NOT EXISTS `makabi2` /*!40100 DEFAULT CHARACTER SET cp1250 */;
USE `makabi2`;


-- Dumping structure for table makabi2.admin
CREATE TABLE IF NOT EXISTS `admin` (
  `dnazwa` varchar(50) COLLATE utf8_polish_ci DEFAULT 'Regionalny Turniej Par nr ',
  `knazwa` varchar(20) COLLATE utf8_polish_ci DEFAULT NULL,
  `ilrun` int(4) DEFAULT '0',
  `rozru` int(4) DEFAULT '0',
  `ilsto` int(4) DEFAULT '0',
  `ilucz` int(4) DEFAULT '0',
  `pary` tinyint(1) DEFAULT '1',
  `maxco` int(4) DEFAULT '0',
  `splic` tinyint(1) DEFAULT '-3' COMMENT '-3=maxy,-2=cav,-1=std.butler,0..=butler, tyle odrzucanych ',
  `datai` varchar(13) COLLATE utf8_polish_ci DEFAULT NULL,
  `logoh` text COLLATE utf8_polish_ci,
  `dochodzenie` tinyint(1) DEFAULT '0',
  `sektory` tinyint(2) DEFAULT '1',
  `vps` tinyint(1) DEFAULT '0',
  `favicon` varchar(100) COLLATE utf8_polish_ci DEFAULT 'gdansk.ico',
  `avimp` decimal(6,2) DEFAULT '3.00',
  `ilrungr` int(4) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

-- Dumping data for table makabi2.admin: 1 rows
INSERT INTO `admin` (`dnazwa`, `knazwa`, `ilrun`, `rozru`, `ilsto`, `ilucz`, `pary`, `maxco`, `splic`, `datai`, `logoh`, `dochodzenie`, `sektory`, `vps`, `favicon`, `avimp`, `ilrungr`) VALUES
	('II Turniej Par', 'makabi', 15, 2, 13, 26, 1, 0, -3, '2013-09-11', '\r\n<div id="container" style="width:670px; position: relative; margin: auto; min-height: 150px;">\r\n\r\n	<div id="logo_left" style=" text-align: center; float: left;"> \r\n		<a target="_blank" href="http://www.makabipolska.org.pl/"><img alt="" src="images/makabi.png"></a>\r\n	</div>\r\n	\r\n	<div id="logo_right" style="text-align: center; float: right;"> \r\n		<a target="_blank" href="http://www.makabipolska.org.pl/"><img alt="" src="images/makabi.png"></a>\r\n	</div>\r\n	\r\n	<div id="place_date" 		style="font-size: 0.75em; font-style: italic; text-align: center;">		Makabi  11.09.2013	</div>\r\n		\r\n	<div id="title_info" 		style="text-align: center; margin-top: 10px;">\r\n		<div id="title" 		style="font-size: 1.75em; font-variant: small-caps;  font-family: serif;"> 											II Turniej Par 					</div>\r\n		<div id="info" 			style="font-size: 1.20em; font-style: italic;">							z IV Cyklu Makabi				</div>\r\n	</div>\r\n	\r\n\r\n	<!--[if !IE]><!-->\r\n	<div id="navigation"  style="text-align: center; position: absolute; bottom: 3px; width: inherit;">\r\n	<!--<![endif]-->\r\n	\r\n	<!--[if gte IE 8]>\r\n	<div id="navigation"  style="text-align: center; position: absolute; bottom: 3px; width: inherit;">\r\n	<![endif]-->\r\n	\r\n	<!--[if lte IE 7]>\r\n	<table width="100%" border="0"><tbody align="center"><tr><td>\r\n	<![endif]-->\r\n	\r\n		<ul style="list-style-type:none; margin:0; padding:0; ">\r\n			<li style="display:inline;"> <a target="_top" class="button" href="W-makabi.html">&nbsp;wyniki&nbsp;</a>\r\n			<li style="display:inline;"> <a target="_top" class="button" href="makabi.html">&nbsp;rozdania&nbsp;</a>\r\n			<li style="display:inline;"> <a target="_top" class="button" href="H-makabi-lista.html">&nbsp;lista historii&nbsp;</a>\r\n		</ul>\r\n	\r\n	<!--[if lte IE 7]>\r\n	</td></tr></tbody></table>\r\n	<![endif]-->\r\n	\r\n	<!--[if gte IE 8]>\r\n	</div>\r\n	<![endif]-->\r\n	\r\n	<!--[if !IE]><!-->\r\n	</div>\r\n	<!--<![endif]-->\r\n	\r\n	\r\n	<div id="end" style="clear: both; height: 0px;"></div>\r\n	\r\n</div>', 0, 1, 0, 'gdansk.ico', 3.00, 15);


-- Dumping structure for table makabi2.dodatki
CREATE TABLE IF NOT EXISTS `dodatki` (
  `miejsce` int(6) NOT NULL DEFAULT '0',
  `pkl` int(6) DEFAULT '0',
  `pdf` int(6) DEFAULT '0',
  `opis` varchar(20) COLLATE utf8_polish_ci DEFAULT NULL,
  `nagroda` varchar(20) COLLATE utf8_polish_ci DEFAULT NULL,
  PRIMARY KEY (`miejsce`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

-- Dumping data for table makabi2.dodatki: 0 rows


-- Dumping structure for table makabi2.grupy
CREATE TABLE IF NOT EXISTS `grupy` (
  `numer` int(6) DEFAULT NULL,
  `nazwa` varchar(30) COLLATE utf8_polish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

-- Dumping data for table makabi2.grupy: 0 rows


-- Dumping structure for view makabi2.ile_razy_grali_na_siebie
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `ile_razy_grali_na_siebie` (
	`a` INT(11) NULL,
	`b` INT(11) NULL,
	`ile_razy` BIGINT(21) NOT NULL
) ENGINE=MyISAM;


-- Dumping structure for function makabi2.inicjal
DELIMITER //
CREATE DEFINER=`root`@`localhost` FUNCTION `inicjal`(imie char(25) charset utf8) RETURNS char(25) CHARSET utf8
BEGIN
DECLARE P INT;
DECLARE M INT;
DECLARE R CHAR(25);
DECLARE I CHAR(25);
SELECT TRIM(imie) INTO I;
SELECT LEFT(I,1) INTO R;
SELECT 2 INTO P;
WHILE P<=LENGTH(I) DO
IF MID(I,P,1)=' ' THEN
BEGIN
SELECT CONCAT(R,MID(I,P,2)) INTO R;
SELECT P+1 INTO P;
END;
END IF;
SELECT P+1 INTO P;
END WHILE;
RETURN R;
END//
DELIMITER ;


-- Dumping structure for table makabi2.karywyr
CREATE TABLE IF NOT EXISTS `karywyr` (
  `id` int(4) NOT NULL,
  `karwy` decimal(10,2) NOT NULL DEFAULT '0.00',
  `kodka` char(1) COLLATE utf8_polish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

-- Dumping data for table makabi2.karywyr: 2 rows
INSERT INTO `karywyr` (`id`, `karwy`, `kodka`) VALUES
	(13, 1.00, 'A'),
	(6, 1.00, 'A');


-- Dumping structure for procedure makabi2.panipierwsza
DELIMITER //
CREATE DEFINER=`root`@`localhost` PROCEDURE `panipierwsza`()
BEGIN
CREATE TEMPORARY TABLE jfr_tmp AS SELECT a.idp,a.id aid,substr(a.imie,-1) aimie,b.id bid,substr(b.imie,-1) bimie FROM zawodnicy a INNER JOIN zawodnicy b ON a.idp=b.idp AND a.id<b.id;
ALTER TABLE `zawodnicy` CHANGE `id` `id` INT(4) DEFAULT '0' NOT NULL, DROP PRIMARY KEY;
UPDATE zawodnicy a,jfr_tmp b SET a.id=b.aid WHERE a.idp=b.idp AND b.bimie='a' AND b.bimie<>b.aimie;
UPDATE zawodnicy a,jfr_tmp b SET a.id=b.bid WHERE a.idp=b.idp AND b.bimie='a' AND substr(a.imie,-1)<>'a';
ALTER TABLE `zawodnicy` CHANGE `id` `id` INT(4) DEFAULT '0' NOT NULL, ADD PRIMARY KEY(`id`);    
END//
DELIMITER ;


-- Dumping structure for procedure makabi2.paryalfa
DELIMITER //
CREATE DEFINER=`root`@`localhost` PROCEDURE `paryalfa`()
BEGIN
CREATE TABLE jfr_tmp AS SELECT a.idp,a.id aid,concat(a.nazw,' ',a.imie) aname,b.id bid,concat(b.nazw,' ',b.imie) bname FROM zawodnicy a INNER JOIN zawodnicy b ON a.idp=b.idp AND a.id<b.id;
ALTER TABLE `zawodnicy` CHANGE `id` `id` INT(4) DEFAULT '0' NOT NULL, DROP PRIMARY KEY;
UPDATE zawodnicy a,jfr_tmp b SET a.id=b.aid WHERE a.idp=b.idp AND b.bname<b.aname;
UPDATE zawodnicy a,jfr_tmp b SET a.id=b.bid WHERE a.idp=b.idp AND b.bname<b.aname AND concat(a.nazw,' ',a.imie)<>b.bname;
ALTER TABLE `zawodnicy` CHANGE `id` `id` INT(4) DEFAULT '0' NOT NULL, ADD PRIMARY KEY(`id`);
CALL panipierwsza();
END//
DELIMITER ;


-- Dumping structure for table makabi2.rozdania
CREATE TABLE IF NOT EXISTS `rozdania` (
  `id` int(4) NOT NULL,
  `nr` int(4) DEFAULT NULL,
  `pbn` text COLLATE utf8_polish_ci,
  `htm` text COLLATE utf8_polish_ci,
  `blok` tinyint(1) NOT NULL DEFAULT '1',
  `zmiana` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

-- Dumping data for table makabi2.rozdania: 30 rows
INSERT INTO `rozdania` (`id`, `nr`, `pbn`, `htm`, `blok`, `zmiana`) VALUES
	(1, 1, NULL, NULL, 0, 0),
	(2, 2, NULL, NULL, 0, 0),
	(3, 3, NULL, NULL, 0, 0),
	(4, 4, NULL, NULL, 0, 0),
	(5, 5, NULL, NULL, 0, 0),
	(6, 6, NULL, NULL, 0, 0),
	(7, 7, NULL, NULL, 0, 0),
	(8, 8, NULL, NULL, 0, 0),
	(9, 9, NULL, NULL, 0, 0),
	(10, 10, NULL, NULL, 0, 0),
	(11, 11, NULL, NULL, 0, 0),
	(12, 12, NULL, NULL, 0, 0),
	(13, 13, NULL, NULL, 0, 0),
	(14, 14, NULL, NULL, 0, 0),
	(15, 15, NULL, NULL, 0, 0),
	(16, 16, NULL, NULL, 0, 0),
	(17, 17, NULL, NULL, 0, 0),
	(18, 18, NULL, NULL, 0, 0),
	(19, 19, NULL, NULL, 0, 0),
	(20, 20, NULL, NULL, 0, 0),
	(21, 21, NULL, NULL, 0, 0),
	(22, 22, NULL, NULL, 0, 0),
	(23, 23, NULL, NULL, 0, 0),
	(24, 24, NULL, NULL, 0, 0),
	(25, 25, NULL, NULL, 0, 0),
	(26, 26, NULL, NULL, 0, 0),
	(27, 27, NULL, NULL, 0, 0),
	(28, 28, NULL, NULL, 0, 0),
	(29, 29, NULL, NULL, 0, 0),
	(30, 30, NULL, NULL, 0, 0);


-- Dumping structure for table makabi2.rozliczenie
CREATE TABLE IF NOT EXISTS `rozliczenie` (
  `idp` int(4) NOT NULL DEFAULT '0',
  `wpisowe` bigint(21) DEFAULT '0',
  `cezar` char(5) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL,
  `Imie` varchar(30) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL,
  `Nazwisko` varchar(50) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL,
  `WK` varchar(10) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL,
  `Okreg` varchar(20) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL,
  `Klub` varchar(50) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL,
  `Plec` char(1) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL,
  `Status` char(1) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL,
  `Znizki` char(1) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL,
  `Czlonek` char(1) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1250;

-- Dumping data for table makabi2.rozliczenie: 52 rows
INSERT INTO `rozliczenie` (`idp`, `wpisowe`, `cezar`, `Imie`, `Nazwisko`, `WK`, `Okreg`, `Klub`, `Plec`, `Status`, `Znizki`, `Czlonek`) VALUES
	(1, 20, '04719', 'Artur', 'Toeplitz', '4', 'PM', 'LOS Gdynia', NULL, NULL, '', 'T'),
	(1, 10, '50007', 'Michał', 'Samet', NULL, '', 'AMATOR', NULL, NULL, NULL, NULL),
	(2, 20, '13580', 'Marek', 'Fijałkowski', '1.5', 'PM', 'Gdańskie Towarzystwo Brydżowe', NULL, 'S', '', 'T'),
	(2, 15, '04659', 'Krzysztof', 'Niemkiewicz', '4', 'PM', 'HOTEL AMBER Gdańsk', NULL, 'S', 'T', 'T'),
	(3, 15, '10794', 'Aleksander', 'Chrenowski', '13', 'PM', 'HOTEL AMBER Gdańsk', NULL, 'S', 'T', 'T'),
	(3, 20, '15729', 'Aldona', 'Chrenowska', '2.5', 'PM', 'HOTEL AMBER Gdańsk', 'K', 'S', '', 'T'),
	(4, 20, '11757', 'Paweł', 'Anastaziak', '2.5', 'PM', 'MERITUM Gdańsk', NULL, NULL, '', 'T'),
	(4, 20, '09689', 'Joanna', 'Śliwowska', '2', 'PM', 'MERITUM Gdańsk', 'K', NULL, '', 'T'),
	(5, 15, '04590', 'Józef', 'Idczak', '7', 'PM', 'ANDRZEJKI BIS Gdańsk', NULL, 'S', 'T', 'T'),
	(5, 15, '04672', 'Andrzej', 'Pella', '2.5', 'PM', 'ACOL +76', NULL, 'N', 'T', 'T'),
	(6, 20, '12390', 'Katarzyna', 'Klimkiewicz', '2', 'PM', 'WRÓBLE Gdańsk', 'K', NULL, '', 'T'),
	(6, 20, '12391', 'Tomasz', 'Klimkiewicz', '2.5', 'PM', 'WRÓBLE Gdańsk', NULL, NULL, '', 'T'),
	(7, 20, '04755', 'Danuta', 'Żabicka', '4', 'PM', 'FALCK-MEDYCYNA Gdańsk', 'K', NULL, '', 'T'),
	(7, 20, '13707', 'Mirosław', 'Małypan', '2', 'PM', 'FALCK-MEDYCYNA Gdańsk', NULL, NULL, '', 'T'),
	(8, 5, '15802', 'Adam', 'Suchodolski', '', 'PM', 'Gdańskie Towarzystwo Brydżowe', NULL, 'M', 'T', 'T'),
	(8, 20, '13028', 'Piotr', 'Suchodolski', '2.5', 'PM', 'WIMPEL Gdańsk', NULL, NULL, '', 'T'),
	(9, 15, '09034', 'Janusz', 'Warchoł', '4', 'PM', 'ACOL +76', NULL, 'N', 'T', 'T'),
	(9, 15, '10820', 'Stanisław', 'Wachnicki', '2.5', 'PM', 'ACOL +76', NULL, 'S', 'T', 'T'),
	(10, 15, '04632', 'Jacek', 'Lew', '13', 'PM', 'WIMPEL Gdańsk', NULL, 'S', 'T', 'T'),
	(10, 15, '04684', 'Józef', 'Pochroń', '18', 'PM', 'WIMPEL Gdańsk', NULL, 'N', 'T', 'T'),
	(11, 20, '04602', 'Aleksander', 'Kasprzak', '18', 'PM', 'SDK Tczew', NULL, 'S', '', 'T'),
	(11, 20, '12680', 'Michał', 'Wróblewski', '2', 'PM', 'WRÓBLE Gdańsk', NULL, NULL, '', 'T'),
	(12, 10, '50024', 'Dariusz', 'Milewski', NULL, 'AMA', 'AMATOR', NULL, NULL, NULL, NULL),
	(12, 10, '50025', 'Grzegorz', 'Czurylik', NULL, 'AMA', 'AMATOR', NULL, NULL, NULL, NULL),
	(13, 15, '04577', 'Gabriela', 'Gnacińska', '7', 'PM', 'FALCK-MEDYCYNA Gdańsk', 'K', 'N', 'T', 'T'),
	(13, 15, '04696', 'Antoni', 'Sękowski', '18', 'PM', 'ALFA Gdynia', NULL, 'N', 'T', 'T'),
	(14, 10, '50021', 'Kamil', 'Puczyłowski', NULL, 'AMA', 'AMATOR', NULL, NULL, NULL, NULL),
	(14, 10, '50059', 'Elżbieta', 'Pasiuk', '', 'AMA', 'AMATOR', 'k', NULL, NULL, NULL),
	(15, 15, '16207', 'Krzysztof', 'Dubno', '1', 'PM', 'WRÓBLE Gdańsk', NULL, 'S', 'T', 'T'),
	(15, 20, '12681', 'Mirosław', 'Wróblewski', '1.5', 'PM', 'WRÓBLE Gdańsk', NULL, NULL, '', 'T'),
	(16, 15, '15059', 'Agata', 'Chojnicka', '1.5', 'PM', 'Gdańskie Towarzystwo Brydżowe', 'K', 'J', 'T', 'T'),
	(16, 15, '03615', 'Adam', 'Zaczek', '2', 'LD', 'KDK2 Kutno', NULL, 'S', 'T', 'T'),
	(17, 10, '50002', 'Grażyna', 'Płocka', NULL, 'AMA', 'AMATOR', 'K', NULL, NULL, NULL),
	(17, 20, '04559', 'Kazimierz', 'Dominiak', '7', 'PM', 'KOSMETERIA Żukowo', NULL, 'S', '', 'T'),
	(18, 20, '10804', 'Maria', 'Kierzkowska', '0.5', 'PM', '', 'K', NULL, '', ''),
	(18, 20, '10805', 'Ryszard', 'Kierzkowski', '1', 'PM', '', NULL, NULL, '', ''),
	(19, 15, '11726', 'Ryszard', 'Kamiński', '2.5', 'PM', 'MKSŁ KONRADIA Gdańsk', NULL, 'S', 'T', 'T'),
	(19, 20, '15486', 'Ireneusz', 'Cebula', '', 'WP', '', NULL, 'S', '', ''),
	(20, 20, '14485', 'Mirosław', 'Staniewicz', '1.5', 'PD', 'Jutrzenka Supraśl', NULL, NULL, '', 'T'),
	(20, 15, '08472', 'Andrzej', 'Michałowski', '2.5', 'PM', 'Gdańskie Towarzystwo Brydżowe', NULL, 'S', 'T', 'T'),
	(21, 20, '14422', 'Zbigniew', 'Dybizbański', '1.5', 'PM', 'SKOK UBEZPIECZENIA Sopot', NULL, NULL, '', 'T'),
	(21, 20, '15139', 'Aleksander', 'Górski', '1.5', 'PM', 'SKOK UBEZPIECZENIA Sopot', NULL, NULL, '', 'T'),
	(22, 15, '16228', 'Marta', 'Harat', '0.5', 'PM', 'WRÓBLE Gdańsk', 'K', 'J', 'T', 'T'),
	(22, 20, '10348', 'Dariusz', 'Podfigurny', '2.5', 'PM', 'MERITUM Gdańsk', NULL, NULL, '', 'T'),
	(23, 15, '04536', 'Marek', 'Boros', '4', 'PM', 'BUDMOR TREFL Władyslawowo', NULL, 'S', 'T', 'T'),
	(23, 20, '01570', 'Zdzisław', 'Podrucki', '1.5', 'DS', '', NULL, 'S', '', ''),
	(24, 15, '09758', 'Adam', 'Kozłowski', '1.5', 'PM', 'MKSŁ KONRADIA Gdańsk', NULL, 'S', 'T', 'T'),
	(24, 15, '04706', 'Zdzisław', 'Stawski', '4', 'PM', 'MKSŁ KONRADIA Gdańsk', NULL, 'N', 'T', 'T'),
	(25, 10, '50060', 'Stanisław', 'Modrzyński', '0.0', '', 'AMATOR', NULL, NULL, NULL, NULL),
	(25, 10, '50061', 'Jerzy', 'Biesiadowski', '0.0', '', 'AMATOR', NULL, NULL, NULL, NULL),
	(26, 20, '04563', 'Ireneusz', 'Dzikowski', '18', 'PM', 'ANDRZEJKI Gdańsk', NULL, 'S', '', 'T'),
	(26, 20, '04735', 'Wacław', 'Wejknis', '13', 'PM', 'ANDRZEJKI Gdańsk', NULL, 'S', '', 'T');


-- Dumping structure for procedure makabi2.rozliczenie_jaom
DELIMITER //
CREATE DEFINER=`root`@`localhost` PROCEDURE `rozliczenie_jaom`()
BEGIN
CREATE OR REPLACE VIEW `zawodnicy+` AS ( SELECT `zawodnicy`.`idp` AS `idp`,`zawodnicy`.`cezar` AS `cezar`,`players_makabi`.`players`.`gname` AS `Imie`,`players_makabi`.`players`.`sname` AS `Nazwisko`,`players_makabi`.`players`.`rank` AS `WK`,`players_makabi`.`players`.`loc1` AS `Okreg`,`players_makabi`.`players`.`loc2` AS `Klub`,`players_makabi`.`players`.`sex` AS `Plec`,`players_makabi`.`players`.`age` AS `Status`,`players_makabi`.`players`.`flag1` AS `Znizki`,`players_makabi`.`players`.`flag2` AS `Czlonek` FROM (`zawodnicy` LEFT JOIN `players_makabi`.`players` on((`players_makabi`.`players`.`ID` = `zawodnicy`.`cezar`))) ORDER BY `zawodnicy`.`idp` );
CREATE TABLE rozliczenie AS ( SELECT idp, ile as `wpisowe`, cezar, Imie, Nazwisko, WK, Okreg, Klub, Plec, `Status`, Znizki, Czlonek  FROM `zawodnicy+` LEFT OUTER JOIN	wpisowe ON wpisowe.`znizka`=`zawodnicy+`.`Status` AND `zawodnicy+`.`Znizki`= 'T');
UPDATE rozliczenie SET wpisowe = ( SELECT ile FROM wpisowe WHERE znizka = 'niezrzeszony' ) WHERE cezar >= 50000;
UPDATE rozliczenie SET wpisowe = ( SELECT ile FROM wpisowe WHERE znizka = 'normalny' ) WHERE wpisowe IS NULL;
DELETE FROM rozliczenie WHERE Nazwisko IS NULL;
END//
DELIMITER ;


-- Dumping structure for table makabi2.sektory
CREATE TABLE IF NOT EXISTS `sektory` (
  `numtab` int(4) NOT NULL,
  `seknum` tinyint(2) NOT NULL DEFAULT '0',
  `seklit` char(2) COLLATE utf8_polish_ci DEFAULT NULL,
  `sektab` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`numtab`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

-- Dumping data for table makabi2.sektory: 13 rows
INSERT INTO `sektory` (`numtab`, `seknum`, `seklit`, `sektab`) VALUES
	(1, 1, 'A', 1),
	(2, 1, 'A', 2),
	(3, 1, 'A', 3),
	(4, 1, 'A', 4),
	(5, 1, 'A', 5),
	(6, 1, 'A', 6),
	(7, 1, 'A', 7),
	(8, 1, 'A', 8),
	(9, 1, 'A', 9),
	(10, 1, 'A', 10),
	(11, 1, 'A', 11),
	(12, 1, 'A', 12),
	(13, 1, 'A', 13);


-- Dumping structure for view makabi2.tmp_kojarzenie
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `tmp_kojarzenie` (
	`a` INT(11) NULL,
	`b` INT(11) NULL,
	`rnd` INT(11) NOT NULL
) ENGINE=MyISAM;


-- Dumping structure for table makabi2.wpisowe
CREATE TABLE IF NOT EXISTS `wpisowe` (
  `znizka` varchar(25) CHARACTER SET utf8 COLLATE utf8_polish_ci DEFAULT NULL,
  `ile` bigint(21) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table makabi2.wpisowe: 6 rows
INSERT INTO `wpisowe` (`znizka`, `ile`) VALUES
	('M', 5),
	('J', 15),
	('N', 15),
	('S', 15),
	('normalny', 20),
	('niezrzeszony', 10);


-- Dumping structure for table makabi2.zapisy
CREATE TABLE IF NOT EXISTS `zapisy` (
  `stol` int(4) NOT NULL,
  `nrr` int(4) NOT NULL COMMENT 'maszynowy',
  `rnd` int(4) NOT NULL DEFAULT '0',
  `gpl` tinyint(1) DEFAULT '0' COMMENT 'grupa podwójnego liczenia',
  `zN` int(4) DEFAULT '0',
  `zS` int(4) DEFAULT '0',
  `zE` int(4) DEFAULT '0',
  `zW` int(4) DEFAULT '0',
  `kont` varchar(100) COLLATE utf8_polish_ci DEFAULT NULL,
  `rozg` char(1) COLLATE utf8_polish_ci DEFAULT NULL,
  `wist` char(3) COLLATE utf8_polish_ci DEFAULT NULL,
  `wyni` int(4) DEFAULT NULL,
  `zapi` int(4) DEFAULT NULL,
  `pNS` decimal(11,5) DEFAULT '0.00000',
  `pEW` decimal(11,5) DEFAULT '0.00000',
  UNIQUE KEY `stol` (`stol`,`nrr`,`rnd`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

-- Dumping data for table makabi2.zapisy: 390 rows
INSERT INTO `zapisy` (`stol`, `nrr`, `rnd`, `gpl`, `zN`, `zS`, `zE`, `zW`, `kont`, `rozg`, `wist`, `wyni`, `zapi`, `pNS`, `pEW`) VALUES
	(1, 1, 1, 0, 26, 0, 1, 0, '2 H', 'W', 'H3', 0, -110, 9.00000, 15.00000),
	(1, 2, 1, 0, 26, 0, 1, 0, '3 NT', 'E', 'S8', 1, -430, 10.00000, 14.00000),
	(2, 1, 15, 0, 25, 0, 7, 0, '4 H', 'E', 'DQ', -1, 50, 15.00000, 9.00000),
	(2, 2, 15, 0, 25, 0, 7, 0, '4 NT', 'E', 'S2', 1, -460, 3.00000, 21.00000),
	(3, 1, 14, 0, 15, 0, 8, 0, '1 NT x', 'N', 'H5', 0, 180, 24.00000, 0.00000),
	(3, 2, 14, 0, 15, 0, 8, 0, '3 NT', 'E', 'CJ', -1, 50, 21.00000, 3.00000),
	(4, 1, 13, 0, 24, 0, 2, 0, '3 H', 'E', 'DQ', -1, 50, 15.00000, 9.00000),
	(4, 2, 13, 0, 24, 0, 2, 0, '3 NT', 'E', 'CJ', -1, 50, 21.00000, 3.00000),
	(5, 1, 12, 0, 14, 0, 23, 0, '2 H', 'E', 'DQ', 0, -110, 9.00000, 15.00000),
	(5, 2, 12, 0, 14, 0, 23, 0, '3 NT', 'E', 'CJ', 2, -460, 3.00000, 21.00000),
	(6, 1, 11, 0, 10, 0, 22, 0, '2 D', 'S', 'HJ', 0, 90, 20.00000, 4.00000),
	(6, 2, 11, 0, 10, 0, 22, 0, '6 H', 'W', 'D8', -1, 50, 21.00000, 3.00000),
	(7, 1, 10, 0, 5, 0, 21, 0, '4 H', 'W', 'D5', -2, 100, 22.00000, 2.00000),
	(7, 2, 10, 0, 5, 0, 21, 0, '3 NT', 'E', 'CJ', 1, -430, 10.00000, 14.00000),
	(8, 1, 9, 0, 20, 0, 6, 0, '3 NT', 'E', 'DQ', 0, -400, 2.00000, 22.00000),
	(8, 2, 9, 0, 20, 0, 6, 0, '3 NT', 'E', 'CJ', 1, -430, 10.00000, 14.00000),
	(9, 1, 8, 0, 19, 0, 4, 0, '5 C x', 'N', 'HA', -3, -500, 0.00000, 24.00000),
	(9, 2, 8, 0, 19, 0, 4, 0, '3 NT', 'E', 'CJ', -1, 50, 21.00000, 3.00000),
	(10, 1, 7, 0, 18, 0, 13, 0, '4 H', 'E', 'DQ', -1, 50, 15.00000, 9.00000),
	(10, 2, 7, 0, 18, 0, 13, 0, '3 D', 'E', 'HQ', 1, -130, 16.00000, 8.00000),
	(11, 1, 6, 0, 11, 0, 9, 0, '3 NT', 'E', 'DQ', -1, 50, 15.00000, 9.00000),
	(11, 2, 6, 0, 11, 0, 9, 0, '3 NT', 'E', 'CJ', 1, -430, 10.00000, 14.00000),
	(12, 1, 5, 0, 3, 0, 17, 0, '3 H', 'E', 'DQ', 0, -140, 5.00000, 19.00000),
	(12, 2, 5, 0, 3, 0, 17, 0, '3 NT', 'E', 'D9', 1, -430, 10.00000, 14.00000),
	(13, 1, 4, 0, 12, 0, 16, 0, '3 H', 'E', 'DQ', 0, -140, 5.00000, 19.00000),
	(13, 2, 4, 0, 12, 0, 16, 0, '4 H', 'W', 'C5', 2, -480, 0.00000, 24.00000),
	(1, 3, 2, 0, 26, 0, 2, 0, '2 NT', 'W', 'H9', 2, -180, 16.00000, 8.00000),
	(1, 4, 2, 0, 26, 0, 2, 0, '2 S', 'S', 'HK', 0, 110, 18.00000, 6.00000),
	(2, 3, 1, 0, 25, 0, 8, 0, '3 NT', 'W', 'DJ', 1, -630, 5.00000, 19.00000),
	(2, 4, 1, 0, 25, 0, 8, 0, '2 S', 'S', 'HK', 1, 140, 23.00000, 1.00000),
	(3, 3, 15, 0, 1, 0, 9, 0, '3 NT', 'W', 'S4', 1, -630, 5.00000, 19.00000),
	(3, 4, 15, 0, 1, 0, 9, 0, '1 S', 'N', 'HK', 0, 80, 12.00000, 12.00000),
	(4, 3, 14, 0, 24, 0, 3, 0, '3 NT', 'W', 'D4', 0, -600, 12.00000, 12.00000),
	(4, 4, 14, 0, 24, 0, 3, 0, '1 H', 'W', 'H4', 1, -110, 3.00000, 21.00000),
	(5, 3, 13, 0, 15, 0, 23, 0, '3 D', 'W', 'SK', 0, -110, 20.00000, 4.00000),
	(5, 4, 13, 0, 15, 0, 23, 0, '2 S', 'S', 'HK', 0, 110, 18.00000, 6.00000),
	(6, 3, 12, 0, 11, 0, 22, 0, '4 NT', 'E', 'S10', -3, 300, 24.00000, 0.00000),
	(6, 4, 12, 0, 11, 0, 22, 0, '1 H', 'W', 'DQ', 1, -110, 3.00000, 21.00000),
	(7, 3, 11, 0, 6, 0, 21, 0, '1 NT', 'W', 'D4', 2, -150, 18.00000, 6.00000),
	(7, 4, 11, 0, 6, 0, 21, 0, '3 S', 'S', 'HK', -1, -100, 7.00000, 17.00000),
	(8, 3, 10, 0, 20, 0, 7, 0, '3 NT', 'W', 'S10', 1, -630, 5.00000, 19.00000),
	(8, 4, 10, 0, 20, 0, 7, 0, '1 NT', 'N', 'HA', -1, -100, 7.00000, 17.00000),
	(9, 3, 9, 0, 19, 0, 5, 0, '3 NT', 'W', 'SA', 0, -600, 12.00000, 12.00000),
	(9, 4, 9, 0, 19, 0, 5, 0, '1 H', 'W', 'DQ', 0, -80, 10.00000, 14.00000),
	(10, 3, 8, 0, 18, 0, 14, 0, '3 NT', 'W', 'D3', 0, -600, 12.00000, 12.00000),
	(10, 4, 8, 0, 18, 0, 14, 0, '3 NT', 'S', 'HK', -3, -300, 0.00000, 24.00000),
	(11, 3, 7, 0, 12, 0, 10, 0, '3 NT', 'E', 'DJ', 2, -660, 0.00000, 24.00000),
	(11, 4, 7, 0, 12, 0, 10, 0, '2 S', 'S', 'HK', 0, 110, 18.00000, 6.00000),
	(12, 3, 6, 0, 4, 0, 17, 0, '2 NT', 'E', 'S5', -1, 100, 22.00000, 2.00000),
	(12, 4, 6, 0, 4, 0, 17, 0, '3 H', 'W', 'H9', -1, 100, 14.00000, 10.00000),
	(13, 3, 5, 0, 13, 0, 16, 0, '3 NT', 'W', 'DJ', 1, -630, 5.00000, 19.00000),
	(13, 4, 5, 0, 13, 0, 16, 0, '2 S', 'S', 'HK', 1, 140, 23.00000, 1.00000),
	(1, 5, 3, 0, 26, 0, 3, 0, '4 S', 'E', 'CQ', 0, -420, 11.00000, 13.00000),
	(1, 6, 3, 0, 26, 0, 3, 0, '3 D', 'S', 'C7', 2, 150, 11.00000, 13.00000),
	(2, 5, 2, 0, 25, 0, 9, 0, '4 S', 'W', 'CQ', 0, -420, 11.00000, 13.00000),
	(2, 6, 2, 0, 25, 0, 9, 0, '3 NT', 'N', 'S6', 0, 400, 17.00000, 7.00000),
	(3, 5, 1, 0, 2, 0, 10, 0, '6 S', 'E', 'S3', -2, 100, 22.00000, 2.00000),
	(3, 6, 1, 0, 2, 0, 10, 0, '3 D', 'N', 'S9', 1, 130, 8.00000, 16.00000),
	(4, 5, 15, 0, 24, 0, 4, 0, '3 NT', 'W', 'CQ', 0, -400, 18.00000, 6.00000),
	(4, 6, 15, 0, 24, 0, 4, 0, '5 D', 'S', 'HA', 0, 400, 17.00000, 7.00000),
	(5, 5, 14, 0, 1, 0, 23, 0, '3 NT', 'W', 'C8', 0, -400, 18.00000, 6.00000),
	(5, 6, 14, 0, 1, 0, 23, 0, '4 D', 'S', 'C8', 1, 150, 11.00000, 13.00000),
	(6, 5, 13, 0, 12, 0, 22, 0, '2 C x', 'N', 'DQ', -2, -500, 0.00000, 24.00000),
	(6, 6, 13, 0, 12, 0, 22, 0, '5 D', 'S', 'H5', 0, 400, 17.00000, 7.00000),
	(7, 5, 12, 0, 7, 0, 21, 0, '4 S', 'W', 'CQ', 0, -420, 11.00000, 13.00000),
	(7, 6, 12, 0, 7, 0, 21, 0, '5 D', 'S', 'HA', -1, -50, 4.00000, 20.00000),
	(8, 5, 11, 0, 20, 0, 8, 0, '3 NT', 'W', 'CQ', 0, -400, 18.00000, 6.00000),
	(8, 6, 11, 0, 20, 0, 8, 0, '4 H x', 'N', 'SK', -1, -100, 0.00000, 24.00000),
	(9, 5, 10, 0, 19, 0, 6, 0, '4 S', 'E', 'C7', 0, -420, 11.00000, 13.00000),
	(9, 6, 10, 0, 19, 0, 6, 0, '2 S', 'W', 'HK', -4, 400, 17.00000, 7.00000),
	(10, 5, 9, 0, 18, 0, 15, 0, '3 NT', 'W', 'C9', 2, -460, 3.00000, 21.00000),
	(10, 6, 9, 0, 18, 0, 15, 0, '5 D', 'S', 'HA', -1, -50, 4.00000, 20.00000),
	(11, 5, 8, 0, 13, 0, 11, 0, '6 S', 'E', 'D6', -3, 150, 24.00000, 0.00000),
	(11, 6, 8, 0, 13, 0, 11, 0, '3 NT x', 'N', 'H6', 1, 650, 22.00000, 2.00000),
	(12, 5, 7, 0, 5, 0, 17, 0, '3 NT', 'E', 'SQ', 2, -460, 3.00000, 21.00000),
	(12, 6, 7, 0, 5, 0, 17, 0, '5 D', 'S', 'S9', -1, -50, 4.00000, 20.00000),
	(13, 5, 6, 0, 14, 0, 16, 0, '3 NT', 'W', 'CQ', 1, -430, 6.00000, 18.00000),
	(13, 6, 6, 0, 14, 0, 16, 0, '3 D x', 'S', 'DA', 2, 670, 24.00000, 0.00000),
	(1, 7, 4, 0, 26, 0, 4, 0, '4 S', 'E', 'C5', -1, 100, 11.00000, 13.00000),
	(1, 8, 4, 0, 26, 0, 4, 0, '2 H', 'S', 'DJ', 1, 140, 13.00000, 11.00000),
	(2, 7, 3, 0, 25, 0, 10, 0, '4 H', 'E', 'C6', 0, -620, 2.00000, 22.00000),
	(2, 8, 3, 0, 25, 0, 10, 0, '3 H', 'S', 'SQ', 0, 140, 13.00000, 11.00000),
	(3, 7, 2, 0, 3, 0, 11, 0, '4 H', 'E', 'C6', -2, 200, 19.00000, 5.00000),
	(3, 8, 2, 0, 3, 0, 11, 0, '2 H', 'S', 'SQ', 1, 140, 13.00000, 11.00000),
	(4, 7, 1, 0, 24, 0, 5, 0, '4 H', 'E', 'S5', -2, 200, 19.00000, 5.00000),
	(4, 8, 1, 0, 24, 0, 5, 0, '3 H', 'S', 'SQ', 0, 140, 13.00000, 11.00000),
	(5, 7, 15, 0, 2, 0, 23, 0, '4 H', 'E', 'H8', -1, 100, 11.00000, 13.00000),
	(5, 8, 15, 0, 2, 0, 23, 0, '2 H', 'S', 'DJ', 1, 140, 13.00000, 11.00000),
	(6, 7, 14, 0, 13, 0, 22, 0, '2 NT', 'E', 'S6', -4, 400, 24.00000, 0.00000),
	(6, 8, 14, 0, 13, 0, 22, 0, '2 H', 'N', 'D6', 1, 140, 13.00000, 11.00000),
	(7, 7, 13, 0, 8, 0, 21, 0, '4 H', 'E', 'S3', -1, 100, 11.00000, 13.00000),
	(7, 8, 13, 0, 8, 0, 21, 0, '3 NT', 'N', 'C5', -1, -50, 1.00000, 23.00000),
	(8, 7, 12, 0, 20, 0, 9, 0, '4 H', 'W', 'C6', 0, -620, 2.00000, 22.00000),
	(8, 8, 12, 0, 20, 0, 9, 0, '4 H', 'S', 'DJ', -1, -50, 1.00000, 23.00000),
	(9, 7, 11, 0, 19, 0, 7, 0, '2 H', 'E', 'H8', 0, -110, 6.00000, 18.00000),
	(9, 8, 11, 0, 19, 0, 7, 0, '3 NT', 'N', 'S4', 0, 400, 24.00000, 0.00000),
	(10, 7, 10, 0, 18, 0, 1, 0, '4 H', 'E', 'DA', 0, -620, 2.00000, 22.00000),
	(10, 8, 10, 0, 18, 0, 1, 0, '3 H', 'S', 'S7', 0, 140, 13.00000, 11.00000),
	(11, 7, 9, 0, 14, 0, 12, 0, '4 H', 'E', 'C6', -1, 100, 11.00000, 13.00000),
	(11, 8, 9, 0, 14, 0, 12, 0, '2 H', 'S', 'SQ', 2, 170, 22.00000, 2.00000),
	(12, 7, 8, 0, 6, 0, 17, 0, '3 NT', 'E', 'S3', -2, 200, 19.00000, 5.00000),
	(12, 8, 8, 0, 6, 0, 17, 0, '2 H', 'S', 'SQ', 1, 140, 13.00000, 11.00000),
	(13, 7, 7, 0, 15, 0, 16, 0, '4 H', 'E', 'C8', -2, 200, 19.00000, 5.00000),
	(13, 8, 7, 0, 15, 0, 16, 0, '1 NT', 'N', 'S4', 1, 120, 4.00000, 20.00000),
	(1, 9, 5, 0, 26, 0, 5, 0, '4 S', 'E', 'SQ', 1, -650, 9.00000, 15.00000),
	(1, 10, 5, 0, 26, 0, 5, 0, '3 NT', 'E', 'H5', 0, -600, 11.00000, 13.00000),
	(2, 9, 4, 0, 25, 0, 11, 0, '4 S', 'E', 'SQ', 1, -650, 9.00000, 15.00000),
	(2, 10, 4, 0, 25, 0, 11, 0, '2 H x', 'N', 'DJ', -2, -500, 14.00000, 10.00000),
	(3, 9, 3, 0, 4, 0, 12, 0, '5 S', 'E', 'DQ', 0, -650, 9.00000, 15.00000),
	(3, 10, 3, 0, 4, 0, 12, 0, '3 NT', 'E', 'H5', 0, -600, 11.00000, 13.00000),
	(4, 9, 2, 0, 24, 0, 6, 0, '4 S', 'E', 'SQ', 1, -650, 9.00000, 15.00000),
	(4, 10, 2, 0, 24, 0, 6, 0, '6 C', 'E', 'HA', -3, 300, 24.00000, 0.00000),
	(5, 9, 1, 0, 3, 0, 23, 0, '5 S', 'E', 'C7', -1, 100, 24.00000, 0.00000),
	(5, 10, 1, 0, 3, 0, 23, 0, '3 NT', 'E', 'S7', -2, 200, 22.00000, 2.00000),
	(6, 9, 15, 0, 14, 0, 22, 0, '4 S', 'E', 'C6', 0, -620, 21.00000, 3.00000),
	(6, 10, 15, 0, 14, 0, 22, 0, '3 NT', 'E', 'C9', -1, 100, 19.00000, 5.00000),
	(7, 9, 14, 0, 9, 0, 21, 0, '4 S', 'E', 'SQ', 1, -650, 9.00000, 15.00000),
	(7, 10, 14, 0, 9, 0, 21, 0, '3 NT', 'E', 'H3', -1, 100, 19.00000, 5.00000),
	(8, 9, 13, 0, 20, 0, 10, 0, '4 S', 'W', 'C6', 0, -620, 21.00000, 3.00000),
	(8, 10, 13, 0, 20, 0, 10, 0, '3 NT', 'W', 'HA', 1, -630, 4.00000, 20.00000),
	(9, 9, 12, 0, 19, 0, 8, 0, '4 S', 'E', 'DQ', 1, -650, 9.00000, 15.00000),
	(9, 10, 12, 0, 19, 0, 8, 0, '3 NT', 'W', 'H8', 1, -630, 4.00000, 20.00000),
	(10, 9, 11, 0, 18, 0, 2, 0, '4 S', 'E', 'DQ', 1, -650, 9.00000, 15.00000),
	(10, 10, 11, 0, 18, 0, 2, 0, '3 NT', 'E', 'D3', 1, -630, 4.00000, 20.00000),
	(11, 9, 10, 0, 15, 0, 13, 0, '4 S', 'E', 'C7', 1, -650, 9.00000, 15.00000),
	(11, 10, 10, 0, 15, 0, 13, 0, '3 NT', 'E', 'C5', 1, -630, 4.00000, 20.00000),
	(12, 9, 9, 0, 7, 0, 17, 0, '5 S', 'E', 'H2', 0, -650, 9.00000, 15.00000),
	(12, 10, 9, 0, 7, 0, 17, 0, '3 NT', 'E', 'D3', 1, -630, 4.00000, 20.00000),
	(13, 9, 8, 0, 1, 0, 16, 0, '5 S', 'E', 'SQ', 0, -650, 9.00000, 15.00000),
	(13, 10, 8, 0, 1, 0, 16, 0, '3 C', 'E', 'HA', 2, -150, 16.00000, 8.00000),
	(1, 11, 6, 0, 26, 0, 6, 0, '4 S', 'N', 'D3', 1, 450, 23.92000, 0.08000),
	(1, 12, 6, 0, 26, 0, 6, 0, '3 NT', 'W', 'DJ', 0, -400, 18.00000, 6.00000),
	(2, 11, 5, 0, 25, 0, 12, 0, '4 D', 'N', 'S7', 1, 150, 10.92000, 13.08000),
	(2, 12, 5, 0, 25, 0, 12, 0, '3 NT', 'W', 'DJ', 1, -430, 9.00000, 15.00000),
	(3, 11, 4, 0, 5, 0, 13, 0, '4 S', 'N', 'D7', -1, -50, 7.67000, 16.33000),
	(3, 12, 4, 0, 5, 0, 13, 0, '3 S', 'W', 'H6', 1, -170, 21.00000, 3.00000),
	(4, 11, 3, 0, 24, 0, 7, 0, '3 NT', 'S', 'H5', -1, -50, 7.67000, 16.33000),
	(4, 12, 3, 0, 24, 0, 7, 0, '4 S', 'E', 'C8', 0, -420, 16.00000, 8.00000),
	(5, 11, 2, 0, 4, 0, 23, 0, '4 S', 'N', 'D3', 0, 420, 17.42000, 6.58000),
	(5, 12, 2, 0, 4, 0, 23, 0, '3 NT', 'E', 'HJ', 1, -430, 9.00000, 15.00000),
	(6, 11, 1, 0, 15, 0, 22, 0, '3 NT', 'S', 'H6', 1, 430, 20.67000, 3.33000),
	(6, 12, 1, 0, 15, 0, 22, 0, '2 H x', 'S', 'C3', -4, -1100, 0.00000, 24.00000),
	(7, 11, 15, 0, 10, 0, 21, 0, '3 NT', 'S', 'H5', 0, 400, 14.17000, 9.83000),
	(7, 12, 15, 0, 10, 0, 21, 0, '3 C', 'E', 'CJ', 1, -130, 24.00000, 0.00000),
	(8, 11, 14, 0, 20, 0, 11, 0, 'APP', NULL, NULL, NULL, 10001, 14.40000, 14.40000),
	(8, 12, 14, 0, 20, 0, 11, 0, '2 S', 'E', 'D6', 2, -170, 21.00000, 3.00000),
	(9, 11, 13, 0, 19, 0, 9, 0, '3 NT', 'S', 'H5', 0, 400, 14.17000, 9.83000),
	(9, 12, 13, 0, 19, 0, 9, 0, '3 NT', 'E', 'C8', 1, -430, 9.00000, 15.00000),
	(10, 11, 12, 0, 18, 0, 3, 0, '4 S', 'N', 'H4', -3, -150, 0.08000, 23.92000),
	(10, 12, 12, 0, 18, 0, 3, 0, '3 NT', 'E', 'C9', 1, -430, 9.00000, 15.00000),
	(11, 11, 11, 0, 1, 0, 14, 0, '3 NT', 'S', 'H10', 1, 430, 20.67000, 3.33000),
	(11, 12, 11, 0, 1, 0, 14, 0, '3 NT', 'W', 'H6', 1, -430, 9.00000, 15.00000),
	(12, 11, 10, 0, 8, 0, 17, 0, '6 NT', 'S', 'H5', -2, -100, 3.33000, 20.67000),
	(12, 12, 10, 0, 8, 0, 17, 0, '3 NT', 'W', 'HJ', 1, -430, 9.00000, 15.00000),
	(13, 11, 9, 0, 2, 0, 16, 0, '4 S', 'N', 'H6', -2, -100, 3.33000, 20.67000),
	(13, 12, 9, 0, 2, 0, 16, 0, '3 NT', 'E', 'C8', 2, -460, 2.00000, 22.00000),
	(1, 13, 7, 0, 26, 0, 7, 0, '3 NT', 'S', 'S5', 0, 600, 16.00000, 8.00000),
	(1, 14, 7, 0, 26, 0, 7, 0, '3 NT', 'N', 'C4', 1, 430, 20.00000, 4.00000),
	(2, 13, 6, 0, 25, 0, 13, 0, '5 D x', 'S', 'HK', -1, -200, 6.00000, 18.00000),
	(2, 14, 6, 0, 25, 0, 13, 0, '3 H x', 'E', 'D5', -2, 300, 13.00000, 11.00000),
	(3, 13, 5, 0, 6, 0, 14, 0, '5 D', 'N', 'HK', 0, 600, 16.00000, 8.00000),
	(3, 14, 5, 0, 6, 0, 14, 0, '4 S', 'S', 'H8', -2, -100, 3.00000, 21.00000),
	(4, 13, 4, 0, 24, 0, 8, 0, '6 D x', 'N', 'HK', -1, -200, 6.00000, 18.00000),
	(4, 14, 4, 0, 24, 0, 8, 0, '4 S', 'S', 'H3', -2, -100, 3.00000, 21.00000),
	(5, 13, 3, 0, 5, 0, 23, 0, '4 H x', 'W', 'DA', 0, -790, 0.00000, 24.00000),
	(5, 14, 3, 0, 5, 0, 23, 0, '4 NT', 'N', 'HA', 0, 430, 20.00000, 4.00000),
	(6, 13, 2, 0, 1, 0, 22, 0, '5 D x', 'N', 'HK', 0, 750, 22.00000, 2.00000),
	(6, 14, 2, 0, 1, 0, 22, 0, '5 D', 'S', 'H3', -1, -50, 7.00000, 17.00000),
	(7, 13, 1, 0, 11, 0, 21, 0, '3 D', 'N', 'HA', 2, 150, 10.00000, 14.00000),
	(7, 14, 1, 0, 11, 0, 21, 0, '3 NT', 'N', 'HQ', -4, -200, 0.00000, 24.00000),
	(8, 13, 15, 0, 20, 0, 12, 0, '5 H x', 'W', 'C2', -3, 800, 24.00000, 0.00000),
	(8, 14, 15, 0, 20, 0, 12, 0, '3 NT', 'N', 'HQ', -1, -50, 7.00000, 17.00000),
	(9, 13, 14, 0, 19, 0, 10, 0, '4 H', 'E', 'D5', 0, -620, 2.00000, 22.00000),
	(9, 14, 14, 0, 19, 0, 10, 0, '3 NT', 'N', 'S5', 1, 430, 20.00000, 4.00000),
	(10, 13, 13, 0, 18, 0, 4, 0, '5 D x', 'N', 'HK', -1, -200, 6.00000, 18.00000),
	(10, 14, 13, 0, 18, 0, 4, 0, '3 H x', 'E', 'DJ', -1, 100, 10.00000, 14.00000),
	(11, 13, 12, 0, 2, 0, 15, 0, '6 C x', 'E', 'DK', -2, 500, 12.00000, 12.00000),
	(11, 14, 12, 0, 2, 0, 15, 0, '3 NT', 'N', 'S9', 1, 430, 20.00000, 4.00000),
	(12, 13, 11, 0, 9, 0, 17, 0, '3 NT', 'S', 'H3', 1, 630, 20.00000, 4.00000),
	(12, 14, 11, 0, 9, 0, 17, 0, '4 H x', 'E', 'SA', -2, 300, 13.00000, 11.00000),
	(13, 13, 10, 0, 3, 0, 16, 0, '3 NT', 'S', 'H9', 0, 600, 16.00000, 8.00000),
	(13, 14, 10, 0, 3, 0, 16, 0, '3 NT', 'N', 'H10', 1, 430, 20.00000, 4.00000),
	(1, 15, 8, 0, 26, 0, 8, 0, '3 D', 'N', 'SA', 0, 110, 22.00000, 2.00000),
	(1, 16, 8, 0, 26, 0, 8, 0, '6 NT', 'E', 'S10', 0, -1440, 16.00000, 8.00000),
	(2, 15, 7, 0, 25, 0, 14, 0, '1 S', 'E', 'D6', 0, -80, 14.00000, 10.00000),
	(2, 16, 7, 0, 25, 0, 14, 0, '4 H', 'E', 'CK', 3, -710, 21.00000, 3.00000),
	(3, 15, 6, 0, 7, 0, 15, 0, '2 H', 'E', 'D10', 0, -110, 11.00000, 13.00000),
	(3, 16, 6, 0, 7, 0, 15, 0, '4 H', 'W', 'CK', 3, -710, 21.00000, 3.00000),
	(4, 15, 5, 0, 24, 0, 9, 0, '2 H', 'E', 'D9', 1, -140, 5.00000, 19.00000),
	(4, 16, 5, 0, 24, 0, 9, 0, '5 H', 'E', 'CK', 2, -710, 21.00000, 3.00000),
	(5, 15, 4, 0, 6, 0, 23, 0, '1 S', 'E', 'D9', -1, 50, 17.00000, 7.00000),
	(5, 16, 4, 0, 6, 0, 23, 0, '6 H', 'E', 'H9', 1, -1460, 9.00000, 15.00000),
	(6, 15, 3, 0, 2, 0, 22, 0, '2 D', 'N', 'D3', 0, 90, 20.00000, 4.00000),
	(6, 16, 3, 0, 2, 0, 22, 0, '6 H', 'E', 'S10', 1, -1460, 9.00000, 15.00000),
	(7, 15, 2, 0, 12, 0, 21, 0, '2 H', 'E', 'D10', 0, -110, 11.00000, 13.00000),
	(7, 16, 2, 0, 12, 0, 21, 0, '6 H', 'E', 'CK', 1, -1460, 9.00000, 15.00000),
	(8, 15, 1, 0, 20, 0, 13, 0, '3 H', 'E', 'H4', 0, -140, 5.00000, 19.00000),
	(8, 16, 1, 0, 20, 0, 13, 0, '7 H', 'E', 'CK', 0, -2210, 1.00000, 23.00000),
	(9, 15, 15, 0, 19, 0, 11, 0, '3 H', 'E', 'D10', 0, -140, 5.00000, 19.00000),
	(9, 16, 15, 0, 19, 0, 11, 0, '6 H', 'E', 'H9', 1, -1460, 9.00000, 15.00000),
	(10, 15, 14, 0, 18, 0, 5, 0, '2 H', 'E', 'S6', 2, -170, 0.00000, 24.00000),
	(10, 16, 14, 0, 18, 0, 5, 0, '6 H', 'E', 'CJ', 1, -1460, 9.00000, 15.00000),
	(11, 15, 13, 0, 3, 0, 1, 0, '2 D x', 'N', 'D3', 1, 380, 24.00000, 0.00000),
	(11, 16, 13, 0, 3, 0, 1, 0, '7 H', 'E', 'CK', 0, -2210, 1.00000, 23.00000),
	(12, 15, 12, 0, 10, 0, 17, 0, '3 H', 'E', 'D10', 0, -140, 5.00000, 19.00000),
	(12, 16, 12, 0, 10, 0, 17, 0, '6 H', 'E', 'CK', 1, -1460, 9.00000, 15.00000),
	(13, 15, 11, 0, 4, 0, 16, 0, '3 H', 'E', 'D10', -1, 50, 17.00000, 7.00000),
	(13, 16, 11, 0, 4, 0, 16, 0, '4 H', 'E', 'CK', 3, -710, 21.00000, 3.00000),
	(1, 17, 9, 0, 26, 0, 9, 0, '5 H', 'N', 'SA', 1, 480, 8.00000, 16.00000),
	(1, 18, 9, 0, 26, 0, 9, 0, '1 NT', 'E', 'C5', 2, -150, 1.00000, 23.00000),
	(2, 17, 8, 0, 25, 0, 15, 0, '3 H', 'N', 'SK', 3, 230, 0.00000, 24.00000),
	(2, 18, 8, 0, 25, 0, 15, 0, '2 C', 'E', 'D5', 1, -110, 10.00000, 14.00000),
	(3, 17, 7, 0, 8, 0, 1, 0, '4 H', 'N', 'SA', 2, 480, 8.00000, 16.00000),
	(3, 18, 7, 0, 8, 0, 1, 0, '3 C', 'E', 'D5', 0, -110, 10.00000, 14.00000),
	(4, 17, 6, 0, 24, 0, 10, 0, '5 H', 'N', 'SA', 1, 480, 8.00000, 16.00000),
	(4, 18, 6, 0, 24, 0, 10, 0, '3 C', 'E', 'D5', 0, -110, 10.00000, 14.00000),
	(5, 17, 5, 0, 7, 0, 23, 0, '4 S x', 'E', 'DQ', -4, 800, 20.00000, 4.00000),
	(5, 18, 5, 0, 7, 0, 23, 0, '3 NT', 'E', 'D5', -2, 100, 19.00000, 5.00000),
	(6, 17, 4, 0, 3, 0, 22, 0, '4 H', 'N', 'SA', 2, 480, 8.00000, 16.00000),
	(6, 18, 4, 0, 3, 0, 22, 0, '1 NT', 'E', 'S7', 1, -120, 5.00000, 19.00000),
	(7, 17, 3, 0, 13, 0, 21, 0, '6 H', 'N', 'SA', 0, 980, 23.00000, 1.00000),
	(7, 18, 3, 0, 13, 0, 21, 0, '3 C', 'E', 'C5', -2, 100, 19.00000, 5.00000),
	(8, 17, 2, 0, 20, 0, 14, 0, '4 H', 'N', 'C4', 2, 480, 8.00000, 16.00000),
	(8, 18, 2, 0, 20, 0, 14, 0, '1 NT', 'E', 'C5', 1, -120, 5.00000, 19.00000),
	(9, 17, 1, 0, 19, 0, 12, 0, '4 S x', 'E', 'DQ', -3, 500, 16.00000, 8.00000),
	(9, 18, 1, 0, 19, 0, 12, 0, '3 NT x', 'W', 'H7', -4, 800, 24.00000, 0.00000),
	(10, 17, 15, 0, 18, 0, 6, 0, '5 H x', 'N', 'SA', 1, 750, 18.00000, 6.00000),
	(10, 18, 15, 0, 18, 0, 6, 0, '3 NT', 'E', 'H8', -2, 100, 19.00000, 5.00000),
	(11, 17, 14, 0, 4, 0, 2, 0, '5 H', 'N', 'SA', 1, 480, 8.00000, 16.00000),
	(11, 18, 14, 0, 4, 0, 2, 0, '3 C', 'S', 'D5', -1, -100, 14.00000, 10.00000),
	(12, 17, 13, 0, 11, 0, 17, 0, '6 H', 'N', 'SA', 0, 980, 23.00000, 1.00000),
	(12, 18, 13, 0, 11, 0, 17, 0, '2 NT', 'E', 'C4', 1, -150, 1.00000, 23.00000),
	(13, 17, 12, 0, 5, 0, 16, 0, '4 H', 'S', 'SQ', 2, 480, 8.00000, 16.00000),
	(13, 18, 12, 0, 5, 0, 16, 0, '3 C', 'E', 'D5', -2, 100, 19.00000, 5.00000),
	(1, 19, 10, 0, 26, 0, 10, 0, '3 H', 'N', 'CK', -2, -100, 9.00000, 15.00000),
	(1, 20, 10, 0, 26, 0, 10, 0, '2 S', 'N', 'D5', -2, -200, 4.00000, 20.00000),
	(2, 19, 9, 0, 25, 0, 1, 0, '1 S', 'S', 'HJ', 1, 110, 16.00000, 8.00000),
	(2, 20, 9, 0, 25, 0, 1, 0, '2 D x', 'N', 'S3', 0, 180, 18.00000, 6.00000),
	(3, 19, 8, 0, 9, 0, 2, 0, '3 D', 'E', 'C3', -2, 200, 24.00000, 0.00000),
	(3, 20, 8, 0, 9, 0, 2, 0, '2 D', 'W', 'HA', -1, 100, 14.00000, 10.00000),
	(4, 19, 7, 0, 24, 0, 11, 0, '4 H', 'N', 'C9', -3, -150, 4.00000, 20.00000),
	(4, 20, 7, 0, 24, 0, 11, 0, '3 NT', 'N', 'C4', 0, 600, 22.00000, 2.00000),
	(5, 19, 6, 0, 8, 0, 23, 0, '2 S', 'N', 'HK', 0, 110, 16.00000, 8.00000),
	(5, 20, 6, 0, 8, 0, 23, 0, '3 NT', 'N', 'C7', -2, -200, 4.00000, 20.00000),
	(6, 19, 5, 0, 4, 0, 22, 0, '2 NT', 'N', 'C6', -2, -100, 9.00000, 15.00000),
	(6, 20, 5, 0, 4, 0, 22, 0, '1 NT', 'S', 'C8', -1, -100, 10.00000, 14.00000),
	(7, 19, 4, 0, 14, 0, 21, 0, '2 S', 'N', 'HA', 1, 140, 21.00000, 3.00000),
	(7, 20, 4, 0, 14, 0, 21, 0, '3 NT', 'N', 'C4', -2, -200, 4.00000, 20.00000),
	(8, 19, 3, 0, 20, 0, 15, 0, '2 S', 'N', 'HK', 1, 140, 21.00000, 3.00000),
	(8, 20, 3, 0, 20, 0, 15, 0, '2 C x', 'E', 'SQ', -2, 500, 20.00000, 4.00000),
	(9, 19, 2, 0, 19, 0, 13, 0, '3 H', 'S', 'D10', -3, -150, 4.00000, 20.00000),
	(9, 20, 2, 0, 19, 0, 13, 0, '3 NT', 'N', 'C4', 1, 630, 24.00000, 0.00000),
	(10, 19, 1, 0, 18, 0, 7, 0, '2 C x', 'N', 'HA', -3, -500, 0.00000, 24.00000),
	(10, 20, 1, 0, 18, 0, 7, 0, '2 NT', 'S', 'C8', -1, -100, 10.00000, 14.00000),
	(11, 19, 15, 0, 5, 0, 3, 0, '4 H', 'S', 'CJ', -3, -150, 4.00000, 20.00000),
	(11, 20, 15, 0, 5, 0, 3, 0, '3 D', 'S', 'H6', -3, -300, 0.00000, 24.00000),
	(12, 19, 14, 0, 12, 0, 17, 0, '2 H', 'N', 'D2', 0, 110, 16.00000, 8.00000),
	(12, 20, 14, 0, 12, 0, 17, 0, '1 NT', 'S', 'D4', 1, 120, 16.00000, 8.00000),
	(13, 19, 13, 0, 6, 0, 16, 0, '3 H', 'N', 'D9', -1, -50, 12.00000, 12.00000),
	(13, 20, 13, 0, 6, 0, 16, 0, '3 NT', 'N', 'C4', -1, -100, 10.00000, 14.00000),
	(1, 21, 11, 0, 26, 0, 11, 0, '3 NT', 'E', 'H8', 0, -400, 9.00000, 15.00000),
	(1, 22, 11, 0, 26, 0, 11, 0, '5 D', 'W', 'C8', 0, -600, 15.55000, 8.45000),
	(2, 21, 10, 0, 25, 0, 2, 0, '1 NT', 'E', 'H5', 3, -180, 15.00000, 9.00000),
	(2, 22, 10, 0, 25, 0, 2, 0, '3 NT', 'E', 'H3', 2, -660, 2.55000, 21.45000),
	(3, 21, 9, 0, 10, 0, 3, 0, '1 NT', 'E', 'H8', 2, -150, 20.00000, 4.00000),
	(3, 22, 9, 0, 10, 0, 3, 0, '3 NT', 'E', 'CQ', 2, -660, 2.55000, 21.45000),
	(4, 21, 8, 0, 24, 0, 12, 0, '3 NT', 'E', 'H8', 1, -430, 3.00000, 21.00000),
	(4, 22, 8, 0, 24, 0, 12, 0, '3 NT', 'E', 'CQ', 1, -630, 8.45000, 15.55000),
	(5, 21, 7, 0, 9, 0, 23, 0, '3 NT', 'E', 'SJ', 1, -430, 3.00000, 21.00000),
	(5, 22, 7, 0, 9, 0, 23, 0, '3 NT', 'E', 'H3', 1, -630, 8.45000, 15.55000),
	(6, 21, 6, 0, 5, 0, 22, 0, '3 NT', 'E', 'S4', 0, -400, 9.00000, 15.00000),
	(6, 22, 6, 0, 5, 0, 22, 0, '3 NT', 'E', 'CQ', 0, -600, 15.55000, 8.45000),
	(7, 21, 5, 0, 15, 0, 21, 0, '1 NT', 'E', 'H4', 3, -180, 15.00000, 9.00000),
	(7, 22, 5, 0, 15, 0, 21, 0, '3 D', 'W', 'C9', 3, -170, 19.09000, 4.91000),
	(8, 21, 4, 0, 20, 0, 1, 0, '1 NT', 'E', 'H8', 2, -150, 20.00000, 4.00000),
	(8, 22, 4, 0, 20, 0, 1, 0, '2 S', 'W', 'D2', 1, -140, 21.45000, 2.55000),
	(9, 21, 3, 0, 19, 0, 14, 0, '2 NT', 'E', 'H8', 1, -150, 20.00000, 4.00000),
	(9, 22, 3, 0, 19, 0, 14, 0, '3 NT', 'E', 'H4', 2, -660, 2.55000, 21.45000),
	(10, 21, 2, 0, 18, 0, 8, 0, '3 NT', 'E', 'H9', -1, 50, 24.00000, 0.00000),
	(10, 22, 2, 1, 18, 0, 8, 0, '3 NT', 'W', 'C9', 0, -600, 15.60000, 13.20000),
	(11, 21, 1, 0, 6, 0, 4, 0, '3 NT', 'E', 'S4', 2, -460, 0.00000, 24.00000),
	(11, 22, 1, 1, 6, 0, 4, 0, '3 NT', 'W', 'C8', 1, -630, 13.20000, 15.60000),
	(12, 21, 15, 0, 13, 0, 17, 0, '3 NT', 'E', 'H5', 0, -400, 9.00000, 15.00000),
	(12, 22, 15, 0, 13, 0, 17, 0, '3 D', 'E', 'C8', 0, -110, 23.82000, 0.18000),
	(13, 21, 14, 0, 7, 0, 16, 0, '3 NT', 'E', 'H8', 0, -400, 9.00000, 15.00000),
	(13, 22, 14, 0, 7, 0, 16, 0, '5 D', 'E', 'CQ', 1, -620, 12.00000, 12.00000),
	(1, 23, 12, 0, 26, 0, 12, 0, '3 NT', 'S', 'S5', 1, 630, 22.00000, 2.00000),
	(1, 24, 12, 0, 26, 0, 12, 0, '2 S', 'W', 'H6', 1, -140, 3.00000, 21.00000),
	(2, 23, 11, 0, 25, 0, 3, 0, '3 D', 'N', 'HA', 1, 130, 5.00000, 19.00000),
	(2, 24, 11, 0, 25, 0, 3, 0, '1 NT', 'N', 'S6', -1, -50, 15.00000, 9.00000),
	(3, 23, 10, 0, 11, 0, 4, 0, '3 NT', 'N', 'S4', 0, 600, 15.00000, 9.00000),
	(3, 24, 10, 0, 11, 0, 4, 0, '2 S x', 'W', 'H4', -1, 100, 22.00000, 2.00000),
	(4, 23, 9, 0, 24, 0, 13, 0, '3 D', 'N', 'HA', 1, 130, 5.00000, 19.00000),
	(4, 24, 9, 0, 24, 0, 13, 0, '1 S', 'W', 'C6', 2, -140, 3.00000, 21.00000),
	(5, 23, 8, 0, 10, 0, 23, 0, '3 NT', 'N', 'D8', 1, 630, 22.00000, 2.00000),
	(5, 24, 8, 0, 10, 0, 23, 0, '2 S', 'E', 'D8', -1, 50, 19.00000, 5.00000),
	(6, 23, 7, 0, 6, 0, 22, 0, '3 NT', 'S', 'CK', 1, 630, 22.00000, 2.00000),
	(6, 24, 7, 0, 6, 0, 22, 0, '2 S', 'W', 'C6', -1, 50, 19.00000, 5.00000),
	(7, 23, 6, 0, 1, 0, 21, 0, '3 NT', 'S', 'S3', 0, 600, 15.00000, 9.00000),
	(7, 24, 6, 0, 1, 0, 21, 0, '2 S', 'W', 'H6', 1, -140, 3.00000, 21.00000),
	(8, 23, 5, 0, 20, 0, 2, 0, '3 NT', 'N', 'S5', 0, 600, 15.00000, 9.00000),
	(8, 24, 5, 0, 20, 0, 2, 0, '2 S', 'W', 'C6', 1, -140, 3.00000, 21.00000),
	(9, 23, 4, 0, 19, 0, 15, 0, '2 D', 'N', 'HK', 2, 130, 5.00000, 19.00000),
	(9, 24, 4, 0, 19, 0, 15, 0, '2 S', 'W', 'C6', 0, -110, 9.00000, 15.00000),
	(10, 23, 3, 0, 18, 0, 9, 0, '3 D', 'N', 'HA', 1, 130, 5.00000, 19.00000),
	(10, 24, 3, 0, 18, 0, 9, 0, '3 H', 'S', 'D5', -2, -100, 12.00000, 12.00000),
	(11, 23, 2, 0, 7, 0, 5, 0, '3 D', 'N', 'S2', 1, 130, 5.00000, 19.00000),
	(11, 24, 2, 0, 7, 0, 5, 0, '2 H', 'S', 'S5', 0, 110, 24.00000, 0.00000),
	(12, 23, 1, 0, 14, 0, 17, 0, '3 NT', 'S', 'S4', 0, 600, 15.00000, 9.00000),
	(12, 24, 1, 0, 14, 0, 17, 0, '3 H', 'N', 'S4', -1, -50, 15.00000, 9.00000),
	(13, 23, 15, 0, 8, 0, 16, 0, '2 D', 'N', 'HA', 2, 130, 5.00000, 19.00000),
	(13, 24, 15, 0, 8, 0, 16, 0, '2 S', 'W', 'C5', 0, -110, 9.00000, 15.00000),
	(1, 25, 13, 0, 26, 0, 13, 0, '4 S', 'E', 'S6', 3, -710, 0.00000, 24.00000),
	(1, 26, 13, 0, 26, 0, 13, 0, '4 H', 'W', 'D5', -3, 300, 23.00000, 1.00000),
	(2, 25, 12, 0, 25, 0, 4, 0, '4 S', 'E', 'C8', 2, -680, 4.00000, 20.00000),
	(2, 26, 12, 0, 25, 0, 4, 0, '2 H', 'W', 'HJ', 0, -110, 2.00000, 22.00000),
	(3, 25, 11, 0, 12, 0, 5, 0, '4 S', 'E', 'HA', 0, -620, 14.00000, 10.00000),
	(3, 26, 11, 0, 12, 0, 5, 0, '2 H', 'W', 'D7', -1, 100, 15.00000, 9.00000),
	(4, 25, 10, 0, 24, 0, 14, 0, '4 S', 'E', 'C7', 1, -650, 9.00000, 15.00000),
	(4, 26, 10, 0, 24, 0, 14, 0, '2 H', 'E', 'S7', -1, 100, 15.00000, 9.00000),
	(5, 25, 9, 0, 11, 0, 23, 0, '4 S', 'W', 'HK', 0, -620, 14.00000, 10.00000),
	(5, 26, 9, 0, 11, 0, 23, 0, '2 H', 'W', 'D7', -1, 100, 15.00000, 9.00000),
	(6, 25, 8, 0, 7, 0, 22, 0, '4 S', 'W', 'DJ', 1, -650, 9.00000, 15.00000),
	(6, 26, 8, 0, 7, 0, 22, 0, '3 NT', 'E', 'S7', -3, 300, 23.00000, 1.00000),
	(7, 25, 7, 0, 2, 0, 21, 0, '4 S', 'E', 'D7', 2, -680, 4.00000, 20.00000),
	(7, 26, 7, 0, 2, 0, 21, 0, '2 H', 'E', 'D10', -1, 100, 15.00000, 9.00000),
	(8, 25, 6, 0, 20, 0, 3, 0, '3 NT', 'E', 'H6', -2, 200, 22.00000, 2.00000),
	(8, 26, 6, 0, 20, 0, 3, 0, '2 H', 'W', 'D7', -1, 100, 15.00000, 9.00000),
	(9, 25, 5, 0, 19, 0, 1, 0, '3 S', 'W', 'HK', 1, -170, 18.00000, 6.00000),
	(9, 26, 5, 0, 19, 0, 1, 0, 'PASS', 'N', '', 0, 0, 7.00000, 17.00000),
	(10, 25, 4, 0, 18, 0, 10, 0, '3 NT', 'E', 'H6', -2, 200, 22.00000, 2.00000),
	(10, 26, 4, 0, 18, 0, 10, 0, '1 NT', 'E', 'D6', 1, -120, 0.00000, 24.00000),
	(11, 25, 3, 0, 8, 0, 6, 0, '4 S', 'W', 'HK', 0, -620, 14.00000, 10.00000),
	(11, 26, 3, 0, 8, 0, 6, 0, '1 NT', 'E', 'S7', 0, -90, 4.00000, 20.00000),
	(12, 25, 2, 0, 15, 0, 17, 0, '4 S', 'E', 'S6', 2, -680, 4.00000, 20.00000),
	(12, 26, 2, 0, 15, 0, 17, 0, 'PASS', 'N', '', 0, 0, 7.00000, 17.00000),
	(13, 25, 1, 0, 9, 0, 16, 0, '3 NT', 'E', 'H2', -2, 200, 22.00000, 2.00000),
	(13, 26, 1, 0, 9, 0, 16, 0, '2 S', 'W', 'SJ', -1, 100, 15.00000, 9.00000),
	(1, 27, 14, 0, 26, 0, 14, 0, '3 H', 'W', 'CA', -2, 100, 12.00000, 12.00000),
	(1, 28, 14, 0, 26, 0, 14, 0, '3 S x', 'S', 'HK', -1, -200, 5.50000, 18.50000),
	(2, 27, 13, 0, 25, 0, 5, 0, '3 NT', 'N', 'HQ', -1, -50, 7.00000, 17.00000),
	(2, 28, 13, 0, 25, 0, 5, 0, '4 S x', 'S', 'DK', -2, -500, 0.08000, 23.92000),
	(3, 27, 12, 0, 13, 0, 6, 0, '1 NT', 'N', 'S5', 1, 120, 20.00000, 4.00000),
	(3, 28, 12, 0, 13, 0, 6, 0, 'AAA', NULL, NULL, 0, 10000, 12.00000, 12.00000),
	(4, 27, 11, 0, 24, 0, 15, 0, '1 NT', 'N', 'S7', 1, 120, 20.00000, 4.00000),
	(4, 28, 11, 0, 24, 0, 15, 0, '4 S x', 'S', 'HK', -1, -200, 5.50000, 18.50000),
	(5, 27, 10, 0, 12, 0, 23, 0, '3 NT', 'N', 'HQ', -1, -50, 7.00000, 17.00000),
	(5, 28, 10, 0, 12, 0, 23, 0, '4 H', 'W', 'SJ', -1, 50, 16.33000, 7.67000),
	(6, 27, 9, 0, 8, 0, 22, 0, '2 H x', 'W', 'CA', -1, 100, 12.00000, 12.00000),
	(6, 28, 9, 0, 8, 0, 22, 0, '4 H', 'W', 'SJ', -1, 50, 16.33000, 7.67000),
	(7, 27, 8, 0, 3, 0, 21, 0, '1 NT', 'N', 'HK', 1, 120, 20.00000, 4.00000),
	(7, 28, 8, 0, 3, 0, 21, 0, '4 H', 'E', 'SK', -1, 50, 16.33000, 7.67000),
	(8, 27, 7, 0, 20, 0, 4, 0, '1 NT', 'N', 'HK', -2, -100, 2.00000, 22.00000),
	(8, 28, 7, 0, 20, 0, 4, 0, '4 H', 'W', 'SJ', -1, 50, 16.33000, 7.67000),
	(9, 27, 6, 0, 19, 0, 2, 0, '3 D', 'S', 'S9', -2, -100, 2.00000, 22.00000),
	(9, 28, 6, 0, 19, 0, 2, 0, '4 H', 'W', 'SJ', -1, 50, 16.33000, 7.67000),
	(10, 27, 5, 0, 18, 0, 11, 0, '1 NT', 'S', 'S9', 1, 120, 20.00000, 4.00000),
	(10, 28, 5, 0, 18, 0, 11, 0, '4 H', 'W', 'SJ', -1, 50, 16.33000, 7.67000),
	(11, 27, 4, 0, 9, 0, 7, 0, '3 NT', 'N', 'DJ', -2, -100, 2.00000, 22.00000),
	(11, 28, 4, 0, 9, 0, 7, 0, '4 H', 'W', 'SJ', 0, -420, 2.25000, 21.75000),
	(12, 27, 3, 0, 1, 0, 17, 0, '1 NT', 'N', 'H5', 1, 120, 20.00000, 4.00000),
	(12, 28, 3, 0, 1, 0, 17, 0, '4 H', 'W', 'SJ', -1, 50, 16.33000, 7.67000),
	(13, 27, 2, 0, 10, 0, 16, 0, '2 H', 'E', 'D5', -2, 100, 12.00000, 12.00000),
	(13, 28, 2, 0, 10, 0, 16, 0, '4 H', 'W', 'S6', -1, 50, 16.33000, 7.67000),
	(1, 29, 15, 0, 26, 0, 15, 0, '2 H', 'S', 'CQ', 0, 110, 20.00000, 4.00000),
	(1, 30, 15, 0, 26, 0, 15, 0, '3 NT', 'E', 'D2', 0, -400, 20.00000, 4.00000),
	(2, 29, 14, 0, 25, 0, 6, 0, '3 C', 'E', 'HA', -1, 100, 13.00000, 11.00000),
	(2, 30, 14, 0, 25, 0, 6, 0, '4 S', 'W', 'CJ', 0, -420, 14.00000, 10.00000),
	(3, 29, 13, 0, 14, 0, 7, 0, '3 NT', 'W', 'H4', -1, 100, 13.00000, 11.00000),
	(3, 30, 13, 0, 14, 0, 7, 0, '3 NT', 'W', 'H3', 0, -400, 20.00000, 4.00000),
	(4, 29, 12, 0, 24, 0, 1, 0, '3 NT x', 'W', 'H4', -3, 800, 24.00000, 0.00000),
	(4, 30, 12, 0, 24, 0, 1, 0, '3 NT', 'E', 'D2', 0, -400, 20.00000, 4.00000),
	(5, 29, 11, 0, 13, 0, 23, 0, '2 H', 'N', 'CA', 0, 110, 20.00000, 4.00000),
	(5, 30, 11, 0, 13, 0, 23, 0, '3 NT', 'E', 'D2', 2, -460, 5.00000, 19.00000),
	(6, 29, 10, 0, 9, 0, 22, 0, '3 NT', 'W', 'H3', 0, -600, 0.00000, 24.00000),
	(6, 30, 10, 0, 9, 0, 22, 0, '3 NT', 'E', 'H3', 2, -460, 5.00000, 19.00000),
	(7, 29, 9, 0, 4, 0, 21, 0, '3 C', 'E', 'HA', -1, 100, 13.00000, 11.00000),
	(7, 30, 9, 0, 4, 0, 21, 0, '3 NT', 'E', 'D2', 0, -400, 20.00000, 4.00000),
	(8, 29, 8, 0, 20, 0, 5, 0, '2 S', 'W', 'HJ', 1, -140, 6.00000, 18.00000),
	(8, 30, 8, 0, 20, 0, 5, 0, '5 C', 'E', 'C5', 0, -400, 20.00000, 4.00000),
	(9, 29, 7, 0, 19, 0, 3, 0, '3 D', 'W', 'H4', -1, 100, 13.00000, 11.00000),
	(9, 30, 7, 0, 19, 0, 3, 0, '3 NT', 'E', 'H7', 2, -460, 5.00000, 19.00000),
	(10, 29, 6, 0, 18, 0, 12, 0, '3 H', 'S', 'CQ', -2, -200, 3.00000, 21.00000),
	(10, 30, 6, 0, 18, 0, 12, 0, '3 NT', 'E', 'D2', 1, -430, 12.00000, 12.00000),
	(11, 29, 5, 0, 10, 0, 8, 0, '3 D', 'E', 'H5', 0, -110, 8.00000, 16.00000),
	(11, 30, 5, 0, 10, 0, 8, 0, '3 NT', 'E', 'S4', 2, -460, 5.00000, 19.00000),
	(12, 29, 4, 0, 2, 0, 17, 0, '2 H', 'N', 'DJ', 0, 110, 20.00000, 4.00000),
	(12, 30, 4, 0, 2, 0, 17, 0, '3 NT', 'E', 'D2', 2, -460, 5.00000, 19.00000),
	(13, 29, 3, 0, 11, 0, 16, 0, '3 H', 'N', 'DJ', -2, -200, 3.00000, 21.00000),
	(13, 30, 3, 0, 11, 0, 16, 0, '3 NT', 'E', 'H7', 2, -460, 5.00000, 19.00000);


-- Dumping structure for table makabi2.zawodnicy
CREATE TABLE IF NOT EXISTS `zawodnicy` (
  `id` int(4) NOT NULL DEFAULT '0',
  `idp` int(4) NOT NULL DEFAULT '0',
  `cezar` char(5) COLLATE utf8_polish_ci DEFAULT '00000',
  `imie` varchar(25) COLLATE utf8_polish_ci DEFAULT NULL,
  `nazw` varchar(25) COLLATE utf8_polish_ci DEFAULT NULL,
  `wk` decimal(3,1) DEFAULT NULL,
  `okr` char(5) COLLATE utf8_polish_ci DEFAULT NULL,
  `klub` varchar(50) COLLATE utf8_polish_ci DEFAULT NULL,
  `cover` decimal(6,2) DEFAULT '0.00',
  `grupa` tinyint(2) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;

-- Dumping data for table makabi2.zawodnicy: 52 rows
INSERT INTO `zawodnicy` (`id`, `idp`, `cezar`, `imie`, `nazw`, `wk`, `okr`, `klub`, `cover`, `grupa`) VALUES
	(1, 1, '04719', 'Artur', 'Toeplitz', 4.0, 'PM', 'LOS Gdynia', 0.00, 0),
	(601, 1, '50007', 'Michał', 'Samet', NULL, '', 'AMATOR', 0.00, 0),
	(2, 2, '13580', 'Marek', 'Fijałkowski', 1.5, 'PM', 'Gdańskie Towarzystwo Brydżowe', 0.00, 0),
	(602, 2, '04659', 'Krzysztof', 'Niemkiewicz', 4.0, 'PM', 'HOTEL AMBER Gdańsk', 0.00, 0),
	(3, 3, '10794', 'Aleksander', 'Chrenowski', 13.0, 'PM', 'HOTEL AMBER Gdańsk', 0.00, 0),
	(603, 3, '15729', 'Aldona', 'Chrenowska', 2.5, 'PM', 'HOTEL AMBER Gdańsk', 0.00, 0),
	(4, 4, '11757', 'Paweł', 'Anastaziak', 2.5, 'PM', 'MERITUM Gdańsk', 0.00, 0),
	(604, 4, '09689', 'Joanna', 'Śliwowska', 2.0, 'PM', 'MERITUM Gdańsk', 0.00, 0),
	(5, 5, '04672', 'Andrzej', 'Pella', 2.5, 'PM', 'ACOL +76', 0.00, 0),
	(605, 5, '04590', 'Józef', 'Idczak', 7.0, 'PM', 'ANDRZEJKI BIS Gdańsk', 0.00, 0),
	(6, 6, '12390', 'Katarzyna', 'Klimkiewicz', 2.0, 'PM', 'WRÓBLE Gdańsk', 0.00, 0),
	(606, 6, '12391', 'Tomasz', 'Klimkiewicz', 2.5, 'PM', 'WRÓBLE Gdańsk', 0.00, 0),
	(7, 7, '04755', 'Danuta', 'Żabicka', 4.0, 'PM', 'FALCK-MEDYCYNA Gdańsk', 0.00, 0),
	(607, 7, '13707', 'Mirosław', 'Małypan', 2.0, 'PM', 'FALCK-MEDYCYNA Gdańsk', 0.00, 0),
	(8, 8, '15802', 'Adam', 'Suchodolski', NULL, 'PM', 'Gdańskie Towarzystwo Brydżowe', 0.00, 0),
	(608, 8, '13028', 'Piotr', 'Suchodolski', 2.5, 'PM', 'WIMPEL Gdańsk', 0.00, 0),
	(9, 9, '09034', 'Janusz', 'Warchoł', 4.0, 'PM', 'ACOL +76', 0.00, 0),
	(609, 9, '10820', 'Stanisław', 'Wachnicki', 2.5, 'PM', 'ACOL +76', 0.00, 0),
	(10, 10, '04632', 'Jacek', 'Lew', 13.0, 'PM', 'WIMPEL Gdańsk', 0.00, 0),
	(610, 10, '04684', 'Józef', 'Pochroń', 18.0, 'PM', 'WIMPEL Gdańsk', 0.00, 0),
	(11, 11, '04602', 'Aleksander', 'Kasprzak', 18.0, 'PM', 'SDK Tczew', 0.00, 0),
	(611, 11, '12680', 'Michał', 'Wróblewski', 2.0, 'PM', 'WRÓBLE Gdańsk', 0.00, 0),
	(12, 12, '50024', 'Dariusz', 'Milewski', NULL, 'AMA', 'AMATOR', 0.00, 0),
	(612, 12, '50025', 'Grzegorz', 'Czurylik', NULL, 'AMA', 'AMATOR', 0.00, 0),
	(13, 13, '04577', 'Gabriela', 'Gnacińska', 7.0, 'PM', 'FALCK-MEDYCYNA Gdańsk', 0.00, 0),
	(613, 13, '04696', 'Antoni', 'Sękowski', 18.0, 'PM', 'ALFA Gdynia', 0.00, 0),
	(14, 14, '50021', 'Kamil', 'Puczyłowski', NULL, 'AMA', 'AMATOR', 0.00, 0),
	(614, 14, '50059', 'Elżbieta', 'Pasiuk', NULL, 'AMA', 'AMATOR', 0.00, 0),
	(15, 15, '16207', 'Krzysztof', 'Dubno', 1.0, 'PM', 'WRÓBLE Gdańsk', 0.00, 0),
	(615, 15, '12681', 'Mirosław', 'Wróblewski', 1.5, 'PM', 'WRÓBLE Gdańsk', 0.00, 0),
	(16, 16, '15059', 'Agata', 'Chojnicka', 1.5, 'PM', 'Gdańskie Towarzystwo Brydżowe', 0.00, 0),
	(616, 16, '04615', 'Jarosław', 'Kotecki', 2.0, 'PM', 'WILCZKI Pogórze', 0.00, 0),
	(17, 17, '50002', 'Grażyna', 'Płocka', NULL, 'AMA', 'AMATOR', 0.00, 0),
	(617, 17, '04559', 'Kazimierz', 'Dominiak', 7.0, 'PM', 'KOSMETERIA Żukowo', 0.00, 0),
	(18, 18, '10804', 'Maria', 'Kierzkowska', 0.5, 'PM', '', 0.00, 0),
	(618, 18, '10805', 'Ryszard', 'Kierzkowski', 1.0, 'PM', '', 0.00, 0),
	(19, 19, '11726', 'Ryszard', 'Kamiński', 2.5, 'PM', 'MKSŁ KONRADIA Gdańsk', 0.00, 0),
	(619, 19, '15486', 'Ireneusz', 'Cebula', NULL, 'WP', '', 0.00, 0),
	(20, 20, '14485', 'Mirosław', 'Staniewicz', 1.5, 'PD', 'Jutrzenka Supraśl', 0.00, 0),
	(620, 20, '08472', 'Andrzej', 'Michałowski', 2.5, 'PM', 'Gdańskie Towarzystwo Brydżowe', 0.00, 0),
	(21, 21, '14422', 'Zbigniew', 'Dybizbański', 1.5, 'PM', 'SKOK UBEZPIECZENIA Sopot', 0.00, 0),
	(621, 21, '15139', 'Aleksander', 'Górski', 1.5, 'PM', 'SKOK UBEZPIECZENIA Sopot', 0.00, 0),
	(22, 22, '16228', 'Marta', 'Harat', 0.5, 'PM', 'WRÓBLE Gdańsk', 0.00, 0),
	(622, 22, '10348', 'Dariusz', 'Podfigurny', 2.5, 'PM', 'MERITUM Gdańsk', 0.00, 0),
	(23, 23, '04536', 'Marek', 'Boros', 4.0, 'PM', 'BUDMOR TREFL Władyslawowo', 0.00, 0),
	(623, 23, '01570', 'Zdzisław', 'Podrucki', 1.5, 'DS', '', 0.00, 0),
	(24, 24, '04706', 'Zdzisław', 'Stawski', 4.0, 'PM', 'MKSŁ KONRADIA Gdańsk', 0.00, 0),
	(624, 24, '09758', 'Adam', 'Kozłowski', 1.5, 'PM', 'MKSŁ KONRADIA Gdańsk', 0.00, 0),
	(25, 25, '50060', 'Stanisław', 'Modrzyński', 0.0, '', 'AMATOR', 0.00, 0),
	(625, 25, '50061', 'Jerzy', 'Biesiadowski', 0.0, '', 'AMATOR', 0.00, 0),
	(26, 26, '04563', 'Ireneusz', 'Dzikowski', 18.0, 'PM', 'ANDRZEJKI Gdańsk', 0.00, 0),
	(626, 26, '04735', 'Wacław', 'Wejknis', 13.0, 'PM', 'ANDRZEJKI Gdańsk', 0.00, 0);


-- Dumping structure for view makabi2.zawodnicy+
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `zawodnicy+` (
	`idp` INT(4) NOT NULL,
	`cezar` CHAR(5) NULL COLLATE 'utf8_polish_ci',
	`Imie` VARCHAR(30) NULL COLLATE 'utf8_polish_ci',
	`Nazwisko` VARCHAR(50) NULL COLLATE 'utf8_polish_ci',
	`WK` VARCHAR(10) NULL COLLATE 'utf8_polish_ci',
	`Okreg` VARCHAR(20) NULL COLLATE 'utf8_polish_ci',
	`Klub` VARCHAR(50) NULL COLLATE 'utf8_polish_ci',
	`Plec` CHAR(1) NULL COLLATE 'utf8_polish_ci',
	`Status` CHAR(1) NULL COLLATE 'utf8_polish_ci',
	`Znizki` CHAR(1) NULL COLLATE 'utf8_polish_ci',
	`Czlonek` CHAR(1) NULL COLLATE 'utf8_polish_ci'
) ENGINE=MyISAM;


-- Dumping structure for trigger makabi2.zmiana
SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER `zmiana` AFTER UPDATE ON `zapisy` FOR EACH ROW BEGIN
UPDATE `rozdania` SET `zmiana`=1 WHERE `id`=NEW.`nrr`;
END//
DELIMITER ;


-- Dumping structure for view makabi2.ile_razy_grali_na_siebie
-- Removing temporary table and create final VIEW structure
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` VIEW `ile_razy_grali_na_siebie` AS select `tmp_kojarzenie`.`a` AS `a`,`tmp_kojarzenie`.`b` AS `b`,count(0) AS `ile_razy` from `tmp_kojarzenie` group by `tmp_kojarzenie`.`a`,`tmp_kojarzenie`.`b` order by 3 desc,1,2 ;


-- Dumping structure for view makabi2.tmp_kojarzenie
-- Removing temporary table and create final VIEW structure
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` VIEW `tmp_kojarzenie` AS select `zapisy`.`zN` AS `a`,`zapisy`.`zE` AS `b`,`zapisy`.`rnd` AS `rnd` from `zapisy` where (`zapisy`.`zN` < `zapisy`.`zE`) union select `zapisy`.`zE` AS `zE`,`zapisy`.`zN` AS `zN`,`zapisy`.`rnd` AS `rnd` from `zapisy` where (`zapisy`.`zE` < `zapisy`.`zN`) ;


-- Dumping structure for view makabi2.zawodnicy+
-- Removing temporary table and create final VIEW structure
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `zawodnicy+` AS (select `makabi2`.`zawodnicy`.`idp` AS `idp`,`makabi2`.`zawodnicy`.`cezar` AS `cezar`,`players_makabi`.`players`.`gname` AS `Imie`,`players_makabi`.`players`.`sname` AS `Nazwisko`,`players_makabi`.`players`.`rank` AS `WK`,`players_makabi`.`players`.`loc1` AS `Okreg`,`players_makabi`.`players`.`loc2` AS `Klub`,`players_makabi`.`players`.`sex` AS `Plec`,`players_makabi`.`players`.`age` AS `Status`,`players_makabi`.`players`.`flag1` AS `Znizki`,`players_makabi`.`players`.`flag2` AS `Czlonek` from (`makabi2`.`zawodnicy` left join `players_makabi`.`players` on((`players_makabi`.`players`.`ID` = `makabi2`.`zawodnicy`.`cezar`))) order by `makabi2`.`zawodnicy`.`idp`);
