database/migrations20220111014748_testCategory.php

<?php

use think\migration\Migrator;

class TestCategory extends Migrator
{
    public function change()
    {
        $table = $this->table('test_category', [
            'engine' => 'InnoDB',
            'comment' => '官方举例，生成分类CURD',
            'collation' => 'utf8mb4_general_ci'
        ]);

        //删除表
        if ($table->exists()) {
            $table->drop();
        }

        $table
            ->addColumn('name', 'string', ['limit' => 255, 'null' => 1, 'default' => '','comment' => '分类名'])
			->addColumn('pid', 'integer', ['limit' => 11, 'null' => 1, 'default' => '0','comment' => '上级分类'])
			->addColumn('sort', 'integer', ['limit' => 11, 'null' => 1, 'default' => '0','comment' => '排序'])
			->addColumn('create_time', 'datetime', ['null' => 1, 'comment' => '创建时间'])
			->addColumn('update_time', 'datetime', ['null' => 1, 'comment' => '更新时间'])
			->addColumn('delete_time', 'datetime', ['null' => 1, 'comment' => '删除时间'])
			
        ;

        $table->create();
    }
}