Laravel5.4 使用 migrate 创建数据表

Laravel有个建议，建议文章表名以名词+复数的形式，外键以名词+下划+id的形式。

创建表名：arts

外键：art_id

时间：created_at/updated_at

Laravel 提供了 migration，数据库迁移。

Usage:

make:migration [options] [--] <name>

Arguments:

name The name of the migration.

Options:

--create[=CREATE] The table to be created.

--table[=TABLE] The table to migrate.

--path[=PATH] The location where the migration file should be created.

-h, --help Display this help message

-q, --quiet Do not output any message

-V, --version Display this application version

--ansi Force ANSI output

--no-ansi Disable ANSI output

-n, --no-interaction Do not ask any interactive question

--env[=ENV] The environment the command should run under

-v|vv|vvv, --verbose Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug

Help:

Create a new migration file

创建表：

laravel 默认已经有两个migration

php artisan make:migration create_art_table

这样就会在 database\migrations下创建 2019_08_31_173421_create_arts_table.php文件，我们打开

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
class CreateArtsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up() //migration要执行的行数
    {
        
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down() //migration要执行的行数
    {
       
    }
}

执行： 使用migrations的

php artisan migrate

回滚使用的是：

migrate：rollback

创建表：修改文件并保存

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateArtsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('arts', function (Blueprint $table) {
            $table->increments('id');
            $table->string('title',100)->default("");
            $table->text('content');
            $table->integer('arts_id')->default("0");
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('arts');
    }
}

执行命令:

php artisan migrate

可以看到创建了4张表