add hs-office-membership test-data

Michael Hoennig

2022-10-17 28bdd9220de5eb92ae254e96f364c43b99133c6a

 src/main/resources/db/changelog/303-hs-office-membership-rbac.sql

@@ -93,7 +93,7 @@
--changeset hs-office-membership-rbac-IDENTITY-VIEW:1 endDelimiter:--//
-- ----------------------------------------------------------------------------
call generateRbacIdentityView('hs_office_membership', idNameExpression => $idName$
    (select idName from hs_office_partner_iv p where p.uuid = target.partnerUuid)
    target.memberNumber || (select idName from hs_office_partner_iv p where p.uuid = target.partnerUuid)
    $idName$);
--//

@@ -102,7 +102,7 @@
--changeset hs-office-membership-rbac-RESTRICTED-VIEW:1 endDelimiter:--//
-- ----------------------------------------------------------------------------
call generateRbacRestrictedView('hs_office_membership',
    orderby => 'target.reference',
    orderby => 'target.memberNumber',
    columnUpdates => $updates$
        validity = new.validity,
        reasonForTermination = new.reasonForTermination