Laravel 迁移设置与实现

Laravel .env 文件预览

1LOG_CHANNEL=stack
2LOG_DEPRECATIONS_CHANNEL=null
3LOG_LEVEL=debug
4
5DB_CONNECTION=mysql
6DB_HOST=127.0.0.1
7DB_PORT=3306
8DB_DATABASE=laravel
9DB_USERNAME=root
10DB_PASSWORD=
11                        ............................

创建 contacts 表的迁移文件

1php artisan make:migration create_contacts_table

实现迁移约束

1Schema::create('contacts', function (Blueprint $table) {
2    $table->id();
3    $table->string('phoneNumber', 64)->unique();
4    $table->text('details')->nullable();
5    $table->timestamps();
6});

回滚数据库迁移

1php artisan migrate:rollback

回滚最近三个步骤

1php artisan migrate:rollback --step=3

定义外键迁移

1Schema::table('contacts_info', function (Blueprint $table) {
2    $table->id();
3    $table->unsignedBigInteger('contact_id');
4    $table->foreign('contact_id')->references('id')->on('contacts')->onUpdate('cascade')->onDelete('cascade');
5});