Databases

Required primary keys

Managed databases require all tables to have primary keys in order to avoid issues with possible replication.

Squashing migrations

composer run-script reset
php artisan schema:dump

PostgreSQL

Migrating from MySQL

To easily migrate a MySQL database to PostgreSQL, use https://github.com/AnatolyUss/NMIG:

cd ~/Downloads
gh repo clone AnatolyUss/nmig
cd nmig
npm install
npm run build

After that, enter your credentials in config/config.json and ensure there's a new empty database ready in PostgreSQL.

Run npm run start to start the migration.