下面由Laravel框架教程欄目給大家介紹laravel 創建數據表,希望對需要的朋友有所幫助!
雖然可以直接在數據庫中創建數據表,但是不便于以后項目的遷移。現使用命令行結合代碼的方式來進行生成。
php artisan make:migration create_table_customers
<?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('customers', function (Blueprint $table) { $table->increments('id'); $table->string('mobile')->nullable()->unique(); $table->string('email')->unique(); $table->string('website')->default('website')->comment('站點:applet、website'); $table->string('store_id')->default('1')->comment('店鋪 ID'); $table->string('first_name'); $table->string('last_name'); $table->integer('appellation')->comment('稱謂'); $table->dateTime('birthday')->comment('生日'); $table->string('province')->comment('省'); $table->string('city')->comment('市'); $table->string('district')->comment('區/縣'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('customers'); } }
php artisan migrate
此時,數據表已經生成!
聲明:本網頁內容旨在傳播知識,若有侵權等問題請及時與本網聯系,我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com