Command:
|
1 |
php artisan make:migration create_user_table --create=user |
Migration Class:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
<?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateChildAccountTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('member_child', function (Blueprint $table) { $table->increments('id'); $table->integer('parent_id')->comment('主帳號ID'); $table->tinyInteger('type'); $table->string('username', 30); $table->string('child', 20); $table->string('password', 20); $table->string('name', 50); $table->longText('description'); $table->tinyInteger('permission')->comment('1:view, 2:inherit'); $table->tinyInteger('enabled')->comment('狀態 ( 1: 啟用 2:停用)'); $table->integer('login_count')->nullable(); $table->dateTime('login_time')->nullable(); $table->string('ip', 30)->nullable(); $table->string('location', 100)->nullable(); $table->decimal('fee', 10, 2)->nullable()->comment('手續費'); $table->dateTime('created_time'); $table->dateTime('updated_time')->nullable(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('member_child'); } } |