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

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

CREATE INDEX `actions_action_idx` ON `actions` (`action`);

CREATE INDEX `actions_contraticker_idx` ON `actions` (`contraticker`);

CREATE INDEX `actions_ticker_idx` ON `actions` (`ticker`);