Thinkphp6 , Migration

$this->addColum('intro','string',['comment'=>'','简介'])
$this->addColum('age','integer',['comment'=>'','年龄'])

php think migrate:new  user_roles

{
  "extra": {
    "think": {
      "services": [
        "magein\\think\\migration\\service\\CommandService"
      ]
    }
  }
}

composer require magein/think-migration

'config' => [
    // 数据库迁移工具使用的配置文件
    'migrate' => [
        'mysql' => [
            // 默认引擎
            'engine' => 'InnoDB',
            // 字符集校队规则 .env文件中为charset建议设置为utf8mb4
            // utf8_general_ci、utf8_unicode_ci、utf8mb4_general_ci、utf8mb4_unicode_ci
            'collation' => 'utf8mb4_unicode_ci',
            // 数据库版本 是数据库的版本  而不是php安装的扩展版本  ^v1.x版本废除此参数
            'version' => env('database.version')
        ]
    ],
],

php think migrate:new users
// 增加money、integral字段（仅生成迁移文件）
php think migrate:new users -a money,integral
// 移除email、role_id字段（仅生成迁移文件）
php think migrate:new usuer -r email,role_id
// 更新status、balance字段（仅生成迁移文件）
php think migrate:new users -u status,balance 

protected $name = 'users';

public function change()
{
    $table = $this->init();
    $table->id();
    $this->create($table);
}

public function change()
{
    $table = $this->init();
    $table->id();
    $table->uuid('uuid');
    $table->string('username', '登录账号', 30)->unique();
    $table->string('password', '登录密码', 128);
    $table->char('phone', '手机号码', 11)->index();
    $table->string('email', '邮箱地址', 64)->nullable();
    $table->integer('integral', '积分')->default();
    $table->integerTiny('from', '来源 1 注册 2 小程序')->default(1);
    $table->integerSmall('order_total', '订单数量')->default(0);
    $table->integerSmall('age', '年龄')->nullable();
    $table->integerTiny('sex', '性别')->default(0);
    $table->date('birthday', '生日')->nullable();
    $table->dateTime('last_login_time', '最后一次登录时间')->nullable();
    $table->boolean('status')->comment('状态 0 禁用 1 启用')->default(1);
    $table->time('notify')->comment('通知时间')->nullable();

    // 这里调用的$this->create() 而非$table->create()
    $this->create($table);
}

$table = $this->init();
$table->setEngine();
// or
$table->innoDB();
$table->myISAM();

// 设置字符集
$table->setCollation();
// 设置表描述
$table->setComment();

$table = $this->init();
// 不指定长度默认为32
$table->char('phone', '手机号码')->unique();
$table->char('phone', '手机号码',11)->unique();
$table->char('phone', '手机号码',11)->unique('phone_uniq');
// 或者
$table->addIndex('phone');
$table->addIndex(['phone']);
$table->addIndex(['phone'],'index_phone');
$table->addUniqueKey('phone');
$table->addIndex(['phone'],'unique_phone');
$table->addForeignKey();

// 表创建完成之后，设置索引 请注意这里使用的是$this
$this->addIndex();
$this->addUniqueIndex();
$this->removeIndex();
$this->removeIndexByName();
$this->addForeignKey();
$this->dropForeignKey();

$table = $this->init();
$table->id();
$table->userId();
$table->memberId();
$table->email();
$table->phone();
$table->remark();
$table->money();
$table->type();
$table->password();
$table->name();
$table->title();
$table->sort();
$table->beginTime();
$table->startTime();
$table->endTime();
$table->status();

$table = $this->init();
$table->rename('旧字段名称','新名称');
$table->update();

public function up(){
    $table = $this->init();
    $table->remove('字段名称');
    $table->update();
}

public function down(){
    $table = $this->init();
    $table->string('字段名称');
    $table->update();
}

$this->drop();

$this->exist();

$this->invokeTable();

# 问题：设置唯一索引长度为128，但是创建后是32
$table->string('path', '权限路径',128)->unique();