M241009102932AlterTableCloudStockLevel.php 826 B

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. <?php
  2. namespace addons\CloudStock\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M241009102932AlterTableCloudStockLevel
  6. */
  7. class M241009102932AlterTableCloudStockLevel extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. try {
  15. $sql = <<<EOF
  16. ALTER TABLE `qimall_addons_cloud_stock_level`
  17. ADD COLUMN `upgrade_type_goods` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启购买商品升级',
  18. ADD COLUMN `upgrade_goods_list` text NULL COMMENT '商品升级条件';
  19. EOF;
  20. $this->execute($sql);
  21. } catch (\Exception $e) {
  22. }
  23. }
  24. /**
  25. * {@inheritdoc}
  26. */
  27. public function safeDown()
  28. {
  29. echo "M241009102932AlterTableCloudStockLevel cannot be reverted.\n";
  30. return false;
  31. }
  32. }