<?php
/**
 * ------------------------ 
 *  版权所有  www.tecmz.com
 *  商业版本请购买正版授权使用
 * ------------------------
*/ use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateMemberVip extends Migration { public function up() { Schema::table('member_user', function (Blueprint $hTN3M) { $hTN3M->integer('vipId')->nullable()->comment(''); $hTN3M->date('vipExpire')->nullable()->comment(''); }); Schema::create('member_vip_set', function (Blueprint $hTN3M) { $hTN3M->increments('id'); $hTN3M->timestamps(); $hTN3M->string('title', 50)->nullable()->comment('名称'); $hTN3M->string('flag', 50)->nullable()->comment('标识'); $hTN3M->integer('pid')->nullable()->comment('排序'); $hTN3M->integer('sort')->nullable()->comment('排序'); $hTN3M->tinyInteger('isDefault')->nullable()->comment('默认'); $hTN3M->string('icon', 100)->nullable()->comment('图标'); $hTN3M->decimal('price', 20, 2)->nullable()->comment(''); $hTN3M->integer('vipDays')->nullable()->comment(''); $hTN3M->text('content')->nullable()->comment('说明'); }); } public function down() { } }