@@ 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'); |
|
@@ 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 | Schema::create('people', function (Blueprint $table) { |
|
98 | $table->increments('id'); |
|
@@ 102-110 (lines=9) @@ | ||
99 | $table->timestamps(); |
|
100 | }); |
|
101 | ||
102 | Schema::create('person_translations', function (Blueprint $table) { |
|
103 | $table->increments('id'); |
|
104 | $table->integer('person_id')->unsigned(); |
|
105 | $table->string('name'); |
|
106 | $table->string('locale')->index(); |
|
107 | ||
108 | $table->unique(['person_id', 'locale']); |
|
109 | $table->foreign('person_id')->references('id')->on('people')->onDelete('cascade'); |
|
110 | }); |
|
111 | } |
|
112 | ||
113 | /** |