<?php

use Phalcon\Mvc\Model\Migration;

class InsertRoleAdminPancekBCMigration_567 extends Migration {
    public function up()
    {
        self::$connection->execute("
            INSERT INTO jaga.roles (name, label, description) VALUES ('admin_kppbc_pancek', 'Admin KPPBC Pancek', 'Admin KPPBC Pancek');
            INSERT INTO jaga.scopes (name, label, description) VALUES ('pancek.kppbc.admin', 'Manajemen KPPBC Pancek', 'Manajemen KPPBC Pancek');
            INSERT INTO jaga.roles_scopes (role_id, scope_id) VALUES ((SELECT id FROM jaga.roles WHERE name = 'admin_kppbc_pancek'), (SELECT id FROM jaga.scopes WHERE name = 'pancek.kppbc.admin'));
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DELETE FROM jaga.roles_scopes WHERE role_id = (SELECT id FROM jaga.roles WHERE name = 'admin_kppbc_pancek') AND scope_id = (SELECT id FROM jaga.scopes WHERE name = 'pancek.kppbc.admin');
            DELETE FROM jaga.roles WHERE name = 'admin_kppbc_pancek';
            DELETE FROM jaga.scopes WHERE name = 'pancek.kppbc.admin';
        ");
    }
}