Completed
Push — task/file-cleanup ( 35de75...35de75 )
by Grant
07:58 queued 03:00
created

AddForeignKeysToWorkplacePhotoCaptionsTable   A

Complexity

Total Complexity 2

Size/Duplication

Total Lines 28
Duplicated Lines 0 %

Importance

Changes 0
Metric Value
eloc 7
dl 0
loc 28
rs 10
c 0
b 0
f 0
wmc 2
1
<?php
2
3
use Illuminate\Database\Migrations\Migration;
4
use Illuminate\Database\Schema\Blueprint;
5
6
class AddForeignKeysToWorkplacePhotoCaptionsTable extends Migration {
7
8
	/**
9
	 * Run the migrations.
10
	 *
11
	 * @return void
12
	 */
13
	public function up()
14
	{
15
		Schema::table('workplace_photo_captions', function(Blueprint $table)
16
		{
17
			$table->foreign('work_environment_id')->references('id')->on('work_environments')->onUpdate('CASCADE')->onDelete('CASCADE');
18
			$table->foreign('workplace_photo_id')->references('id')->on('workplace_photos')->onUpdate('CASCADE')->onDelete('NO ACTION');
19
		});
20
	}
21
22
23
	/**
24
	 * Reverse the migrations.
25
	 *
26
	 * @return void
27
	 */
28
	public function down()
29
	{
30
		Schema::table('workplace_photo_captions', function(Blueprint $table)
31
		{
32
			$table->dropForeign('workplace_photo_captions_work_environment_id_foreign');
33
			$table->dropForeign('workplace_photo_captions_workplace_photo_id_foreign');
34
		});
35
	}
36
37
}
38