thinkphp数据库迁移_米醋屋个人技术博客

#### 安装

composer require topthink/think-migration
	
#### 创建迁移工具文件

//执行命令,创建一个操作文件,一定要用大驼峰写法,如下
	php think migrate:create AnyClassNameYouWant
	//执行完成后,会在项目根目录多一个database目录,这里面存放类库操作文件
	//文件名类似/database/migrations/20190615151716_any_class_name_you_want.php
[![](https://micuu.com/data/avatar/20211018/a6c4c7a48569f54a5793c68326fe95a0.png)](https://micuu.com/data/avatar/20211018/a6c4c7a48569f54a5793c68326fe95a0.png)

#### 编辑文件

1：创建表

if (!$this->hasTable('email_blacklist')) {
            $tableEmailBlacklist = $this->table('email_blacklist');
            $tableEmailBlacklist
                ->addColumn('email', 'string', ['limit' => 100, 'default' => '', 'comment' => '邮件'])
                ->addColumn('create_time', 'integer', ['limit' => 11, 'default' => null, 'comment' => '创建时间'])
                ->addColumn('update_time', 'integer', ['limit' => 11, 'default' => null, 'comment' => '更新时间'])
                ->addColumn('add_user_id', 'integer', ['limit' => 11, 'default' => null, 'comment' => '添加者'])
                ->addColumn('delete_time', 'integer', ['limit' => 11, 'default' => null, 'comment' => '删除时间'])
                ->addColumn('name', 'string', ['limit' => 20, 'default' => '', 'comment' => '姓名'])
                ->addIndex('id', ['unique' => true])
                ->setComment('黑名单邮箱')
                ->create();
        }
		
2：insert

public function change()
    {
        $sql = "
        INSERT INTO csi.csi_admin_node (pid,group_id,name,title,remark,`level`,`type`,sort,status,isdelete,create_time,update_time) VALUES
	 (199,1,'index','邮箱管理','',3,0,50,0,0,NULL,NULL),
	 (1,1,'AdminEmail','邮箱管理','',2,1,50,1,0,NULL,NULL);
                 ";
        $this->query($sql);
    }
	
3：其他判断

public function change() {
        $replyTable = $this->table('reply');
        $updateTime = $replyTable->hasColumn('update_time');
        if (!$updateTime) {
            $replyTable->addColumn('update_time', 'integer', ['limit' => 11, 'default' => 0, 'comment' => '更新时间'])
                ->save();
        }
    }
	
4：执行

php think migrate:run
	
最后附官方手册地址：
https://www.kancloud.cn/manual/thinkphp6_0/1118028

[![](https://micuu.com/data/avatar/20211018/ffd980dcf96b252a9bcff408b9d29f75.png)](https://micuu.com/data/avatar/20211018/ffd980dcf96b252a9bcff408b9d29f75.png)

注:原创不易,转载请注明出处( https://micuu.com/new/2251.html )，本站所有资源来源于网络收集，如有侵权请联系QQ245557979进行清除。