| 12345678910111213141516171819 |
- <?php
- use Illuminate\Database\Migrations\Migration;
- use Illuminate\Database\Schema\Blueprint;
- use Illuminate\Support\Facades\DB;
- use Illuminate\Support\Facades\Schema;
- return new class extends Migration {
- public function up(): void
- {
- Schema::table('activity_rewards', function (Blueprint $t) { $t->string('click_position', 16)->nullable(); });
- DB::table('activity_rewards')->whereIn('click_type', ['external', 'internal'])->update(['click_position' => 'cover']);
- }
- public function down(): void
- {
- Schema::table('activity_rewards', function (Blueprint $t) { $t->dropColumn('click_position'); });
- }
- };
|