rel-eng/packages/spacewalk-schema
| 2 +-
schema/spacewalk/common/tables/log.sql
| 2 +-
schema/spacewalk/spacewalk-schema.spec
| 5 ++++-
schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/012-log.sql.oracle
| 5 +++++
schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/012-log.sql.postgresql
| 2 ++
5 files changed, 13 insertions(+), 3 deletions(-)
New commits:
commit 42af372067ef2094b777d2eb0688d45adf86a057
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Mon Aug 5 16:36:59 2013 +0200
Automatic commit of package [spacewalk-schema] release [2.1.6-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index d5d4e95..314a150 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-2.1.5-1 schema/spacewalk/
+2.1.6-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index 74472b8..4fdc257 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.5
+Version: 2.1.6
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -71,6 +71,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Mon Aug 05 2013 Tomas Lestach <tlestach(a)redhat.com> 2.1.6-1
+- changing stamp type on log table
+
* Wed Jul 31 2013 Simon Lukasik <slukasik(a)redhat.com> 2.1.5-1
- New OrgConfig attribute: period during which it is not possible to delete
scan
commit c8fc7f598f189daf79190232fae034cee706fabd
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Mon Aug 5 16:13:50 2013 +0200
changing stamp type on log table
to timestamp with local time zone
diff --git a/schema/spacewalk/common/tables/log.sql
b/schema/spacewalk/common/tables/log.sql
index e2b4469..cbd8a90 100644
--- a/schema/spacewalk/common/tables/log.sql
+++ b/schema/spacewalk/common/tables/log.sql
@@ -17,7 +17,7 @@
CREATE TABLE log
(
id NUMBER NOT NULL PRIMARY KEY,
- stamp TIMESTAMP WITH TIME ZONE,
+ stamp TIMESTAMP WITH LOCAL TIME ZONE,
user_id NUMBER REFERENCES web_contact_all(id)
)
ENABLE ROW MOVEMENT
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/012-log.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/012-log.sql.oracle
new file mode 100644
index 0000000..f25520b
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/012-log.sql.oracle
@@ -0,0 +1,5 @@
+ALTER TABLE log ADD stamp_ltz TIMESTAMP WITH LOCAL TIME ZONE;
+UPDATE log SET stamp_ltz = stamp;
+ALTER TABLE log DROP COLUMN stamp;
+ALTER TABLE log RENAME COLUMN stamp_ltz TO stamp;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/012-log.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/012-log.sql.postgresql
new file mode 100644
index 0000000..745bb50
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/012-log.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 331fbb666a23cd70f7fa9891acceaff8afa045bf
+-- This file is intentionally left empty.
Show replies by date