-- Loo Open WebUI andmebaas
CREATE DATABASE openwebui_db;
GRANT ALL PRIVILEGES ON DATABASE openwebui_db TO ai_user;

-- Loo RAG API andmebaas
CREATE DATABASE pdf_research;
GRANT ALL PRIVILEGES ON DATABASE pdf_research TO ai_user;

-- Loo kasutaja RAG API jaoks
CREATE USER osm WITH PASSWORD 'osm';
GRANT ALL PRIVILEGES ON DATABASE pdf_research TO osm;