nachofassini/laravel-database-structure

Package that generates a php file with the tables and fields of the database after running all the migrations

2.0.0 2018-05-17 14:28 UTC

Requires

• php: ^7.1
• illuminate/console: ~5.5|~5.6
• illuminate/contracts: ~5.5|~5.6
• illuminate/support: ~5.5|~5.6
• thedevsaddam/laravel-schema: ^2.0

MIT

• Ignacio Fassini

• database
• schema
• laravel
• structure
• schema-file

README

Install

You can pull in the package via composer:

    composer require nachofassini/laravel-database-structure

For laravel < 5.6: the service provider must be registered:

    // config/app.php
    'providers' => [
        ...
        NachoFassini\LaravelDatabaseStructure\ServiceProvider::class,
        
    ];

How to generate schema file

To generate schema file just type in the console:

    php artisan schema:file

The file should be generated at your database path like schema.php and would look like these:

    $tables => [
        'users' => [
            'id',
            'name',
            'email',
            'created_at',
            ...
        ],
        'posts' => [
            'user_id',
            'title',
            ...
        ]
    ];

There are no conventions about this, but I think this file should be ignored.

Automatic update on migrations

If you want the file to be updated every time you change the database through any migrate command, just set AUTOMATIC_SCHEMA_FILE=true in your .env file.

This will make that after executing any kind of migration command, the schema file gets up to date with the final database structure.

Contributing

I think this can be much more useful, any collaboration is appreciated.

License

The MIT License (MIT). Please see License File for more information.