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)
