kitloong / laravel-migrations-generator

Generates Laravel Migrations from an existing database

Stars
76

Laravel Migrations Generator

Build Status
Scrutinizer Code Quality

Generate Laravel Migrations from an existing database, including indexes and foreign keys!

This package is cloned from https://github.com/Xethron/migrations-generator and updated to support Laravel 6 and above.

V4 Changes

  1. Major rewrite on FieldGenerator and IndexGenerator.
  2. Added spatial data type support such as geometry, point, etc.
  3. Support more Laravel migration types such as uuid, longtext, year, etc
  4. Added spatialIndex support.
  5. timestamp and datetime support precision.
  6. Able generate softDeletes, rememberToken, timestamps types.
  7. Support set for MySQL
  8. It is now possible to generate nullable timestamp
  9. Removed unused classes.
  10. Fixed miscellaneous bugs.
  11. Added UT!
  12. More UT will be added increase coverage

Version Compatibility

Laravel Version
7.x 4.x
6.x 4.x
5.8.x 4.x
5.7.x 4.x
5.6.x 4.x
5.5 and below https://github.com/Xethron/migrations-generator

Laravel Installation

The recommended way to install this is through composer:

composer require --dev "kitloong/laravel-migrations-generator"

Usage

To generate migrations from a database, you need to have your database setup in Laravel's Config.

Run php artisan migrate:generate to create migrations for all the tables, or you can specify the tables you wish to generate using php artisan migrate:generate table1,table2,table3,table4,table5. You can also ignore tables with --ignore="table3,table4,table5"

Laravel Migrations Generator will first generate all the tables, columns and indexes, and afterwards setup all the foreign key constraints. So make sure you include all the tables listed in the foreign keys so that they are present when the foreign keys are created.

You can also specify the connection name if you are not using your default connection with --connection="connection_name"

Run php artisan help migrate:generate for a list of options.

Thank You

Thanks to Xethron for his great work. This package is cloned from https://github.com/Xethron/migrations-generator

Thanks to Jeffrey Way for his amazing Laravel-4-Generators package. This package depends greatly on his work.

Contributors

Kit Loong

Bernhard Breytenbach (@BBreyten)

License

The Laravel Migrations Generator is open-sourced software licensed under the MIT license