M250402063847Optimize1529.php 940 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. <?php
  2. namespace addons\Rebate\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M250402063847Optimize1529
  6. */
  7. class M250402063847Optimize1529 extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. $sql = <<<SQL
  15. ALTER TABLE `qimall_addons_rebate`
  16. ADD COLUMN `is_reward_after_n` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否开启第N人后开始才可以获得奖励 0否 1是',
  17. ADD COLUMN `reward_threshold` smallint UNSIGNED NOT NULL DEFAULT 0 COMMENT '具体配置的第N人之后';
  18. SQL;
  19. $this->execute($sql);
  20. }
  21. /**
  22. * {@inheritdoc}
  23. */
  24. public function safeDown()
  25. {
  26. return false;
  27. }
  28. /*
  29. // Use up()/down() to run migration code without a transaction.
  30. public function up()
  31. {
  32. }
  33. public function down()
  34. {
  35. echo "M250402063847Optimize1529 cannot be reverted.\n";
  36. return false;
  37. }
  38. */
  39. }