thinkPHP database migration tool: topthink/think-migration
1: Install topthink/think-migration
Note here that you install topthink/ You need to pay attention to your thinkPHP version when thinking-migration. My thinkPHP version here is 5.1, so you can install version 2.0 of topthink/think-migration. Version 3.0 cannot be installed. Choose the version that suits you to install
composer require topthink/think-migration=2.0.*
After the installation is complete, execute on the command line:
php think
The following indicates that migrate is installed successfully
php think migrate:create CreateUser
// create the table $table = $this->table('user', ['id' => 'user_id', 'comment' => '用户表', 'engine' => 'MyISAM', '']); $table->addColumn('user_name', 'string', ['limit' => 15, 'default' => '', 'comment' => '用户名']) ->addColumn('password', 'string', ['limit' => 15, 'default' => '', 'comment' => '密码',]) ->addColumn('status', 'boolean', ['limit' => 1, 'default' => 0, 'comment' => '状态']) ->addIndex(['user_name'], ['unique' => true])//为user_name创建索引并设置唯一(唯一索引) ->addTimestamps()//默认生成create_time和update_time两个字段 ->create();
$this->table('user') ->addColumn('test', 'string', ['limit' => 15, 'default' => '', 'comment' => '测试'])//在user表中增加一个test字段 ->update();
$this->table('user')->drop();
$this->table('user') ->removeColumn('test')//删除user表中的test字段 ->save();
php think migrate:create CreateUser #创建一个迁移类 php think migrate:run #执行迁移 php think migrate:rollback #迁移回滚
TP5》
The above is the detailed content of thinkPHP uses migrate to migrate database. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
