M230807172326InsertQimallTown.php 1.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. <?php
  2. namespace app\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M230807172326InsertQimallTown
  6. */
  7. class M230807172326InsertQimallTown extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. $sql = "INSERT INTO `qimall_town`(`id`, `district_id`, `adcode`, `name`, `created_at`, `updated_at`) VALUES
  15. (38994, 2381, 511026, '桂花井镇', 1594555186, 1594555186),
  16. (38995, 2381, 511026, '胡家镇', 1594555186, 1594555186),
  17. (38996, 2381, 511026, '黄家镇', 1594555186, 1594555186),
  18. (38997, 2381, 511026, '界市镇', 1594555186, 1594555186),
  19. (38998, 2381, 511026, '金鹅街道', 1594555186, 1594555186),
  20. (38999, 2381, 511026, '李市镇', 1594555186, 1594555186),
  21. (39000, 2381, 511026, '龙市镇', 1594555186, 1594555186),
  22. (39001, 2381, 511026, '普润镇', 1594555186, 1594555186),
  23. (39002, 2381, 511026, '山川镇', 1594555186, 1594555186),
  24. (39003, 2381, 511026, '圣灯镇', 1594555186, 1594555186),
  25. (39004, 2381, 511026, '石碾镇', 1594555186, 1594555186),
  26. (39005, 2381, 511026, '石燕桥镇', 1594555186, 1594555186),
  27. (39006, 2381, 511026, '双凤镇', 1594555186, 1594555186),
  28. (39007, 2381, 511026, '响石镇', 1594555186, 1594555186),
  29. (39008, 2381, 511026, '迎祥镇', 1594555186, 1594555186),
  30. (39009, 2381, 511026, '渔箭镇', 1594555186, 1594555186),
  31. (39010, 2381, 511026, '云顶镇', 1594555186, 1594555186),
  32. (39011, 2381, 511026, '周兴镇', 1594555186, 1594555186);";
  33. $this->execute($sql);
  34. }
  35. /**
  36. * {@inheritdoc}
  37. */
  38. public function safeDown()
  39. {
  40. echo "M230807172326InsertQimallTown cannot be reverted.\n";
  41. return false;
  42. }
  43. /*
  44. // Use up()/down() to run migration code without a transaction.
  45. public function up()
  46. {
  47. }
  48. public function down()
  49. {
  50. echo "M230807172326InsertQimallTown cannot be reverted.\n";
  51. return false;
  52. }
  53. */
  54. }