Laravel creates a data table (using the command line combined with code)

                                                                                                                                                   

The following is the Laravelframework tutorial column to introduce laravel to create a data table. I hope it will be helpful to friends in need!

Although you can create data tables directly in the database, it is not convenient for future project migration. Now use the command line combined with code to generate it.

1. Create the data table file through the command

php artisan make:migration create_table_customers

2. In the data table Complete the relevant fields of the data table in the file

<?php

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

class CreateTableCustomers extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create(&#39;customers&#39;, function (Blueprint $table) {
            $table->increments(&#39;id&#39;);
            $table->string(&#39;mobile&#39;)->nullable()->unique();
            $table->string(&#39;email&#39;)->unique();
            $table->string(&#39;website&#39;)->default(&#39;website&#39;)->comment(&#39;站点：applet、website&#39;);
            $table->string(&#39;store_id&#39;)->default(&#39;1&#39;)->comment(&#39;店铺 ID&#39;);
            $table->string(&#39;first_name&#39;);
            $table->string(&#39;last_name&#39;);
            $table->integer(&#39;appellation&#39;)->comment(&#39;称谓&#39;);
            $table->dateTime(&#39;birthday&#39;)->comment(&#39;生日&#39;);
            $table->string(&#39;province&#39;)->comment(&#39;省&#39;);
            $table->string(&#39;city&#39;)->comment(&#39;市&#39;);
            $table->string(&#39;district&#39;)->comment(&#39;区/县&#39;);
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists(&#39;customers&#39;);
    }
}

3. Generate the data table

php artisan migrate

At this point, the data table has been generated!                                                                                                                

The above is the detailed content of Laravel creates a data table (using the command line combined with code). For more information, please follow other related articles on the PHP Chinese website!