tabledump icon indicating copy to clipboard operation
tabledump copied to clipboard

Bug int unsigned decimal

Open niektenhoopen opened this issue 5 years ago • 2 comments

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

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

niektenhoopen avatar Jun 19 '20 18:06 niektenhoopen

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.

slaFFik avatar Jun 04 '21 13:06 slaFFik

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

xuandung38 avatar Sep 15 '21 12:09 xuandung38