CREATE TABLE users ( id UUID PRIMARY KEY, username VARCHAR(32) NOT NULL UNIQUE, display_name VARCHAR(100) NOT NULL, password_hash TEXT NOT NULL, created_at TIMESTAMPTZ NOT NULL DEFAULT now() ); CREATE TABLE chats ( id UUID PRIMARY KEY, title VARCHAR(100) NOT NULL, created_at TIMESTAMPTZ NOT NULL DEFAULT now() ); 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 TABLE messages ( id UUID PRIMARY KEY, chat_id UUID NOT NULL REFERENCES chats(id), sender_id UUID NOT NULL REFERENCES users(id), text VARCHAR(4000) NOT NULL, created_at TIMESTAMPTZ NOT NULL DEFAULT now() ); CREATE INDEX chat_members_user_idx ON chat_members (user_id, chat_id); CREATE INDEX messages_history_idx ON messages (chat_id, created_at, id);