yajra / cms-core

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreateTagsTable extends Migration {

	public function up()

	{

		Schema::create('tagging_tags', function(Blueprint $table) {

			$table->increments('id');

			$table->string('slug', 255)->index();

			$table->string('name', 255);

			$table->boolean('suggest')->default(false);

			$table->integer('count')->unsigned()->default(0); // count of how many times this tag was used

		});

	}

	public function down()

	{

		Schema::drop('tagging_tags');

	}

}

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreateFileAssetsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('file_assets', function (Blueprint $table) {

            $table->increments('id');

            $table->string('name')->index();

            $table->string('type', 20)->index();

            $table->string('category', 20)->index();

            $table->string('url', 512);

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('file_assets');

    }

}

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class UpdateTagsTable extends Migration

{

    public function up()

    {

        Schema::table('tagging_tags', function (Blueprint $table) {

            $table->integer('tag_group_id')->unsigned()->nullable()->after('id');

            $table->foreign('tag_group_id', 'tag_group_id_foreign')->references('id')->on('tagging_tag_groups');

        });

    }

    public function down()

    {

        Schema::table('tagging_tags', function ($table) {

            $table->dropForeign('tag_group_id_foreign');

            $table->dropColumn('tag_group_id');

        });

    }

}