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(a)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(a)redhat.com> 2.1.3-1
+- recreate logging triggers after we change the logging table column types
+
* Wed Jul 24 2013 Tomas Lestach <tlestach(a)redhat.com> 2.1.2-1
- fix oracle equivalent source sha1
- fix_f624b843
commit c778b1cbbcd916908c9d822f2b4ae67189f88180
Author: Tomas Lestach <tlestach(a)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');