source: database/migrations/2019_10_25_180620_create_post_securities_table.php

Last change on this file 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: 852 bytes
Line 
1<?php
2
3use Illuminate\Support\Facades\Schema;
4use Illuminate\Database\Schema\Blueprint;
5use Illuminate\Database\Migrations\Migration;
6
7class CreatePostSecuritiesTable extends Migration
8{
9 /**
10 * Run the migrations.
11 *
12 * @return void
13 */
14 public function up()
15 {
16 Schema::create('post_securities', function (Blueprint $table) {
17 $table->bigIncrements('id');
18 $table->unsignedInteger('role_id');
19 $table->string('phase_ids');
20
21 $table->foreign("role_id")
22 ->references("id")
23 ->on("roles")
24 ->onDelete("cascade");
25
26 $table->timestamps();
27 });
28 }
29
30 /**
31 * Reverse the migrations.
32 *
33 * @return void
34 */
35 public function down()
36 {
37 Schema::dropIfExists('post_securities');
38 }
39}
Note: See TracBrowser for help on using the repository browser.