2026_10_28_130000_add_activity_click_position.php 650 B

12345678910111213141516171819
  1. <?php
  2. use Illuminate\Database\Migrations\Migration;
  3. use Illuminate\Database\Schema\Blueprint;
  4. use Illuminate\Support\Facades\DB;
  5. use Illuminate\Support\Facades\Schema;
  6. return new class extends Migration {
  7. public function up(): void
  8. {
  9. Schema::table('activity_rewards', function (Blueprint $t) { $t->string('click_position', 16)->nullable(); });
  10. DB::table('activity_rewards')->whereIn('click_type', ['external', 'internal'])->update(['click_position' => 'cover']);
  11. }
  12. public function down(): void
  13. {
  14. Schema::table('activity_rewards', function (Blueprint $t) { $t->dropColumn('click_position'); });
  15. }
  16. };