<?php

use Phalcon\Mvc\Model\Migration;

class RolesScopesMigration_180 extends Migration
{
    public function up()
    {
        $this->batchInsert('scopes', [
            'id',
            'name',
            'label',
            'description'
        ]);

        $this->batchInsert('roles_scopes', [
            'role_id',
            'scope_id'
        ]);

        self::$connection->execute("SELECT setval('scopes_id_seq', (SELECT MAX(id) FROM scopes));");
        self::$connection->execute("SELECT setval('roles_scopes_id_seq', (SELECT MAX(id) FROM roles_scopes));");
    }

    public function down()
    { }
}