Spaces:
Running
Running
| -- ═══════════════════════════════════════════════════════════ | |
| -- MicProtocol - Database initialization | |
| -- Creates one DB per self-hosted integration. The MicProtocol | |
| -- API itself uses POSTGRES_DB (mirroring POSTGRES_USER) which is | |
| -- created automatically by the postgres image; these scripts add | |
| -- the rest. | |
| -- ═══════════════════════════════════════════════════════════ | |
| -- Core extension used by MicProtocol itself. | |
| CREATE EXTENSION IF NOT EXISTS pgcrypto; | |
| -- pgvector is required by Chatwoot AND Formbricks. The image | |
| -- pgvector/pgvector:pg16 ships the extension; just enable it. | |
| CREATE EXTENSION IF NOT EXISTS vector; | |
| -- ─── MicProtocol integration DBs (each owns its own schema) ─ | |
| CREATE DATABASE chatwoot; | |
| CREATE DATABASE calcom; | |
| CREATE DATABASE documenso; | |
| CREATE DATABASE formbricks; | |
| CREATE DATABASE listmonk; | |
| CREATE DATABASE umami; | |
| -- ─── Per-DB extensions ───────────────────────────────────── | |
| -- pgvector has to be enabled inside each database that needs it. | |
| \c chatwoot | |
| CREATE EXTENSION IF NOT EXISTS vector; | |
| CREATE EXTENSION IF NOT EXISTS pgcrypto; | |
| \c formbricks | |
| CREATE EXTENSION IF NOT EXISTS vector; | |
| CREATE EXTENSION IF NOT EXISTS pgcrypto; | |
| \c calcom | |
| CREATE EXTENSION IF NOT EXISTS pgcrypto; | |
| \c documenso | |
| CREATE EXTENSION IF NOT EXISTS pgcrypto; | |
| \c umami | |
| CREATE EXTENSION IF NOT EXISTS pgcrypto; | |
| \c listmonk | |
| CREATE EXTENSION IF NOT EXISTS pgcrypto; | |