How to add tinyint to database field in cakephp 3 using migration Plugin?

Question

I am using cakephp 3 migrations plugin to design database. I want to add a status field tinyint with limit as 1 to an field, I have tried the following but nothing adds up.

Attempt 1. (Fails)

$table->addColumn('status', 'smallinteger', [
        'default' => 0,
        'limit' => 1,
        'null' => false,
]);

Attempt 2. (Fails)

$table->addColumn('status', 'tinyint', [
        'default' => 0,
        'limit' => 1,
        'null' => false,
]);

I could not find any documentation for the same may be its there and i am missing something Docs Link

Nabin Nembang · Accepted Answer · 2016-01-22 13:27:36Z

8

Adding field type of boolean adds tinyint column of length 1

$table
      ->addColumn('status', 'boolean', [
                'default' => false,
                'null' => false,
            ]);

edited Jan 22, 2016 at 13:27

answered Jan 22, 2016 at 13:20

Nabin Nembang

7538 silver badges14 bronze badges

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

2 Comments

Sahil Sharma Over a year ago

thanks man i dind not think that way cakephp take tinyint 1 as boolean

Nicolas Castro Over a year ago

You can also add 'signed' => false to get an unsigned tinyint.

Moby Duck · Accepted Answer · 2020-12-15 09:53:13Z

2

It took me a while to figure out how to add a regular, non-boolean tinyint, and I kept coming across this question when searching for an answer. So for the others like me, it's this:

use Phinx\Db\Adapter\MysqlAdapter;
    
$table->addColumn('status', 'integer', [
    'default' => 0,
    'limit' => MysqlAdapter::INT_TINY,
    'null' => false,
]);

answered Dec 15, 2020 at 9:53

Moby Duck

2,1602 gold badges21 silver badges30 bronze badges

Comments

Awemo · Accepted Answer · 2016-01-22 14:50:01Z

1

The migration plugin uses the Phinx library for executing these updates. Adding tinyint columns should be done with MysqlAdapter::INT_TINY constant as follows:

use Phinx\Db\Adapter\MysqlAdapter;
...
$table->addColumn('status', 'tinyint', [
    'default' => 0,
    'limit' => MysqlAdapter::INT_TINY, // 255
    'null' => false,
]);

Source: Phinx Mysql Tinyint

edited Jan 22, 2016 at 14:50

answered Jan 22, 2016 at 12:53

Awemo

8951 gold badge12 silver badges26 bronze badges

5 Comments

Sahil Sharma Over a year ago

PHP Fatal error: Class 'MysqlAdapter' not found in /var/www/html/cake3plugin/config/Migrations/20160122144154_CreateProducts.php on line 35

Awemo Over a year ago

You have to add the classes to be used at the top. use Phinx\Db\Adapter\MysqlAdapter;. Fine if N nem's solution works.

Sahil Sharma Over a year ago

[InvalidArgumentException] An invalid column type "tinyint" was specified for column "status "

Sahil Sharma Over a year ago

appreciate the effort though

ndm Over a year ago

There is no tinyint type, you'd have to use integer, and a length of 255. While this would create a TINYINT column, it would have a length of 255, which is not what the OP is looking for.

Collectives™ on Stack Overflow

How to add tinyint to database field in cakephp 3 using migration Plugin?

3 Answers 3

2 Comments

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related