M250115085317AlterQimallAddonsDoubleCopyLevelSetting.php 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. <?php
  2. namespace addons\DoubleCopy\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M250115085317AlterQimallAddonsDoubleCopyLevelSetting
  6. */
  7. class M250115085317AlterQimallAddonsDoubleCopyLevelSetting extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. $sql = "ALTER TABLE `qimall_addons_double_copy_level_setting`
  15. ADD COLUMN `is_thaw` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否勾选额外解冻条件',
  16. ADD COLUMN `first_level` int(11) COMMENT '额外解冻条件-直推1、2号位需满足等级条件 ',
  17. ADD COLUMN `push_num` int(11) NOT NULL DEFAULT 0 COMMENT '额外解冻条件-直推个数',
  18. ADD COLUMN `second_level` int(11) COMMENT '额外解冻条件-直推用户满足等级条件';";
  19. $this->execute($sql);
  20. }
  21. /**
  22. * {@inheritdoc}
  23. */
  24. public function safeDown()
  25. {
  26. echo "M250115085317AlterQimallAddonsDoubleCopyLevelSetting cannot be reverted.\n";
  27. return false;
  28. }
  29. /*
  30. // Use up()/down() to run migration code without a transaction.
  31. public function up()
  32. {
  33. }
  34. public function down()
  35. {
  36. echo "M250115085317AlterQimallAddonsDoubleCopyLevelSetting cannot be reverted.\n";
  37. return false;
  38. }
  39. */
  40. }