M250422093741AlterBossTable.php 934 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. <?php
  2. namespace addons\Boss\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M250422093741AlterBossTable
  6. */
  7. class M250422093741AlterBossTable extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. $sql = <<<SQL
  15. ALTER TABLE `qimall_addons_boss`
  16. ADD COLUMN `is_extra_bonus_alone_limit` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否开启额外分红独立限额',
  17. ADD COLUMN `extra_bonus_limit` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '额外分红独立限额';
  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 "M250422093741AlterBossTable cannot be reverted.\n";
  36. return false;
  37. }
  38. */
  39. }