NN2021040101/database/migrations/2019_07_08_141029_create_love_users_table.php

<?php

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

class CreateLoveUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('love_users', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->bigInteger('lid')->unique()->index()->comment('靓号');
            $table->binary('name')->comment('名');
            $table->string('avatar')->nullable()->comment('头像');
            $table->bigInteger('tel')->unique()->index()->comment('电话');
            $table->tinyInteger('sex')->default(1)->index()->comment('1男2女');
            $table->tinyInteger('age')->default(0)->index()->comment('年龄');
            $table->unsignedTinyInteger('vip')->default(0)->comment('1是vip0不是');
            $table->unsignedTinyInteger('height')->default(0)->index()->comment('身高');
            $table->tinyInteger('income')->default(0)->comment('收入');
            $table->integer('pcode')->default(0)->index()->comment('省代号');
            $table->integer('citycode')->default(0)->index()->comment('城市代号');
            $table->string('pname',20)->default('')->comment('省');
            $table->string('city',20)->default('')->comment('市');
            $table->string('adname',30)->default('')->comment('区');
            $table->decimal('lat',10,6)->default(0.00)->comment('Latitude');
            $table->decimal('lng',10,6)->default(0.00)->comment('Longitude');
            $table->string('requirement',40)->nullable()->default('')->comment('征友条件');
            $table->tinyInteger('marriage')->default(0)->comment('婚姻情况0未婚1离3丧');
            $table->tinyInteger('type')->default(0)->index()->comment('0普通1红娘');
            $table->tinyInteger('status')->default(2)->index()->comment('1在线2PushOnline3离线');
            $table->tinyInteger('opt')->default(0)->comment('0浏览中1相亲2专属4语音相亲中3交友5七人相亲6七人交友');
            $table->tinyInteger('trump')->default(0)->comment('0普同1王牌红娘');
            $table->string('think',140)->nullable()->comment('交友心声音');
            $table->string('wechat',40)->nullable()->comment('微信号');
            $table->string('openid',40)->nullable()->comment('微信openid');
            $table->string('occupation',40)->nullable()->default('')->comment('职业');
            $table->tinyInteger('education')->default(0)->comment('住房1初中以下2高专院3大专4本科5硕士以上');
            $table->tinyInteger('house')->default(0)->comment('住房1已购2与父母3租4其他');
            $table->tinyInteger('blood')->default(0)->comment('血型1a2b3c4ab');
            $table->tinyInteger('place')->default(0)->comment('是否婚后和父母住1可以2不愿意，3看情况');
            $table->tinyInteger('cohabitation')->default(0)->comment('是否婚后前同居');
            $table->integer('vip_time')->default(0)->comment('vip有效期');
            $table->integer('rose')->default(0)->comment('玫瑰数');
            $table->bigInteger('keep_to_uid')->default(0)->comment('我守护了谁');
            $table->bigInteger('keep_from_uid')->default(0)->comment('谁守护了我');
            $table->tinyInteger('charm')->default(0)->comment('魅力部位');
            $table->string('realname',8)->nullable()->comment('真名');
            $table->string('idcard')->nullable()->default('')->comment('身份证号');
            $table->string('like_tag')->nullable()->comment('喜欢的类型');
            $table->string('tag')->nullable()->default('')->comment('标签');
            $table->bigInteger('tuid')->default(0)->comment('推荐用户id');
            $table->integer('channel')->default(0)->comment('渠道');
            $table->integer('ban')->default(0)->comment('禁止');
            $table->timestamps();
            $table->comment = '用户表';
        });
    }

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