rel-eng/packages/spacewalk-schema | 2 +- schema/spacewalk/spacewalk-schema.spec | 5 ++++- schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/005-logging-recreate-triggers.sql.oracle | 6 ++++++ schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/005-logging-recreate-triggers.sql.postgresql | 5 +++++ 4 files changed, 16 insertions(+), 2 deletions(-)

New commits: commit 934f8dbcc79b79e99670229fd8f6447658568e9c Author: Tomas Lestach tlestach@redhat.com Date: Thu Jul 25 17:30:33 2013 +0200

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

diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema index feca68d..c8b6565 100644 --- a/rel-eng/packages/spacewalk-schema +++ b/rel-eng/packages/spacewalk-schema @@ -1 +1 @@ -2.1.2-1 schema/spacewalk/ +2.1.3-1 schema/spacewalk/ diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec index cbdb6db..5d9bcb0 100644 --- a/schema/spacewalk/spacewalk-schema.spec +++ b/schema/spacewalk/spacewalk-schema.spec @@ -4,7 +4,7 @@ Name: spacewalk-schema Group: Applications/Internet Summary: Oracle SQL schema for Spacewalk server

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

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

%changelog +* Thu Jul 25 2013 Tomas Lestach tlestach@redhat.com 2.1.3-1 +- recreate logging triggers after we change the logging table column types + * Wed Jul 24 2013 Tomas Lestach tlestach@redhat.com 2.1.2-1 - fix oracle equivalent source sha1 - fix_f624b843

commit c778b1cbbcd916908c9d822f2b4ae67189f88180 Author: Tomas Lestach tlestach@redhat.com Date: Thu Jul 25 17:30:04 2013 +0200

recreate logging triggers after we change the logging table column types

diff --git a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/005-logging-recreate-triggers.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/005-logging-recreate-triggers.sql.oracle new file mode 100644 index 0000000..d4a9426 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/005-logging-recreate-triggers.sql.oracle @@ -0,0 +1,6 @@ +begin logging.recreate_trigger('web_contact'); end; +/ +begin logging.recreate_trigger('rhnserver'); end; +/ +begin logging.recreate_trigger('rhnservergroup'); end; +/ diff --git a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/005-logging-recreate-triggers.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/005-logging-recreate-triggers.sql.postgresql new file mode 100644 index 0000000..bf70bef --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/005-logging-recreate-triggers.sql.postgresql @@ -0,0 +1,5 @@ +-- oracle equivalent source sha1 8010783526a5b9528c26336d99a4412c1a8aa1c3 + +select logging.recreate_trigger('web_contact'); +select logging.recreate_trigger('rhnserver'); +select logging.recreate_trigger('rhnservergroup');