M240206115509AddUserReportMenu.php 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. <?php
  2. namespace app\migrations;
  3. use yii\db\Migration;
  4. /**
  5. * Class M240206115509AddUserReportMenu
  6. */
  7. class M240206115509AddUserReportMenu extends Migration
  8. {
  9. /**
  10. * {@inheritdoc}
  11. */
  12. public function safeUp()
  13. {
  14. try {
  15. $sql = "
  16. INSERT INTO `qimall_menu` (
  17. `title`, `app_id`, `cate_id`, `addons_name`, `is_addon`, `pid`, `url`, `icon`, `level`, `dev`, `sort`, `params`, `tree`, `status`, `created_at`, `updated_at`
  18. )
  19. VALUES (
  20. '举报列表', 'backend', 2, '', 0, 34, 'mall/user-report/list', '', 2, 1, 999, NULL, 'tr_0 tr_34', 1, 1682058236, 1682058236
  21. )";
  22. $this->execute($sql);
  23. } catch (\Exception $e) {
  24. }
  25. }
  26. /**
  27. * {@inheritdoc}
  28. */
  29. public function safeDown()
  30. {
  31. echo "M240206115509AddUserReportMenu cannot be reverted.\n";
  32. return false;
  33. }
  34. /*
  35. // Use up()/down() to run migration code without a transaction.
  36. public function up()
  37. {
  38. }
  39. public function down()
  40. {
  41. echo "M240206115509AddUserReportMenu cannot be reverted.\n";
  42. return false;
  43. }
  44. */
  45. }