CREATE TABLE profiles (
    user_id TEXT PRIMARY KEY REFERENCES users(id),
    name TEXT NOT NULL DEFAULT '',
    bio TEXT NOT NULL DEFAULT '',
    location TEXT NOT NULL DEFAULT '',
    website TEXT NOT NULL DEFAULT '',
    picture_url TEXT NOT NULL DEFAULT ''
);