aboutsummaryrefslogtreecommitdiff
path: root/db/migrations/1.54_step_00161_plugin_admin.php
blob: d6b0145e849f9f4cec2c5708ab00ec2b874e97c9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?php
class Step00161PluginAdmin extends Migration
{
    function description()
    {
        return 'remove plugin admin and role admin plugin';
    }

    function up()
    {
        $db = DBManager::get();

        $db->exec("DELETE FROM plugins WHERE pluginid IN (1, 3)");
        $db->exec("DELETE FROM plugins_activated WHERE pluginid IN (1, 3)");
        $db->exec("DELETE FROM roles_plugins WHERE pluginid IN (1, 3)");

        $db->exec("ALTER TABLE plugins DROP plugindesc");
    }

    function down()
    {
        $db = DBManager::get();

        $db->exec("ALTER TABLE plugins ADD plugindesc varchar(45) NOT NULL default '' AFTER pluginname");

        $db->exec("INSERT INTO plugins
                    (pluginid, pluginclassname, pluginpath, pluginname, plugintype, enabled, navigationpos, dependentonid)
                   VALUES
                    (1, 'PluginAdministrationPlugin', 'core', 'Plugin-Administration', 'AdministrationPlugin', 'yes', 0, NULL),
                    (3, 'RoleManagementPlugin', 'core', 'RollenManagement', 'AdministrationPlugin', 'yes', 1, 1)");

        $db->exec("INSERT INTO roles_plugins (roleid, pluginid) VALUES (1, 1), (1, 3)");
    }
}
?>