Create a new numbered database migration file following the project's 001-010 naming convention in database/migrations/
Create a new numbered SQL migration file in database/migrations/.
database/migrations/ and find the highest numbered file (format: NNN_description.sql){NNN}_{user_description}.sql using the description provided by the user (snake_case)-- Migration: {NNN}_{description}
-- Created: {current_date}
-- Description: {user's description of what this migration does}
BEGIN;
-- Your migration SQL here
COMMIT;
docker exec trademate-postgres psql -U trademate -d trademate -f /path/to/migration.sqlscripts/migrate.sh and scripts/migrate-railway.sh if neededThe user should provide a brief description of what the migration does, e.g.:
/db-migrate add customer products table/db-migrate add recurring schedule fields.sql011_customer_products.sql