schema/spacewalk/oracle/procs/channel_name_join.sql
| 52 ----------
schema/spacewalk/oracle/types/channel_name_t.sql
| 29 -----
schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/008-channel_name_join-drop.sql
| 3
schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/009-channel_name_t-drop.sql
| 3
4 files changed, 6 insertions(+), 81 deletions(-)
New commits:
commit d5849854c3aa1cc97ee0919f7de5f5a34351deca
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Dec 23 14:38:47 2010 +0100
Procedure channel_name_join not used anywhere, removing (together with the
channel_name_t type).
diff --git a/schema/spacewalk/oracle/procs/channel_name_join.sql
b/schema/spacewalk/oracle/procs/channel_name_join.sql
deleted file mode 100644
index 5d4c537..0000000
--- a/schema/spacewalk/oracle/procs/channel_name_join.sql
+++ /dev/null
@@ -1,52 +0,0 @@
---
--- Copyright (c) 2008 Red Hat, Inc.
---
--- This software is licensed to you under the GNU General Public License,
--- version 2 (GPLv2). There is NO WARRANTY for this software, express or
--- implied, including the implied warranties of MERCHANTABILITY or FITNESS
--- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
--- along with this software; if not, see
---
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
---
--- Red Hat trademarks are not licensed under GPLv2. No permission is
--- granted to use or replicate Red Hat trademarks that are incorporated
--- in this software or its documentation.
---
---
---
---
-
-create or replace function
-channel_name_join(sep_in in varchar2, ch_in in channel_name_t)
-return varchar2
-deterministic
-is
- ret varchar2(4000);
- i binary_integer;
-begin
- ret := '';
- i := ch_in.first;
-
- if i is null
- then
- return ret;
- end if;
-
- ret := ch_in(i);
- i := ch_in.next(i);
-
- while i is not null
- loop
- ret := ret || sep_in || ch_in(i);
- i := ch_in.next(i);
- end loop;
-
- return ret;
-end;
-/
-
---
--- Revision 1.3 2002/05/13 22:53:38 pjones
--- cvs id/log
--- some (note enough) readability fixes
---
diff --git a/schema/spacewalk/oracle/types/channel_name_t.sql
b/schema/spacewalk/oracle/types/channel_name_t.sql
deleted file mode 100644
index 8219115..0000000
--- a/schema/spacewalk/oracle/types/channel_name_t.sql
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- Copyright (c) 2008 Red Hat, Inc.
---
--- This software is licensed to you under the GNU General Public License,
--- version 2 (GPLv2). There is NO WARRANTY for this software, express or
--- implied, including the implied warranties of MERCHANTABILITY or FITNESS
--- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
--- along with this software; if not, see
---
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
---
--- Red Hat trademarks are not licensed under GPLv2. No permission is
--- granted to use or replicate Red Hat trademarks that are incorporated
--- in this software or its documentation.
---
---
---
---
--- this creates the channel_name_t type
-
-create or replace type channel_name_t as table of varchar(64)
-/
-
---
--- Revision 1.2 2002/05/09 22:34:53 pjones
--- argh, ; doesn't work right here
---
--- Revision 1.1 2002/05/09 22:31:42 pjones
--- make types first-class schema
---
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/008-channel_name_join-drop.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/008-channel_name_join-drop.sql
new file mode 100644
index 0000000..4e34675
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/008-channel_name_join-drop.sql
@@ -0,0 +1,3 @@
+
+drop function channel_name_join;
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/009-channel_name_t-drop.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/009-channel_name_t-drop.sql
new file mode 100644
index 0000000..b33eb27
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/009-channel_name_t-drop.sql
@@ -0,0 +1,3 @@
+
+drop type channel_name_t;
+