2019_11_12_114222_create_posts_table.php 1.34 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
<?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()
    {
Bagus Pambudi committed
16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
        Schema::create('swp_posts', function (Blueprint $table) {
            $table->string('id', 36)->primary();
            $table->string('title');
            $table->text('content')->nullable();
            $table->string('categories', 36)->nullable();
            $table->string('thumbnail')->nullable();
            $table->timestamp('post_date')->nullable();
            $table->boolean('post_status')->nullable();
            $table->boolean('cover_status')->nullable();
            $table->string('posts_password')->nullable();
            $table->boolean('comment_status')->nullable();
            $table->integer('viewer')->nullable();
            $table->integer('comment_count')->nullable();
            $table->string('slug')->nullable();
            $table->string('userid_created', 36)->nullable();
            $table->string('userid_updated', 36)->nullable();
            $table->timestamps();
        });
34 35 36 37 38 39 40 41 42 43 44 45
    }

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