Database

Overview

Wedissimo uses a multi-database setup with PostgreSQL as the primary database and MySQL for legacy WordPress data.

Connections

Primary (PostgreSQL)

• All application data
• UUID primary keys
• Full-text search
• JSONB support

Legacy (MySQL)

• WordPress migration source
• Corcel package for ORM
• Maintains wp_id foreign keys

Common Commands

# Run migrations
docker exec wedissimo-api php artisan migrate

# Rollback
docker exec wedissimo-api php artisan migrate:rollback

# Fresh migration with seed
docker exec wedissimo-api php artisan migrate:fresh --seed

# Check migration status
docker exec wedissimo-api php artisan migrate:status

Creating Migrations

Always use Artisan commands:

docker exec wedissimo-api php artisan make:migration create_your_table --table=your_table

# For modules
docker exec wedissimo-api php artisan make:migration create_your_table --path=modules/YourModule/Database/Migrations

Migration Best Practices

1. Include ALL column attributes when modifying
2. Use UUID primary keys (HasUuids trait)
3. Add indexes for foreign keys
4. Write reversible migrations (up/down)

See Architecture for more details.