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: | |
11: | |
12: | |
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: | |
22: | |
23: | |
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: | |