source: database/migrations/2019_10_25_180617_create_phases_table.php@ f457265

Last change on this file since f457265 was d25ba66, checked in by Özkan İliyaz <iliyaz_96@…>, 4 years ago

ADD post confirmation with multiple phases, notification after succesfully password creation

  • Property mode set to 100644
File size: 1.0 KB
Line 
1<?php
2
3use Illuminate\Support\Facades\Schema;
4use Illuminate\Database\Schema\Blueprint;
5use Illuminate\Database\Migrations\Migration;
6
7class CreatePhasesTable extends Migration
8{
9 /**
10 * Run the migrations.
11 *
12 * @return void
13 */
14 public function up()
15 {
16 Schema::create('phases', function (Blueprint $table) {
17 $table->increments('id');
18 $table->string('name')->unique();
19 $table->unsignedInteger('reviewer_role_id');
20 $table->unsignedInteger('user_id');
21
22 $table->foreign("reviewer_role_id")
23 ->references("id")
24 ->on("roles")
25 ->onDelete("cascade");
26
27 $table->foreign("user_id")
28 ->references("id")
29 ->on("users")
30 ->onDelete("cascade");
31
32 $table->timestamps();
33 });
34 }
35
36 /**
37 * Reverse the migrations.
38 *
39 * @return void
40 */
41 public function down()
42 {
43 Schema::dropIfExists('phases');
44 }
45}
Note: See TracBrowser for help on using the repository browser.