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

CREATE TABLE IF NOT EXISTS "events" (
  "ticker" TEXT NOT NULL,
  "date" TEXT NOT NULL,
  "eventcodes" TEXT,
  PRIMARY KEY ("date", "ticker")
);

CREATE INDEX IF NOT EXISTS "events_ticker_idx" ON "events" ("ticker");