jucai/database/migrations/2018_10_11_150800_create_setmeals_table.php

<?php

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

class CreateSetmealsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('setmeals', function (Blueprint $table) {
            $table->increments('id');
            $table->tinyInteger('display')->default('1')->comment('是否显示(1:显示 0:不显示)');
            $table->tinyInteger('apply')->default('1')->comment('是否显示(1:[月度会员,季度会员,年度会员] 0:免费会员)');
            $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('show_order')->comment('显示顺序');
            $table->integer('set_sms')->comment('赠送短信条数');
            $table->integer('set_points')->comment('赠送积分');
            $table->string('setmeal_img')->comment('套餐图片');
            $table->tinyInteger('show_apply_contact')->default('1')->comment('收到的简历是否可以直接查看联系方式(1:是 0:否)');
            $table->tinyInteger('show_contact_direct')->default('1')->comment('显示联系方式 1:显示 0:不显示');
            $table->tinyInteger('is_free')->default('1')->comment('是否免费(1:是 0;否)');
            $table->double('discount_download_resume')->comment('简历增值包折扣');
            $table->double('discount_sms')->comment('短信增值包折扣');
            $table->double('discount_stick')->comment('职位置顶增值包折扣');
            $table->double('discount_emergency')->comment('职位紧急增值包折扣');
            $table->double('discount_tpl')->comment('企业模板增值包折扣');
            $table->double('discount_auto_refresh_jobs')->comment('职位预约刷新折扣');
            $table->timestamps();
            $table->softDeletes();
        });
    }

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