-- 红动未来 - 初始化数据库和扩展
CREATE EXTENSION IF NOT EXISTS vector;

-- 为各微服务创建数据库
SELECT 'CREATE DATABASE admin_go'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'admin_go')\gexec
SELECT 'CREATE DATABASE ai_agent'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'ai_agent')\gexec
SELECT 'CREATE DATABASE assets'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'assets')\gexec
SELECT 'CREATE DATABASE cid'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'cid')\gexec
SELECT 'CREATE DATABASE customer_server'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'customer_server')\gexec
SELECT 'CREATE DATABASE data_engine'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'data_engine')\gexec
SELECT 'CREATE DATABASE erp'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'erp')\gexec
SELECT 'CREATE DATABASE media'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'media')\gexec
SELECT 'CREATE DATABASE model_gateway'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'model_gateway')\gexec
SELECT 'CREATE DATABASE orders'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'orders')\gexec
SELECT 'CREATE DATABASE oss'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'oss')\gexec
SELECT 'CREATE DATABASE prompts_core'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'prompts_core')\gexec
SELECT 'CREATE DATABASE rag'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'rag')\gexec
SELECT 'CREATE DATABASE shop_user_trade'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'shop_user_trade')\gexec
SELECT 'CREATE DATABASE video_factory'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'video_factory')\gexec