M240801060712AlterQimallOrder.php 864 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. <?php
  2. namespace app\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M240801060712AlterQimallOrder
  6. */
  7. class M240801060712AlterQimallOrder extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. $sql = "ALTER TABLE `qimall_order`
  15. MODIFY COLUMN `coupon_money` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '优惠券券支付金额' AFTER `coupon_id`;";
  16. $this->execute($sql);
  17. }
  18. /**
  19. * {@inheritdoc}
  20. */
  21. public function safeDown()
  22. {
  23. echo "M240801060712AlterQimallOrder cannot be reverted.\n";
  24. return false;
  25. }
  26. /*
  27. // Use up()/down() to run migration code without a transaction.
  28. public function up()
  29. {
  30. }
  31. public function down()
  32. {
  33. echo "M240801060712AlterQimallOrder cannot be reverted.\n";
  34. return false;
  35. }
  36. */
  37. }