| @@ -6,47 +6,47 @@ | ||
| 6 | 6 | |
| 7 | 7 |  class CreateTournamentTable extends Migration { | 
| 8 | 8 | |
| 9 | - public function up() | |
| 10 | -	{ | |
| 11 | -		Schema::create('tournament', function(Blueprint $table) { | |
| 12 | -			$table->increments('id'); | |
| 9 | + public function up() | |
| 10 | +    { | |
| 11 | +        Schema::create('tournament', function(Blueprint $table) { | |
| 12 | +            $table->increments('id'); | |
| 13 | 13 |              $table->Integer('user_id')->unsigned()->index(); | 
| 14 | -			$table->foreign('user_id') | |
| 15 | -					->references('id') | |
| 16 | -					->on('users') | |
| 17 | -					->onUpdate('cascade') | |
| 18 | -					->onDelete('cascade'); | |
| 14 | +            $table->foreign('user_id') | |
| 15 | +                    ->references('id') | |
| 16 | +                    ->on('users') | |
| 17 | +                    ->onUpdate('cascade') | |
| 18 | +                    ->onDelete('cascade'); | |
| 19 | 19 | |
| 20 | -			$table->string('name'); | |
| 21 | -			$table->string('slug')->default('')->unique(); | |
| 20 | +            $table->string('name'); | |
| 21 | +            $table->string('slug')->default('')->unique(); | |
| 22 | 22 | |
| 23 | -			$table->date('dateIni'); | |
| 24 | -			$table->date('dateFin'); | |
| 23 | +            $table->date('dateIni'); | |
| 24 | +            $table->date('dateFin'); | |
| 25 | 25 |              $table->date('registerDateLimit'); | 
| 26 | 26 |              $table->integer('sport')->unsigned()->default(1); // Default is Kendo for now | 
| 27 | -			$table->string('promoter')->nullable(); | |
| 28 | -			$table->string('host_organization')->nullable(); | |
| 29 | -			$table->string('technical_assistance')->nullable(); | |
| 30 | -			$table->integer('rule_id')->default(1); | |
| 27 | +            $table->string('promoter')->nullable(); | |
| 28 | +            $table->string('host_organization')->nullable(); | |
| 29 | +            $table->string('technical_assistance')->nullable(); | |
| 30 | +            $table->integer('rule_id')->default(1); | |
| 31 | 31 |              $table->tinyInteger('type')->default(1); // 1= local, 2= state, 3= national, 4=continent, 5=world | 
| 32 | 32 |              $table->integer("venue_id")->nullable()->unsigned(); | 
| 33 | -			$table->integer("level_id")->unsigned()->default(1); | |
| 33 | +            $table->integer("level_id")->unsigned()->default(1); | |
| 34 | 34 | |
| 35 | 35 |              $table->foreign('venue_id') | 
| 36 | 36 |                  ->references('id') | 
| 37 | 37 |                  ->on('venue'); | 
| 38 | 38 | |
| 39 | - $table->timestamps(); | |
| 40 | - $table->softDeletes(); | |
| 41 | - $table->engine = 'InnoDB'; | |
| 39 | + $table->timestamps(); | |
| 40 | + $table->softDeletes(); | |
| 41 | + $table->engine = 'InnoDB'; | |
| 42 | 42 | |
| 43 | - }); | |
| 44 | - } | |
| 43 | + }); | |
| 44 | + } | |
| 45 | 45 | |
| 46 | - public function down() | |
| 47 | -	{ | |
| 48 | -		DB::statement('SET FOREIGN_KEY_CHECKS = 0'); | |
| 49 | -		Schema::dropIfExists('tournament'); | |
| 50 | -		DB::statement('SET FOREIGN_KEY_CHECKS = 1'); | |
| 51 | - } | |
| 46 | + public function down() | |
| 47 | +    { | |
| 48 | +        DB::statement('SET FOREIGN_KEY_CHECKS = 0'); | |
| 49 | +        Schema::dropIfExists('tournament'); | |
| 50 | +        DB::statement('SET FOREIGN_KEY_CHECKS = 1'); | |
| 51 | + } | |
| 52 | 52 | } | 
| 53 | 53 | \ No newline at end of file |