-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.10.0.7000
-- --------------------------------------------------------


-- Dumping structure for table realbetradar_amperaplay.winnerbet_meciuri
CREATE TABLE IF NOT EXISTS `winnerbet_meciuri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `meciId` int(11) DEFAULT NULL,
  `sportId` int(5) DEFAULT NULL,
  `status` varchar(45) DEFAULT 'NOT_STARTED',
  `data` datetime DEFAULT NULL,
  `home` varchar(100) DEFAULT NULL,
  `away` varchar(100) DEFAULT NULL,
  `data_added` datetime DEFAULT NULL,
  `data_updated` datetime DEFAULT NULL,
  `updated_by` varchar(50) NOT NULL,
  `score` longtext DEFAULT NULL,
  `score_set` varchar(400) DEFAULT NULL,
  `scores_det` varchar(400) DEFAULT NULL,
  `clock` varchar(20) DEFAULT NULL,
  `period` varchar(45) DEFAULT NULL,
  `score2` varchar(400) DEFAULT NULL,
  `score_set2` varchar(400) DEFAULT NULL,
  `clock2` varchar(20) DEFAULT NULL,
  `period2` varchar(45) DEFAULT NULL,
  `data_updated2` datetime DEFAULT NULL,
  `status2` varchar(20) DEFAULT NULL,
  `cote_main` longtext DEFAULT NULL,
  `cote_live` longtext DEFAULT NULL,
  `status_match` varchar(20) DEFAULT NULL,
  `liga_id` int(11) DEFAULT NULL,
  `liga` varchar(500) DEFAULT NULL,
  `tara` varchar(500) DEFAULT NULL,
  `tara_id` int(11) DEFAULT NULL,
  `bri` varchar(10) DEFAULT '0',
  `activ` int(11) DEFAULT 1,
  `suspended` int(11) DEFAULT NULL,
  `br_id` int(11) DEFAULT NULL,
  `br_events` longtext DEFAULT NULL,
  `br_link` varchar(300) DEFAULT NULL,
  `br_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `CDT_IDMECI_UQ` (`meciId`) USING BTREE,
  KEY `CDT_IDMECI` (`meciId`,`sportId`) USING BTREE,
  KEY `CDT_IDLIGA` (`liga_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- Dumping data for table realbetradar_amperaplay.winnerbet_meciuri: ~0 rows (approximately)
DELETE FROM `winnerbet_meciuri`;

