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


-- Dumping structure for table realbetradar_amperaplay.guinee_meciuri
CREATE TABLE IF NOT EXISTS `guinee_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,
  `cote` longtext DEFAULT NULL,
  `cote_extra` longtext DEFAULT NULL,
  `cote_extra_updated` datetime DEFAULT NULL,
  `cote_extra_updatedby` varchar(50) DEFAULT NULL,
  `liga_id` int(11) 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`) USING BTREE,
  UNIQUE KEY `GUI_IDMECI_UQ` (`meciId`) USING BTREE,
  KEY `GUI_IDMECI` (`meciId`,`sportId`) USING BTREE,
  KEY `GUI_IDLIGA` (`liga_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

