1
|
<?php
|
2
|
|
3
|
use Illuminate\Database\Migrations\Migration;
|
4
|
use Illuminate\Database\Schema\Blueprint;
|
5
|
use Illuminate\Support\Facades\Schema;
|
6
|
|
7
|
class CreateArtefactsTable extends Migration
|
8
|
{
|
9
|
/**
|
10
|
* Run the migrations.
|
11
|
*
|
12
|
* @return void
|
13
|
*/
|
14
|
public function up()
|
15
|
{
|
16
|
Schema::create('artefacts', function (Blueprint $table) {
|
17
|
$table->id();
|
18
|
$table->string('name');
|
19
|
$table->string('author');
|
20
|
$table->string('made_in');
|
21
|
$table->string('publisher');
|
22
|
$table->integer('year');
|
23
|
$table->integer('pages');
|
24
|
//$table->integer('likes');
|
25
|
|
26
|
$table->integer('main_category_id')->unsigned();
|
27
|
$table->foreign('main_category_id')->references('id')->on('categories');
|
28
|
});
|
29
|
}
|
30
|
|
31
|
/**
|
32
|
* Reverse the migrations.
|
33
|
*
|
34
|
* @return void
|
35
|
*/
|
36
|
public function down()
|
37
|
{
|
38
|
Schema::dropIfExists('artefacts');
|
39
|
}
|
40
|
}
|