Download the PHP package kitloong/laravel-migrations-generator without Composer
On this page you can find all versions of the php package kitloong/laravel-migrations-generator. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package laravel-migrations-generator
Laravel Migrations Generator
Generate Laravel Migrations from an existing database, including indexes and foreign keys!
This package is a modified version of https://github.com/Xethron/migrations-generator that has been updated to support Laravel 5.6 and beyond, along with additional features.
Supported Database
Laravel Migrations Generator supports all five Laravel first-party support databases:
- [x] MariaDB
- [x] MySQL
- [x] PostgreSQL
- [x] SQL Server
- [x] SQLite
Version Compatibility
| Laravel | Version |
|---|---|
| 11.x | 7.x |
| >= 10.43.x | 7.x |
| 10.x | <= 10.42.x | 6.x |
| 9.x | 6.x |
| 8.x | 6.x |
| 7.x | 6.x |
| 6.x | 6.x |
| 5.8.x | 6.x |
| 5.7.x | 6.x |
| 5.6.x | 6.x |
| <= 5.5.x | https://github.com/Xethron/migrations-generator |
Install
The recommended way to install this is through composer:
Laravel Setup
Laravel will automatically register service provider for you.
Lumen Setup
Expand
Auto-discovery is not available in Lumen, you need some modification on `bootstrap/app.php`. #### Enable Facade Uncomment the following line. #### Register Provider Add following line into the `Register Service Providers` section.Usage
To generate migrations from a database, you need to have your database setup in Laravel's config (config/database.php).
To create migrations for all the tables, run:
You can specify the tables you wish to generate using:
You can also ignore tables with:
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:
Squash Migrations
By default, Generator will generate multiple migration files for each table.
You can squash all migrations into a single file with:
Options
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 or views you wish to generate migrations for separated by a comma: users,posts,comments |
| -i, --ignore[=IGNORE] | A list of tables or views you wish to ignore, separated by a comma: users,posts,comments |
| -p, --path[=PATH] | Where should the file be created? |
| -tp, --template-path[=TEMPLATE-PATH] | The location of the template for this generator |
| --date[=DATE] | Migrations will be created with specified date. Views and foreign keys will be created with + 1 second. Date should be in format supported by Carbon::parse |
| --table-filename[=TABLE-FILENAME] | Define table migration filename, default pattern: [datetime]\_create_[name]_table.php |
| --view-filename[=VIEW-FILENAME] | Define view migration filename, default pattern: [datetime]\_create_[name]_view.php |
| --proc-filename[=PROC-FILENAME] | Define stored procedure filename, default pattern: [datetime]\_create_[name]_proc.php |
| --fk-filename[=FK-FILENAME] | Define foreign key migration filename, default pattern: [datetime]\_add_foreign_keys_to_[name]_table.php |
| --log-with-batch[=LOG-WITH-BATCH] | Log migrations with given batch number. We recommend using batch number 0 so that it becomes the first migration |
| --default-index-names | Don\'t use DB index names for migrations |
| --default-fk-names | Don\'t use DB foreign key names for migrations |
| --use-db-collation | Generate migrations with existing DB collation |
| --skip-log | Don\'t log into migrations table |
| --skip-vendor | Don\'t generate vendor migrations |
| --skip-views | Don\'t generate views |
| --skip-proc | Don\'t generate stored procedures |
| --squash | Generate all migrations into a single file |
| --with-has-table | Check for the existence of a table using hasTable |
SQLite Alter Foreign Key
The generator first generates all tables and then adds foreign keys to existing tables.
However, SQLite only supports foreign keys upon creation of the table and not when tables are altered. _add_foreignkeys migrations will still be generated, however will get omitted if migrate to SQLite type database.
User-Defined Type Columns
The generator will recognize user-defined type from the schema, and then generate migration as
Note that the new column is always added at the end of the created table which means the ordering of the column generated in migration will differ from what we have from the schema.
Supported database with user-defined types:
- [x] PostgreSQL
- [x] SQL Server
Thank You
Thanks to Bernhard Breytenbach for his great work. This package is based on https://github.com/Xethron/migrations-generator.
Contributors
License
The Laravel Migrations Generator is open-sourced software licensed under the MIT license
