rel-eng/packages/spacewalk-schema
| 2
schema/spacewalk/spacewalk-schema.spec
| 5
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/132-tables-timestamps.sql.oracle
| 83 ----------
3 files changed, 5 insertions(+), 85 deletions(-)
New commits:
commit 5cb5811204a434a9c9d23b9096525045e7f88e6f
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu May 2 15:22:07 2013 +0200
Automatic commit of package [spacewalk-schema] release [1.10.27-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 3e4417a..176dfa7 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.10.26-1 schema/spacewalk/
+1.10.27-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index 3463893..e83bf8e 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: 1.10.26
+Version: 1.10.27
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -71,6 +71,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Thu May 02 2013 Michael Mraka <michael.mraka(a)redhat.com> 1.10.27-1
+- columns can be altered with values inside
+
* Mon Apr 29 2013 Michael Mraka <michael.mraka(a)redhat.com> 1.10.26-1
- fixed dependency
commit b2428015353d91a091b2af779fc2b0ccc657a95a
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Tue Apr 30 10:36:00 2013 +0200
columns can be altered with values inside
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/132-tables-timestamps.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/132-tables-timestamps.sql.oracle
index 9647876..89a8aaf 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/132-tables-timestamps.sql.oracle
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/132-tables-timestamps.sql.oracle
@@ -1,41 +1,4 @@
-
-begin
- for rec in (
- select trigger_name
- from user_triggers
- where table_name in (
- select table_name
- from user_tab_columns
- where DATA_TYPE = 'DATE'
- )
- and trigger_name not like '%$%'
- ) loop
- execute immediate 'alter trigger ' || rec.trigger_name || ' disable';
- end loop;
-end;
-/
-
-begin
- for rec in (
- select table_name, constraint_name
- from user_constraints
- where table_name in (
- select table_name
- from user_tab_columns
- where DATA_TYPE = 'DATE'
- )
- and table_name not like '%$%'
- and constraint_type = 'C'
- ) loop
- execute immediate 'alter table ' || rec.table_name || ' disable constraint
' || rec.constraint_name;
- end loop;
-end;
-/
-
-declare
- prev_table varchar2(30);
begin
- prev_table := 'none';
for rec in (
select table_name, column_name
from user_tab_columns
@@ -47,22 +10,9 @@ begin
and data_type = 'DATE'
order by table_name
) loop
- if prev_table <> rec.table_name then
- if prev_table <> 'none' then
- execute immediate 'alter table ' || prev_table || ' drop column
orig_date';
- end if;
- execute immediate 'alter table ' || rec.table_name || ' add orig_date
date';
- end if;
- execute immediate 'update ' || rec.table_name || ' set orig_date = ' ||
rec.column_name;
- execute immediate 'update ' || rec.table_name || ' set ' ||
rec.column_name || ' = null';
execute immediate 'alter table ' || rec.table_name || ' modify ' ||
rec.column_name || ' timestamp with local time zone';
- execute immediate 'update ' || rec.table_name || ' set ' ||
rec.column_name || ' = orig_date';
- prev_table := rec.table_name;
end loop;
- if prev_table <> 'none' then
- execute immediate 'alter table ' || prev_table || ' drop column
orig_date';
- end if;
end;
/
@@ -81,36 +31,3 @@ begin
end;
/
-begin
- for rec in (
- select table_name, constraint_name
- from user_constraints
- where table_name in (
- select table_name
- from user_tab_columns
- where DATA_TYPE = 'TIMESTAMP(6) WITH LOCAL TIME ZONE'
- )
- and table_name not like '%$%'
- and constraint_type = 'C'
- ) loop
- execute immediate 'alter table ' || rec.table_name || ' enable constraint
' || rec.constraint_name;
- end loop;
-end;
-/
-
-begin
- for rec in (
- select trigger_name
- from user_triggers
- where table_name in (
- select table_name
- from user_tab_columns
- where DATA_TYPE = 'TIMESTAMP(6) WITH LOCAL TIME ZONE'
- )
- and trigger_name not like '%$%'
- ) loop
- execute immediate 'alter trigger ' || rec.trigger_name || ' enable';
- end loop;
-end;
-/
-
Show replies by date