rel-eng/packages/spacewalk-schema | 2 +- schema/spacewalk/spacewalk-schema.spec | 6 +++++- schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.postgresql | 2 +- schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.postgresql | 8 +++++--- schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.postgresql | 5 ++++- 5 files changed, 16 insertions(+), 7 deletions(-)

New commits: commit 8302b27b64cea3233ce0ac091d7e6e6ef4cc1e6e Author: Milan Zazrivec mzazrivec@redhat.com Date: Mon Dec 5 10:21:43 2011 +0100

Automatic commit of package [spacewalk-schema] release [1.6.37-1].

diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema index 494bb90..f9960fe 100644 --- a/rel-eng/packages/spacewalk-schema +++ b/rel-eng/packages/spacewalk-schema @@ -1 +1 @@ -1.6.36-1 schema/spacewalk/ +1.6.37-1 schema/spacewalk/ diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec index 3e16daf..273a23a 100644 --- a/schema/spacewalk/spacewalk-schema.spec +++ b/schema/spacewalk/spacewalk-schema.spec @@ -2,7 +2,7 @@ Name: spacewalk-schema Group: Applications/Internet Summary: Oracle SQL schema for Spacewalk server

-Version: 1.6.36 +Version: 1.6.37 Release: 1%{?dist} Source0: %{name}-%{version}.tar.gz

@@ -66,6 +66,10 @@ rm -rf $RPM_BUILD_ROOT %{_mandir}/man1/spacewalk-sql*

%changelog +* Mon Dec 05 2011 Milan Zazrivec mzazrivec@redhat.com 1.6.37-1 +- pgsql: consistent unique constraints +- pgsql: consistent not null constraint + * Fri Dec 02 2011 Jan Pazdziora 1.6.36-1 - 633975 - mark probe as updated if server IP address changed.

commit 309184c292f59b9735e7ca8a8de2c8a80fffaa40 Author: Milan Zazrivec mzazrivec@redhat.com Date: Mon Dec 5 10:20:02 2011 +0100

pgsql: consistent unique constraints

diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.postgresql index 7b8a6b7..a6ac09b 100644 --- a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.postgresql +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.postgresql @@ -13,6 +13,8 @@ CREATE TABLE rhnServerNetAddress4 modified timestamptz default current_timestamp NOT NULL );

-CREATE UNIQUE INDEX rhn_srv_net_addr4_iid_addr_uq - ON rhnServerNetAddress4 (interface_id, address) - ; +CREATE INDEX rhn_srv_net_addr4_iid_addr_uq + ON rhnServerNetAddress4 (interface_id, address); + +ALTER TABLE rhnServerNetAddress4 + ADD CONSTRAINT rhn_srv_net_addr4_iid_addr_uq UNIQUE (interface_id, address); diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.postgresql index 844c601..4898433 100644 --- a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.postgresql +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.postgresql @@ -13,5 +13,8 @@ CREATE TABLE rhnServerNetAddress6 modified timestamptz default current_timestamp NOT NULL );

-CREATE UNIQUE INDEX rhn_srv_net_ad6_iid_sc_ad_uq +CREATE INDEX rhn_srv_net_ad6_iid_sc_ad_uq ON rhnServerNetAddress6 (interface_id, scope, address); + +ALTER TABLE rhnServerNetAddress6 + ADD CONSTRAINT rhn_srv_net_ad6_iid_sc_ad_uq UNIQUE (interface_id, scope, address);

commit a2721a9eacde09c22a6575d363c30c5f1cb3da22 Author: Milan Zazrivec mzazrivec@redhat.com Date: Mon Dec 5 10:14:57 2011 +0100

pgsql: consistent not null constraint

diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.postgresql index 02a4bf0..0e9ccee 100644 --- a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.postgresql +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.postgresql @@ -6,6 +6,6 @@ create sequence rhn_srv_net_iface_id_seq;

update rhnServerNetInterface set id = nextval('rhn_srv_net_iface_id_seq');

-alter table rhnServerNetInterface add constraint rhn_srv_net_iface_id_nn check (id is not null); +alter table rhnServerNetInterface modify id number not null;

alter table rhnServerNetInterface add constraint rhn_srv_net_iface_id_pk primary key ( id );