1: <?php
2:
3: use Illuminate\Database\Migrations\Migration;
4: use Illuminate\Database\Schema\Blueprint;
5: use Illuminate\Database\Capsule\Manager as Capsule;
6:
7: class AlterUserBlocksTableAddUseridColumn extends Migration
8: {
9: /**
10: * Run the migrations.
11: *
12: * @return void
13: */
14: public function up()
15: {
16: $prefix = Capsule::connection()->getTablePrefix();
17: Capsule::statement("ALTER TABLE {$prefix}core_user_blocks ADD UserId int(11) default 0");
18: }
19:
20: /**
21: * Reverse the migrations.
22: *
23: * @return void
24: */
25: public function down()
26: {
27: $prefix = Capsule::connection()->getTablePrefix();
28: Capsule::statement("ALTER TABLE {$prefix}core_user_blocks DROP COLUMN UserId");
29: }
30: }
31: