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

CREATE TABLE IF NOT EXISTS `sp500` (
  `date` DATE NOT NULL,
  `action` VARCHAR(255) NOT NULL,
  `ticker` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255),
  `contraticker` VARCHAR(255),
  `contraname` VARCHAR(255),
  `note` VARCHAR(255),
  PRIMARY KEY (`date`, `action`, `ticker`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `sp500_action_idx` ON `sp500` (`action`);

CREATE INDEX `sp500_contraticker_idx` ON `sp500` (`contraticker`);

CREATE INDEX `sp500_ticker_idx` ON `sp500` (`ticker`);