schema/spacewalk/common/views/rhnServerOutdatedPackages.sql
| 5 +++--
schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/051-rhnServerOutdatedPackages.sql
| 5 +++--
2 files changed, 6 insertions(+), 4 deletions(-)
New commits:
commit 3b5a677a0e0d060892790752f4c2a8956d9cf8ec
Author: Jeremy Davis <jddavis(a)godaddy.com>
Date: Fri Feb 21 13:55:24 2014 +0100
updated rhnServerOutdatePackages to include arch
diff --git a/schema/spacewalk/common/views/rhnServerOutdatedPackages.sql
b/schema/spacewalk/common/views/rhnServerOutdatedPackages.sql
index d1a4ba4..9dd3283 100644
--- a/schema/spacewalk/common/views/rhnServerOutdatedPackages.sql
+++ b/schema/spacewalk/common/views/rhnServerOutdatedPackages.sql
@@ -26,8 +26,9 @@ rhnServerOutdatedPackages
)
AS
SELECT DISTINCT SNPC.server_id,
- P.name_id,
- P.evr_id,
+ P.name_id,
+ P.evr_id,
+ P.package_arch_id,
PN.name || '-' || evr_t_as_vre_simple( PE.evr ),
E.id,
E.advisory
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/051-rhnServerOutdatedPackages.sql
b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/051-rhnServerOutdatedPackages.sql
index d1a4ba4..9dd3283 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/051-rhnServerOutdatedPackages.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/051-rhnServerOutdatedPackages.sql
@@ -26,8 +26,9 @@ rhnServerOutdatedPackages
)
AS
SELECT DISTINCT SNPC.server_id,
- P.name_id,
- P.evr_id,
+ P.name_id,
+ P.evr_id,
+ P.package_arch_id,
PN.name || '-' || evr_t_as_vre_simple( PE.evr ),
E.id,
E.advisory
Show replies by date