SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

CREATE TABLE IF NOT EXISTS `event_lu` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `event_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_start` datetime NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `invalid` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `event_name` (`event_name`),
  UNIQUE KEY `event_code` (`event_code`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=173 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `event_lu` (`id`, `event_name`, `event_code`, `date_start`, `timestamp`, `invalid`) VALUES
(1, 'Rocket City Regional', 'ALHU', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(2, 'Arkansas Regional', 'ARLI', '2024-03-06 00:00:00', '2024-01-13 17:17:45', 0),
(3, 'Southern Cross Regional', 'AUSC', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(4, 'Arizona East Regional', 'AZGL', '2024-03-20 00:00:00', '2024-01-13 17:17:45', 0),
(5, 'Arizona Valley Regional', 'AZVA', '2024-03-13 00:00:00', '2024-01-13 17:17:45', 0),
(6, 'Canadian Pacific Regional', 'BCVI', '2024-02-28 00:00:00', '2024-01-13 17:17:45', 0),
(7, 'Brazil Regional', 'BRBR', '2024-02-28 00:00:00', '2024-01-13 17:17:45', 0),
(8, 'Aerospace Valley Regional', 'CAAV', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(9, 'East Bay Regional', 'CABE', '2024-04-04 00:00:00', '2024-01-13 17:17:45', 0),
(10, 'Sacramento Regional', 'CADA', '2024-03-13 00:00:00', '2024-01-13 17:17:45', 0),
(11, 'Central Valley Regional', 'CAFR', '2024-03-21 00:00:00', '2024-01-13 17:17:45', 0),
(12, 'Los Angeles Regional', 'CALA', '2024-03-14 00:00:00', '2024-01-13 17:17:45', 0),
(13, 'Monterey Bay Regional', 'CAMB', '2024-03-27 00:00:00', '2024-01-13 17:17:45', 0),
(14, 'Orange County Regional', 'CAOC', '2024-03-27 00:00:00', '2024-01-13 17:17:45', 0),
(15, 'Hueneme Port Regional', 'CAPH', '2024-02-29 00:00:00', '2024-01-13 17:17:45', 0),
(16, 'San Diego Regional presented by Qualcomm', 'CASD', '2024-03-21 00:00:00', '2024-01-13 17:17:45', 0),
(17, 'San Francisco Regional', 'CASF', '2024-03-07 00:00:00', '2024-01-13 17:17:45', 0),
(18, 'Silicon Valley Regional', 'CASJ', '2024-02-29 00:00:00', '2024-01-13 17:17:45', 0),
(19, 'Ventura County Regional', 'CAVE', '2024-03-07 00:00:00', '2024-01-13 17:17:45', 0),
(20, 'FIRST Chesapeake District Championship', 'CHCMP', '2024-04-04 00:00:00', '2024-01-13 17:17:45', 0),
(21, 'FIRST Championship - FIRST Robotics Competition', 'CMPTX', '2024-04-17 00:00:00', '2024-01-13 17:17:45', 0),
(22, 'Colorado Regional', 'CODE', '2024-03-20 00:00:00', '2024-01-13 17:17:45', 0),
(23, 'NE District Hartford Event', 'CTHAR', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(24, 'NE District Waterbury Event', 'CTWAT', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(25, 'Orlando Regional', 'FLOR', '2024-03-20 00:00:00', '2024-01-13 17:17:45', 0),
(26, 'Tallahassee Regional', 'FLTA', '2024-03-13 00:00:00', '2024-01-13 17:17:45', 0),
(27, 'South Florida Regional', 'FLWP', '2024-02-28 00:00:00', '2024-01-13 17:17:45', 0),
(28, 'PCH District Albany Event', 'GAALB', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(29, 'PCH District Carrollton Event', 'GACAR', '2024-03-21 00:00:00', '2024-01-13 17:17:45', 0),
(30, 'Peachtree District Championship', 'GACMP', '2024-04-04 00:00:00', '2024-01-13 17:17:45', 0),
(31, 'PCH District Dalton Event', 'GADAL', '2024-03-07 00:00:00', '2024-01-13 17:17:45', 0),
(32, 'PCH District Gwinnett Event', 'GAGWI', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(33, 'Hawaii Regional', 'HIHO', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(34, 'Iowa Regional', 'IACF', '2024-03-20 00:00:00', '2024-01-13 17:17:45', 0),
(35, 'Idaho Regional', 'IDBO', '2024-03-20 00:00:00', '2024-01-13 17:17:45', 0),
(36, 'Midwest Regional', 'ILCH', '2024-03-27 00:00:00', '2024-01-13 17:17:45', 0),
(37, 'Central Illinois Regional', 'ILPE', '2024-03-13 00:00:00', '2024-01-13 17:17:45', 0),
(38, 'FIRST Indiana State Championship', 'INCMP', '2024-04-05 00:00:00', '2024-01-13 17:17:45', 0),
(39, 'FIN District Columbus Event', 'INCOL', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(40, 'FIN District Washington Event presented by Toyota', 'INEVA', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(41, 'FIN District Mishawaka Event', 'INMIS', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(42, 'FIN District Plainfield Event presented by Carrier', 'INPLA', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(43, 'FIRST Israel District Championship', 'ISCMP', '2024-03-19 00:00:00', '2024-01-13 17:17:45', 0),
(44, 'ISR District Event #1', 'ISDE1', '2024-02-25 00:00:00', '2024-01-13 17:17:45', 0),
(45, 'ISR District Event #2', 'ISDE2', '2024-02-27 00:00:00', '2024-01-13 17:17:45', 0),
(46, 'ISR District Event #3', 'ISDE3', '2024-03-10 00:00:00', '2024-01-13 17:17:45', 0),
(47, 'ISR District Event #4', 'ISDE4', '2024-03-12 00:00:00', '2024-01-13 17:17:45', 0),
(48, 'Heartland Regional', 'KSLA', '2024-03-13 00:00:00', '2024-01-13 17:17:45', 0),
(49, 'Bayou Regional', 'LAKE', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(50, 'NE District Greater Boston Event', 'MABOS', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(51, 'NE District BSU Event', 'MABRI', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(52, 'NE District North Shore Event', 'MAREA', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(53, 'NE District Western NE Event', 'MAWNE', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(54, 'NE District WPI Event', 'MAWOR', '2024-03-29 00:00:00', '2024-01-13 17:17:45', 0),
(55, 'CHS District Owings Mills MD Event', 'MDOWI', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(56, 'CHS District Severn MD Event', 'MDSEV', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(57, 'NE District Pine Tree Event', 'MELEW', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(58, 'FIM District Ann Arbor Event', 'MIANN', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(59, 'FIM District Battle Creek Event', 'MIBAT', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(60, 'FIM District Belleville Event', 'MIBEL', '2024-03-07 00:00:00', '2024-01-13 17:17:45', 0),
(61, 'FIM District Berrien Springs Event', 'MIBER', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(62, 'FIM District Jackson at Columbia Event', 'MIBKN', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(63, 'FIM District Woodhaven Event', 'MIBRO', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(64, 'FIRST in Michigan State Championship', 'MICMP', '2024-04-04 00:00:00', '2024-01-13 17:17:45', 0),
(65, 'FIM District Renaissance Event', 'MIDET', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(66, 'FIM District Wayne State Event', 'MIDTR', '2024-03-14 00:00:00', '2024-01-13 17:17:45', 0),
(67, 'FIM District Escanaba Event', 'MIESC', '2024-03-07 00:00:00', '2024-01-13 17:17:45', 0),
(68, 'FIM District Kettering University Event #2', 'MIKE2', '2024-03-07 00:00:00', '2024-01-13 17:17:45', 0),
(69, 'FIM District Kentwood Event', 'MIKEN', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(70, 'FIM District Kettering University Event #1', 'MIKET', '2024-02-29 00:00:00', '2024-01-13 17:17:45', 0),
(71, 'FIM District Lake City Event', 'MILAC', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(72, 'FIM District Lansing Event', 'MILAN', '2024-03-21 00:00:00', '2024-01-13 17:17:45', 0),
(73, 'FIM District Livonia Event', 'MILIV', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(74, 'FIM District LSSU Event', 'MILSU', '2024-03-14 00:00:00', '2024-01-13 17:17:45', 0),
(75, 'FIM District Macomb Community College Event', 'MIMCC', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(76, 'FIM District Midland Event', 'MIMID', '2024-03-21 00:00:00', '2024-01-13 17:17:45', 0),
(77, 'FIM District Milford Event', 'MIMIL', '2024-02-29 00:00:00', '2024-01-13 17:17:45', 0),
(78, 'FIM District Central Michigan University Event', 'MIMTP', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(79, 'FIM District Muskegon Event', 'MIMUS', '2024-03-14 00:00:00', '2024-01-13 17:17:45', 0),
(80, 'FIM District St. Joseph Event', 'MISJO', '2024-03-07 00:00:00', '2024-01-13 17:17:45', 0),
(81, 'FIM District Troy Event #2', 'MITR2', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(82, 'FIM District Troy Event #1', 'MITRY', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(83, 'FIM District Traverse City Event', 'MITVC', '2024-03-14 00:00:00', '2024-01-13 17:17:45', 0),
(84, 'FIM District West Michigan Event', 'MIWMI', '2024-03-21 00:00:00', '2024-01-13 17:17:45', 0),
(85, 'Lake Superior Regional', 'MNDU', '2024-02-28 00:00:00', '2024-01-13 17:17:45', 0),
(86, 'Northern Lights Regional', 'MNDU2', '2024-02-28 00:00:00', '2024-01-13 17:17:45', 0),
(87, 'Minnesota 10,000 Lakes Regional', 'MNMI', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(88, 'Minnesota Granite City Regional', 'MNMI2', '2024-04-04 00:00:00', '2024-01-13 17:17:45', 0),
(89, 'Greater Kansas City Regional', 'MOKC', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(90, 'Central Missouri Regional', 'MOSE', '2024-03-06 00:00:00', '2024-01-13 17:17:45', 0),
(91, 'St. Louis Regional', 'MOSL', '2024-03-20 00:00:00', '2024-01-13 17:17:45', 0),
(92, 'FIRST Mid-Atlantic District Championship', 'MRCMP', '2024-04-04 00:00:00', '2024-01-13 17:17:45', 0),
(93, 'Magnolia Regional', 'MSLR', '2024-03-13 00:00:00', '2024-01-13 17:17:45', 0),
(94, 'Regional Monterrey', 'MXMO', '2024-02-28 00:00:00', '2024-01-13 17:17:45', 0),
(95, 'Regional Hermosillo', 'MXPU', '2024-03-13 00:00:00', '2024-01-13 17:17:45', 0),
(96, 'Regional Laguna presented by Peñoles', 'MXTO', '2024-03-20 00:00:00', '2024-01-13 17:17:45', 0),
(97, 'FNC District UNC Asheville Event', 'NCASH', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(98, 'FIRST North Carolina District State Championship', 'NCCMP', '2024-04-05 00:00:00', '2024-01-13 17:17:45', 0),
(99, 'FNC District Mecklenburg County Event', 'NCMEC', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(100, 'FNC District UNC Pembroke Event', 'NCPEM', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(101, 'FNC District Wake County Event', 'NCWA2', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(102, 'FNC District Orange County Event', 'NCWAK', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(103, 'Great Northern Regional', 'NDGF', '2024-03-06 00:00:00', '2024-01-13 17:17:45', 0),
(104, 'New England FIRST District Championship', 'NECMP', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(105, 'NE District UNH Event', 'NHDUR', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(106, 'NE District Granite State Event', 'NHGRS', '2024-02-29 00:00:00', '2024-01-13 17:17:45', 0),
(107, 'FMA District Allentown Event', 'NJALL', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(108, 'FMA District Mount Olive Event', 'NJFLA', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(109, 'FMA District Montgomery Event', 'NJSKI', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(110, 'FMA District Seneca Event', 'NJTAB', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(111, 'FMA District Warren Hills Event', 'NJWAS', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(112, 'Las Vegas Regional', 'NVLV', '2024-03-27 00:00:00', '2024-01-13 17:17:45', 0),
(113, 'FIRST Long Island Regional', 'NYLI2', '2024-03-20 00:00:00', '2024-01-13 17:17:45', 0),
(114, 'New York City Regional', 'NYNY', '2024-04-04 00:00:00', '2024-01-13 17:17:45', 0),
(115, 'Finger Lakes Regional', 'NYRO', '2024-03-13 00:00:00', '2024-01-13 17:17:45', 0),
(116, 'Hudson Valley Regional', 'NYSU', '2024-03-06 00:00:00', '2024-01-13 17:17:45', 0),
(117, 'New York Tech Valley Regional', 'NYTR', '2024-03-20 00:00:00', '2024-01-13 17:17:45', 0),
(118, 'Buckeye Regional', 'OHCL', '2024-03-20 00:00:00', '2024-01-13 17:17:45', 0),
(119, 'Miami Valley Regional', 'OHMV', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(120, 'Oklahoma Regional', 'OKOK', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(121, 'Green Country Regional', 'OKTU', '2024-03-06 00:00:00', '2024-01-13 17:17:45', 0),
(122, 'ONT District Georgian Event', 'ONBAR', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(123, 'FIRST Ontario Provincial Championship', 'ONCMP', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(124, 'ONT District McMaster University', 'ONHAM', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(125, 'ONT District Newmarket Complex Event', 'ONNEW', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(126, 'ONT District North Bay Event', 'ONNOB', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(127, 'ONT District Durham College Event', 'ONOSH', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(128, 'ONT District Centennial College Event', 'ONSCA', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(129, 'ONT District Humber College Event', 'ONTOR', '2024-03-18 00:00:00', '2024-01-13 17:17:45', 0),
(130, 'ONT District University of Waterloo Event', 'ONWAT', '2024-03-21 00:00:00', '2024-01-13 17:17:45', 0),
(131, 'ONT District Windsor Essex Great Lakes Event', 'ONWIN', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(132, 'PNW District Clackamas Academy Event', 'ORORE', '2024-02-29 00:00:00', '2024-01-13 17:17:45', 0),
(133, 'PNW District Oregon State Fairgrounds Event', 'ORSAL', '2024-03-07 00:00:00', '2024-01-13 17:17:45', 0),
(134, 'PNW District Wilsonville Event', 'ORWIL', '2024-03-21 00:00:00', '2024-01-13 17:17:45', 0),
(135, 'FMA District Bensalem Event', 'PABEN', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(136, 'Greater Pittsburgh Regional', 'PACA', '2024-02-28 00:00:00', '2024-01-13 17:17:45', 0),
(137, 'FMA District Hatboro-Horsham Event', 'PAHAT', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(138, 'FMA District Springside Chestnut Hill Event', 'PAPHI', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(139, 'Pacific Northwest FIRST District Championship', 'PNCMP', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(140, 'Festival de Robotique Regional', 'QCMO', '2024-02-28 00:00:00', '2024-01-13 17:17:45', 0),
(141, 'NE District URI Event', 'RIKIN', '2024-03-14 00:00:00', '2024-01-13 17:17:45', 0),
(142, 'PCH District Anderson Event presented by MAGNA', 'SCAND', '2024-03-07 00:00:00', '2024-01-13 17:17:45', 0),
(143, 'PCH District Charleston Event', 'SCCHA', '2024-03-21 00:00:00', '2024-01-13 17:17:45', 0),
(144, 'Smoky Mountains Regional', 'TNKN', '2024-03-03 00:00:00', '2024-01-13 17:17:45', 0),
(145, 'Haliç Regional', 'TUHC', '2024-03-19 00:00:00', '2024-01-13 17:17:45', 0),
(146, 'İstanbul Regional', 'TUIS', '2024-03-05 00:00:00', '2024-01-13 17:17:45', 0),
(147, 'Bosphorus Regional', 'TUIS2', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(148, 'Marmara Regional', 'TUIS3', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(149, 'FIT District Amarillo Event', 'TXAMA', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(150, 'FIT District Belton Event', 'TXBEL', '2024-03-07 00:00:00', '2024-01-13 17:17:45', 0),
(151, 'FIT District Space City @ Friendswood Event', 'TXCLE', '2024-03-28 00:00:00', '2024-01-13 17:17:45', 0),
(152, 'FIRST In Texas District Championship', 'TXCMP', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(153, 'FIT District Dallas Event', 'TXDAL', '2024-03-21 00:00:00', '2024-01-13 17:17:45', 0),
(154, 'FIT District Fort Worth Event', 'TXFOR', '2024-03-14 00:00:00', '2024-01-13 17:17:45', 0),
(155, 'FIT District Houston Event', 'TXHOU', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(156, 'FIT District Katy Event', 'TXKAT', '2024-02-29 00:00:00', '2024-01-13 17:17:45', 0),
(157, 'FIT District Plano Event', 'TXPLA', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(158, 'FIT District San Antonio Event', 'TXSAN', '2024-03-14 00:00:00', '2024-01-13 17:17:45', 0),
(159, 'FIT District Waco Event', 'TXWAC', '2024-02-29 00:00:00', '2024-01-13 17:17:45', 0),
(160, 'Utah Regional', 'UTWV', '2024-02-28 00:00:00', '2024-01-13 17:17:45', 0),
(161, 'CHS District Ashland VA Event', 'VAASH', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(162, 'CHS District Blacksburg VA Event', 'VABLA', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(163, 'CHS District Falls Church VA Event presented by Department of Energy', 'VAFAL', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(164, 'CHS District Glen Allen VA Event', 'VAGLE', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(165, 'CHS District Portsmouth VA Event', 'VAPOR', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(166, 'PNW District Auburn Event', 'WAAHS', '2024-03-08 00:00:00', '2024-01-13 17:17:45', 0),
(167, 'PNW District Bonney Lake Event', 'WABON', '2024-03-15 00:00:00', '2024-01-13 17:17:45', 0),
(168, 'PNW District Sammamish Event', 'WASAM', '2024-03-22 00:00:00', '2024-01-13 17:17:45', 0),
(169, 'PNW District Glacier Peak Event', 'WASNO', '2024-03-01 00:00:00', '2024-01-13 17:17:45', 0),
(170, 'PNW District SunDome Event', 'WAYAK', '2024-03-14 00:00:00', '2024-01-13 17:17:45', 0),
(171, 'Seven Rivers Regional', 'WILA', '2024-04-03 00:00:00', '2024-01-13 17:17:45', 0),
(172, 'Wisconsin Regional', 'WIMI', '2024-03-14 00:00:00', '2024-01-13 17:17:45', 0);

CREATE TABLE IF NOT EXISTS `fact_match_data_2024` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `event_id` int(4) UNSIGNED NOT NULL,
  `team_id` int(5) UNSIGNED NOT NULL,
  `match_id` int(4) UNSIGNED NOT NULL,
  `practice_match` tinyint(1) NOT NULL DEFAULT '0',
  `position_id` int(3) UNSIGNED NOT NULL,
  `auto_leave` tinyint(1) NOT NULL DEFAULT '0',
  `auto_speaker_score` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `auto_speaker_miss` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `auto_amp_score` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `auto_amp_miss` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `auto_wing_amp_acq` tinyint(1) NOT NULL DEFAULT '0',
  `auto_wing_mid_acq` tinyint(1) NOT NULL DEFAULT '0',
  `auto_wing_stage_acq` tinyint(1) NOT NULL DEFAULT '0',
  `auto_center_1_amp_acq` tinyint(1) NOT NULL DEFAULT '0',
  `auto_center_2_acq` tinyint(1) NOT NULL DEFAULT '0',
  `auto_center_3_acq` tinyint(1) NOT NULL DEFAULT '0',
  `auto_center_4_acq` tinyint(1) NOT NULL DEFAULT '0',
  `auto_center_5_tbl_acq` tinyint(1) NOT NULL DEFAULT '0',
  `auto_stop` tinyint(1) NOT NULL DEFAULT '0',
  `tele_speaker_score` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `tele_speaker_miss` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `tele_amp_score` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `tele_amp_miss` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `floor_pickup` tinyint(1) NOT NULL DEFAULT '0',
  `chute_direct` tinyint(1) NOT NULL DEFAULT '0',
  `stage_park` tinyint(1) NOT NULL DEFAULT '0',
  `stage_attempt_failed` tinyint(1) NOT NULL DEFAULT '0',
  `stage_onstage` tinyint(1) NOT NULL DEFAULT '0',
  `harmony_attempt_failed` tinyint(1) NOT NULL DEFAULT '0',
  `harmony_success` tinyint(1) NOT NULL DEFAULT '0',
  `trap_note_score` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `trap_note_miss` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `chain_mobility` tinyint(1) NOT NULL DEFAULT '0',
  `dropped_gp_count` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `feed_count` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `defense` tinyint(1) NOT NULL DEFAULT '0',
  `foul_count` int(3) NOT NULL DEFAULT '0',
  `yellow_card` tinyint(1) NOT NULL DEFAULT '0',
  `red_card` tinyint(1) NOT NULL DEFAULT '0',
  `no_show` tinyint(1) NOT NULL DEFAULT '0',
  `no_show_w_rep` tinyint(1) NOT NULL DEFAULT '0',
  `notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `invalid` tinyint(1) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `event_id` (`event_id`,`team_id`,`match_id`,`practice_match`,`position_id`),
  KEY `invalid` (`invalid`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `game_info` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `keystring` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `intvalue` int(15) NOT NULL,
  `stringval` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `invalid` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`keystring`),
  UNIQUE KEY `intvalue` (`intvalue`),
  KEY `timestamp` (`timestamp`,`invalid`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `notes_options` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `option_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `invalid` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `notes_options` (`id`, `option_text`, `timestamp`, `invalid`) VALUES
(2, 'Non-functional', '2014-01-25 15:21:36', 0),
(3, 'Defender', '2016-01-15 16:30:02', 0),
(10, 'Stopped responding mid-match', '2016-03-17 23:53:21', 0),
(11, 'Significant damage to robot in match', '2024-01-27 13:07:06', 0),
(12, 'Trapped Notes', '2024-01-27 13:07:06', 0);

CREATE TABLE IF NOT EXISTS `position_lu` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `position` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `invalid` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `timestamp` (`timestamp`,`invalid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `position_lu` (`id`, `position`, `timestamp`, `invalid`) VALUES
(1, 'Red 1', '2015-02-12 00:30:10', 0),
(2, 'Red 2', '2015-02-12 00:30:10', 0),
(3, 'Red 3', '2015-02-12 00:30:36', 0),
(4, 'Blue 1', '2015-02-12 00:30:36', 0),
(5, 'Blue 2', '2015-02-12 00:30:50', 0),
(6, 'Blue 3', '2015-02-12 00:30:50', 0);

CREATE TABLE IF NOT EXISTS `programming_lu` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `language_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `invalid` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `programming_lu` (`id`, `language_name`, `timestamp`, `invalid`) VALUES
(1, 'Other', '2024-01-27 13:07:06', 0),
(2, 'Java', '2024-01-27 13:07:06', 0),
(3, 'C++', '2024-01-27 13:07:06', 0),
(4, 'LabView', '2024-01-27 13:07:06', 0),
(5, 'Python', '2024-01-27 13:07:06', 0);

CREATE TABLE IF NOT EXISTS `robot_lu` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `team_id` int(5) UNSIGNED NOT NULL,
  `robot_photo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `invalid` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `team_id` (`team_id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `scout_pit_data_2024` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `team_id` int(5) UNSIGNED NOT NULL,
  `programming_id` int(2) NOT NULL,
  `traction_wheels` tinyint(1) NOT NULL,
  `pneumatic_wheels` tinyint(1) NOT NULL,
  `omni_wheels` tinyint(1) NOT NULL,
  `mecanum_wheels` tinyint(1) NOT NULL,
  `other_wheels` tinyint(1) NOT NULL,
  `swerve_x_wcp` tinyint(1) NOT NULL,
  `swerve_sds` tinyint(1) NOT NULL,
  `swerve_rev` tinyint(1) NOT NULL,
  `swerve_custom` tinyint(1) NOT NULL,
  `tank_drive` tinyint(1) NOT NULL,
  `arcade_drive` tinyint(1) NOT NULL,
  `other_drive` tinyint(1) NOT NULL,
  `robot_inspection_weight_lbs` int(4) UNSIGNED NOT NULL,
  `floor_pickup` tinyint(1) NOT NULL,
  `source_direct` tinyint(1) NOT NULL,
  `fit_under_stage` tinyint(1) NOT NULL,
  `communication_barrier` tinyint(1) NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `invalid` tinyint(1) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `team_id` (`team_id`),
  KEY `invalid` (`invalid`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `superscout_data_2024` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `event_id` int(4) UNSIGNED NOT NULL,
  `team_id` int(5) UNSIGNED NOT NULL,
  `match_id` int(4) UNSIGNED NOT NULL,
  `practice_match` tinyint(1) NOT NULL DEFAULT '0',
  `position_id` int(3) UNSIGNED NOT NULL,
  `offense_rank` int(1) UNSIGNED NOT NULL,
  `defense_rank` int(1) UNSIGNED NOT NULL,
  `driver_rank` int(1) UNSIGNED NOT NULL,
  `caused_foul` tinyint(1) NOT NULL DEFAULT '0',
  `notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `invalid` tinyint(1) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `event_id` (`event_id`,`team_id`,`match_id`,`practice_match`,`position_id`),
  KEY `invalid` (`invalid`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
