src/database/migrations/2018_04_18_193555_add_foreign_keys_to_botan_shortener_table.php 1 location
|
@@ 8-23 (lines=16) @@
|
5 |
|
use Illuminate\Database\Migrations\Migration; |
6 |
|
use Illuminate\Database\Schema\Blueprint; |
7 |
|
|
8 |
|
class AddForeignKeysToBotanShortenerTable extends Migration |
9 |
|
{ |
10 |
|
public function up() |
11 |
|
{ |
12 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'botan_shortener', static function (Blueprint $table) { |
13 |
|
$table->foreign('user_id', config('phptelegrambot.database.prefix', '') . 'botan_shortener_ibfk_1')->references('id')->on(config('phptelegrambot.database.prefix', '') . 'user')->onUpdate('RESTRICT')->onDelete('RESTRICT'); |
14 |
|
}); |
15 |
|
} |
16 |
|
|
17 |
|
public function down() |
18 |
|
{ |
19 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'botan_shortener', static function (Blueprint $table) { |
20 |
|
$table->dropForeign(config('phptelegrambot.database.prefix', '') . 'botan_shortener_ibfk_1'); |
21 |
|
}); |
22 |
|
} |
23 |
|
} |
24 |
|
|
src/database/migrations/2018_04_18_193555_add_foreign_keys_to_chosen_inline_result_table.php 1 location
|
@@ 8-23 (lines=16) @@
|
5 |
|
use Illuminate\Database\Migrations\Migration; |
6 |
|
use Illuminate\Database\Schema\Blueprint; |
7 |
|
|
8 |
|
class AddForeignKeysToChosenInlineResultTable extends Migration |
9 |
|
{ |
10 |
|
public function up() |
11 |
|
{ |
12 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'chosen_inline_result', static function (Blueprint $table) { |
13 |
|
$table->foreign('user_id', config('phptelegrambot.database.prefix', '') . 'chosen_inline_result_ibfk_1')->references('id')->on(config('phptelegrambot.database.prefix', '') . 'user')->onUpdate('RESTRICT')->onDelete('RESTRICT'); |
14 |
|
}); |
15 |
|
} |
16 |
|
|
17 |
|
public function down() |
18 |
|
{ |
19 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'chosen_inline_result', static function (Blueprint $table) { |
20 |
|
$table->dropForeign(config('phptelegrambot.database.prefix', '') . 'chosen_inline_result_ibfk_1'); |
21 |
|
}); |
22 |
|
} |
23 |
|
} |
24 |
|
|
src/database/migrations/2018_04_18_193555_add_foreign_keys_to_inline_query_table.php 1 location
|
@@ 8-23 (lines=16) @@
|
5 |
|
use Illuminate\Database\Migrations\Migration; |
6 |
|
use Illuminate\Database\Schema\Blueprint; |
7 |
|
|
8 |
|
class AddForeignKeysToInlineQueryTable extends Migration |
9 |
|
{ |
10 |
|
public function up() |
11 |
|
{ |
12 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'inline_query', static function (Blueprint $table) { |
13 |
|
$table->foreign('user_id', config('phptelegrambot.database.prefix', '') . 'inline_query_ibfk_1')->references('id')->on(config('phptelegrambot.database.prefix', '') . 'user')->onUpdate('RESTRICT')->onDelete('RESTRICT'); |
14 |
|
}); |
15 |
|
} |
16 |
|
|
17 |
|
public function down() |
18 |
|
{ |
19 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'inline_query', static function (Blueprint $table) { |
20 |
|
$table->dropForeign(config('phptelegrambot.database.prefix', '') . 'inline_query_ibfk_1'); |
21 |
|
}); |
22 |
|
} |
23 |
|
} |
24 |
|
|
src/database/migrations/2020_05_18_123462_add_foreign_keys_to_poll_answer_table.php 1 location
|
@@ 8-23 (lines=16) @@
|
5 |
|
use Illuminate\Database\Migrations\Migration; |
6 |
|
use Illuminate\Database\Schema\Blueprint; |
7 |
|
|
8 |
|
class AddForeignKeysToPollAnswerTable extends Migration |
9 |
|
{ |
10 |
|
public function up() |
11 |
|
{ |
12 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'poll_answer', static function (Blueprint $table) { |
13 |
|
$table->foreign('poll_id', config('phptelegrambot.database.prefix', '') . 'poll_answer_ibfk_1')->references('id')->on(config('phptelegrambot.database.prefix', '') . 'poll')->onUpdate('RESTRICT')->onDelete('RESTRICT'); |
14 |
|
}); |
15 |
|
} |
16 |
|
|
17 |
|
public function down() |
18 |
|
{ |
19 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'poll_answer', static function (Blueprint $table) { |
20 |
|
$table->dropForeign(config('phptelegrambot.database.prefix', '') . 'poll_answer_ibfk_1'); |
21 |
|
}); |
22 |
|
} |
23 |
|
} |
24 |
|
|
src/database/migrations/2020_05_18_123463_add_foreign_keys_to_pre_checkout_query_table.php 1 location
|
@@ 8-23 (lines=16) @@
|
5 |
|
use Illuminate\Database\Migrations\Migration; |
6 |
|
use Illuminate\Database\Schema\Blueprint; |
7 |
|
|
8 |
|
class AddForeignKeysToPreCheckoutQueryTable extends Migration |
9 |
|
{ |
10 |
|
public function up() |
11 |
|
{ |
12 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'pre_checkout_query', static function (Blueprint $table) { |
13 |
|
$table->foreign('user_id', config('phptelegrambot.database.prefix', '') . 'pre_checkout_query_ibfk_1')->references('id')->on(config('phptelegrambot.database.prefix', '') . 'user')->onUpdate('RESTRICT')->onDelete('RESTRICT'); |
14 |
|
}); |
15 |
|
} |
16 |
|
|
17 |
|
public function down() |
18 |
|
{ |
19 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'pre_checkout_query', static function (Blueprint $table) { |
20 |
|
$table->dropForeign(config('phptelegrambot.database.prefix', '') . 'pre_checkout_query_ibfk_1'); |
21 |
|
}); |
22 |
|
} |
23 |
|
} |
24 |
|
|
src/database/migrations/2020_05_18_123464_add_foreign_keys_to_shipping_query_table.php 1 location
|
@@ 8-23 (lines=16) @@
|
5 |
|
use Illuminate\Database\Migrations\Migration; |
6 |
|
use Illuminate\Database\Schema\Blueprint; |
7 |
|
|
8 |
|
class AddForeignKeysToShippingQueryTable extends Migration |
9 |
|
{ |
10 |
|
public function up() |
11 |
|
{ |
12 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'shipping_query', static function (Blueprint $table) { |
13 |
|
$table->foreign('user_id', config('phptelegrambot.database.prefix', '') . 'shipping_query_ibfk_1')->references('id')->on(config('phptelegrambot.database.prefix', '') . 'user')->onUpdate('RESTRICT')->onDelete('RESTRICT'); |
14 |
|
}); |
15 |
|
} |
16 |
|
|
17 |
|
public function down() |
18 |
|
{ |
19 |
|
Schema::table(config('phptelegrambot.database.prefix', '') . 'shipping_query', static function (Blueprint $table) { |
20 |
|
$table->dropForeign(config('phptelegrambot.database.prefix', '') . 'shipping_query_ibfk_1'); |
21 |
|
}); |
22 |
|
} |
23 |
|
} |
24 |
|
|