M220906062938AlterIsOpenScreenColumnToQimallAddonsCoupon.php 1.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. <?php
  2. namespace addons\Coupon\console\migrations;
  3. use yii\db\Exception;
  4. use yii\db\Migration;
  5. /**
  6. * Class M220906062938AlterIsOpenScreenColumnToQimallAddonsCoupon
  7. */
  8. class M220906062938AlterIsOpenScreenColumnToQimallAddonsCoupon extends Migration
  9. {
  10. /**
  11. * {@inheritdoc}
  12. */
  13. public function safeUp()
  14. {
  15. try {
  16. $this->execute("alter table qimall_addons_coupon add `is_open_screen` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否开屏显示';");
  17. }catch (\Exception $e){
  18. var_dump($e->getMessage());
  19. }
  20. }
  21. /**
  22. * {@inheritdoc}
  23. */
  24. public function safeDown()
  25. {
  26. echo "M220906062938AlterIsOpenScreenColumnToQimallAddonsCoupon 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 "M220906062938AlterIsOpenScreenColumnToQimallAddonsCoupon cannot be reverted.\n";
  37. return false;
  38. }
  39. */
  40. }