class Auth_Usuario_Funcao extends Doctrine_Record {

    public function setTableDefinition() {

        $this->setTableName('auth_usuarios_funcoes');

        $this->hasColumn('id', 'integer', null, array('primary', 'sequence' => 'SEQ_AUTH_USUARIOS_FUNCOES'));
        $this->hasColumn('auth_usuario_id', 'integer', null, array(
            'primary' => true));
        $this->hasColumn('auth_funcao_id', 'integer', null, array(
            'primary' => true));

    }

}

class Auth_Usuario extends Doctrine_Record {

    public function setTableDefinition() {
        $this->setTableName('auth_usuarios');

        $this->hasColumn('id', 'integer', null, array('primary', 'sequence' => 'SEQ_AUTH_USUARIOS'));
        $this->hasColumn('usuario', 'string', 150, array(
            'unique' => 'true'
        ));
        $this->hasColumn('senha', 'string', 150);
        $this->hasColumn('estaAtivo', 'integer', 1);
    }

    public function setUp() {
        $this->hasMany('Auth_Funcao as Funcoes', array(
            'local' => 'auth_usuario_id',
            'foreign' => 'auth_funcao_id',
            'refClass' => 'Auth_Usuario_Funcao'
            )
        );
    }

}

class Auth_Funcao extends Doctrine_Record {

    public function setTableDefinition() {

        $this->setTableName('auth_funcoes');

        $this->hasColumn('id', 'integer', null, array('primary', 'sequence' => 'SEQ_AUTH_FUNCOES'));
        $this->hasColumn('nome', 'string', 150);
        $this->hasColumn('descricao', 'string');
        $this->hasColumn('importancia', 'integer', 11);

    }
    public function setUp() {

        $this->hasMany('Auth_Usuario as Usuarios', array(
            'local' => 'auth_funcao_id',
            'foreign' => 'auth_usuario_id',
            'refClass' => 'Auth_Usuario_Funcao'
            )
        )

    }

}