Allon Mureinik has submitted this change and it was merged. Change subject: db: create domains_with_unregistered_entities_view ...................................................................... db: create domains_with_unregistered_entities_view A few view creation scripts use the same sub queries. Thus moving the common code to create a view makes more sense. Change-Id: I0adc14a3ac084b1ec1705327c0a78c4e2c14ef79 Related-To: https://bugzilla.redhat.com/1247144 Signed-off-by: Idan Shaby <ishaby(a)redhat.com&gt; --- M packaging/dbscripts/create_views.sql 1 file changed, 22 insertions(+), 24 deletions(-) Approvals: Jenkins CI: Passed CI tests Allon Mureinik: Looks good to me, approved Idan Shaby: Verified -- To view, visit https://gerrit.ovirt.org/44149 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I0adc14a3ac084b1ec1705327c0a78c4e2c14ef79 Gerrit-PatchSet: 4 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Idan Shaby <ishaby(a)redhat.com&gt; Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com&gt; Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Idan Shaby <ishaby(a)redhat.com&gt; Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Tal Nisan <tnisan(a)redhat.com&gt; Gerrit-Reviewer: automation(a)ovirt.org