/** * Run the migrations. * * @return void */ public function up() { Schema::create('users', function (Blueprint $table) { $table->increments('id')->comment('用户ID'); $table->string('mobile', 20)->index('mobile')->nullable()->comment('手机号'); $table->string('email', 100)->index('email')->nullable()->comment('邮箱'); $table->string('password', 64)->nullable()->comment('密码'); $table->enum('status', Status::getValues())->default(Status::ENABLE)->comment('状态'); // timestamp fields $table->timestamps(); }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('post_categories', function (Blueprint $table) { $table->smallIncrements('id')->comment('类别ID'); $table->string('name', 20)->comment('名称'); $table->unsignedSmallInteger('parent_id')->nullable()->comment('父类ID'); $table->unsignedSmallInteger('count_sub_categories')->comment('子类个数'); $table->enum('status', Status::getValues())->default(Status::ENABLE)->comment('状态'); // timestamp fields $table->timestamps(); // foreign key $table->foreign('parent_id')->references('id')->on('post_categories'); }); // }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('comments', function (Blueprint $table) { $table->increments('id')->comment('评论ID'); $table->unsignedInteger('user_id')->comment('评论的用户ID'); $table->unsignedInteger('post_id')->comment('所评论的信息ID'); $table->unsignedInteger('parent_id')->nullable()->comment('父评论ID'); $table->text('content')->comment('评论内容'); $table->enum('status', Status::getValues())->default(Status::ENABLE)->comment('状态'); // timestamp fields $table->timestamps(); // foreign key $table->foreign('user_id')->references('id')->on('users'); $table->foreign('post_id')->references('id')->on('posts'); $table->foreign('parent_id')->references('id')->on('comments'); }); // }
/** * Run the migrations. * * @return void */ public function up() { Schema::create('posts', function (Blueprint $table) { $table->increments('id')->comment('帖子id'); $table->unsignedSmallInteger('post_category_id')->index('post_category_id')->comment('分类ID'); $table->unsignedInteger('user_id')->comment('信息发布者用户 ID'); $table->text('content')->nullable()->comment('信息内容'); $table->unsignedInteger('count_images')->default(0)->comment('包含图片数量'); $table->unsignedInteger('count_views')->default(0)->comment('阅读次数'); $table->unsignedInteger('count_comments')->default(0)->comment('评论次数'); // 小数点后6位 精确到4米 $table->decimal('lng', 20, 6)->default(0.0)->index('lng')->comment('经度'); $table->decimal('lat', 20, 6)->default(0.0)->index('lat')->comment('维度'); $table->enum('status', Status::getValues())->default(Status::ENABLE)->comment('状态'); $table->boolean('deleted')->default(false)->comment('删除状态'); // timestamp fields $table->timestamps(); // foreign key $table->foreign('user_id')->references('id')->on('users'); $table->foreign('post_category_id')->references('id')->on('post_categories'); }); // }