laravel5.6 migrate操作

桃扇骨 2023-03-06 05:23 14阅读 0赞

## 一.创建表 ##

1.执行命令：sudo php artisan make:migration create\_tableName\_table  
执行完后会在 migrations 文件夹下面生成一个文件  
![在这里插入图片描述][20200805160904849.png]

2.在 up 方法中添加或者修改你需要的字段  
![在这里插入图片描述][20200805162133524.png]

3.执行命令： php artisan migrate  
![在这里插入图片描述][20200805162143660.png]  
打开Navicat查看，表已创建成功  
![在这里插入图片描述][20200805162202737.png]

<?php
    
    use Illuminate\Support\Facades\Schema;
    use Illuminate\Database\Schema\Blueprint;
    use Illuminate\Database\Migrations\Migration;
    use Illuminate\Support\Facades\DB;
    
    class CreateOperationCenterAdminTable extends Migration
    { 
    
        /** * User: clj * Date: 20-8-26 * Time: 下午2:26 * Run the migrations. * @return void */
    
        public function up()
        { 
            Schema::create('operation_center_admin', function (Blueprint $table) { 
                $table->increments('id')->comment("主索引");
                $table->string("username","20")->comment("用户名");
                $table->string("truename","20")->comment("真实姓名");
                $table->char("phone",'11')->nullable()->comment("手机号");
                $table->char("password","32")->comment("密码");
                $table->char("salt" ,"32")->comment("加密盐值");
                $table->string("token","255")->nullable()->comment("token");
                $table->integer("organize_id",false,false)->comment("组织ID");
                $table->integer("roler_id",false,false)->comment("角色ID");
                $table->integer("department_id",false,false)->comment("部门ID");
                $table->string("position")->nullable()->comment("职位");
                $table->tinyInteger("is_admin",false,false)->default("-1")->comment("是否是管理员 1:是　-1:不是");
                $table->tinyInteger('status',false,false)->default("-1")->comment("状态 1:正常　-1:禁用");
                $table->string("ip");
                $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
                $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'));
            });
        }
    
        /** * Reverse the migrations. * * @return void */
        public function down()
        { 
            Schema::dropIfExists('operation_center_admin');
        }
    }

报错:  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzcxMzQ5OA_size_16_color_FFFFFF_t_70_pic_center]  
删除ekee\_broker\_scheme表再次运行

![在这里插入图片描述][20200826143821539.png_pic_center]

Schema::create('operation_center_permission', function (Blueprint $table) { 
                $table->increments('id')->comment("主索引");
                $table->string('module',50)->comment("模块");
                $table->string("module_name",150)->nullable()->comment("模块名");
                $table->string("route",255)->unique()->comment("路由");
                $table->string("route_desc",255)->nullable()->comment("路由描述");
                $table->tinyInteger("type",false,false)->comment("0接口 1前端页面");
                $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
                $table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'));
            });

## 二.表里添加字段 ##

1.执行命令：php artisan make:migration alter\_表名\_table --table=表名

2.在 up 方法中添加或者修改你需要的字段  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzcxMzQ5OA_size_16_color_FFFFFF_t_70]  
3.执行命令： php artisan migrate

在laravel迁移中，我们一般知道把一个字段设置为空，可以通过

$table->column->nullable();

那么，把一个空字段改成非空字段呢，

$table->column->nullable(false);  
![在这里插入图片描述][20200811170557876.png]

[20200805160904849.png]: /images/20230208/afa9b8b33a0f4f368591e737cb416c91.png
[20200805162133524.png]: /images/20230208/c6efa35d3a5d430587d74f921bb403a8.png
[20200805162143660.png]: /images/20230208/73a6e910279346e7bae8c57ead79547d.png
[20200805162202737.png]: /images/20230208/0a67348117784de8b3e5a378967484f4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzcxMzQ5OA_size_16_color_FFFFFF_t_70_pic_center]: /images/20230208/cf46776bf4374e48a55371142a9e9377.png
[20200826143821539.png_pic_center]: /images/20230208/f16d3fd4dee74e969773e11322ade3b1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzcxMzQ5OA_size_16_color_FFFFFF_t_70]: /images/20230208/6997009595314dd09aa4a6a652df67d9.png
[20200811170557876.png]: /images/20230208/dd5ca4be705b45e3976e91d1d97132d2.png