CREATE TABLE content (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    channel_id BIGINT NOT NULL,
    account_id BIGINT NOT NULL,
    content TEXT DEFAULT NULL,
    content_type VARCHAR(255) NOT NULL CHECK (content_type IN ('post', 'story')),
    media_type VARCHAR(255) DEFAULT 'none' CHECK (media_type IN ('image', 'video', 'audio', 'gif', 'none')),
    thumbnail TEXT DEFAULT NULL,
    content_url TEXT DEFAULT NULL,
    tags JSON DEFAULT NULL,
    mentions JSON DEFAULT NULL,
    language VARCHAR(255) DEFAULT NULL,
    image_description TEXT DEFAULT NULL,
    audio_transcription TEXT DEFAULT NULL,
    sbi DECIMAL(6, 5) DEFAULT 0.00000,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE tags (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    tag_name VARCHAR(255) NOT NULL
);