diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrations/6.2.4_step5675_running_processes_widget.php | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/db/migrations/6.2.4_step5675_running_processes_widget.php b/db/migrations/6.2.4_step5675_running_processes_widget.php new file mode 100644 index 0000000..a68dcb8 --- /dev/null +++ b/db/migrations/6.2.4_step5675_running_processes_widget.php @@ -0,0 +1,16 @@ +<?php + +class Step5675RunningProcessesWidget extends Migration +{ + protected function up() + { + $pos = DBManager::get()->fetchColumn("SELECT MAX(navigationpos) + 1 FROM plugins WHERE plugintype = 'PortalPlugin'"); + $sql = "INSERT INTO plugins (pluginclassname, pluginname, plugintype, enabled, navigationpos) VALUES (?)"; + DBManager::get()->execute($sql, [['RunningProcessesWidget', 'RunningProcessesWidget', 'PortalPlugin', 'yes', $pos]]); + + $sql = "INSERT INTO roles_plugins (roleid, pluginid) + SELECT roleid, ? FROM roles WHERE `system` = 'y' AND rolename != 'Nobody'"; + DBManager::get()->execute($sql, [DBManager::get()->lastInsertId()]); + } + +} |
