5b67551fee
- Add Notification entity, SignalR hub and NotificationDispatcher - Add Obsidian document endpoints and document extractors - Add RagRetrievalService with chunking/retrieval config - Add ProcessKnowledgeBase and UpdateKnowledgeBase endpoints - Add EF migrations for RAG enhancements, chunking modes and notification center - Add unit/integration tests project
23 lines
804 B
SQL
23 lines
804 B
SQL
-- pgvector for rag database
|
|
\c rag;
|
|
CREATE EXTENSION IF NOT EXISTS vector;
|
|
|
|
-- Create databases for other services (idempotent)
|
|
\c postgres;
|
|
DO $$
|
|
BEGIN
|
|
IF NOT EXISTS (SELECT FROM pg_database WHERE datname = 'im_system') THEN
|
|
PERFORM dblink_exec('dbname=postgres', 'CREATE DATABASE im_system');
|
|
END IF;
|
|
IF NOT EXISTS (SELECT FROM pg_database WHERE datname = 'workflow') THEN
|
|
PERFORM dblink_exec('dbname=postgres', 'CREATE DATABASE workflow');
|
|
END IF;
|
|
IF NOT EXISTS (SELECT FROM pg_database WHERE datname = 'file_system') THEN
|
|
PERFORM dblink_exec('dbname=postgres', 'CREATE DATABASE file_system');
|
|
END IF;
|
|
IF NOT EXISTS (SELECT FROM pg_database WHERE datname = 'order_service') THEN
|
|
PERFORM dblink_exec('dbname=postgres', 'CREATE DATABASE order_service');
|
|
END IF;
|
|
END
|
|
$$;
|