search

TablePlus / tabledump

This is a TablePlus plugin which add `copy table creation` menu in left panel
MIT License
104 stars 18 forks source link

Bug int unsigned decimal #21

Open niektenhoopen opened 4 years ago

niektenhoopen commented 4 years ago

On MySQL 5 the following column xxx decimal(6,2) unsigned

is converted to: $table->decimal('xxx', 6, 2) unsigned->unsigned()

slaFFik commented 3 years ago

Another example using TablePlus 4.0.5(168) and the latest available tabledump for bigint: 

$table->bigint unsigned('id')->unsigned()->autoIncrement();

It should use unsignedBigInteger() in my case: https://laravel.com/docs/8.x/migrations#column-method-unsignedBigInteger

And https://laravel.com/docs/8.x/migrations#column-method-unsignedDecimal for a topic-starter.

xuandung38 commented 3 years ago

It should be $table->id() if column name is id ( laravel 7x and late)