create table users ( id uuid primary key, username text not null unique, display_name text not null, password_hash text not null, created_at timestamptz not null ); create table chats ( id uuid primary key, title text not null, created_at timestamptz not null ); create table chat_members ( chat_id uuid not null references chats(id), user_id uuid not null references users(id), primary key (chat_id, user_id) ); create index chat_members_user_idx on chat_members (user_id); create table messages ( id uuid primary key, chat_id uuid not null references chats(id), sender_id uuid not null references users(id), text text not null, created_at timestamptz not null ); create index messages_history_idx on messages (chat_id, created_at, id); create table sessions ( token_hash bytea primary key, user_id uuid not null references users(id) on delete cascade, created_at timestamptz not null, expires_at timestamptz not null );