tp6数据迁移

历史老师-

已于 2023-05-06 16:20:06 修改

阅读量164

点赞数

分类专栏： ThinkPHP框架文章标签：数据库 java mysql

于 2023-05-06 16:19:26 首次发布

原文链接：https://blog.csdn.net/hrf368246980/article/details/124684820

版权

ThinkPHP框架专栏收录该内容

9 篇文章 0 订阅

订阅专栏


    public function up()
    {
        // create the table
        $table  =  $this->table('student',['id' => false, 'engine'=>'InnoDB', 'charset'=>'utf8','primary_key'=>['uid']])->setComment('学生表');
        $table->addColumn(Column::unsignedInteger('uid')->setNull(false)->setIdentity('uid')->setComment('用户id'))
            ->addColumn(Column::string('mobile', 20)->setNull(false)->setDefault('')->setComment('昵称'))
            ->addColumn(Column::tinyInteger('sex')->setNull(false)->setDefault(0)->setComment('性别：0保密 1男 2女'))
            ->addColumn(Column::char('sex_cn', 10)->setNull(false)->setDefault('保密')->setComment('性别'))
            ->addColumn(Column::integer('city_id')->setNull(false)->setDefault(0)->setComment('城市id'))
            ->addColumn(Column::smallInteger('grade_id')->setNull(false)->setDefault(0)->setComment('年级id'))
            ->addColumn(Column::tinyInteger('subject_id')->setNull(false)->setDefault(0)->setComment('科目id'))
            ->addColumn(Column::smallInteger('class')->setNull(false)->setDefault(0)->setComment('班级id'))
            ->addColumn(Column::decimal('balance', 10, 2)->setNull(false)->setDefault(0)->setComment('余额'))
            ->addColumn(Column::dateTime('created_at')->setNull(false)->setComment('创建时间'))
            ->addIndex(['mobile', 'delete_time'], ['unique' => true, 'name'=>'unique_mobile_time'])
            ->addIndex(['grade_id', 'subject_id'], ['name'=>'grade_subject_id'])
            ->addIndex(['city_id'], ['name'=>'index_city_id'])
            ->create();
    }