Skip to content

Laravel Migrations Generator: Automatically generate your migrations from an existing database schema.

License

Notifications You must be signed in to change notification settings

bradzoob/laravel-migrations-generator

 
 

Repository files navigation

Laravel Migrations Generator

Build Status Scrutinizer Code Quality Latest Stable Version License

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

V4 Changes

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

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

Version Compatibility

Laravel Version
8.x 4.x
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

Install

The recommended way to install this is through composer:

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

Laravel Setup

Laravel will automatically register service provider for you.

Lumen Setup

Auto discovery is not available in Lumen, you need some modification on bootstrap/app.php

Enable facade

Uncomment the following line

$app->withFacades();

Register provider

Add following line

$app->register(\KitLoong\MigrationsGenerator\MigrationsGeneratorServiceProvider::class);

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.

Options Description
-c, --connection[=CONNECTION] The database connection to use
-t, --tables[=TABLES] A list of Tables you wish to Generate Migrations for separated by a comma: users,posts,comments
-i, --ignore[=IGNORE] A list of Tables you wish to ignore, separated by a comma: users,posts,comments
-p, --path[=PATH] Where should the file be created?
--defaultIndexNames Don't use db index names for migrations
--defaultFKNames Don't use db foreign key names for migrations
-tp, --templatePath[=TEMPLATEPATH] The location of the template for this generator

Thank You

Thanks to Bernhard Breytenbach 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

About

Laravel Migrations Generator: Automatically generate your migrations from an existing database schema.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • PHP 98.9%
  • Gherkin 1.1%