@@ -12,7 +12,7 @@ discard block |
||
12 | 12 | */ |
13 | 13 | public function up() |
14 | 14 | { |
15 | - Schema::table('settings_system', function (Blueprint $table) { |
|
15 | + Schema::table('settings_system', function(Blueprint $table) { |
|
16 | 16 | $table->foreign('time_zone', 'settings_system_ibfk_1')->references('id')->on('timezone')->onUpdate('NO ACTION')->onDelete('RESTRICT'); |
17 | 17 | $table->foreign('time_farmat', 'settings_system_ibfk_2')->references('id')->on('time_format')->onUpdate('NO ACTION')->onDelete('RESTRICT'); |
18 | 18 | $table->foreign('date_format', 'settings_system_ibfk_3')->references('id')->on('date_format')->onUpdate('NO ACTION')->onDelete('RESTRICT'); |
@@ -27,7 +27,7 @@ discard block |
||
27 | 27 | */ |
28 | 28 | public function down() |
29 | 29 | { |
30 | - Schema::table('settings_system', function (Blueprint $table) { |
|
30 | + Schema::table('settings_system', function(Blueprint $table) { |
|
31 | 31 | $table->dropForeign('settings_system_ibfk_1'); |
32 | 32 | $table->dropForeign('settings_system_ibfk_2'); |
33 | 33 | $table->dropForeign('settings_system_ibfk_3'); |
@@ -12,7 +12,7 @@ |
||
12 | 12 | */ |
13 | 13 | public function up() |
14 | 14 | { |
15 | - Schema::create('tickets', function (Blueprint $table) { |
|
15 | + Schema::create('tickets', function(Blueprint $table) { |
|
16 | 16 | $table->increments('id'); |
17 | 17 | $table->string('ticket_number'); |
18 | 18 | $table->integer('user_id')->unsigned()->nullable()->index('user_id'); |
@@ -12,7 +12,7 @@ |
||
12 | 12 | */ |
13 | 13 | public function up() |
14 | 14 | { |
15 | - Schema::create('password_resets', function (Blueprint $table) { |
|
15 | + Schema::create('password_resets', function(Blueprint $table) { |
|
16 | 16 | $table->string('email')->index(); |
17 | 17 | $table->string('token')->index(); |
18 | 18 | $table->dateTime('created_at')->default('0000-00-00 00:00:00'); |
@@ -12,14 +12,14 @@ discard block |
||
12 | 12 | */ |
13 | 13 | public function up() |
14 | 14 | { |
15 | - Schema::create('workflow_action', function (Blueprint $table) { |
|
15 | + Schema::create('workflow_action', function(Blueprint $table) { |
|
16 | 16 | $table->increments('id'); |
17 | 17 | $table->integer('workflow_id')->unsigned(); |
18 | 18 | $table->string('condition'); |
19 | 19 | $table->string('action'); |
20 | 20 | $table->timestamps(); |
21 | 21 | }); |
22 | - Schema::table('workflow_action', function (Blueprint $table) { |
|
22 | + Schema::table('workflow_action', function(Blueprint $table) { |
|
23 | 23 | $table->foreign('workflow_id', 'workflow_action_1')->references('id')->on('workflow_name')->onUpdate('NO ACTION')->onDelete('RESTRICT'); |
24 | 24 | }); |
25 | 25 | } |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | public function down() |
33 | 33 | { |
34 | 34 | Schema::drop('workflow_action'); |
35 | - Schema::table('workflow_action', function (Blueprint $table) { |
|
35 | + Schema::table('workflow_action', function(Blueprint $table) { |
|
36 | 36 | $table->dropForeign('workflow_action_idfk_1'); |
37 | 37 | }); |
38 | 38 | } |
@@ -12,7 +12,7 @@ discard block |
||
12 | 12 | */ |
13 | 13 | public function up() |
14 | 14 | { |
15 | - Schema::table('ticket_thread', function (Blueprint $table) { |
|
15 | + Schema::table('ticket_thread', function(Blueprint $table) { |
|
16 | 16 | $table->foreign('ticket_id', 'ticket_thread_ibfk_1')->references('id')->on('tickets')->onUpdate('NO ACTION')->onDelete('RESTRICT'); |
17 | 17 | $table->foreign('user_id', 'ticket_thread_ibfk_2')->references('id')->on('users')->onUpdate('NO ACTION')->onDelete('RESTRICT'); |
18 | 18 | $table->foreign('source', 'ticket_thread_ibfk_3')->references('id')->on('ticket_source')->onUpdate('NO ACTION')->onDelete('RESTRICT'); |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | */ |
27 | 27 | public function down() |
28 | 28 | { |
29 | - Schema::table('ticket_thread', function (Blueprint $table) { |
|
29 | + Schema::table('ticket_thread', function(Blueprint $table) { |
|
30 | 30 | $table->dropForeign('ticket_thread_ibfk_1'); |
31 | 31 | $table->dropForeign('ticket_thread_ibfk_2'); |
32 | 32 | $table->dropForeign('ticket_thread_ibfk_3'); |
@@ -12,7 +12,7 @@ |
||
12 | 12 | */ |
13 | 13 | public function up() |
14 | 14 | { |
15 | - Schema::create('api_settings', function (Blueprint $table) { |
|
15 | + Schema::create('api_settings', function(Blueprint $table) { |
|
16 | 16 | $table->increments('id'); |
17 | 17 | $table->string('key'); |
18 | 18 | $table->string('value'); |
@@ -12,7 +12,7 @@ |
||
12 | 12 | */ |
13 | 13 | public function up() |
14 | 14 | { |
15 | - Schema::create('template_types', function (Blueprint $table) { |
|
15 | + Schema::create('template_types', function(Blueprint $table) { |
|
16 | 16 | $table->increments('id'); |
17 | 17 | $table->string('name'); |
18 | 18 | $table->timestamps(); |
@@ -12,7 +12,7 @@ |
||
12 | 12 | */ |
13 | 13 | public function up() |
14 | 14 | { |
15 | - Schema::create('kb_article_relationship', function (Blueprint $table) { |
|
15 | + Schema::create('kb_article_relationship', function(Blueprint $table) { |
|
16 | 16 | $table->increments('id'); |
17 | 17 | $table->integer('article_id')->unsigned()->index('article_relationship_article_id_foreign'); |
18 | 18 | $table->integer('category_id')->unsigned()->index('article_relationship_category_id_foreign'); |
@@ -12,7 +12,7 @@ |
||
12 | 12 | */ |
13 | 13 | public function up() |
14 | 14 | { |
15 | - Schema::create('ratings', function (Blueprint $table) { |
|
15 | + Schema::create('ratings', function(Blueprint $table) { |
|
16 | 16 | $table->increments('id'); |
17 | 17 | $table->string('name'); |
18 | 18 | $table->integer('display_order'); |