M230203028220UpdateQimallMenu.php 700 B

12345678910111213141516171819202122232425262728293031323334353637
  1. <?php
  2. namespace app\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M230203028220UpdateQimallMenu
  6. */
  7. class M230203028220UpdateQimallMenu extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. try {
  15. $sql = <<<SQL
  16. ALTER TABLE `qimall_order_refund`
  17. MODIFY COLUMN `saler_address` TEXT NULL COMMENT '买家收货地址(json存储)';
  18. SQL;
  19. $this->execute($sql);
  20. } catch (\Exception $e) {
  21. }
  22. }
  23. /**
  24. * {@inheritdoc}
  25. */
  26. public function safeDown()
  27. {
  28. echo "M230203028220UpdateQimallMenu cannot be reverted.\n";
  29. return false;
  30. }
  31. }