M250113093458AlterCommissionItemSettingDetail.php 814 B

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. namespace addons\DoubleCopy\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M250113093458AlterCommissionItemSettingDetail
  6. */
  7. class M250113093458AlterCommissionItemSettingDetail extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. try {
  15. $sql = <<<SQL
  16. ALTER TABLE `qimall_addons_double_copy_commission_item_setting_detail`
  17. CHANGE COLUMN `allowance_prize` `allowance_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '津贴奖' AFTER `equal_level_prize`;
  18. SQL;
  19. $this->execute($sql);
  20. } catch (\Exception $e) {
  21. }
  22. }
  23. /**
  24. * {@inheritdoc}
  25. */
  26. public function safeDown()
  27. {
  28. echo "M250113093458AlterCommissionItemSettingDetail cannot be reverted.\n";
  29. return false;
  30. }
  31. }