-- +goose up
CREATE TABLE user_style_profiles (
    id BIGSERIAL PRIMARY KEY,
    user_id TEXT NOT NULL,
    platform TEXT NOT NULL,
    embedding VECTOR(768) NOT NULL,
    top_keywords TEXT[] NOT NULL,
    style_summary TEXT NOT NULL,
    post_count INTEGER NOT NULL,
    modified_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
    created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
    UNIQUE (user_id, platform)
);

-- +goose down
DROP TABLE IF EXISTS user_style_profiles;