Laravel 5.5 set size of integer fields in migration file

Question

I am new to laravel.

Now i am using the migrate command to make a table, but the length of the filed is not applicable. Laravel does not provide this option. ?

Below is my codes:

$table->increments('id')->length(11);
$table->dateTime('created_time');
$table->integer('bank_id')->length(11);
$table->tinyInteger('is_black')->length(1);

The length of the field is_black should be 1, but it is actually being generated as 4. How can I solve this problem ?

Any suggestion or advice would be appreciated.

Thank you in advance

As I see, you want an 11 length integer. This is a common mistake when you use an unsigned integer. Not unsigned integers are 11 lengths, and unsigned ones are 10 lengths. So try setting the unsigned flag to false, or removing the ->unsigned() operator. — JuliSmz
– JuliSmz, Commented Aug 3, 2020 at 21:31
after adding table schema, you can add the DB::statement query and add here the ALTER query for changing the column type and length. Currently we can do this only to produce expected result — Amit Kumar
– Amit Kumar, Commented Dec 13, 2022 at 12:20

Alexey Mezenin · Accepted Answer · 2017-12-27 07:15:10Z

33

You can't do this, but you can use different types of integer:

$table->bigInteger()
$table->mediumInteger()
$table->integer()
$table->smallInteger()
$table->tinyInteger()

https://laravel.com/docs/5.5/migrations#columns

answered Dec 27, 2017 at 7:15

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

oriberu · Accepted Answer · 2019-09-24 13:36:15Z

8

According to https://laravel.com/docs/5.1/migrations, as of Laravel 5.1 you can use the boolean column type to create a "boolean-like" TINYINT of length 1 (MySQL). So, for example:

$table->boolean('nameOfColumn');

answered Sep 24, 2019 at 13:36

oriberu

1,21611 silver badges7 bronze badges

Comments

mfadel · Accepted Answer · 2017-12-27 07:19:27Z

6

According to https://laravel.com/docs/5.5/migrations, you can use one of these types:

$table->bigInteger('votes');
$table->integer('votes');

$table->mediumInteger('votes'); 
$table->smallInteger('votes');
$table->tinyInteger('votes');
$table->unsignedBigInteger('votes');
$table->unsignedMediumInteger('votes'); 
$table->unsignedSmallInteger('votes');  
$table->unsignedTinyInteger('votes');

edited Dec 27, 2017 at 7:19

answered Dec 27, 2017 at 7:16

mfadel

8971 gold badge12 silver badges33 bronze badges

4 Comments

Alexey Mezenin Over a year ago

There are 5 types actually.

mfadel Over a year ago

@AlexeyMezenin thanks, you are right there are more integer types, actually, with the unsigned versions, there are more than 5 types.

Alexey Mezenin Over a year ago

unsigned is just a shortcut for integer()->unsigned() so it's not a type.

David Over a year ago

OK, but how is this possible to choose length ?

Carlos Ivan Olvidaos · Accepted Answer · 2020-06-22 17:42:32Z

this is solution for me! Inside on function run.

    $tableName = 'tblresefeage';
    $comments = 'Resumen efectividad por agencia';
    Schema::create($tableName, function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->unsignedInteger('agencia')->comment('Agencia');
        $table->date('fechacierre')->comment('Fecha cierre');           
        $table->timestamps();
    });
    DB::statement('ALTER TABLE tblresefeage MODIFY COLUMN agencia INTEGER (11);');

    Schema::table($tableName, function (Blueprint $table) {
        $table->foreign('agencia')->on('tblentage')->references('cveentage')->onDelete('cascade');
    });

    DB::statement("ALTER TABLE `$tableName` comment '".$comments."'");

commadelimited · Accepted Answer · 2021-12-06 16:41:30Z

2

This code works for me.

$table->addColumn(
    'tinyInteger', 'field_name',
    [
        'length'   => 2,
        'default'  => '1',
        'autoIncrement' => false,
        'unsigned' => true,
        'comment'  => 'Some comments'
    ]
);

edited Dec 6, 2021 at 16:41

commadelimited

5,0467 gold badges47 silver badges83 bronze badges

answered Dec 22, 2020 at 4:07

akituti

414 bronze badges

1 Comment

myeongkil kim Over a year ago

Can you improve the formatting of your suggested code through code blocks?

quoctinh0897 · Accepted Answer · 2019-02-21 04:15:34Z

0

You can use this way. Good luck.

$table->decimal('is_black',1,0);

answered Feb 21, 2019 at 4:15

quoctinh0897

251 silver badge1 bronze badge

Comments

Hans Paul · Accepted Answer · 2023-06-15 05:15:49Z

0

In Laravel 10, I did not find any other way to get tinyint(1), but this:

public function up(): void
{
    Schema::create('country', function (Blueprint $table) {
        // This generate tinyint(4) default 1
        $table->tinyInteger('active', false, true)->default(1);
        $table->timestamps();
    });
    // This generate tinyint(1) default 1
    DB::statement('ALTER TABLE `country` ADD `active2` TINYINT(1) NOT NULL DEFAULT 1');
}

answered Jun 15, 2023 at 5:15

Hans Paul

215 bronze badges

Comments

user12255561 · Accepted Answer · 2019-10-22 06:22:48Z

-5

$table->increments('id',11);
$table->dateTime('created_time');
$table->integer('bank_id',11);
$table->tinyInteger('is_black',1);

answered Oct 22, 2019 at 6:22

user12255561

231 silver badge1 bronze badge

4 Comments

BDL Over a year ago

From review: Although this code might solve the problem, a good answer should also explain what the code does and how it solves the problem.

Muhammad Noman Over a year ago

Also, this doesn't work. Have you read it somewhere in docs that a second parameter could be passed?

David Over a year ago

This code is not working, if I put a second argument, I got this error : SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key (SQL: create table tvas (id bigint unsigned not null auto_increment primary key, taux int not null auto_increment primary key, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

K.B. Over a year ago

The second parameter on the integer method is for flagging autoIncrement as true, not setting the length of the field.

Collectives™ on Stack Overflow

Laravel 5.5 set size of integer fields in migration file

8 Answers 8

Comments

Comments

4 Comments

Comments

1 Comment

Comments

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

4 Comments

Comments

1 Comment

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related