rel-eng/packages/spacewalk-schema
| 2 +-
schema/spacewalk/spacewalk-schema.spec
| 5 ++++-
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql
| 1 -
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql.oracle
| 1 +
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql.postgresql
| 1 +
5 files changed, 7 insertions(+), 3 deletions(-)
New commits:
commit 61d1bedba7fb5220837b78d9a5f4901992fd03b3
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Tue Jul 31 13:43:11 2012 +0200
Automatic commit of package [spacewalk-schema] release [1.8.67-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 271b233..24496ec 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.8.66-1 schema/spacewalk/
+1.8.67-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index 4911684..b1a5252 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.8.66
+Version: 1.8.67
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -68,6 +68,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Tue Jul 31 2012 Tomas Lestach <tlestach(a)redhat.com> 1.8.67-1
+- fix upgrade script
+
* Mon Jul 30 2012 Tomas Lestach <tlestach(a)redhat.com> 1.8.66-1
- remove org_applicant from rhnUserGroupType table
- remove org_applicant related triggers
commit 1dd81a19fcc3c97698eaa9556dac125c8f248383
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Tue Jul 31 13:40:26 2012 +0200
fix upgrade script
addressing:
psql:/var/log/spacewalk/schema-upgrade/20120730-175640-script.sql:1754:
ERROR: syntax error at or near ";"
LINE 1: DROP FUNCTION is_user_applicant;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql
deleted file mode 100644
index ea74b1e..0000000
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql
+++ /dev/null
@@ -1 +0,0 @@
-DROP FUNCTION is_user_applicant;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql.oracle
new file mode 100644
index 0000000..ea74b1e
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql.oracle
@@ -0,0 +1 @@
+DROP FUNCTION is_user_applicant;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql.postgresql
new file mode 100644
index 0000000..f680a77
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/117-is_user_applicant.sql.postgresql
@@ -0,0 +1 @@
+DROP FUNCTION is_user_applicant(user_id_in IN numeric);
Show replies by date