2024012300-remove_user_invite_num.php 562 B

1234567891011121314151617181920212223242526
  1. <?php
  2. declare(strict_types=1);
  3. use App\Interfaces\MigrationInterface;
  4. use App\Services\DB;
  5. return new class() implements MigrationInterface {
  6. public function up(): int
  7. {
  8. DB::getPdo()->exec('
  9. ALTER TABLE user DROP COLUMN IF EXISTS `invite_num`;
  10. ');
  11. return 2024012300;
  12. }
  13. public function down(): int
  14. {
  15. DB::getPdo()->exec("
  16. ALTER TABLE user ADD COLUMN IF NOT EXISTS `invite_num` int(11) NOT NULL DEFAULT 0 COMMENT '可用邀请次数';
  17. ");
  18. return 2024012000;
  19. }
  20. };