-- Create the posts_made table
CREATE TABLE IF NOT EXISTS posts_made (
    createdAt  TEXT NOT NULL, -- ISO8601 timestamp string of when we recorded a post was made
    subject    TEXT NOT NULL
);

-- Index for faster lookup by subject
CREATE INDEX IF NOT EXISTS idx_posts_made_subject ON posts_made(subject);