How thinkPHP uses migrate to implement database migration

The following tutorial column of thinkphp framework will introduce to you how thinkPHP uses migrate to implement database migration. I hope it will be helpful to friends in need!

thinkPHP uses migrate to implement database migration

thinkPHP’s database migration tool: topthink/think-migration

1: Install topthink/think-migration

Note here that you need to pay attention to your thinkPHP version when installing topthink/think-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, select the version that suits you to install

composer require topthink/think-migration=2.0.*

After the installation is completed, execute on the command line:

php think

The following indicates that the migrate installation is successful

2: Use topthink/think-migration to implement database migration

1: Create a migration class

Execute on the command line

php think migrate:create CreateUser

After the execution is completed, we will Create a migrate migration file in the ./database/migrateions directory

#2: Implement database migration

migrate method usage documentation: http://docs. phinx.org/en/latest/migrations.html

[1]: Migrate code description:

There are three methods in migrate

up: when migrate:run Execution (provided that the change method does not exist in the file)

down: Execute when migrate:rollback (provided that the change method does not exist in the file)

change:migrate:run and migrate:rollback (If this method exists, up and down will not be executed)

Generally, I delete the change method in the migrate file. The up method is specifically used to add and update tables, and the down method Place delete table and delete field operations

(1)Add new table:

// 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();

(2)Update table:

$this->table('user')
    ->addColumn('test', 'string', ['limit' => 15, 'default' => '', 'comment' => '测试'])//在user表中增加一个test字段
    ->update();

(3)Delete table:

$this->table('user')->drop();

(4) Delete field

$this->table('user')
    ->removeColumn('test')//删除user表中的test字段
    ->save();

[2]: migrate command:

There are three commonly used commands for migrate, namely:

php think migrate:create CreateUser  #创建一个迁移类
php think migrate:run  #执行迁移
php think migrate:rollback #迁移回滚

The above is the detailed content of How thinkPHP uses migrate to implement database migration. For more information, please follow other related articles on the PHP Chinese website!