1
|
<?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->integer('artefact_id')->unsigned();;
|
18
|
$table->integer('catagory_id')->unsigned();;
|
19
|
$table->foreign('artefact_id')->references('id')->on('artefacts');
|
20
|
$table->foreign('category_id')->references('id')->on('categories');
|
21
|
});
|
22
|
}
|
23
|
|
24
|
/**
|
25
|
* Reverse the migrations.
|
26
|
*
|
27
|
* @return void
|
28
|
*/
|
29
|
public function down()
|
30
|
{
|
31
|
Schema::dropIfExists('artefact_category');
|
32
|
}
|
33
|
}
|