M240912191622AddPaymentFlowStatusToConfig.php 812 B

123456789101112131415161718192021222324252627282930313233343536373839
  1. <?php
  2. namespace addons\AvoidTax\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M240912191622AddPaymentFlowStatusToConfig
  6. */
  7. class M240912191622AddPaymentFlowStatusToConfig extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. try {
  15. // 插入表数据
  16. $sql = <<<SQL
  17. ALTER TABLE `qimall_addons_tax_config`
  18. ADD COLUMN `payment_flow_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '过流水账户状态' AFTER `type`;
  19. SQL;
  20. $this->execute($sql);
  21. } catch (\Exception $e) {
  22. }
  23. }
  24. /**
  25. * {@inheritdoc}
  26. */
  27. public function safeDown()
  28. {
  29. echo "M240912191622AddPaymentFlowStatusToConfig cannot be reverted.\n";
  30. return false;
  31. }
  32. }