<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;


//To execute:
// php artisan  migrate --path=app/database/migrations/api-project

class CreateContestOptionsTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
        $connections = array_keys(Config::get('database.connections'));

        foreach($connections as $connection) {
            Schema::connection($connection)->create('contest_options', function(Blueprint $table)
            {
                $table->increments('id');
                $table->string('option_key')->unique();
                $table->string('option_value');
                $table->string('option_description')->nullable();
            });
        }

	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
        $connections = array_keys(Config::get('database.connections'));

        foreach($connections as $connection) {
            Schema::connection($connection)->drop('contest_options');
        }
	}

}