jucai/database/migrations/2018_10_12_130855_create_members_setmeals_table.php

<?php

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

class CreateMembersSetmealsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('members_setmeals', function (Blueprint $table) {
            $table->increments('id');
            $table->tinyInteger('expire')->default('0')->comment('套餐是否到期 1:到期 0:没到期');
            $table->integer('uid')->comment('会员uid');
            $table->tinyInteger('utype')->default('1')->comment('会员类型1、企业、2个人');
            $table->integer('setmeal_id')->comment('套餐id');
            $table->string('setmeal_name')->comment('套餐名称');
            $table->integer('days')->comment('套餐时长');
            $table->integer('expense')->comment('套餐价格');
            $table->integer('jobs_meanwhile')->comment('可发布职位数');
            $table->integer('refresh_jobs_free')->comment('每天免费刷新职位数');
            $table->integer('download_resume')->comment('简历下载数');
            $table->integer('download_resume_max')->comment('每天可下载简历最大数');
            $table->integer('jobfair_num')->comment('招聘会场次');
            $table->string('added')->comment('附赠说明');
            $table->integer('starttime')->comment('开始时间');
            $table->integer('endtime')->comment('结束时间');
            $table->string('setmeal_img')->comment('套餐图标');
            $table->tinyInteger('show_apply_contact')->default('1')->comment('收到的简历是否免费查看 0:不免费 1:免费');
            $table->tinyInteger('is_free')->default('1')->comment('是否免费会员 0:不免费 1:免费');
            $table->double('discount_download_resume')->comment('简历包折扣');
            $table->double('discount_sms')->comment('短信包折扣');
            $table->double('discount_jobs')->comment('职位包折扣');
            $table->double('discount_jobfair')->comment('招聘会包折扣');
            $table->double('discount_stick')->comment('职位置顶折扣');
            $table->double('discount_emergency')->comment('职位紧急折扣');
            $table->double('discount_tpl')->comment('企业模板折扣');
            $table->double('discount_auto_refresh_jobs')->comment('职位预约刷新折扣');
            $table->tinyInteger('show_contact_direct')->default('1')->comment('显示联系方式 1:显示 0:不显示');
            $table->timestamps();
            $table->softDeletes();
        });
    }

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