jucai/database/migrations/2018_09_27_033453_create_companys_table.php

<?php

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

class CreateCompanysTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('companys', function (Blueprint $table) {
            $table->increments('id');
            $table->tinyInteger('utype')->default('0')->comment('标志为企业会员')->nullable();
            $table->tinyInteger('email_audit')->default('0')->comment('邮箱认证 1:认证通过 2:认证失败0未认证');
            $table->tinyInteger('mobile_audit')->default('0')->comment('手机认证 1:认证通过 2:认证失败0未认证');
            $table->integer('reg_time')->default('0')->comment('注册时间');
            $table->integer('reg_ip')->default('0')->comment('注册IP');
            $table->string('reg_address')->default('')->comment('注册地址');
            $table->integer('last_login_time')->default('0')->comment('上次登录时间');
            $table->integer('last_login_ip')->default('0')->comment('上次登录IP');
            $table->integer('remind_email_time')->default('0')->comment('下次邮件提醒时间');
            $table->tinyInteger('reg_type')->default('1')->comment('注册方式(1:手机，2:邮箱，3:微信)');
            $table->tinyInteger('reg_source')->default('1')->comment('注册来源 1:网页端 2:手机端 3:微信小程序');
            $table->string('reg_source_cn')->default('网页端')->comment("注册来源 1:网页端 2:手机端 3:微信小程序");
            $table->integer('remind_email_ex_time')->default('1')->comment('已经邮件提醒次数');
            $table->string('tpl')->default('default')->comment('企业模版');
            $table->string('companyname')->unique()->comment('企业名称');
            $table->string('password')->comment('企业用户密码');
            $table->string('old_password')->comment('企业用户旧密码');
            $table->smallInteger('nature')->comment('企业性质编号');
            $table->string('nature_cn')->comment('企业性质');
            $table->smallInteger('trade')->comment('企业行业编号');
            $table->string('trade_cn')->comment('企业行业');
            $table->string('district')->comment('所在地区大类');
            $table->string('district_cn')->comment('所在地区小类');
            $table->smallInteger('scale')->comment('企业规模ID');
            $table->string('scale_cn')->comment('企业规模');
            $table->integer('registered')->comment('注册资金');
            $table->string('currency')->comment('资金类型万人民币/万美元');
            $table->string('address')->comment('企业地址');
            $table->string('contact')->comment('联系人');
            $table->bigInteger('mobile')->comment('联系电话');
            $table->string('landline_tel')->comment('座机');
            $table->string('email')->comment('邮箱');
            $table->string('website')->comment('企业网址');
            $table->string('certificate_img')->comment('营业执照');
            $table->string('logo')->comment('企业logo');
            $table->string('organization_code')->comment('组织机构代码');
            $table->text('contents')->comment('企业介绍');
            $table->smallInteger('setmeal_id')->comment('套餐ID');
            $table->string('setmeal_name')->comment('套餐名称');
            $table->tinyInteger('audit')->default('2')->comment('审核状态：1审核通过，2待审核，3审核未通过');
            $table->tinyInteger('certificate_img_audit')->default('0')->comment('营业执照认证状态：0未认证；1审核通过，2待审核，3审核未通过');
            $table->smallInteger('subsite_id')->comment('分站ID');
            $table->tinyInteger('map_open')->comment('电子地图');
            $table->decimal('map_x')->default('0.000000')->comment('X坐标');
            $table->decimal('map_y')->default('0.000000')->comment('Y坐标');
            $table->tinyInteger('map_zoom')->comment('地图放大级别');
            $table->integer('refresh_time')->comment('刷新时间');
            $table->integer('click')->default('1')->comment('点击量');
            $table->tinyInteger('user_status')->default('1')->comment('用户身份');
            $table->tinyInteger('contact_show')->default('1')->comment('是否显示联系人:1是0否');
            $table->tinyInteger('telephone_show')->default('1')->comment('是否显示联系电话:1是0否');
            $table->tinyInteger('email_show')->default('1')->comment('是否显示email:1是0否');
            $table->tinyInteger('landline_tel_show')->default('1')->comment('是否显示座机:1是0否');
            $table->tinyInteger('robot')->comment('是否为采集信息：0人工1采集');
            $table->integer('comment')->comment('评论数');
            $table->tinyInteger('resume_processing')->default('100')->comment('简历处理率');
            $table->string('tag')->comment('标签');
            $table->tinyInteger('wzp_tpl')->comment('微信招聘模板：0否1是');
            $table->integer('praise')->comment('点赞');
            $table->integer('jobs')->comment('职位');
            $table->integer('replys')->comment('回复');
            $table->integer('sms_num')->comment('短信数');
            $table->string('qq')->comment('qq');
            $table->string('short_name')->comment('企业简称');
            $table->rememberToken();
            $table->timestamps();
            $table->softDeletes();
        });
    }

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