M230329024430InsertToQimallTown.php 943 B

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. namespace app\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M230329024430InsertToQimallTown
  6. */
  7. class M230329024430InsertToQimallTown extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. try {
  15. $sql = "
  16. INSERT INTO `qimall_town`( `district_id`, `adcode`, `name`, `created_at`, `updated_at`) VALUES ( 1013, 331102, '南明山街道', 1594556513, 1594556513);
  17. ";
  18. $this->execute($sql);
  19. } catch (\Exception $e) {
  20. }
  21. }
  22. /**
  23. * {@inheritdoc}
  24. */
  25. public function safeDown()
  26. {
  27. echo "M230329024430InsertToQimallTown 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 "M230329024430InsertToQimallTown cannot be reverted.\n";
  38. return false;
  39. }
  40. */
  41. }