M240417073459RebateAddColumn.php 986 B

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?php
  2. namespace addons\Rebate\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M240417073459RebateAddColumn
  6. */
  7. class M240417073459RebateAddColumn extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. $sql = "ALTER TABLE `qimall_addons_rebate`
  15. ADD COLUMN `repeat_setting` tinyint(2) NULL DEFAULT 0 COMMENT '是否开启触发奖励设置[0=否,1=是]',
  16. ADD COLUMN `agent_limit_num` int(11) NULL DEFAULT 0 COMMENT '渠道分红订单限制';";
  17. $this->execute($sql);
  18. }
  19. /**
  20. * {@inheritdoc}
  21. */
  22. public function safeDown()
  23. {
  24. echo "M240417073459RebateAddColumn cannot be reverted.\n";
  25. return false;
  26. }
  27. /*
  28. // Use up()/down() to run migration code without a transaction.
  29. public function up()
  30. {
  31. }
  32. public function down()
  33. {
  34. echo "M240417073459RebateAddColumn cannot be reverted.\n";
  35. return false;
  36. }
  37. */
  38. }