@@ -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 |