-- Upgrade an EXISTING installation once. Fresh installations use schema.sql instead.
CREATE TABLE IF NOT EXISTS media (
    id CHAR(32) CHARACTER SET ascii COLLATE ascii_bin PRIMARY KEY,
    filename VARCHAR(80) NOT NULL,
    original_name VARCHAR(255) NOT NULL,
    mime_type VARCHAR(40) NOT NULL,
    width INT UNSIGNED NOT NULL,
    height INT UNSIGNED NOT NULL,
    bytes INT UNSIGNED NOT NULL,
    alt_text VARCHAR(250) NOT NULL,
    caption VARCHAR(500) NOT NULL DEFAULT '',
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
ALTER TABLE articles ADD COLUMN featured_image_id CHAR(32) CHARACTER SET ascii COLLATE ascii_bin NULL;