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


-- Dumping structure for table realbetradar_amperaplay.betika_meciuri
CREATE TABLE IF NOT EXISTS `betika_meciuri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status_event` varchar(50) DEFAULT NULL,
  `status_match` varchar(20) 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,
  `cote_main` longtext DEFAULT NULL,
  `cote_live` longtext DEFAULT NULL,
  `period` varchar(45) DEFAULT NULL,
  `clock` varchar(20) DEFAULT NULL,
  `sportId` int(5) DEFAULT NULL,
  `score` longtext DEFAULT NULL,
  `score_set` varchar(400) DEFAULT NULL,
  `idMeci` int(11) DEFAULT NULL,
  `idLiga` int(11) DEFAULT NULL,
  `liga` varchar(500) DEFAULT NULL,
  `tara` varchar(50) 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,
  `in_oferta` int(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `CDT_IDMECI_UQ` (`idMeci`),
  KEY `CDT_IDLIGA` (`idLiga`),
  KEY `CDT_IDMECI` (`idMeci`,`sportId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

