@@ 20-28 (lines=9) @@ | ||
17 | $table->softDeletes(); |
|
18 | }); |
|
19 | ||
20 | Schema::create('country_translations', function (Blueprint $table) { |
|
21 | $table->increments('id'); |
|
22 | $table->integer('country_id')->unsigned(); |
|
23 | $table->string('name'); |
|
24 | $table->string('locale')->index(); |
|
25 | ||
26 | $table->unique(['country_id', 'locale']); |
|
27 | $table->foreign('country_id')->references('id')->on('countries')->onDelete('cascade'); |
|
28 | }); |
|
29 | ||
30 | Schema::create('cities', function (Blueprint $table) { |
|
31 | $table->increments('id'); |
|
@@ 38-46 (lines=9) @@ | ||
35 | $table->foreign('country_id')->references('id')->on('countries'); |
|
36 | }); |
|
37 | ||
38 | Schema::create('city_translations', function (Blueprint $table) { |
|
39 | $table->increments('id'); |
|
40 | $table->integer('city_id')->unsigned(); |
|
41 | $table->string('name'); |
|
42 | $table->string('locale')->index(); |
|
43 | ||
44 | $table->unique(['city_id', 'locale']); |
|
45 | $table->foreign('city_id')->references('id')->on('cities')->onDelete('cascade'); |
|
46 | }); |
|
47 | ||
48 | Schema::create('companies', function (Blueprint $table) { |
|
49 | $table->increments('id'); |
|
@@ 64-72 (lines=9) @@ | ||
61 | $table->timestamps(); |
|
62 | }); |
|
63 | ||
64 | Schema::create('food_translations', function (Blueprint $table) { |
|
65 | $table->increments('id'); |
|
66 | $table->integer('food_id')->unsigned(); |
|
67 | $table->string('name'); |
|
68 | $table->string('locale')->index(); |
|
69 | ||
70 | $table->unique(['food_id', 'locale']); |
|
71 | $table->foreign('food_id')->references('id')->on('foods')->onDelete('cascade'); |
|
72 | }); |
|
73 | ||
74 | Schema::create('continent_translations', function (Blueprint $table) { |
|
75 | $table->increments('id'); |
|
@@ 87-95 (lines=9) @@ | ||
84 | $table->timestamps(); |
|
85 | }); |
|
86 | ||
87 | Schema::create('vegetable_translations', function (Blueprint $table) { |
|
88 | $table->increments('id'); |
|
89 | $table->integer('vegetable_identity')->unsigned(); |
|
90 | $table->string('name'); |
|
91 | $table->string('locale')->index(); |
|
92 | ||
93 | $table->unique(['vegetable_identity', 'locale']); |
|
94 | $table->foreign('vegetable_identity')->references('identity')->on('vegetables')->onDelete('cascade'); |
|
95 | }); |
|
96 | } |
|
97 | ||
98 | /** |