Passed
Push — master ( 2c3721...94fb22 )
by Grant
09:10 queued 10s
created

CreateApplicantProfileQuestionTranslationsTable   A

Complexity

Total Complexity 2

Size/Duplication

Total Lines 31
Duplicated Lines 0 %

Importance

Changes 0
Metric Value
wmc 2
eloc 10
dl 0
loc 31
rs 10
c 0
b 0
f 0
1
<?php
2
3
use Illuminate\Database\Migrations\Migration;
4
use Illuminate\Database\Schema\Blueprint;
5
6
class CreateApplicantProfileQuestionTranslationsTable extends Migration {
7
8
	/**
9
	 * Run the migrations.
10
	 *
11
	 * @return void
12
	 */
13
	public function up()
14
	{
15
		Schema::create('applicant_profile_question_translations', function(Blueprint $table)
16
		{
17
			$table->increments('id');
18
			$table->integer('applicant_profile_question_id')->unsigned()->index('applicant_profile_question_trans_applicant_profile_question_idx'); //Custom index name because exceeds length limit
19
			$table->string('locale');
20
			$table->text('value');
21
			$table->text('description');
22
			$table->timestamps();
23
                        
24
            $table->unique(['applicant_profile_question_id','locale'], 'app_profile_ques_trans_app_profile_question_id_locale_unique');
25
		});
26
	}
27
28
29
	/**
30
	 * Reverse the migrations.
31
	 *
32
	 * @return void
33
	 */
34
	public function down()
35
	{
36
		Schema::drop('applicant_profile_question_translations');
37
	}
38
39
}
40