-- Sharadar table schema: events (MySQL)
-- As of 2026-08-02
-- https://api.sharadar.com/v1.0/schema/events?format=mysql

CREATE TABLE IF NOT EXISTS `events` (
  `ticker` VARCHAR(255) NOT NULL,
  `date` DATE NOT NULL,
  `eventcodes` VARCHAR(255),
  PRIMARY KEY (`date`, `ticker`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `events_ticker_idx` ON `events` (`ticker`);