[SOLVED] Add custom column to user model

[khan-umer]

Hello Everyone,
I am looking to add new columns in users table & i followed steps as per #333 & answered by @datamweb.
I Execute command php spark migrate to apply changes to the users table, but changes are not reflecting in users table.
here is my code changes

<?php
namespace App\Database\Migrations;
use CodeIgniter\Database\Migration;

// Add custom column for shield
class AddCustomColumnForUser extends Migration
{
    public function up()
    {
        
        $fields = [
            'first_name' => [
                'type'       => 'text',
                'constraint' => '50',
                'null'       => TRUE
            ],
            'last_name' => [
                'type'       => 'VARCHAR',
                'constraint' => '50',
                'null'       => TRUE
            ],
            'phone_number' => [
                'type'       => 'VARCHAR',
                'constraint' => '20',
                'null'       => TRUE
            ]
        ];

        $this->forge->addColumn('users', $fields);
    
    }

    public function down()
    {
        $fields = [
            'first_name',
            'last_name',
            'phone_number',
        ];
        $this->forge->dropColumn('users', $fields);
    }
}

here is CLI result

[datamweb]

Hey @khan-umer ,
Please delete file AddCustomColumnForUser.php from path app\Database\Migrations.
Now run command php spark make:migration AddCustomColumnForUser.
Edit this file and add the following:

<?php
namespace App\Database\Migrations;
use CodeIgniter\Database\Migration;

// Add custom column for shield
class AddCustomColumnForUser extends Migration
{
    public function up()
    {
        
        $fields = [
            'first_name' => [
                'type'       => 'text',
                'constraint' => '50',
                'null'       => TRUE
            ],
            'last_name' => [
                'type'       => 'VARCHAR',
                'constraint' => '50',
                'null'       => TRUE
            ],
            'phone_number' => [
                'type'       => 'VARCHAR',
                'constraint' => '20',
                'null'       => TRUE
            ]
        ];

        $this->forge->addColumn('users', $fields);
    
    }

    public function down()
    {
        $fields = [
            'first_name',
            'last_name',
            'phone_number',
        ];
        $this->forge->dropColumn('users', $fields);
    }
}

Now run command php spark migrate.

[khan-umer]

yes it's work. thks