-- --------------------------------------------------------
-- Host:                         86.122.186.163
-- Server version:               11.7.2-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             12.10.0.7000
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping structure for table realbetradar_amperaplay.betika_tip_pariuri
CREATE TABLE IF NOT EXISTS `betika_tip_pariuri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sub_type_id` int(11) DEFAULT NULL,
  `name` varchar(25) DEFAULT NULL,
  `name_en` varchar(25) DEFAULT NULL,
  `display` varchar(50) DEFAULT NULL,
  `display_en` varchar(100) DEFAULT NULL,
  `odd_def` varchar(100) DEFAULT NULL,
  `data_added` datetime DEFAULT NULL,
  `data_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UQ_PARIURI` (`sub_type_id`,`display`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table realbetradar_amperaplay.betika_tip_pariuri: ~74 rows (approximately)
DELETE FROM `betika_tip_pariuri`;
INSERT INTO `betika_tip_pariuri` (`id`, `sub_type_id`, `name`, `name_en`, `display`, `display_en`, `odd_def`, `data_added`, `data_updated`) VALUES
	(1, 643, '2E MANCHE - CRITCHLEY, MA', NULL, 'PLUS DE 2.5', NULL, 'Plus de {total}', '2023-07-12 18:40:30', NULL),
	(2, 643, '2E MANCHE - CRITCHLEY, MA', NULL, 'MOINS DE 2.5', NULL, 'Moins de {total}', '2023-07-12 18:40:30', NULL),
	(3, 643, '2E MANCHE - LAWRENCE, DAN', NULL, 'PLUS DE 8.5', NULL, 'Plus de {total}', '2023-07-12 18:40:31', NULL),
	(4, 643, '2E MANCHE - LAWRENCE, DAN', NULL, 'MOINS DE 8.5', NULL, 'Moins de {total}', '2023-07-12 18:40:31', NULL),
	(5, 651, '2E MANCHE - CRITCHLEY, MA', NULL, 'ARRÃªT DE VOLÃ©E PAR CHASSEUR', NULL, 'arrÃªt de volÃ©e par chasseur', '2023-07-12 18:40:31', '2023-07-12 18:40:32'),
	(6, 651, '2E MANCHE - CRITCHLEY, MA', NULL, 'GUICHET DÃ©TRUIT PAR LE LANCEUR', NULL, 'guichet dÃ©truit par le lanceur', '2023-07-12 18:40:31', '2023-07-12 18:40:32'),
	(7, 651, '2E MANCHE - CRITCHLEY, MA', NULL, 'ARRÃªT DE VOLÃ©E PAR GARDIEN', NULL, 'arrÃªt de volÃ©e par gardien', '2023-07-12 18:40:31', '2023-07-12 18:40:32'),
	(8, 651, '2E MANCHE - CRITCHLEY, MA', NULL, 'JAMBE DEVANT GUICHET', NULL, 'jambe devant guichet', '2023-07-12 18:40:31', '2023-07-12 18:40:32'),
	(9, 651, '2E MANCHE - CRITCHLEY, MA', NULL, 'RUN OUT', NULL, 'run out', '2023-07-12 18:40:31', '2023-07-12 18:40:32'),
	(10, 651, '2E MANCHE - CRITCHLEY, MA', NULL, 'GUICHET DÃ©TRUIT PAR LE GARDIEN', NULL, 'guichet dÃ©truit par le gardien', '2023-07-12 18:40:31', '2023-07-12 18:40:32'),
	(11, 651, '2E MANCHE - CRITCHLEY, MA', NULL, 'AUTRE', NULL, 'autre', '2023-07-12 18:40:31', '2023-07-12 18:40:32'),
	(19, 657, '2E MANCHE - 4E BATTEUR OU', NULL, 'CRITCHLEY, MATT', NULL, '{%player1}', '2023-07-12 18:40:32', NULL),
	(20, 657, '2E MANCHE - 4E BATTEUR OU', NULL, 'LAWRENCE, DAN', NULL, '{%player2}', '2023-07-12 18:40:32', NULL),
	(21, 659, '2E MANCHE - ESSEX TOTAL D', NULL, 'PLUS DE 26.5', NULL, 'Plus de {total}', '2023-07-12 18:40:33', NULL),
	(22, 659, '2E MANCHE - ESSEX TOTAL D', NULL, 'MOINS DE 26.5', NULL, 'Moins de {total}', '2023-07-12 18:40:33', NULL),
	(23, 661, '2E MANCHE - ESSEX TOTAL D', NULL, 'PLUS DE 0.5', NULL, 'Plus de {total}', '2023-07-12 18:40:33', NULL),
	(24, 661, '2E MANCHE - ESSEX TOTAL D', NULL, 'MOINS DE 0.5', NULL, 'Moins de {total}', '2023-07-12 18:40:33', NULL),
	(25, 662, '2E MANCHE - CRITCHLEY, MA', NULL, 'OUI', NULL, 'oui', '2023-07-12 18:40:33', '2023-07-12 18:40:36'),
	(26, 662, '2E MANCHE - CRITCHLEY, MA', NULL, 'NON', NULL, 'non', '2023-07-12 18:40:33', '2023-07-12 18:40:36'),
	(39, 667, '2E MANCHE - ESSEX TOTAL E', NULL, 'PLUS DE 14.5', NULL, 'Plus de {total}', '2023-07-12 18:40:36', NULL),
	(40, 667, '2E MANCHE - ESSEX TOTAL E', NULL, 'MOINS DE 14.5', NULL, 'Moins de {total}', '2023-07-12 18:40:36', NULL),
	(41, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'BLATHERWICK, JACK', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(42, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'WILLIAMS, WILL', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(43, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'HARTLEY, TOM', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(44, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'VILAS, DANE', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(45, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'WELLS, LUKE', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(46, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'JENNINGS, KEATON', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(47, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'BAILEY, TOM', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(48, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'DE GRANDHOMME, COLIN', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(49, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'JONES, ROB', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(50, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'SALT, PHIL', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(51, 674, '2E MANCHE - LANCASHIRE ME', NULL, 'BOHANNON, JOSH', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(52, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'WALTER, PAUL IAN', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(53, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'COOK, SAM', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(54, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'BUTTLEMAN, WILLIAM EDWARD LEWIS', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(55, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'COOK, ALASTAIR', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(56, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'WESTLEY, TOM', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(57, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'BROWNE, NICK', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(58, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'BRACEWELL, DOUG', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(59, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'HARMER, SIMON', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(60, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'PORTER, JAMIE', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(61, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'LAWRENCE, DAN', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(62, 675, '2E MANCHE - ESSEX MEILLEU', NULL, 'CRITCHLEY, MATT', NULL, NULL, '2023-07-12 18:40:37', NULL),
	(63, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'BLATHERWICK, JACK', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(64, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'WILLIAMS, WILL', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(65, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'HARTLEY, TOM', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(66, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'VILAS, DANE', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(67, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'WELLS, LUKE', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(68, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'JENNINGS, KEATON', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(69, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'BAILEY, TOM', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(70, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'DE GRANDHOMME, COLIN', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(71, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'JONES, ROB', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(72, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'SALT, PHIL', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(73, 676, '2E MANCHE - LANCASHIRE ME', NULL, 'BOHANNON, JOSH', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(74, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'WALTER, PAUL IAN', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(75, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'COOK, SAM', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(76, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'BUTTLEMAN, WILLIAM EDWARD LEWIS', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(77, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'COOK, ALASTAIR', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(78, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'WESTLEY, TOM', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(79, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'BROWNE, NICK', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(80, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'BRACEWELL, DOUG', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(81, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'HARMER, SIMON', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(82, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'PORTER, JAMIE', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(83, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'LAWRENCE, DAN', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(84, 679, '2E MANCHE - ESSEX DERNIER', NULL, 'CRITCHLEY, MATT', NULL, NULL, '2023-07-12 18:40:38', NULL),
	(85, 817, '2E MANCHES - ESSEX 4E MÃ©', NULL, 'ARRÃªT DE VOLÃ©E PAR CHASSEUR', NULL, 'arrÃªt de volÃ©e par chasseur', '2023-07-12 18:40:39', NULL),
	(86, 817, '2E MANCHES - ESSEX 4E MÃ©', NULL, 'GUICHET DÃ©TRUIT PAR LE LANCEUR', NULL, 'guichet dÃ©truit par le lanceur', '2023-07-12 18:40:39', NULL),
	(87, 817, '2E MANCHES - ESSEX 4E MÃ©', NULL, 'ARRÃªT DE VOLÃ©E PAR GARDIEN', NULL, 'arrÃªt de volÃ©e par gardien', '2023-07-12 18:40:39', NULL),
	(88, 817, '2E MANCHES - ESSEX 4E MÃ©', NULL, 'JAMBE DEVANT GUICHET', NULL, 'jambe devant guichet', '2023-07-12 18:40:39', NULL),
	(89, 817, '2E MANCHES - ESSEX 4E MÃ©', NULL, 'RUN OUT', NULL, 'run out', '2023-07-12 18:40:39', NULL),
	(90, 817, '2E MANCHES - ESSEX 4E MÃ©', NULL, 'GUICHET DÃ©TRUIT PAR LE GARDIEN', NULL, 'guichet dÃ©truit par le gardien', '2023-07-12 18:40:39', NULL),
	(91, 817, '2E MANCHES - ESSEX 4E MÃ©', NULL, 'AUTRE', NULL, 'autre', '2023-07-12 18:40:39', NULL),
	(92, 1139, '2E INNINGS OVER 19 - 2E D', NULL, 'OUI', NULL, 'oui', '2023-07-12 18:40:39', '2023-07-12 18:40:41'),
	(93, 1139, '2E INNINGS OVER 19 - 2E D', NULL, 'NON', NULL, 'non', '2023-07-12 18:40:39', '2023-07-12 18:40:41');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
