zedisdog/laravel-schema-extend

supplement for eloquent migration

1.4.1 2020-12-05 12:59 UTC

Requires

• php: >=5.4.0
• illuminate/database: >=5.4
• illuminate/support: >=5.4

Requires (Dev)

• phpunit/phpunit: ^5.0|^6.0|^8.4|^9.0

WTFPL

• zed

README

• support MySQL 'table comment'.
• 'column comment' is built-in in greater than 5.1 version.
• support variable length for integer/tinyint/mediumint/smallint/bigint

just extend the original class

Install

Require this package with composer using the following command:

composer require zedisdog/laravel-schema-extend

less than 5.5

modify the alias Schema in config/app.php:

'aliases' => [
    ...
    // 'Schema' => Illuminate\Support\Facades\Schema::class,
    'Schema'    => Jialeo\LaravelSchemaExtend\Schema::class,
],

great than 5.5

just modify use statement from

use Illuminate\Support\Facades\Schema;

to

use Jialeo\LaravelSchemaExtend\Schema;

in migrate files.

Usage

Schema::create('tests', function ($table) {
    //this is alredy built-in.
    $table->increments('id')->comment('column comment');
    
    $table->integer('int')->default(1)->length(1);
    $table->bigInteger('big')->default(1)->length(1);
    $table->smallInteger('small')->default(1)->length(1);
    $table->tinyInteger('tiny')->default(1)->length(1);
    $table->mediumInteger('medium')->default(1)->length(1);
    
    $table->comment = 'table comment';
    $table->autoIncrement = 100;
});

Thanks

• jialeo
• ghostboyzone
• xuhuan
• xiaobeicn
• 5-say

PS.

sorry for my bad english