thinkphp 表字段

php think migrate:run

namespace app\common\model;

use think\Model;

class User extends Model
{
    protected $table = 'user';
    protected $schema = [
        'id' => 'int unsigned not null auto_increment',
        'username' => 'varchar(50) not null',
        'email' => 'varchar(100)',
        'password' => 'varchar(255) not null',
        'created_at' => 'timestamp default current_timestamp',
        'updated_at' => 'timestamp default current_timestamp on update current_timestamp',
        'deleted_at' => 'timestamp null',
    ];
}

use think\migration\Migrator;
use think\migration\db\Column;

class AddNewFieldToUserTable extends Migrator
{
    public function change()
    {
        $this->table('user')
            ->addColumn('new_field', 'varchar(255)')
            ->update();
    }
}