123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- <?php
- use Illuminate\Support\Facades\Schema;
- use Illuminate\Database\Schema\Blueprint;
- use Illuminate\Database\Migrations\Migration;
- class CreateTableFeed extends Migration
- {
- /**
- * Run the migrations.
- *
- * @return void
- */
- public function up()
- {
- Schema::create('feed', function (Blueprint $table) {
- $table->bigIncrements('id');
- $table->integer('uid')
- ->index('uid')
- ->comment('uid');
- $table->integer('follow_uid')
- ->comment('关注人uid');
- $table->string('follow_username')
- ->default('')
- ->comment('关注人昵称');
- $table->string('follow_avatar')
- ->default('')
- ->comment('关注人头像');
- $table->string('type', 32)
- ->default('post_create')
- ->comment('类型');
- $table->integer('relate_id')
- ->default(0)
- ->comment('相关id');
- $table->string('content', 1000)
- ->default('')
- ->comment('内容');
- $table->timestamps();
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::dropIfExists('feed');
- }
- }
|