<?php

use Phalcon\Mvc\Model\Migration;

class ActivityScopesMigration_274 extends Migration
{

    public function up()
    {
        self::$connection->execute("
            INSERT INTO jaga.scopes (name, label, description)
                VALUES ('activity.user', 'Melihat dan modifikasi data aktivitas sendiri', 'Melihat dan modifikasi data aktivitas sendiri') ON CONFLICT DO NOTHING;

            INSERT INTO jaga.scopes (name, label, description)
                VALUES ('activity.admin', 'Melihat dan modifikasi semua data aktivitas', 'Melihat dan modifikasi semua data aktivitas') ON CONFLICT DO NOTHING;

            INSERT INTO jaga.roles_scopes (role_id, scope_id)
                SELECT r.id, s.id
                FROM jaga.roles r
                JOIN jaga.scopes s ON r.name = 'pengguna' and s.name = 'activity.user' ON CONFLICT DO NOTHING;

            INSERT INTO jaga.roles_scopes (role_id, scope_id)
                SELECT r.id, s.id
                FROM jaga.roles r
                JOIN jaga.scopes s ON r.name = 'admin_sistem' and s.name = 'activity.admin' ON CONFLICT DO NOTHING;
        ");
    }

    /**
     * Reverse the migrations
     *
     * @return void
     */
    public function down()
    {
    }
}