1 |
41eaf441
|
Adam Mištera
|
<?php
|
2 |
|
|
|
3 |
|
|
use Illuminate\Database\Migrations\Migration;
|
4 |
|
|
use Illuminate\Database\Schema\Blueprint;
|
5 |
|
|
use Illuminate\Support\Facades\Schema;
|
6 |
|
|
|
7 |
|
|
class CreateArtefactCategoryTable extends Migration
|
8 |
|
|
{
|
9 |
|
|
/**
|
10 |
|
|
* Run the migrations.
|
11 |
|
|
*
|
12 |
|
|
* @return void
|
13 |
|
|
*/
|
14 |
|
|
public function up()
|
15 |
|
|
{
|
16 |
|
|
Schema::create('artefact_category', function (Blueprint $table) {
|
17 |
|
|
$table->unsignedBigInteger('artefact_id');
|
18 |
|
|
$table->unsignedBigInteger('category_id');
|
19 |
|
|
$table->foreign('artefact_id')->references('id')->on('artefacts');
|
20 |
|
|
$table->foreign('category_id')->references('id')->on('categories');
|
21 |
|
|
|
22 |
|
|
});
|
23 |
|
|
}
|
24 |
|
|
|
25 |
|
|
/**
|
26 |
|
|
* Reverse the migrations.
|
27 |
|
|
*
|
28 |
|
|
* @return void
|
29 |
|
|
*/
|
30 |
|
|
public function down()
|
31 |
|
|
{
|
32 |
|
|
Schema::dropIfExists('artefact_category');
|
33 |
|
|
}
|
34 |
|
|
}
|