laravel-schema-extend
- 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-extendless 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
PS.
sorry for my bad english
