| 12345678910111213141516171819202122232425262728293031323334353637383940 |
- <?php
- use Illuminate\Database\Schema\Blueprint;
- use Illuminate\Database\Migrations\Migration;
- /**
- * Class CreateAlbumsTable.
- */
- class CreateAlbumsTable extends Migration
- {
- /**
- * Run the migrations.
- *
- * @return void
- */
- public function up()
- {
- Schema::create('albums', function(Blueprint $table) {
- $table->increments('id');
- $table->integer('m_id')->default(0)->index('m_id')->comment('会员ID');
- $table->string('file_url')->comment('文件地址');
- $table->string('cover_url')->comment('文件封面');
- $table->string('time')->comment('视频文件时长');
- $table->tinyInteger('file_type')->index('file_type')->comment('文件类型 1:照片,2:视频');
- $table->tinyInteger('status')->default(0)->index('status')->comment('文件状态 0:待审,1:过审,2:人工审核中,3:审核不通过');
- $table->tinyInteger('is_del')->default(0)->index('is_del')->comment('是否删除 0:否,1:是');
- $table->timestamps();
- });
- }
- /**
- * Reverse the migrations.
- *
- * @return void
- */
- public function down()
- {
- Schema::drop('albums');
- }
- }
|