postgres migrations

2 files changed, 4 insertions, 1 deletions

diff --git a/communities/red-right-hand/174bg.net/Dockerfile b/communities/red-right-hand/174bg.net/Dockerfile
index bf4fce4..636d9b2 100644
--- a/communities/red-right-hand/174bg.net/Dockerfile
+++ b/communities/red-right-hand/174bg.net/Dockerfile
@@ -89,6 +89,9 @@ ENV HOSTNAME="0.0.0.0"
 # Copy production assets
 COPY --from=builder --chown=node:node /app/public ./public
 
+# Copy database migration files
+COPY --from=builder --chown=node:node /app/better-auth_migrations ./better-auth_migrations
+
 # Set the correct permission for prerender cache
 RUN mkdir .next
 RUN chown node:node .next
diff --git a/communities/red-right-hand/174bg.net/README.md b/communities/red-right-hand/174bg.net/README.md
index b1d2ba4..6fee992 100644
--- a/communities/red-right-hand/174bg.net/README.md
+++ b/communities/red-right-hand/174bg.net/README.md
@@ -11,7 +11,7 @@ The website is built using [Next.js](https://nextjs.org/) and is deployed via [D
 After starting the containers, apply the database migrations by piping each SQL file in `better-auth_migrations/` into the postgres container:
 
 ```sh
-cat better-auth_migrations/*.sql | docker compose exec -T postgres psql -U postgres -d postgres
+docker compose exec -T 174bg-net sh -c 'cat better-auth_migrations/*.sql' | docker compose exec -T postgres psql -U postgres -d postgres
 ```
 
 > If your `.env` uses a different `POSTGRES_USER` or `POSTGRES_DB`, substitute those values for `postgres` above.