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