rel-eng/packages web/spacewalk-web.spec
by Michael Mraka
rel-eng/packages/spacewalk-web | 2 +-
web/spacewalk-web.spec | 5 ++++-
2 files changed, 5 insertions(+), 2 deletions(-)
New commits:
commit 269790b0f2b9c54aa3c1790e8b935091181ec5c9
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Fri Feb 19 09:13:04 2010 +0100
Automatic commit of package [spacewalk-web] release [0.9.1-1].
diff --git a/rel-eng/packages/spacewalk-web b/rel-eng/packages/spacewalk-web
index b40c664..823affd 100644
--- a/rel-eng/packages/spacewalk-web
+++ b/rel-eng/packages/spacewalk-web
@@ -1 +1 @@
-0.8.14-1 web/
+0.9.1-1 web/
diff --git a/web/spacewalk-web.spec b/web/spacewalk-web.spec
index f5a982e..3ad33a4 100644
--- a/web/spacewalk-web.spec
+++ b/web/spacewalk-web.spec
@@ -2,7 +2,7 @@ Name: spacewalk-web
Summary: Spacewalk Web site packages
Group: Applications/Internet
License: GPLv2
-Version: 0.9.0
+Version: 0.9.1
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -256,6 +256,9 @@ rm -rf $RPM_BUILD_ROOT
# $Id$
%changelog
+* Fri Feb 19 2010 Michael Mraka <michael.mraka(a)redhat.com> 0.9.1-1
+- moved PXT::Debug to separate module
+
* Thu Feb 04 2010 Michael Mraka <michael.mraka(a)redhat.com> 0.8.14-1
- updated copyrights
- removed a lot of unused code
14 years, 2 months
Changes to 'refs/tags/spacewalk-schema-0.8.13-1'
by Michael Mraka
Tag 'spacewalk-schema-0.8.13-1' created by Michael Mraka <michael.mraka(a)redhat.com> at 2010-02-18 22:46 +0000
Tagging package [spacewalk-schema] version [0.8.13-1] in directory [schema/spacewalk/].
Changes since spacewalk-backend-0.8.46-1:
Michael Mraka (2):
improved rhnPackageFile 0.7 -> 0.8 upgrades
Automatic commit of package [spacewalk-schema] release [0.8.13-1].
---
rel-eng/packages/spacewalk-schema | 2
schema/spacewalk/spacewalk-schema.spec | 5 +-
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql | 21 +++++-----
3 files changed, 17 insertions(+), 11 deletions(-)
---
14 years, 2 months
Branch 'SPACEWALK-0.8' - rel-eng/packages schema/spacewalk
by Michael Mraka
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/spacewalk-schema.spec | 5 ++++-
2 files changed, 5 insertions(+), 2 deletions(-)
New commits:
commit 69e150b67a33062230d4e1b4575ba8b76d110109
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Feb 18 23:46:49 2010 +0100
Automatic commit of package [spacewalk-schema] release [0.8.13-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 7bcf770..d5ec189 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-0.8.12-1 schema/spacewalk/
+0.8.13-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index 4b1de2b..9337c74 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: 0.8.12
+Version: 0.8.13
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -58,6 +58,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-schema-upgrade*
%changelog
+* Thu Feb 18 2010 Michael Mraka <michael.mraka(a)redhat.com> 0.8.13-1
+- improved rhnPackageFile upgrades
+
* Wed Feb 10 2010 Michael Mraka <michael.mraka(a)redhat.com> 0.8.12-1
- making position column unique in given kickstart
14 years, 2 months
schema/spacewalk
by Michael Mraka
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql | 21 +++++-----
1 file changed, 12 insertions(+), 9 deletions(-)
New commits:
commit 68354452bf8cf6f006ccd5f3ab2ae9a96514708b
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Feb 18 23:35:14 2010 +0100
improved rhnPackageFile 0.7 -> 0.8 upgrades
- forced indexes with hint
- replaced minus with not exists
- decreased number of packages in one round (decreased UNDO and TEMP usage)
...was able to process 125000 packages in 3 and 1/2 hours
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
index b3647d0..e5c3ed5 100644
--- a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
+++ b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
@@ -15,20 +15,23 @@ begin
from rhnPackageFile;
lmin := min_pid;
- lmax := lmin + 99999;
+ lmax := lmin + 1999;
while lmin < max_pid loop
insert into rhnChecksum (id, checksum_type_id, checksum)
(select rhnChecksum_seq.nextval, md5_id, csum
- from (select distinct md5 as csum
- from rhnPackageFile
+ from (select /*+ index(p rhn_package_file_pid_cid_uq) */
+ distinct md5 as csum
+ from rhnPackageFile p
where package_id between lmin and lmax
and md5 is not null
- minus
- select checksum as csum
- from rhnChecksum
- where checksum_type_id = md5_id));
+ and not exists (select /*+ index(c rhnchecksum_chsum_idx) */ 1
+ from rhnChecksum c
+ where p.md5 = c.checksum
+ and c.checksum_type_id = md5_id)
+ )
+ );
commit;
- update rhnPackageFile p
+ update /*+ index(p rhn_package_file_pid_cid_uq) */ rhnPackageFile p
set checksum_id = (select id
from rhnChecksum c
where checksum_type_id = md5_id
@@ -37,7 +40,7 @@ begin
and md5 is not null;
commit;
lmin := lmax + 1;
- lmax := lmin + 99999;
+ lmax := lmin + 1999;
end loop;
end;
/
14 years, 2 months
Branch 'SPACEWALK-0.8' - schema/spacewalk
by Michael Mraka
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql | 21 +++++-----
1 file changed, 12 insertions(+), 9 deletions(-)
New commits:
commit cb8912e7477453a029a6377ffdb7f39dd830c8a5
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Feb 18 23:43:47 2010 +0100
improved rhnPackageFile 0.7 -> 0.8 upgrades
- forced indexes with hint
- replaced minus with not exists
- decreased number of packages in one round (decreased UNDO and TEMP usage)
...was able to process 125000 packages in 3 and 1/2 hours
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
index b3647d0..e5c3ed5 100644
--- a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
+++ b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/012-2-rhnPackageFile-data.sql
@@ -15,20 +15,23 @@ begin
from rhnPackageFile;
lmin := min_pid;
- lmax := lmin + 99999;
+ lmax := lmin + 1999;
while lmin < max_pid loop
insert into rhnChecksum (id, checksum_type_id, checksum)
(select rhnChecksum_seq.nextval, md5_id, csum
- from (select distinct md5 as csum
- from rhnPackageFile
+ from (select /*+ index(p rhn_package_file_pid_cid_uq) */
+ distinct md5 as csum
+ from rhnPackageFile p
where package_id between lmin and lmax
and md5 is not null
- minus
- select checksum as csum
- from rhnChecksum
- where checksum_type_id = md5_id));
+ and not exists (select /*+ index(c rhnchecksum_chsum_idx) */ 1
+ from rhnChecksum c
+ where p.md5 = c.checksum
+ and c.checksum_type_id = md5_id)
+ )
+ );
commit;
- update rhnPackageFile p
+ update /*+ index(p rhn_package_file_pid_cid_uq) */ rhnPackageFile p
set checksum_id = (select id
from rhnChecksum c
where checksum_type_id = md5_id
@@ -37,7 +40,7 @@ begin
and md5 is not null;
commit;
lmin := lmax + 1;
- lmax := lmin + 99999;
+ lmax := lmin + 1999;
end loop;
end;
/
14 years, 2 months
backend/satellite_tools
by Justin Sherrill
backend/satellite_tools/spacewalk-remove-channel | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
New commits:
commit 3eb8ef7b643d453292c0b6397f996b15ff66a92c
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Thu Feb 18 11:16:22 2010 -0500
making repo deletion on channel remove script to obey justdb option
diff --git a/backend/satellite_tools/spacewalk-remove-channel b/backend/satellite_tools/spacewalk-remove-channel
index c848327..2a3b91e 100755
--- a/backend/satellite_tools/spacewalk-remove-channel
+++ b/backend/satellite_tools/spacewalk-remove-channel
@@ -314,8 +314,8 @@ def delete_channels(channelLabels, force=0, justdb=0):
log_debug(3, "Processing table %s" % table)
h = rhnSQL.prepare(query % (table, field))
h.executemany(channel_id=channel_ids)
-
- __deleteRepoData(channelLabels)
+ if not justdb:
+ __deleteRepoData(channelLabels)
def __deleteRepoData(labels):
14 years, 2 months
java/code
by Justin Sherrill
java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/snippet/test/SnippetHandlerTest.java | 10 ++++++----
1 file changed, 6 insertions(+), 4 deletions(-)
New commits:
commit d2359249b47e68260f71d125efb5e952a96c6f6f
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Thu Feb 18 11:13:24 2010 -0500
unit test fix
diff --git a/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/snippet/test/SnippetHandlerTest.java b/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/snippet/test/SnippetHandlerTest.java
index a701a1a..0bdfd5b 100644
--- a/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/snippet/test/SnippetHandlerTest.java
+++ b/java/code/src/com/redhat/rhn/frontend/xmlrpc/kickstart/snippet/test/SnippetHandlerTest.java
@@ -30,9 +30,11 @@ public class SnippetHandlerTest extends BaseHandlerTestCase {
public void testListAll() {
deleteAllSnippets();
- assertTrue(handler.listAll(adminKey).isEmpty());
+ List old = handler.listAll(adminKey);
CobblerSnippet.createOrUpdate(true, "foo", "My foo snippet", admin.getOrg());
- assertFalse(handler.listAll(adminKey).isEmpty());
+ List newList = handler.listAll(adminKey);
+ assertTrue(old.size() + 1 == newList.size());
+
}
public void testListCustom() {
@@ -46,13 +48,13 @@ public class SnippetHandlerTest extends BaseHandlerTestCase {
public void testCreateOrUpdate() {
deleteAllSnippets();
handler.createOrUpdate(adminKey, "foobar", "My Little foobar");
- assertTrue(handler.listAll(adminKey).get(0).getName().equals("foobar"));
+ assertTrue(handler.listCustom(adminKey).get(0).getName().equals("foobar"));
}
public void testDelete() {
deleteAllSnippets();
handler.createOrUpdate(adminKey, "foobar", "My Little foobar");
- assertTrue(handler.listAll(adminKey).get(0).getName().equals("foobar"));
+ assertTrue(handler.listCustom(adminKey).get(0).getName().equals("foobar"));
handler.delete(adminKey, "foobar");
assertTrue(handler.listCustom(adminKey).isEmpty());
}
14 years, 2 months
Changes to 'refs/tags/spacewalk-schema-0.9.1-1'
by Miroslav Suchý
Tag 'spacewalk-schema-0.9.1-1' created by Miroslav Suchý <msuchy(a)redhat.com> at 2010-02-18 14:13 +0000
Tagging package [spacewalk-schema] version [0.9.1-1] in directory [schema/spacewalk/].
Changes since spacewalk-setup-jabberd-0.9.1-1:
Lukáš Ďurfina (1):
Changes in database schema for Debian support
Miroslav Suchý (1):
Automatic commit of package [spacewalk-schema] release [0.9.1-1].
Tomas Lestach (2):
fixing ConfigureCertificateCommandTest
checkstyle fixes
---
java/code/src/com/redhat/rhn/manager/satellite/test/ConfigureCertificateCommandTest.java | 37 +
rel-eng/packages/spacewalk-schema | 2
schema/spacewalk/common/data/rhnArchType.sql | 2
schema/spacewalk/common/data/rhnChannelArch.sql | 27 +
schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql | 86 +++
schema/spacewalk/common/data/rhnPackageArch.sql | 23 +
schema/spacewalk/common/data/rhnServerArch.sql | 44 ++
schema/spacewalk/common/data/rhnServerPackageArchCompat.sql | 83 +++
schema/spacewalk/spacewalk-schema.spec | 5
schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-0.9/001-debian-support.sql | 217 ++++++++++
10 files changed, 517 insertions(+), 9 deletions(-)
---
14 years, 2 months
rel-eng/packages schema/spacewalk
by Miroslav Suchý
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/spacewalk-schema.spec | 5 ++++-
2 files changed, 5 insertions(+), 2 deletions(-)
New commits:
commit ee7c1570c36b1a80879f7468950a598be44735e4
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Thu Feb 18 15:13:32 2010 +0100
Automatic commit of package [spacewalk-schema] release [0.9.1-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 36c104a..4b0d885 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-0.8.9-1 schema/spacewalk/
+0.9.1-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index f982708..6628f9e 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: 0.9.0
+Version: 0.9.1
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -58,6 +58,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-schema-upgrade*
%changelog
+* Thu Feb 18 2010 Miroslav Suchý <msuchy(a)redhat.com> 0.9.1-1
+- support for Debian (lukas.durfina(a)gmail.com)
+
* Thu Feb 04 2010 Michael Mraka <michael.mraka(a)redhat.com> 0.8.9-1
- call update_family_counts() only once in prune_family()
14 years, 2 months
schema/spacewalk
by Miroslav Suchý
schema/spacewalk/common/data/rhnArchType.sql | 2
schema/spacewalk/common/data/rhnChannelArch.sql | 27 +
schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql | 86 +++
schema/spacewalk/common/data/rhnPackageArch.sql | 23 +
schema/spacewalk/common/data/rhnServerArch.sql | 44 ++
schema/spacewalk/common/data/rhnServerPackageArchCompat.sql | 83 +++
schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-0.9/001-debian-support.sql | 217 ++++++++++
7 files changed, 482 insertions(+)
New commits:
commit 3ec756e722bcb36bd5386aa94baebe715d8c70b0
Author: Lukáš Ďurfina <lukas.durfina(a)gmail.com>
Date: Wed Feb 17 23:15:11 2010 +0100
Changes in database schema for Debian support
diff --git a/schema/spacewalk/common/data/rhnArchType.sql b/schema/spacewalk/common/data/rhnArchType.sql
index f1270d4..dd0a446 100644
--- a/schema/spacewalk/common/data/rhnArchType.sql
+++ b/schema/spacewalk/common/data/rhnArchType.sql
@@ -18,6 +18,8 @@
insert into rhnArchType (id, label, name) values
(rhn_archtype_id_seq.nextval, 'rpm', 'RPM');
insert into rhnArchType (id, label, name) values
+ (rhn_archtype_id_seq.nextval, 'deb', 'DEB');
+insert into rhnArchType (id, label, name) values
(rhn_archtype_id_seq.nextval, 'sysv-solaris', 'SysV-Solaris');
insert into rhnArchType (id, label, name) values
(rhn_archtype_id_seq.nextval, 'tar', 'tar');
diff --git a/schema/spacewalk/common/data/rhnChannelArch.sql b/schema/spacewalk/common/data/rhnChannelArch.sql
index b0d8014..09a11d7 100644
--- a/schema/spacewalk/common/data/rhnChannelArch.sql
+++ b/schema/spacewalk/common/data/rhnChannelArch.sql
@@ -20,18 +20,33 @@ insert into rhnChannelArch (id, label, name, arch_type_id) values
(rhn_channel_arch_id_seq.nextval, 'channel-ia32', 'IA-32', lookup_arch_type('rpm'));
insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-ia32-deb', 'IA-32 Debian', lookup_arch_type('deb'));
+
+insert into rhnChannelArch (id, label, name, arch_type_id) values
(rhn_channel_arch_id_seq.nextval, 'channel-ia64', 'IA-64', lookup_arch_type('rpm'));
insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-ia64-deb', 'IA-64 Debian', lookup_arch_type('deb'));
+
+insert into rhnChannelArch (id, label, name, arch_type_id) values
(rhn_channel_arch_id_seq.nextval, 'channel-sparc', 'Sparc', lookup_arch_type('rpm'));
insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-sparc-deb', 'Sparc Debian', lookup_arch_type('deb'));
+
+insert into rhnChannelArch (id, label, name, arch_type_id) values
(rhn_channel_arch_id_seq.nextval, 'channel-alpha', 'Alpha', lookup_arch_type('rpm'));
insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-alpha-deb', 'Alpha Debian', lookup_arch_type('deb'));
+
+insert into rhnChannelArch (id, label, name, arch_type_id) values
(rhn_channel_arch_id_seq.nextval, 'channel-s390', 's390', lookup_arch_type('rpm'));
insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-s390-deb', 's390 Debian', lookup_arch_type('deb'));
+
+insert into rhnChannelArch (id, label, name, arch_type_id) values
(rhn_channel_arch_id_seq.nextval, 'channel-s390x', 's390x', lookup_arch_type('rpm'));
insert into rhnChannelArch (id, label, name, arch_type_id) values
@@ -44,9 +59,21 @@ insert into rhnChannelArch (id, label, name, arch_type_id) values
(rhn_channel_arch_id_seq.nextval, 'channel-x86_64', 'x86_64', lookup_arch_type('rpm'));
insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-x86_64-deb', 'x86_64 Debian', lookup_arch_type('deb'));
+
+insert into rhnChannelArch (id, label, name, arch_type_id) values
(rhn_channel_arch_id_seq.nextval, 'channel-ppc', 'PPC', lookup_arch_type('rpm'));
insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-powerpc-deb', 'PowerPC Debian', lookup_arch_type('deb'));
+
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-arm-deb', 'arm Debian', lookup_arch_type('deb'));
+
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-mips-deb', 'mips Debian', lookup_arch_type('deb'));
+
+insert into rhnChannelArch (id, label, name, arch_type_id) values
(rhn_channel_arch_id_seq.nextval, 'channel-sparc-sun-solaris', 'Sparc Solaris', lookup_arch_type('sysv-solaris'));
insert into rhnChannelArch (id, label, name, arch_type_id) values
diff --git a/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql b/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql
index bf423e6..3a2c877 100644
--- a/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql
+++ b/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql
@@ -37,6 +37,14 @@ values (LOOKUP_CHANNEL_ARCH('channel-ia32'), LOOKUP_PACKAGE_ARCH('src'));
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-ia32'), LOOKUP_PACKAGE_ARCH('athlon'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia32-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia32-deb'), LOOKUP_PACKAGE_ARCH('i386-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia32-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-ia64'), LOOKUP_PACKAGE_ARCH('noarch'));
@@ -59,6 +67,18 @@ values (LOOKUP_CHANNEL_ARCH('channel-ia64'), LOOKUP_PACKAGE_ARCH('ia64'));
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-ia64'), LOOKUP_PACKAGE_ARCH('src'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia64-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia64-deb'), LOOKUP_PACKAGE_ARCH('i386-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia64-deb'), LOOKUP_PACKAGE_ARCH('ia64-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia64-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-sparc'), LOOKUP_PACKAGE_ARCH('noarch'));
@@ -75,6 +95,15 @@ values (LOOKUP_CHANNEL_ARCH('channel-sparc'), LOOKUP_PACKAGE_ARCH('sparc64'));
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-sparc'), LOOKUP_PACKAGE_ARCH('src'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-sparc-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-sparc-deb'), LOOKUP_PACKAGE_ARCH('sparc-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-sparc-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-alpha'), LOOKUP_PACKAGE_ARCH('noarch'));
@@ -88,6 +117,15 @@ values (LOOKUP_CHANNEL_ARCH('channel-alpha'), LOOKUP_PACKAGE_ARCH('alphaev6'));
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-alpha'), LOOKUP_PACKAGE_ARCH('src'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-alpha-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-alpha-deb'), LOOKUP_PACKAGE_ARCH('alpha-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-alpha-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-s390'), LOOKUP_PACKAGE_ARCH('noarch'));
@@ -98,6 +136,15 @@ values (LOOKUP_CHANNEL_ARCH('channel-s390'), LOOKUP_PACKAGE_ARCH('s390'));
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-s390'), LOOKUP_PACKAGE_ARCH('src'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-s390-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-s390-deb'), LOOKUP_PACKAGE_ARCH('s390-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-s390-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-s390x'), LOOKUP_PACKAGE_ARCH('noarch'));
@@ -171,6 +218,18 @@ values (LOOKUP_CHANNEL_ARCH('channel-x86_64'), LOOKUP_PACKAGE_ARCH('x86_64'));
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-x86_64'), LOOKUP_PACKAGE_ARCH('src'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-x86_64-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-x86_64-deb'), LOOKUP_PACKAGE_ARCH('i386-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-x86_64-deb'), LOOKUP_PACKAGE_ARCH('amd64-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-x86_64-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-ppc'), LOOKUP_PACKAGE_ARCH('noarch'));
@@ -191,6 +250,33 @@ insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-ppc'), LOOKUP_PACKAGE_ARCH('src'));
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-powerpc-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-powerpc-deb'), LOOKUP_PACKAGE_ARCH('powerpc-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-powerpc-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-arm-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-arm-deb'), LOOKUP_PACKAGE_ARCH('arm-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-arm-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-mips-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-mips-deb'), LOOKUP_PACKAGE_ARCH('mips-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-mips-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-sparc-sun-solaris'), LOOKUP_PACKAGE_ARCH('sparc-solaris'));
insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
diff --git a/schema/spacewalk/common/data/rhnPackageArch.sql b/schema/spacewalk/common/data/rhnPackageArch.sql
index 3f9ca79..0f04f72 100644
--- a/schema/spacewalk/common/data/rhnPackageArch.sql
+++ b/schema/spacewalk/common/data/rhnPackageArch.sql
@@ -95,6 +95,29 @@ insert into rhnPackageArch (id, label, name, arch_type_id) values
insert into rhnPackageArch (id, label, name, arch_type_id) values
(rhn_package_arch_id_seq.nextval, 'noarch-solaris-patch-cluster', 'noarch-solaris-patch-cluster', lookup_arch_type('sysv-solaris'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'all-deb', 'all-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'i386-deb', 'i386-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'alpha-deb', 'alpha-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'ia64-deb', 'ia64-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'sparc-deb', 'sparc-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'src-deb', 'src-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 's390-deb', 's390-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'powerpc-deb', 'powerpc-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'arm-deb', 'arm-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'mips-deb', 'mips-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'amd64-deb', 'AMD64-deb', lookup_arch_type('deb'));
+
commit;
--
diff --git a/schema/spacewalk/common/data/rhnServerArch.sql b/schema/spacewalk/common/data/rhnServerArch.sql
index b0a0cc6..ef341c5 100644
--- a/schema/spacewalk/common/data/rhnServerArch.sql
+++ b/schema/spacewalk/common/data/rhnServerArch.sql
@@ -17,56 +17,100 @@
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'i386-redhat-linux', 'i386', lookup_arch_type('rpm'));
insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'i386-debian-linux', 'i386 Debian', lookup_arch_type('deb'));
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'i486-redhat-linux', 'i486', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'i586-redhat-linux', 'i586', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'i686-redhat-linux', 'i686', lookup_arch_type('rpm'));
+
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'athlon-redhat-linux', 'athlon', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'alpha-redhat-linux', 'alpha', lookup_arch_type('rpm'));
insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'alpha-debian-linux', 'alpha Debian', lookup_arch_type('deb'));
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'alphaev6-redhat-linux', 'alphaev6', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'ia64-redhat-linux', 'ia64', lookup_arch_type('rpm'));
insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'ia64-debian-linux', 'ia64 Debian', lookup_arch_type('deb'));
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'sparc-redhat-linux', 'sparc', lookup_arch_type('rpm'));
insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'sparc-debian-linux', 'sparc Debian', lookup_arch_type('deb'));
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'sparcv9-redhat-linux', 'sparcv9', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'sparc64-redhat-linux', 'sparc64', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 's390-redhat-linux', 's390', lookup_arch_type('rpm'));
insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 's390-debian-linux', 's390 Debian', lookup_arch_type('deb'));
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 's390x-redhat-linux', 's390x', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'ppc-redhat-linux', 'ppc', lookup_arch_type('rpm'));
insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'powerpc-debian-linux', 'powerpc Debian', lookup_arch_type('deb'));
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'ppc64-redhat-linux', 'ppc64', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'pSeries-redhat-linux', 'pSeries', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'iSeries-redhat-linux', 'iSeries', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'x86_64-redhat-linux', 'x86_64', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'ppc64iseries-redhat-linux', 'ppc64iseries', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'ppc64pseries-redhat-linux', 'ppc64pseries', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'sparc-sun4m-solaris', 'Sparc Solaris', lookup_arch_type('sysv-solaris'));
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'sparc-sun4u-solaris', 'Sparc Solaris', lookup_arch_type('sysv-solaris'));
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'sparc-sun4v-solaris', 'Sparc Solaris', lookup_arch_type('sysv-solaris'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'ia32e-redhat-linux', 'EM64T', lookup_arch_type('rpm'));
+
insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'amd64-redhat-linux', 'AMD64', lookup_arch_type('rpm'));
insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'amd64-debian-linux', 'AMD64 Debian', lookup_arch_type('deb'));
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
(rhn_server_arch_id_seq.nextval, 'i386-i86pc-solaris', 'i386 Solaris', lookup_arch_type('sysv-solaris'));
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'arm-debian-linux', 'arm Debian', lookup_arch_type('deb'));
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'mips-debian-linux', 'mips Debian', lookup_arch_type('deb'));
+
commit;
--
diff --git a/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql b/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
index 7abd419..a49cfe1 100644
--- a/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
+++ b/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
@@ -26,6 +26,14 @@ insert into rhnServerPackageArchCompat
insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('i386-debian-linux'), LOOKUP_PACKAGE_ARCH('i386-deb'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('i386-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('i486-redhat-linux'), LOOKUP_PACKAGE_ARCH('i486'), 0);
insert into rhnServerPackageArchCompat
@@ -72,6 +80,7 @@ insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('i686-redhat-linux'), LOOKUP_PACKAGE_ARCH('noarch'), 1000);
+
insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('athlon-redhat-linux'), LOOKUP_PACKAGE_ARCH('athlon'), 0);
@@ -106,6 +115,14 @@ insert into rhnServerPackageArchCompat
insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('alpha-debian-linux'), LOOKUP_PACKAGE_ARCH('alpha-deb'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('alpha-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('alphaev6-redhat-linux'), LOOKUP_PACKAGE_ARCH('alphaev6'), 0);
insert into rhnServerPackageArchCompat
@@ -142,6 +159,18 @@ insert into rhnServerPackageArchCompat
insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('ia64-debian-linux'), LOOKUP_PACKAGE_ARCH('ia64-deb'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('ia64-debian-linux'), LOOKUP_PACKAGE_ARCH('i386-deb'), 100);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('ia64-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('sparc-redhat-linux'), LOOKUP_PACKAGE_ARCH('sparc'), 0);
insert into rhnServerPackageArchCompat
@@ -150,6 +179,14 @@ insert into rhnServerPackageArchCompat
insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('sparc-debian-linux'), LOOKUP_PACKAGE_ARCH('sparc-deb'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('sparc-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('sparcv9-redhat-linux'), LOOKUP_PACKAGE_ARCH('sparcv9'), 0);
insert into rhnServerPackageArchCompat
@@ -186,6 +223,14 @@ insert into rhnServerPackageArchCompat
insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('s390-debian-linux'), LOOKUP_PACKAGE_ARCH('s390-deb'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('s390-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('s390x-redhat-linux'), LOOKUP_PACKAGE_ARCH('s390x'), 0);
insert into rhnServerPackageArchCompat
@@ -196,6 +241,7 @@ insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('s390x-redhat-linux'), LOOKUP_PACKAGE_ARCH('noarch'), 1000);
+
insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('ppc-redhat-linux'), LOOKUP_PACKAGE_ARCH('ppc'), 0);
@@ -206,6 +252,30 @@ insert into rhnServerPackageArchCompat
insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('powerpc-debian-linux'), LOOKUP_PACKAGE_ARCH('powerpc-deb'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('powerpc-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('arm-debian-linux'), LOOKUP_PACKAGE_ARCH('arm-deb'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('arm-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('mips-debian-linux'), LOOKUP_PACKAGE_ARCH('mips-deb'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('mips-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('ppc64-redhat-linux'), LOOKUP_PACKAGE_ARCH('ppc64'), 0);
insert into rhnServerPackageArchCompat
@@ -310,6 +380,18 @@ insert into rhnServerPackageArchCompat
insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('amd64-debian-linux'), LOOKUP_PACKAGE_ARCH('amd64-deb'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('amd64-debian-linux'), LOOKUP_PACKAGE_ARCH('i386-deb'), 140);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('amd64-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('ia32e-redhat-linux'), LOOKUP_PACKAGE_ARCH('ia32e'), 0);
insert into rhnServerPackageArchCompat
@@ -340,6 +422,7 @@ insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('ia32e-redhat-linux'), LOOKUP_PACKAGE_ARCH('noarch'), 1000);
+
insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('ppc64iseries-redhat-linux'), LOOKUP_PACKAGE_ARCH('ppc64iseries'), 0);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-0.9/001-debian-support.sql b/schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-0.9/001-debian-support.sql
new file mode 100644
index 0000000..6216459
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-0.9/001-debian-support.sql
@@ -0,0 +1,217 @@
+--
+-- Add new rows for debian support
+--
+
+
+insert into rhnArchType (id, label, name) values
+ (rhn_archtype_id_seq.nextval, 'deb', 'DEB');
+
+commit;
+
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-ia32-deb', 'IA-32 Debian', lookup_arch_type('deb'));
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-ia64-deb', 'IA-64 Debian', lookup_arch_type('deb'));
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-sparc-deb', 'Sparc Debian', lookup_arch_type('deb'));
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-alpha-deb', 'Alpha Debian', lookup_arch_type('deb'));
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-s390-deb', 's390 Debian', lookup_arch_type('deb'));
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-x86_64-deb', 'x86_64 Debian', lookup_arch_type('deb'));
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-powerpc-deb', 'PowerPC Debian', lookup_arch_type('deb'));
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-arm-deb', 'arm Debian', lookup_arch_type('deb'));
+insert into rhnChannelArch (id, label, name, arch_type_id) values
+(rhn_channel_arch_id_seq.nextval, 'channel-mips-deb', 'mips Debian', lookup_arch_type('deb'));
+
+commit;
+
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'all-deb', 'all-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'i386-deb', 'i386-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'alpha-deb', 'alpha-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'ia64-deb', 'ia64-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'sparc-deb', 'sparc-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'src-deb', 'src-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 's390-deb', 's390-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'powerpc-deb', 'powerpc-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'arm-deb', 'arm-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'mips-deb', 'mips-deb', lookup_arch_type('deb'));
+insert into rhnPackageArch (id, label, name, arch_type_id) values
+(rhn_package_arch_id_seq.nextval, 'amd64-deb', 'AMD64-deb', lookup_arch_type('deb'));
+
+commit;
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia32-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia32-deb'), LOOKUP_PACKAGE_ARCH('i386-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia32-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia64-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia64-deb'), LOOKUP_PACKAGE_ARCH('i386-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia64-deb'), LOOKUP_PACKAGE_ARCH('ia64-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-ia64-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-sparc-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-sparc-deb'), LOOKUP_PACKAGE_ARCH('sparc-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-sparc-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-alpha-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-alpha-deb'), LOOKUP_PACKAGE_ARCH('alpha-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-alpha-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-s390-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-s390-deb'), LOOKUP_PACKAGE_ARCH('s390-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-s390-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-x86_64-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-x86_64-deb'), LOOKUP_PACKAGE_ARCH('i386-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-x86_64-deb'), LOOKUP_PACKAGE_ARCH('amd64-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-x86_64-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-powerpc-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-powerpc-deb'), LOOKUP_PACKAGE_ARCH('powerpc-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-powerpc-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-arm-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-arm-deb'), LOOKUP_PACKAGE_ARCH('arm-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-arm-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-mips-deb'), LOOKUP_PACKAGE_ARCH('all-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-mips-deb'), LOOKUP_PACKAGE_ARCH('mips-deb'));
+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
+values (LOOKUP_CHANNEL_ARCH('channel-mips-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
+
+commit;
+
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'i386-debian-linux', 'i386 Debian', lookup_arch_type('deb'));
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'alpha-debian-linux', 'alpha Debian', lookup_arch_type('deb'));
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'ia64-debian-linux', 'ia64 Debian', lookup_arch_type('deb'));
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'sparc-debian-linux', 'sparc Debian', lookup_arch_type('deb'));
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 's390-debian-linux', 's390 Debian', lookup_arch_type('deb'));
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'powerpc-debian-linux', 'powerpc Debian', lookup_arch_type('deb'));
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'amd64-debian-linux', 'AMD64 Debian', lookup_arch_type('deb'));
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'arm-debian-linux', 'arm Debian', lookup_arch_type('deb'));
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(rhn_server_arch_id_seq.nextval, 'mips-debian-linux', 'mips Debian', lookup_arch_type('deb'));
+
+commit;
+
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('i386-debian-linux'), LOOKUP_PACKAGE_ARCH('i386-deb'), 0);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('i386-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('alpha-debian-linux'), LOOKUP_PACKAGE_ARCH('alpha-deb'), 0);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('alpha-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('ia64-debian-linux'), LOOKUP_PACKAGE_ARCH('ia64-deb'), 0);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('ia64-debian-linux'), LOOKUP_PACKAGE_ARCH('i386-deb'), 100);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('ia64-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('sparc-debian-linux'), LOOKUP_PACKAGE_ARCH('sparc-deb'), 0);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('sparc-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('s390-debian-linux'), LOOKUP_PACKAGE_ARCH('s390-deb'), 0);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('s390-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('powerpc-debian-linux'), LOOKUP_PACKAGE_ARCH('powerpc-deb'), 0);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('powerpc-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('arm-debian-linux'), LOOKUP_PACKAGE_ARCH('arm-deb'), 0);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('arm-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('mips-debian-linux'), LOOKUP_PACKAGE_ARCH('mips-deb'), 0);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('mips-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('amd64-debian-linux'), LOOKUP_PACKAGE_ARCH('amd64-deb'), 0);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('amd64-debian-linux'), LOOKUP_PACKAGE_ARCH('i386-deb'), 140);
+insert into rhnServerPackageArchCompat
+ (server_arch_id, package_arch_id, preference) values
+ (LOOKUP_SERVER_ARCH('amd64-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
+
+commit;
14 years, 2 months