schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.oracle
| 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/123-trigger-rhnServerNetInterface.sql.postgresql
| 2 ++
2 files changed, 3 insertions(+), 1 deletion(-)
New commits:
commit d8ba558b2d44a9a463ea7c23b673c9c23a9c50f4
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Wed Nov 30 11:34:16 2011 +0100
rhnServerNetInterface: drop existing trigger before creating a modification
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/123-trigger-rhnServerNetInterface.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/123-trigger-rhnServerNetInterface.sql.postgresql
index 473e0d5..7cbe8a4 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/123-trigger-rhnServerNetInterface.sql.postgresql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/123-trigger-rhnServerNetInterface.sql.postgresql
@@ -10,6 +10,8 @@ begin
end;
$$ language plpgsql;
+drop trigger if exists rhn_srv_net_iface_mod_trig on rhnServerNetInterface;
+
create trigger
rhn_srv_net_iface_mod_trig
before insert or update on rhnServerNetInterface
commit e88d88ae2eeafd388df8adcd718b5b8dfbd22999
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Wed Nov 30 11:32:50 2011 +0100
rhnServerNetInterface: consistent not null constraints
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.oracle
index 1f0ab2a..b7ce233 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.oracle
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.oracle
@@ -4,6 +4,6 @@ create sequence rhn_srv_net_iface_id_seq;
update rhnServerNetInterface set id = rhn_srv_net_iface_id_seq.nextval;
-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
);
Show replies by date