M240605021754ChangeBusinessCardLngLatField.php 987 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. <?php
  2. namespace addons\BusinessCard\console\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M240605021754ChangeBusinessCardLngLatField
  6. */
  7. class M240605021754ChangeBusinessCardLngLatField extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. $this->execute("ALTER TABLE `qimall_addons_business_card`
  15. CHANGE COLUMN `lat` `lat` DECIMAL(10,7) NOT NULL DEFAULT '0.00' COMMENT '纬度',
  16. CHANGE COLUMN `lng` `lng` DECIMAL(10,7) NOT NULL DEFAULT '0.00' COMMENT '经度' AFTER `lat`;");
  17. }
  18. /**
  19. * {@inheritdoc}
  20. */
  21. public function safeDown()
  22. {
  23. echo "M240605021754ChangeBusinessCardLngLatField cannot be reverted.\n";
  24. return false;
  25. }
  26. /*
  27. // Use up()/down() to run migration code without a transaction.
  28. public function up()
  29. {
  30. }
  31. public function down()
  32. {
  33. echo "M240605021754ChangeBusinessCardLngLatField cannot be reverted.\n";
  34. return false;
  35. }
  36. */
  37. }