M240703014009AlterQimallAddonsStoreCoupon.php 1.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. <?php
  2. namespace addons\Store\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M240703014009AlterQimallAddonsStoreCoupon
  6. */
  7. class M240703014009AlterQimallAddonsStoreCoupon extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. $sql = "ALTER TABLE `qimall_addons_store_coupon` MODIFY COLUMN `type` tinyint(1) NOT NULL DEFAULT '2' COMMENT '优惠券类型,1:折扣,2:满减,3:兑换', ADD COLUMN `exchange_voucher_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '兑换券类型,0-抵扣,1-部分抵扣';";
  15. $this->execute($sql);
  16. }
  17. /**
  18. * {@inheritdoc}
  19. */
  20. public function safeDown()
  21. {
  22. echo "M240703014009AlterQimallAddonsStoreCoupon cannot be reverted.\n";
  23. return false;
  24. }
  25. /*
  26. // Use up()/down() to run migration code without a transaction.
  27. public function up()
  28. {
  29. }
  30. public function down()
  31. {
  32. echo "M240703014009AlterQimallAddonsStoreCoupon cannot be reverted.\n";
  33. return false;
  34. }
  35. */
  36. }