faithgen / app-build

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreateBuildsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

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

            $table->string('ministry_id', 150)->index();

            $table->string('version');

            $table->enum('status', Build::BUILD_STATUS)->default('building');

            $table->timestamps();

            $table->foreign('ministry_id')->references('id')->on('fg_ministries')->onDelete('cascade');

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('fg_app_builds');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreateBuildLogsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

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

            $table->string('build_id', 150)->index();

            $table->string('task');

            $table->text('result');

            $table->boolean('success');

            $table->timestamps();

            $table->foreign('build_id')->references('id')->on('fg_app_builds')->onDelete('cascade');

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('fg_build_logs');

    }

}