M250726074810AlterQimallAddonsStoreGoodsCate.php 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. namespace addons\Store\console\migrations;
  3. use common\enums\RabbitMqEnum;
  4. use Yii;
  5. use yii\db\Migration;
  6. /**
  7. * Class M250726074810AlterQimallAddonsStoreGoodsCate
  8. */
  9. class M250726074810AlterQimallAddonsStoreGoodsCate extends Migration
  10. {
  11. /**
  12. * {@inheritdoc}
  13. */
  14. public function safeUp()
  15. {
  16. $sql = "ALTER TABLE `qimall_addons_store_goods_cate`
  17. ADD COLUMN `level` tinyint(1) NOT NULL DEFAULT 0 COMMENT '分类层级,从0开始';";
  18. $this->execute($sql);
  19. Yii::$app->services->rabbitMq->push(RabbitMqEnum::EXCHANGE_TASK, RabbitMqEnum::TASK_QUEUE, [], \addons\Store\common\models\StoreGoodsCate::class, 'migrateCateLevel');
  20. }
  21. /**
  22. * {@inheritdoc}
  23. */
  24. public function safeDown()
  25. {
  26. echo "M250726074810AlterQimallAddonsStoreGoodsCate cannot be reverted.\n";
  27. return false;
  28. }
  29. /*
  30. // Use up()/down() to run migration code without a transaction.
  31. public function up()
  32. {
  33. }
  34. public function down()
  35. {
  36. echo "M250726074810AlterQimallAddonsStoreGoodsCate cannot be reverted.\n";
  37. return false;
  38. }
  39. */
  40. }