M230531060314AlterQimallGoodsExtra.php 928 B

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. namespace app\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M230531060314AlterQimallGoodsExtra
  6. */
  7. class M230531060314AlterQimallGoodsExtra extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. try {
  15. $sql="alter table qimall_goods_extra add `is_level` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否享受会员功能 [0=否,1=是]';";
  16. $this->execute($sql);
  17. }catch (\Exception $e){
  18. }
  19. }
  20. /**
  21. * {@inheritdoc}
  22. */
  23. public function safeDown()
  24. {
  25. echo "M230531060314AlterQimallGoodsExtra cannot be reverted.\n";
  26. return false;
  27. }
  28. /*
  29. // Use up()/down() to run migration code without a transaction.
  30. public function up()
  31. {
  32. }
  33. public function down()
  34. {
  35. echo "M230531060314AlterQimallGoodsExtra cannot be reverted.\n";
  36. return false;
  37. }
  38. */
  39. }