-- Only run by a new assistant-learning Compose volume. No source project DBs.
CREATE DATABASE assistant_retrieval OWNER assistant;
CREATE DATABASE assistant_learning_test OWNER assistant;

\connect assistant_retrieval
CREATE EXTENSION IF NOT EXISTS vector;
CREATE EXTENSION IF NOT EXISTS pg_search;

\connect assistant_learning_test
CREATE EXTENSION IF NOT EXISTS vector;
CREATE EXTENSION IF NOT EXISTS pg_search;