M240930020929AlterQimallAddonsStoreOrder.php 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. <?php
  2. namespace addons\Store\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M240930020929AlterQimallAddonsStoreOrder
  6. */
  7. class M240930020929AlterQimallAddonsStoreOrder extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. $sql = "
  15. alter table qimall_addons_store_order add create_type int(1) not null default 1 comment'创建方式:1:线上下单;2:系统创建';
  16. alter table qimall_addons_store_order_reserve add service_start_at int(11) not null default 0 comment'服务开始时间';
  17. alter table qimall_addons_store_order_reserve add service_end_at int(11) not null default 0 comment'服务结束时间';
  18. alter table qimall_addons_store_order_reserve add goods_id int(11) not null default 0 comment'商品id';
  19. ";
  20. $this->execute($sql);
  21. }
  22. /**
  23. * {@inheritdoc}
  24. */
  25. public function safeDown()
  26. {
  27. echo "M240930020929AlterQimallAddonsStoreOrder cannot be reverted.\n";
  28. return false;
  29. }
  30. /*
  31. // Use up()/down() to run migration code without a transaction.
  32. public function up()
  33. {
  34. }
  35. public function down()
  36. {
  37. echo "M240930020929AlterQimallAddonsStoreOrder cannot be reverted.\n";
  38. return false;
  39. }
  40. */
  41. }