<?php

use Phalcon\Mvc\Model\Migration;

class UserDinkesMigration_339  extends Migration
{
    public function up()
    {
        $this->down();

        self::$connection->execute("
            INSERT INTO jaga.users_roles (user_id, role_id)
                SELECT user_id, role_id FROM (SELECT user_id, (SELECT id FROM roles WHERE name = 'pengguna') AS role_id FROM users_roles WHERE role_id = (SELECT id FROM roles WHERE name = 'keluhan_covid_dinkes')) AS usdinkes WHERE user_id NOT IN (SELECT user_id FROM users_roles WHERE role_id = (SELECT id FROM roles WHERE name = 'pengguna'))
            ON CONFLICT DO NOTHING;
       ");
    }

    public function down()
    {

    }
}