/home/mip/mip/database/migrations/client/2017_08_23_011705_create_posts_table.php
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreatePostsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('posts', function (Blueprint $table) {
$table->increments('id');
$table->mediumInteger('author_id')->unsigned();
$table->mediumInteger('posts_category_id')->unsigned()->nullable();
$table->string('title');
$table->longText('content');
$table->string('featured_image');
$table->text('excerpt');
$table->string('slug');
$table->enum('status', ['Publish', 'Draft', 'Inactive']);
$table->enum('visibility', ['Public', 'Private']);
$table->enum('post_type', ['Post', 'Page']);
$table->integer('post_parent_id')->nullable()->unsigned();
$table->date('published_at');
$table->date('expired_at')->nullable();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('posts');
}
}