4 commits - rel-eng/packages schema/spacewalk

29 Nov 2013

rel-eng/packages/spacewalk-schema schema/spacewalk/common/data/rhnActionStatus.sql schema/spacewalk/common/data/rhnActionType.sql schema/spacewalk/common/data/rhnArchType.sql schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql schema/spacewalk/common/data/rhnChannelPermissionRole.sql schema/spacewalk/common/data/rhnConfigChannelType.sql schema/spacewalk/common/data/rhnConfigFileFailure.sql schema/spacewalk/common/data/rhnConfigFileState.sql schema/spacewalk/common/data/rhnConfigFileType.sql schema/spacewalk/common/data/rhnCpuArch.sql schema/spacewalk/common/data/rhnCryptoKeyType.sql schema/spacewalk/common/data/rhnErrataFileType.sql schema/spacewalk/common/data/rhnException.sql schema/spacewalk/common/data/rhnKickstartSessionState.sql schema/spacewalk/common/data/rhnOrgChannelSettingsType.sql schema/spacewalk/common/data/rhnOrgEntitlementType.sql schema/spacewalk/common/data/rhnPackageArch.sql schema/spacewalk/common/data/rhnPackageGroup.sql schema/spacewalk/common/data/rhnPackageKeyType.sql schema/spacewalk/common/data/rhnPackageSyncBlacklist.sql schema/spacewalk/common/data/rhnPushClientState.sql schema/spacewalk/common/data/rhnServerArch.sql schema/spacewalk/common/data/rhnServerChannelArchCompat.sql schema/spacewalk/common/data/rhnServerGroupType.sql schema/spacewalk/common/data/rhnServerPackageArchCompat.sql schema/spacewalk/common/data/rhnServerProfileType.sql schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql schema/spacewalk/common/data/rhnSnapshotInvalidReason.sql schema/spacewalk/common/data/rhnSolarisPatchType.sql schema/spacewalk/common/data/rhnTransactionOperation.sql schema/spacewalk/common/data/rhnUserGroupType.sql schema/spacewalk/common/data/rhnWebContactChangeState.sql schema/spacewalk/common/data/rhn_command.sql schema/spacewalk/common/data/rhn_command_class.sql schema/spacewalk/common/data/rhn_command_groups.sql schema/spacewalk/common/data/rhn_command_param_threshold.sql schema/spacewalk/common/data/rhn_command_parameter.sql schema/spacewalk/common/data/rhn_command_queue_commands.sql schema/spacewalk/common/data/rhn_command_requirements.sql schema/spacewalk/common/data/rhn_config_group.sql schema/spacewalk/common/data/rhn_config_macro.sql schema/spacewalk/common/data/rhn_config_parameter.sql schema/spacewalk/common/data/rhn_config_security_type.sql schema/spacewalk/common/data/rhn_method_types.sql schema/spacewalk/common/data/rhn_metrics.sql schema/spacewalk/common/data/rhn_notification_formats.sql schema/spacewalk/common/data/rhn_os.sql schema/spacewalk/common/data/rhn_os_commands_xref.sql schema/spacewalk/common/data/rhn_pager_types.sql schema/spacewalk/common/data/rhn_physical_location.sql schema/spacewalk/common/data/rhn_probe_types.sql schema/spacewalk/common/data/rhn_quanta.sql schema/spacewalk/common/data/rhn_redirect_match_types.sql schema/spacewalk/common/data/rhn_redirect_types.sql schema/spacewalk/common/data/rhn_schedule_types.sql schema/spacewalk/common/data/rhn_schedules.sql schema/spacewalk/common/data/rhn_semantic_data_type.sql schema/spacewalk/common/data/rhn_strategies.sql schema/spacewalk/common/data/rhn_threshold_type.sql schema/spacewalk/common/data/rhn_units.sql schema/spacewalk/common/data/rhn_widget.sql schema/spacewalk/common/data/web_user_site_type.sql schema/spacewalk/common/views/rhnUserAvailableChannels.sql schema/spacewalk/spacewalk-schema.spec schema/spacewalk/upgrade/spacewalk-schema-2.0-to-sp 66 files changed, 110 insertions(+), 1028

|    2 |    4 |   30 -- |   11 - |   34 --- |    6 |   15 - |   13 - |    5 |    7 |   22 -- |    5 |    9 |  101 ---------- |   25 -- |    9 |   16 - |   33 --- |    4 |    5 |    5 |    5 |   29 -- |    3 |   27 -- |   52 ++--- |    5 |   38 ++- |   22 -- |    1 |    9 |   25 -- |    3 |   30 -- |   19 - |   20 - |   31 --- |   16 - |   16 - |   22 -- |   16 - |    5 |   15 - |   13 - |   13 - |   19 - |   33 --- |   15 - |   24 -- |   13 - |    4 |   13 - |   13 - |   13 - |   13 - |   13 - |   14 - |   13 - |   20 - |   13 - |   13 - |   14 - |    7 |   18 - |    5 acewalk-schema-2.1/036-armv6hl.sql |   52 +++++ deletions(-)
New commits:
commit 10bca1df1bef1a86a8ba1203296efbceebb8810f
Author: Michael Mraka michael.mraka@redhat.com
Date:   Fri Nov 29 13:48:56 2013 +0100
Automatic commit of package [spacewalk-schema] release [2.1.29-1].

diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index dda92ad..03b9653 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-2.1.28-1 schema/spacewalk/
+2.1.29-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index 2b227cd..f594dcb 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.28
+Version:        2.1.29
 Release:        1%{?dist}
 Source0:        %{name}-%{version}.tar.gz
@@ -71,6 +71,9 @@ rm -rf $RPM_BUILD_ROOT
 %{_mandir}/man1/spacewalk-sql*
%changelog
+* Fri Nov 29 2013 Michael Mraka michael.mraka@redhat.com 2.1.29-1
+- 1034742 - support for new Raspberry Pi arch (armv6hl)
+
 * Tue Nov 26 2013 Milan Zazrivec mzazrivec@redhat.com 2.1.28-1
 - delete child channel references from rhnDistChannelMap
commit 83bc8c66881633184e9b372b0612ea6e4868dfe1
Author: Michael Mraka michael.mraka@redhat.com
Date:   Fri Nov 29 13:41:11 2013 +0100
removed old revision comments
diff --git a/schema/spacewalk/common/data/rhnActionStatus.sql b/schema/spacewalk/common/data/rhnActionStatus.sql
index 4626d6b..42b8308 100644
--- a/schema/spacewalk/common/data/rhnActionStatus.sql
+++ b/schema/spacewalk/common/data/rhnActionStatus.sql
@@ -24,7 +24,3 @@ insert into rhnActionStatus values (3, 'Failed', current_timestamp, current_time
commit;
---
--- Revision 1.1  2002/03/08 23:01:05  pjones
--- split imports out into seperate files
---
diff --git a/schema/spacewalk/common/data/rhnActionType.sql b/schema/spacewalk/common/data/rhnActionType.sql
index f07aa89..3ef1e0e 100644
--- a/schema/spacewalk/common/data/rhnActionType.sql
+++ b/schema/spacewalk/common/data/rhnActionType.sql
@@ -71,33 +71,3 @@ commit;
 insert into rhnActionType values (49, 'proxy.deactivate', 'Deactivate Proxy', 'N', 'N');
 insert into rhnActionType values (50, 'scap.xccdf_eval', 'OpenSCAP xccdf scanning', 'N', 'Y');
 insert into rhnActionType values (500, 'image.deploy', 'Deploy an image to a virtual host.', 'N', 'N');
---
---
--- Revision 1.25  2004/10/29 05:07:52  pjones
--- bugzilla: 136675 -- remove the new action type we created but aren't using
---
--- Revision 1.24  2004/09/23 16:38:02  pjones
--- bugzilla: 133354 -- fix Robin's engrish.
---
--- Revision 1.23  2004/09/23 14:20:08  pjones
--- bugzilla: 133354 -- add action type to support proxy activation
---
--- Revision 1.22  2004/04/13 16:40:31  bretm
--- bugzilla:  119871
---
--- action type for the applet+satellite scheduled action
---
--- Revision 1.21  2004/04/13 16:26:16  pjones
--- bugzilla: 101315 -- add action type entries for package verify
---
--- Revision 1.20  2004/03/16 19:51:43  misa
--- New action type rhnsd.configure
---
--- Revision 1.19  2004/03/03 16:52:47  pjones
--- bugzilla: none -- something went wrong tagging this, starting over.
---
--- Revision 1.18.2.1  2004/03/03 15:43:13  pjones
--- bugzilla: 117023 -- add solarispkgs.refresh_list
---
--- Revision 1.18  2004/02/17 00:22:59  pjones
--- bugzilla: 115898 -- add the action type for arbitrary scripts
diff --git a/schema/spacewalk/common/data/rhnArchType.sql b/schema/spacewalk/common/data/rhnArchType.sql
index 318abd8..cb126c5 100644
--- a/schema/spacewalk/common/data/rhnArchType.sql
+++ b/schema/spacewalk/common/data/rhnArchType.sql
@@ -30,14 +30,3 @@ insert into rhnArchType (id, label, name) values
    	'Solaris Patch Cluster');
 commit;
---
---
--- Revision 1.3  2004/02/13 20:47:23  pjones
--- bugzilla: none -- add solaris-patch-cluster
---
--- Revision 1.2  2004/02/09 20:55:04  pjones
--- bugzilla: none -- add rhnArchType for solaris patches
---
--- Revision 1.1  2004/02/05 17:33:12  pjones
--- bugzilla: 115009 -- rhnArchType is new, and has changes to go with it
---
diff --git a/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql b/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql
index 1e09632..8e5817c 100644
--- a/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql
+++ b/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql
@@ -370,37 +370,3 @@ insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
 values (LOOKUP_CHANNEL_ARCH('channel-sparc-sun-solaris'), LOOKUP_PACKAGE_ARCH('noarch-solaris-patch-cluster'));
commit;
---
--- Revision 1.11  2004/02/19 17:40:28  misa
--- Solaris patches
---
--- Revision 1.10  2004/02/18 23:41:04  pjones
--- bugzilla: 116188 -- ia32e
---
--- Revision 1.9  2004/02/13 14:38:50  misa
--- bugzilla: 115516  Arches and compat stuff for solaris patches
---
--- Revision 1.8  2004/02/06 02:21:16  misa
--- Weird solaris arches added
---
--- Revision 1.7  2003/07/23 18:47:53  misa
--- bugzilla: none  More compat mappings for ia64
---
--- Revision 1.6  2003/06/09 18:16:04  misa
--- bugzilla: 86150  Added the ppc64iseries and ppc64pseries arches, plus the channel-ppc channel arch
---
--- Revision 1.5  2003/01/30 16:46:06  misa
--- bugzilla: 83022  Doh. x86_64 is allowed in x86_64 channels
---
--- Revision 1.4  2003/01/29 17:52:22  misa
--- bugzilla: 78615  Re-generated the arch compat tables from webdev
---
--- Revision 1.3  2003/01/29 17:11:36  misa
--- bugzilla: 83022  Adding x86_64 as a supported arch
---
--- Revision 1.2  2002/11/14 18:00:59  pjones
--- commits
---
--- Revision 1.1  2002/11/14 17:03:48  misa
--- Populated table
---
diff --git a/schema/spacewalk/common/data/rhnChannelPermissionRole.sql b/schema/spacewalk/common/data/rhnChannelPermissionRole.sql
index dd917e0..cb7b58f 100644
--- a/schema/spacewalk/common/data/rhnChannelPermissionRole.sql
+++ b/schema/spacewalk/common/data/rhnChannelPermissionRole.sql
@@ -25,9 +25,3 @@ insert into rhnChannelPermissionRole (id, label, description)
    	'manage',
    	'Permission to manage channel');
---
--- Revision 1.1  2003/07/15 17:36:50  pjones
--- bugzilla: 98933
---
--- channel permissions
---
diff --git a/schema/spacewalk/common/data/rhnConfigChannelType.sql b/schema/spacewalk/common/data/rhnConfigChannelType.sql
index fce907d..6dcb7e0 100644
--- a/schema/spacewalk/common/data/rhnConfigChannelType.sql
+++ b/schema/spacewalk/common/data/rhnConfigChannelType.sql
@@ -29,18 +29,3 @@ insert into rhnConfigChannelType(id, label, name, priority) values (
    'Files imported from the server', 2);
commit;
---
---
--- Revision 1.3  2003/11/10 10:19:42  cturner
--- fix forgotten column when adding values
---
--- Revision 1.2  2003/11/09 20:50:38  cturner
--- toss priority back in... no idea if this is right or not. pjones, please berate me if not :)
---
--- Revision 1.1  2003/11/07 18:05:42  pjones
--- bugzilla: 109083
--- kill old config file schema (currently just an exclude except for
---   rhnConfigFile which is replaced)
--- exclude the snapshot stuff, and comment it from triggers and procs
--- more to come, but the basic config file stuff is in.
---
diff --git a/schema/spacewalk/common/data/rhnConfigFileFailure.sql b/schema/spacewalk/common/data/rhnConfigFileFailure.sql
index 8b163e7..a0351fd 100644
--- a/schema/spacewalk/common/data/rhnConfigFileFailure.sql
+++ b/schema/spacewalk/common/data/rhnConfigFileFailure.sql
@@ -33,16 +33,3 @@ insert into rhnConfigFileFailure (id, label, name) values
commit;
---
--- Revision 1.3  2004/01/07 18:05:37  bretm
--- bugzilla:  112901
---
--- new type of failure reason:  insufficient quota space
---
--- Revision 1.2  2003/11/17 14:37:44  misa
--- One more reason for a diff to fail: binary files
---
--- Revision 1.1  2003/11/15 01:45:33  misa
--- bugzilla: 107284  Schema for storing missing files
---
---
diff --git a/schema/spacewalk/common/data/rhnConfigFileState.sql b/schema/spacewalk/common/data/rhnConfigFileState.sql
index cb874f4..8c020bd 100644
--- a/schema/spacewalk/common/data/rhnConfigFileState.sql
+++ b/schema/spacewalk/common/data/rhnConfigFileState.sql
@@ -24,8 +24,3 @@ insert into rhnConfigFileState(id, label, name) values
commit;
---
---
--- Revision 1.1  2003/11/09 21:51:47  pjones
--- bugzilla: 109083 -- add data for rhnConfigFileState
---
diff --git a/schema/spacewalk/common/data/rhnConfigFileType.sql b/schema/spacewalk/common/data/rhnConfigFileType.sql
index 122980b..82a4805 100644
--- a/schema/spacewalk/common/data/rhnConfigFileType.sql
+++ b/schema/spacewalk/common/data/rhnConfigFileType.sql
@@ -20,10 +20,3 @@ insert into rhnConfigFileType values (1, 'file', 'File', current_timestamp, curr
 insert into rhnConfigFileType values (2, 'directory', 'Directory', current_timestamp, current_timestamp);
 insert into rhnConfigFileType values (3, 'symlink', 'Symlink', current_timestamp, current_timestamp);
---
---
--- Revision 1.2  2005/02/10 21:56:02  jslagle
--- Added documentation changes
---
---
-
diff --git a/schema/spacewalk/common/data/rhnCpuArch.sql b/schema/spacewalk/common/data/rhnCpuArch.sql
index e1970ff..b8c728b 100644
--- a/schema/spacewalk/common/data/rhnCpuArch.sql
+++ b/schema/spacewalk/common/data/rhnCpuArch.sql
@@ -74,23 +74,3 @@ insert into rhnCpuArch (id, label, name) values
 (sequence_nextval('rhn_cpu_arch_id_seq'), 'armv6hl', 'ARMv6hl');
 commit;
---
--- Revision 1.6  2004/05/11 18:29:40  pjones
--- bugzilla: none -- make EM64T and AMD64 registerable as such, and fix their
--- names while I'm at it.
---
--- Revision 1.5  2004/02/18 23:41:04  pjones
--- bugzilla: 116188 -- ia32e
---
--- Revision 1.4  2004/02/11 20:19:57  misa
--- New architectures for sun
---
--- Revision 1.3  2003/01/29 17:11:36  misa
--- bugzilla: 83022  Adding x86_64 as a supported arch
---
--- Revision 1.2  2002/11/14 18:00:59  pjones
--- commits
---
--- Revision 1.1  2002/11/14 16:35:08  misa
--- Populating the table
---
diff --git a/schema/spacewalk/common/data/rhnCryptoKeyType.sql b/schema/spacewalk/common/data/rhnCryptoKeyType.sql
index d789541..66d5715 100644
--- a/schema/spacewalk/common/data/rhnCryptoKeyType.sql
+++ b/schema/spacewalk/common/data/rhnCryptoKeyType.sql
@@ -23,8 +23,3 @@ insert into rhnCryptoKeyType(id, label, description) values
commit;
---
---
--- Revision 1.1  2003/11/13 15:29:17  pjones
--- bugzilla: 109896 -- add schema to hold cryptographic keys
---
diff --git a/schema/spacewalk/common/data/rhnErrataFileType.sql b/schema/spacewalk/common/data/rhnErrataFileType.sql
index 88b36a5..bb6c175 100644
--- a/schema/spacewalk/common/data/rhnErrataFileType.sql
+++ b/schema/spacewalk/common/data/rhnErrataFileType.sql
@@ -24,12 +24,3 @@ insert into rhnErrataFileType ( id, label )
 insert into rhnErrataFileType ( id, label )
    values ( sequence_nextval('rhn_erratafile_type_id_seq'), 'OVAL' );
-
---
--- Revision 1.1  2003/03/11 00:37:16  pjones
--- bugzilla: 85516
---
--- public errata schema checkin
---
--- bretm, you owe me cookies.
---
diff --git a/schema/spacewalk/common/data/rhnException.sql b/schema/spacewalk/common/data/rhnException.sql
index 026dd89..13e908f 100644
--- a/schema/spacewalk/common/data/rhnException.sql
+++ b/schema/spacewalk/common/data/rhnException.sql
@@ -121,104 +121,3 @@ insert into rhnException values (-20296, 'not_enough_flex_entitlements', 'You do
commit;
---
--- Revision 1.27  2004/08/10 16:36:17  pjones
--- bugzilla: 128589 -- exceptions for web
---
--- Revision 1.26  2004/07/02 22:18:29  pjones
--- bugzilla: none -- wrong id here...
---
--- Revision 1.25  2004/07/02 19:25:43  pjones
--- bugzilla: 125937 -- add exceptions for role maintanance.
---
--- Revision 1.24  2004/02/19 22:27:56  misa
--- Cannot entitle non-linux box to software manager
---
--- Revision 1.23  2004/02/19 22:19:29  pjones
--- bugzilla: 115896 -- don't let servers subscribe to services for which
--- their server arch is not compatible
---
--- Revision 1.22  2004/01/13 23:36:29  pjones
--- bugzilla: none -- put those exceptions here too
---
--- Revision 1.21  2003/12/19 22:07:30  pjones
--- bugzilla: 112392 -- quota support for config files
---
--- Revision 1.20  2003/10/17 17:08:43  pjones
--- bugzilla: 107172
--- rhn_server.remove_action(server_id_in, action_id_in) to dissociate
--- servers with actions
---
--- Revision 1.19  2003/10/07 20:49:18  pjones
--- bugzilla: 106188
---
--- snapshot invalidation
---
--- Revision 1.18  2003/09/19 22:35:07  pjones
--- bugzilla: none
---
--- provisioning and config management entitlement support
---
--- Revision 1.17  2003/07/21 17:50:31  pjones
--- bugzilla: none
---
--- channel permissions typo, new exception for rhn_channel
---
--- Revision 1.16  2003/07/09 16:29:33  cturner
--- update some strings and change lookup_transaction_package to throw an exception instead of SILENTLY RETURNING NULL
---
--- Revision 1.15  2003/07/07 12:03:21  misa
--- bugzilla: none  Fixing typo
---
--- Revision 1.14  2003/07/02 14:40:25  pjones
--- add -20260 (which already exists) to rhnException_data
--- fix the exception in the validation trigger on rhnServerGroupMembers
---   (a 2 year old bug last week...)
---
--- Revision 1.13  2003/05/08 21:24:26  pjones
--- and get the number in the exception right.
---
--- Revision 1.12  2003/03/11 00:37:16  pjones
--- bugzilla: 85516
---
--- public errata schema checkin
---
--- bretm, you owe me cookies.
---
--- Revision 1.11  2003/03/03 15:49:24  pjones
--- add cannot_delete_user
---
--- Revision 1.10  2003/02/12 21:06:26  pjones
--- add text for 'no_server_multiple_swmgr_entitlements'
---
--- Revision 1.9  2003/01/27 17:42:39  pjones
--- added 2 exceptions used by rhn_ep when granting channel entitlements
---
--- Revision 1.8  2003/01/10 16:28:09  pjones
--- add rhn_bel exceptions
---
--- Revision 1.7  2003/01/07 21:32:16  pjones
--- add the exception we raise in rhn_uemail_mod_trig
---
--- Revision 1.6  2002/11/21 22:08:11  pjones
--- make unsubscribe_channels have a "unsubscribe_children_in number := 0"
--- argument so that you can tell it to unsubscribe children.
---
--- Also, make it raise an exception instead of silent failure in the
--- other case.
---
--- Revision 1.5  2002/11/14 16:27:41  pjones
--- add exceptions for arch not found
---
--- Revision 1.4  2002/09/20 19:21:58  bretm
--- o  more 3rd party channel stuff...
---
--- Revision 1.3  2002/08/20 15:11:54  misa
--- Exception for arch not found.
---
--- Revision 1.2  2002/06/04 14:44:25  misa
--- Fixed typo
---
--- Revision 1.1  2002/03/08 23:01:05  pjones
--- split imports out into seperate files
---
diff --git a/schema/spacewalk/common/data/rhnKickstartSessionState.sql b/schema/spacewalk/common/data/rhnKickstartSessionState.sql
index 0331e4f..07b0d02 100644
--- a/schema/spacewalk/common/data/rhnKickstartSessionState.sql
+++ b/schema/spacewalk/common/data/rhnKickstartSessionState.sql
@@ -110,28 +110,3 @@ values (sequence_nextval('rhn_ks_session_state_id_seq'), 'Failed', 'failed',
commit;
---
---
--- Revision 1.7  2004/04/20 04:28:59  rnorwood
--- bugzilla: 113914 - add new kickstart session state.
---
--- Revision 1.6  2004/03/07 17:09:25  pjones
--- bugzilla: none -- add commit
---
--- Revision 1.5  2003/11/04 20:07:35  misa
--- bugzilla: 109062  Need another state and another action type
---
--- Revision 1.4  2003/10/14 15:24:38  rnorwood
--- bugzilla: 106063 - get rid of uniqueness of kickstart sessions - fail the old ones instead.
---
--- Revision 1.3  2003/10/08 19:23:09  pjones
--- bugzilla: none
---
--- change the constraint/trigger/sequence names again, this time less
--- consistant with everywhere else, but a lot more palitable
---
--- Revision 1.2  2003/10/08 18:51:44  pjones
--- bugzilla: none
---
--- Clean up the rhnKickstartSession stuff a bit.
---
diff --git a/schema/spacewalk/common/data/rhnOrgChannelSettingsType.sql b/schema/spacewalk/common/data/rhnOrgChannelSettingsType.sql
index d468c6b..737bafe 100644
--- a/schema/spacewalk/common/data/rhnOrgChannelSettingsType.sql
+++ b/schema/spacewalk/common/data/rhnOrgChannelSettingsType.sql
@@ -21,12 +21,3 @@ insert into rhnOrgChannelSettingsType ( id, label )
commit;
---
--- Revision 1.2  2003/07/25 18:18:52  cturner
--- missing reference to data for rhnOrgChannelSettingsType
---
--- Revision 1.1  2003/07/17 18:07:18  pjones
--- bugzilla: none
---
--- change this to be the new way which was discussed
---
diff --git a/schema/spacewalk/common/data/rhnOrgEntitlementType.sql b/schema/spacewalk/common/data/rhnOrgEntitlementType.sql
index 5f95f7c..ae38e78 100644
--- a/schema/spacewalk/common/data/rhnOrgEntitlementType.sql
+++ b/schema/spacewalk/common/data/rhnOrgEntitlementType.sql
@@ -50,19 +50,3 @@ insert into rhnOrgEntitlementType (id, label, name)
commit;
---
--- Revision 1.4  2004/02/19 20:17:50  pjones
--- bugzilla: 115896 -- add sgt and oet data for nonlinux, add
--- [un]set_customer_nonlinux
---
--- Revision 1.3  2003/09/19 22:35:07  pjones
--- bugzilla: none
---
--- provisioning and config management entitlement support
---
--- Revision 1.2  2002/07/29 21:03:38  rnorwood
--- Cleanup for messages on front page
---
--- Revision 1.1  2002/03/08 23:01:05  pjones
--- split imports out into seperate files
---
diff --git a/schema/spacewalk/common/data/rhnPackageArch.sql b/schema/spacewalk/common/data/rhnPackageArch.sql
index 672eb99..16dfc3a 100644
--- a/schema/spacewalk/common/data/rhnPackageArch.sql
+++ b/schema/spacewalk/common/data/rhnPackageArch.sql
@@ -130,36 +130,3 @@ insert into rhnPackageArch (id, label, name, arch_type_id) values
commit;
---
--- Revision 1.10  2004/05/11 18:29:40  pjones
--- bugzilla: none -- make EM64T and AMD64 registerable as such, and fix their
--- names while I'm at it.
---
--- Revision 1.9  2004/02/18 23:41:04  pjones
--- bugzilla: 116188 -- ia32e
---
--- Revision 1.8  2004/02/16 16:38:26  rnorwood
--- bugzilla: 115111 - package arch data for solaris-patch-cluster.
---
--- Revision 1.7  2004/02/13 14:38:50  misa
--- bugzilla: 115516  Arches and compat stuff for solaris patches
---
--- Revision 1.6  2004/02/06 02:21:16  misa
--- Weird solaris arches added
---
--- Revision 1.5  2004/02/05 17:33:12  pjones
--- bugzilla: 115009 -- rhnArchType is new, and has changes to go with it
---
--- Revision 1.4  2003/06/09 18:16:04  misa
--- bugzilla: 86150  Added the ppc64iseries and ppc64pseries arches, plus the channel-ppc channel arch
---
--- Revision 1.3  2003/01/29 17:11:36  misa
--- bugzilla: 83022  Adding x86_64 as a supported arch
---
--- Revision 1.2  2002/11/14 18:00:59  pjones
--- commits
---
--- Revision 1.1  2002/11/13 23:42:28  misa
--- Sequence; data to populate stuff
---
-
diff --git a/schema/spacewalk/common/data/rhnPackageGroup.sql b/schema/spacewalk/common/data/rhnPackageGroup.sql
index 90d1a27..fb82b4b 100644
--- a/schema/spacewalk/common/data/rhnPackageGroup.sql
+++ b/schema/spacewalk/common/data/rhnPackageGroup.sql
@@ -22,7 +22,3 @@ insert into rhnPackageGroup values (sequence_nextval('rhn_package_group_id_seq')
commit;
---
--- Revision 1.1  2002/03/08 23:01:05  pjones
--- split imports out into seperate files
---
diff --git a/schema/spacewalk/common/data/rhnPackageKeyType.sql b/schema/spacewalk/common/data/rhnPackageKeyType.sql
index 211dbae..04a5e94 100644
--- a/schema/spacewalk/common/data/rhnPackageKeyType.sql
+++ b/schema/spacewalk/common/data/rhnPackageKeyType.sql
@@ -27,8 +27,3 @@ insert into rhnPackageKeyType (id, label) values
commit;
---
--- Revision 1.1  2008/07/02 23:42:28  jsherrill
--- Sequence; data to populate stuff
---
-
diff --git a/schema/spacewalk/common/data/rhnPackageSyncBlacklist.sql b/schema/spacewalk/common/data/rhnPackageSyncBlacklist.sql
index bcc2ffd..ce6ea04 100644
--- a/schema/spacewalk/common/data/rhnPackageSyncBlacklist.sql
+++ b/schema/spacewalk/common/data/rhnPackageSyncBlacklist.sql
@@ -27,8 +27,3 @@ insert into rhnPackageSyncBlacklist (package_name_id)
commit;
---
---
--- Revision 1.1  2004/07/12 15:16:18  pjones
--- bugzilla: 126865 -- data for rhnPackageSyncBlacklist
---
diff --git a/schema/spacewalk/common/data/rhnPushClientState.sql b/schema/spacewalk/common/data/rhnPushClientState.sql
index 9c37e1e..f314b31 100644
--- a/schema/spacewalk/common/data/rhnPushClientState.sql
+++ b/schema/spacewalk/common/data/rhnPushClientState.sql
@@ -22,8 +22,3 @@ insert into rhnPushClientState (id, label, name)
     values (sequence_nextval('rhn_pclient_state_id_seq'), 'offline', 'offline');
commit;
---
---
--- Revision 1.1  2004/10/07 20:07:50  misa
--- Push client table changes
---
diff --git a/schema/spacewalk/common/data/rhnServerArch.sql b/schema/spacewalk/common/data/rhnServerArch.sql
index 1382115..de56229 100644
--- a/schema/spacewalk/common/data/rhnServerArch.sql
+++ b/schema/spacewalk/common/data/rhnServerArch.sql
@@ -126,29 +126,3 @@ insert into rhnServerArch (id, label, name, arch_type_id) values
commit;
---
--- Revision 1.8  2004/05/11 18:29:40  pjones
--- bugzilla: none -- make EM64T and AMD64 registerable as such, and fix their
--- names while I'm at it.
---
--- Revision 1.7  2004/02/18 23:41:04  pjones
--- bugzilla: 116188 -- ia32e.
---
--- Revision 1.6  2004/02/06 02:21:16  misa
--- Weird solaris arches added
---
--- Revision 1.5  2004/02/05 17:33:12  pjones
--- bugzilla: 115009 -- rhnArchType is new, and has changes to go with it
---
--- Revision 1.4  2003/06/09 18:16:04  misa
--- bugzilla: 86150  Added the ppc64iseries and ppc64pseries arches, plus the channel-ppc channel arch
---
--- Revision 1.3  2003/01/29 17:11:36  misa
--- bugzilla: 83022  Adding x86_64 as a supported arch
---
--- Revision 1.2  2002/11/14 18:00:59  pjones
--- commits
---
--- Revision 1.1  2002/11/13 22:30:53  misa
--- server arch stuff: added sequence and data
---
diff --git a/schema/spacewalk/common/data/rhnServerGroupType.sql b/schema/spacewalk/common/data/rhnServerGroupType.sql
index d6f18d1..9800dd5 100644
--- a/schema/spacewalk/common/data/rhnServerGroupType.sql
+++ b/schema/spacewalk/common/data/rhnServerGroupType.sql
@@ -75,30 +75,3 @@ insert into rhnServerGroupType ( id, label, name, permanent, is_base)
commit;
---
--- Revision 1.7  2004/05/25 21:41:48  pjones
--- bugzilla: 123639 -- monitoring SG type.
---
--- Revision 1.6  2004/02/19 20:17:50  pjones
--- bugzilla: 115896 -- add sgt and oet data for nonlinux, add
--- [un]set_customer_nonlinux
---
--- Revision 1.5  2003/09/24 15:40:37  pjones
--- bugzilla: 103233
---
--- changes for new names
---
--- Revision 1.4  2003/09/19 22:35:07  pjones
--- bugzilla: none
---
--- provisioning and config management entitlement support
---
--- Revision 1.3  2002/05/31 15:44:08  cturner
--- fix from last night
---
--- Revision 1.2  2002/05/23 20:20:51  cturner
--- remove old vestigal silly server group type
---
--- Revision 1.1  2002/03/08 23:01:05  pjones
--- split imports out into seperate files
---
diff --git a/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql b/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
index de32069..8a27e1b 100644
--- a/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
+++ b/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
@@ -639,34 +639,3 @@ insert into rhnServerPackageArchCompat
commit;
---
--- Revision 1.10  2004/02/19 00:13:11  pjones
--- bugzilla: 116188 -- ia32e/amd64 support that might actually work.
---
--- Revision 1.9  2004/02/18 23:41:04  pjones
--- bugzilla: 116188 -- ia32e
---
--- Revision 1.8  2004/02/13 14:38:50  misa
--- bugzilla: 115516  Arches and compat stuff for solaris patches
---
--- Revision 1.7  2004/02/06 02:21:16  misa
--- Weird solaris arches added
---
--- Revision 1.6  2003/07/23 18:47:53  misa
--- bugzilla: none  More compat mappings for ia64
---
--- Revision 1.5  2003/06/09 18:16:04  misa
--- bugzilla: 86150  Added the ppc64iseries and ppc64pseries arches, plus the channel-ppc channel arch
---
--- Revision 1.4  2003/01/29 17:52:22  misa
--- bugzilla: 78615  Re-generated the arch compat tables from webdev
---
--- Revision 1.3  2003/01/29 17:11:37  misa
--- bugzilla: 83022  Adding x86_64 as a supported arch
---
--- Revision 1.2  2002/11/14 18:00:59  pjones
--- commits
---
--- Revision 1.1  2002/11/14 01:06:09  misa
--- Populating the table
---
diff --git a/schema/spacewalk/common/data/rhnServerProfileType.sql b/schema/spacewalk/common/data/rhnServerProfileType.sql
index 1c7e2d4..27d584c 100644
--- a/schema/spacewalk/common/data/rhnServerProfileType.sql
+++ b/schema/spacewalk/common/data/rhnServerProfileType.sql
@@ -25,8 +25,3 @@ insert into rhnServerProfileType(id, label, name) values (
    'A server profile associated with a package sync');
commit;
---
---
--- Revision 1.1  2003/11/12 04:55:26  cturner
--- bugzilla: 109080, schema for server profile types
---
diff --git a/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql b/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql
index 5fc1f36..4abc44d 100644
--- a/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql
+++ b/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql
@@ -752,17 +752,3 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type)
commit;
---
---
--- Revision 1.3  2005/02/15 20:35:05  jslagle
--- bz #140447
--- Dropped column schedule_zone_id.
---
--- Revision 1.2  2004/05/11 18:29:40  pjones
--- bugzilla: none -- make EM64T and AMD64 registerable as such, and fix their
--- names while I'm at it.
---
--- Revision 1.1  2004/02/19 22:19:29  pjones
--- bugzilla: 115896 -- don't let servers subscribe to services for which
--- their server arch is not compatible
---
diff --git a/schema/spacewalk/common/data/rhnSnapshotInvalidReason.sql b/schema/spacewalk/common/data/rhnSnapshotInvalidReason.sql
index 80b4e00..4c12dab 100644
--- a/schema/spacewalk/common/data/rhnSnapshotInvalidReason.sql
+++ b/schema/spacewalk/common/data/rhnSnapshotInvalidReason.sql
@@ -42,25 +42,3 @@ insert into rhnSnapshotInvalidReason (id, label, name)
commit;
---
---
--- Revision 1.5  2004/03/22 19:51:47  pjones
--- bugzilla: none -- whitespace changes
---
--- Revision 1.4  2003/11/14 21:43:59  pjones
--- bugzilla: 110095 -- add cc_removed invalidation reason
---
--- Revision 1.3  2003/11/14 21:00:44  pjones
--- bugzilla: none -- snapshot invalid on config rev removal
---
--- Revision 1.2  2003/10/10 19:10:18  pjones
--- bugzilla: 106187
---
--- This implements snapshotting of namespaces.  Rolling them back to come
--- soon...
---
--- Revision 1.1  2003/10/07 20:49:18  pjones
--- bugzilla: 106188
---
--- snapshot invalidation
---
diff --git a/schema/spacewalk/common/data/rhnSolarisPatchType.sql b/schema/spacewalk/common/data/rhnSolarisPatchType.sql
index 8346875..1efa1c2 100644
--- a/schema/spacewalk/common/data/rhnSolarisPatchType.sql
+++ b/schema/spacewalk/common/data/rhnSolarisPatchType.sql
@@ -27,4 +27,3 @@ insert into rhnSolarisPatchType (id, name, label)
 insert into rhnSolarisPatchType (id, name, label)
    values (sequence_nextval('rhn_solaris_pt_seq'), 'Nonstandard Patch', 'nonstandard');
---
diff --git a/schema/spacewalk/common/data/rhnTransactionOperation.sql b/schema/spacewalk/common/data/rhnTransactionOperation.sql
index d2b63d9..dd9a00b 100644
--- a/schema/spacewalk/common/data/rhnTransactionOperation.sql
+++ b/schema/spacewalk/common/data/rhnTransactionOperation.sql
@@ -21,12 +21,3 @@ insert into rhnTransactionOperation (id, label) values (1,'insert');
 insert into rhnTransactionOperation (id, label) values (2,'delete');
 insert into rhnTransactionOperation (id, label) values (3,'upgrade');
---
--- Revision 1.2  2003/07/02 21:33:28  pjones
--- bugzilla: none
---
--- add "upgrade" transaction type
---
--- Revision 1.1  2002/09/25 19:21:36  pjones
--- more of the transaction changes
---
diff --git a/schema/spacewalk/common/data/rhnUserGroupType.sql b/schema/spacewalk/common/data/rhnUserGroupType.sql
index be981d7..a5f216a 100644
--- a/schema/spacewalk/common/data/rhnUserGroupType.sql
+++ b/schema/spacewalk/common/data/rhnUserGroupType.sql
@@ -61,28 +61,3 @@ insert into rhnUserGroupType (id, label, name) values (
commit;
---
--- Revision 1.8  2004/07/09 18:39:00  pjones
--- bugzilla: 126751 -- cert admin
---
--- Revision 1.7  2004/06/22 16:05:05  pjones
--- bugzilla: 126461 -- add user groups for new roles
---
--- Revision 1.6  2004/06/21 16:56:21  pjones
--- bugzilla: 125648 -- user group role.
---
--- Revision 1.5  2004/04/16 12:29:54  misa
--- Removing duplicates to make nightly builds happy
---
--- Revision 1.4  2004/04/15 21:18:20  pjones
--- bugzilla: 118940 -- fix user group type names to be consistent.
---
--- Revision 1.3  2003/08/21 02:20:32  rnorwood
--- bugzilla: 102046 - SQL changes for config admin role.
---
--- Revision 1.2  2002/09/05 22:47:40  cturner
--- sql for support entitlement
---
--- Revision 1.1  2002/03/08 23:01:05  pjones
--- split imports out into seperate files
---
diff --git a/schema/spacewalk/common/data/rhnWebContactChangeState.sql b/schema/spacewalk/common/data/rhnWebContactChangeState.sql
index b41a87a..d720a4a 100644
--- a/schema/spacewalk/common/data/rhnWebContactChangeState.sql
+++ b/schema/spacewalk/common/data/rhnWebContactChangeState.sql
@@ -18,6 +18,3 @@
 insert into rhnWebContactChangeState (id, label) values (sequence_nextval('rhn_wcon_change_state_seq'), 'enabled');
 insert into rhnWebContactChangeState (id, label) values (sequence_nextval('rhn_wcon_change_state_seq'), 'disabled');
---
---
---
diff --git a/schema/spacewalk/common/data/rhn_command.sql b/schema/spacewalk/common/data/rhn_command.sql
index b716d97..09ebdccc 100644
--- a/schema/spacewalk/common/data/rhn_command.sql
+++ b/schema/spacewalk/common/data/rhn_command.sql
@@ -414,33 +414,3 @@ command_class,enabled,for_host_probe,last_update_user,last_update_date,system_re
 commit;
---
---Revision 1.9  2004/11/15 23:18:13  nhansen
---bug 138411: Drop the Check Alive probe.
---
---Revision 1.8  2004/08/02 22:14:10  dfaraldo
---Changed 'Unix' command group to 'Linux'. -dfaraldo
---
---Revision 1.7  2004/07/26 16:01:43  nhansen
---bug 128448: Drop the SNMP TrapReciever check from the command list for the triumph beta
---
---Revision 1.6  2004/07/23 22:25:56  dfaraldo
---Removed current state push probe (now part of the scheduler). -dfaraldo
---
---Revision 1.5  2004/06/17 20:25:18  kja
---bugzilla 124620 -- Include only approved probes.  Fixed data referential
---integrity errors.  Only approved operating systems.
---
---Revision 1.4  2004/06/09 17:22:06  nhansen
---bug 124620: changes for command and command_groups tables (sql and xml) for probes
---that will be supported in the rhn350 release.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/23 18:27:47  kja
---More reference table data.
---
diff --git a/schema/spacewalk/common/data/rhn_command_class.sql b/schema/spacewalk/common/data/rhn_command_class.sql
index 1857ec4..2589242 100644
--- a/schema/spacewalk/common/data/rhn_command_class.sql
+++ b/schema/spacewalk/common/data/rhn_command_class.sql
@@ -157,22 +157,3 @@ insert into rhn_command_class(class_name)
     values ( 'Unix::ProcessRunning');
 commit;
---
---Revision 1.6  2004/11/15 23:18:13  nhansen
---bug 138411: Drop the Check Alive probe.
---
---Revision 1.5  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.4  2004/06/09 17:59:38  nhansen
---bug 124620: removed unused command_class entries
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 20:27:40  kja
---More reference table data.
---
diff --git a/schema/spacewalk/common/data/rhn_command_groups.sql b/schema/spacewalk/common/data/rhn_command_groups.sql
index 048091a..4a34dfd 100644
--- a/schema/spacewalk/common/data/rhn_command_groups.sql
+++ b/schema/spacewalk/common/data/rhn_command_groups.sql
@@ -42,23 +42,3 @@ insert into rhn_command_groups(group_name,description)
     values ( 'tools','General');
 commit;
---
---Revision 1.6  2004/08/02 22:14:10  dfaraldo
---Changed 'Unix' command group to 'Linux'. -dfaraldo
---
---Revision 1.5  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.4  2004/06/09 17:22:06  nhansen
---bug 124620: changes for command and command_groups tables (sql and xml) for probes
---that will be supported in the rhn350 release.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 20:27:40  kja
---More reference table data.
---
diff --git a/schema/spacewalk/common/data/rhn_command_param_threshold.sql b/schema/spacewalk/common/data/rhn_command_param_threshold.sql
index 6f52767..20e3c37 100644
--- a/schema/spacewalk/common/data/rhn_command_param_threshold.sql
+++ b/schema/spacewalk/common/data/rhn_command_param_threshold.sql
@@ -1235,34 +1235,3 @@ command_class)
commit;
-
---
---Revision 1.8  2004/12/07 20:34:09  cturner
---bugzilla: 141999, fix bad data
---
---Revision 1.7  2004/11/18 21:48:57  nhansen
---bug 136828: fix typo
---
---Revision 1.6  2004/11/18 21:29:03  nhansen
---bug 136828: sql changes and xml change script to add the needed command_paramter_threshold entries
---and update to current params to support thresholding on some satellite probe metrics
---
---Revision 1.5  2004/11/16 14:39:51  nhansen
---bug 138411: remove check alive param threshold entries
---
---Revision 1.4  2004/06/17 20:25:18  kja
---bugzilla 124620 -- Include only approved probes.  Fixed data referential
---integrity errors.  Only approved operating systems.
---
---Revision 1.3  2004/06/09 19:32:33  nhansen
---bug 124620: drop unneeded command_param_threshold data for rhn350
---
---Revision 1.2  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.1  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 20:27:40  kja
---More reference table data.
---
diff --git a/schema/spacewalk/common/data/rhn_command_parameter.sql b/schema/spacewalk/common/data/rhn_command_parameter.sql
index dfd3e88..c8d9f70 100644
--- a/schema/spacewalk/common/data/rhn_command_parameter.sql
+++ b/schema/spacewalk/common/data/rhn_command_parameter.sql
@@ -3670,19 +3670,3 @@ field_visible,default_value_visible,last_update_user,last_update_date)
commit;
-
---Revision 1.5  2004/06/09 19:11:35  system
---bug 124620: pull out all unneeded rhn_command_parameters
---
---Revision 1.4  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.3  2004/05/21 18:44:41  system
---default DNS lookuphost should be www.redhat.com
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 20:27:40  kja
---More reference table data.
---
diff --git a/schema/spacewalk/common/data/rhn_command_queue_commands.sql b/schema/spacewalk/common/data/rhn_command_queue_commands.sql
index 6a3b387..bb508e5 100644
--- a/schema/spacewalk/common/data/rhn_command_queue_commands.sql
+++ b/schema/spacewalk/common/data/rhn_command_queue_commands.sql
@@ -40,19 +40,3 @@ last_update_date)
 sequence_nextval('rhn_command_q_comm_recid_seq'),'ANY command as nocpulse','Enter any command - it will run as the nocpulse user','%s','1','0','nocpulse','nocpulse','system',current_timestamp);
 commit;
---
---Revision 1.5  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.4  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.3  2004/05/28 19:44:56  pjones
---bugzilla: none -- make it use right schema names...
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/23 18:27:47  kja
---More reference table data.
---
diff --git a/schema/spacewalk/common/data/rhn_command_requirements.sql b/schema/spacewalk/common/data/rhn_command_requirements.sql
index 4753671..f283eb4 100644
--- a/schema/spacewalk/common/data/rhn_command_requirements.sql
+++ b/schema/spacewalk/common/data/rhn_command_requirements.sql
@@ -46,25 +46,3 @@ insert into rhn_command_requirements(name,description)
commit;
---
---Revision 1.7  2004/06/22 18:01:26  nhansen
---bug 126498: replace Command Center Daemon refrences with RHNMD
---
---Revision 1.6  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.5  2004/06/09 19:10:36  nhansen
---bug 124620: put the commit back
---
---Revision 1.4  2004/06/09 17:35:36  nhansen
---bug 124620: pulled out unused command_requirements data that won't be used for rhn monitoring
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_config_group.sql b/schema/spacewalk/common/data/rhn_config_group.sql
index 5835374..8f16d5a 100644
--- a/schema/spacewalk/common/data/rhn_config_group.sql
+++ b/schema/spacewalk/common/data/rhn_config_group.sql
@@ -78,19 +78,3 @@ insert into rhn_config_group(name,description)
     values ( 'ProbeFramework','Probe framework configuration');
 commit;
---
---Revision 1.5  2004/07/16 21:51:32  dfaraldo
---Added ProbeFramework section and data. -dfaraldo
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_config_macro.sql b/schema/spacewalk/common/data/rhn_config_macro.sql
index 36cbfe4..89c7923 100644
--- a/schema/spacewalk/common/data/rhn_config_macro.sql
+++ b/schema/spacewalk/common/data/rhn_config_macro.sql
@@ -67,8 +67,3 @@ insert into rhn_config_macro(name,definition,description,editable,last_update_us
 insert into rhn_config_macro(name,definition,description,editable,last_update_user,last_update_date)     values ( 'USER', 'nocpulse', 'Production user', '0', 'system',current_timestamp);
 insert into rhn_config_macro(name,definition,description,editable,last_update_user,last_update_date)     values ( 'XPROTO', '**XPROTO**', 'External protocol (''http'' or ''https'')', '1', 'system',current_timestamp);
---
---Revision 1.7  2004/07/15 00:54:11  dfaraldo
---New RHN_CONFIG_MACRO and RHN_CONFIG_PARAMETER static data for the
---combined satellite.
---
diff --git a/schema/spacewalk/common/data/rhn_config_parameter.sql b/schema/spacewalk/common/data/rhn_config_parameter.sql
index a1c0bce..c26c253 100644
--- a/schema/spacewalk/common/data/rhn_config_parameter.sql
+++ b/schema/spacewalk/common/data/rhn_config_parameter.sql
@@ -200,18 +200,3 @@ insert into rhn_config_parameter(group_name,name,value,security_type,last_update
 insert into rhn_config_parameter(group_name,name,value,security_type,last_update_user,last_update_date) values ( 'trapReceiver', 'trapdir', '%{NPLIB}/trapReceiver/traps', 'ALL', 'system',current_timestamp);
 insert into rhn_config_parameter(group_name,name,value,security_type,last_update_user,last_update_date) values ( 'ts_db', 'url', '%{TSDBURL}', 'INTERNAL', 'system',current_timestamp);
---
---Revision 1.9  2004/10/29 15:19:34  kja
---Bugzilla 137559: Changing the from name on the monitoring notification email message.
---
---Revision 1.8  2004/07/21 00:21:34  dfaraldo
---Moved TSDBLocalQueue log files to /var/log/nocpulse/TSDBLocalQueue
---(a directory writable by apache). -dfaraldo
---
---Revision 1.7  2004/07/16 21:51:32  dfaraldo
---Added ProbeFramework section and data. -dfaraldo
---
---Revision 1.6  2004/07/15 00:54:11  dfaraldo
---New RHN_CONFIG_MACRO and RHN_CONFIG_PARAMETER static data for the
---combined satellite.
---
diff --git a/schema/spacewalk/common/data/rhn_config_security_type.sql b/schema/spacewalk/common/data/rhn_config_security_type.sql
index 6cfb318..05821e9 100644
--- a/schema/spacewalk/common/data/rhn_config_security_type.sql
+++ b/schema/spacewalk/common/data/rhn_config_security_type.sql
@@ -28,16 +28,3 @@ insert into rhn_config_security_type(name,description)
     values ( 'ALL','All security levels');
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_method_types.sql b/schema/spacewalk/common/data/rhn_method_types.sql
index 59e3a54..922d16e 100644
--- a/schema/spacewalk/common/data/rhn_method_types.sql
+++ b/schema/spacewalk/common/data/rhn_method_types.sql
@@ -30,16 +30,3 @@ insert into rhn_method_types(recid,method_type_name,notification_format_id)
     values ( 5,'SNMP',4);
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_metrics.sql b/schema/spacewalk/common/data/rhn_metrics.sql
index 4bc61a1..ed0175a 100644
--- a/schema/spacewalk/common/data/rhn_metrics.sql
+++ b/schema/spacewalk/common/data/rhn_metrics.sql
@@ -124,22 +124,3 @@ insert into rhn_metrics(metric_id,storage_unit_id,description,last_update_user,l
commit;
-
---
---Revision 1.5  2004/11/16 14:25:23  nhansen
---bug 138411: need to drop metrics for the check alive as well
---
---Revision 1.4  2004/06/17 20:25:18  kja
---bugzilla 124620 -- Include only approved probes.  Fixed data referential
---integrity errors.  Only approved operating systems.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none 
--- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/23 18:27:47  kja
---More reference table data.
---
diff --git a/schema/spacewalk/common/data/rhn_notification_formats.sql b/schema/spacewalk/common/data/rhn_notification_formats.sql
index 4bfeb86..c0434a3 100644
--- a/schema/spacewalk/common/data/rhn_notification_formats.sql
+++ b/schema/spacewalk/common/data/rhn_notification_formats.sql
@@ -40,36 +40,3 @@ subject_format,body_format,max_subject_length,max_body_length,reply_format)
     values ( sequence_nextval('rhn_ntfmt_recid_seq'),NULL,'Pager Default (3.6)',NULL,'^[probe state]: ^[hostname]: ^[probe description] at ^[timestamp:"%H:%M %Z"], notification ^[alert id]',0,200,NULL);
 commit;
---
---Revision 1.10  2005/02/15 21:40:35  jslagle
---bz #141966
---Improve notification format
---
---Revision 1.9  2004/12/01 15:10:43  kja
---Bugzilla 137559: Replace "Red Hat Command Center" with "Spacewalk Monitoring Satellite."
---
---Revision 1.8  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.7  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.6  2004/05/28 19:44:56  pjones
---bugzilla: none -- make it use right schema names...
---
---Revision 1.5  2004/05/06 17:35:10  kja
---More syntax/identifier length changes.
---
---Revision 1.4  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.3  2004/04/22 19:05:45  kja
---Added the 24 x 7 schedule data.  Corrected logic for skipping sequence numbers
---in rhn_notification_formats_data.sql and rhn_strategies_data.sql.
---
---Revision 1.2  2004/04/22 17:53:18  kja
---Changed NOCpulse to Red Hat.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_os.sql b/schema/spacewalk/common/data/rhn_os.sql
index 9d25522..ac547e3 100644
--- a/schema/spacewalk/common/data/rhn_os.sql
+++ b/schema/spacewalk/common/data/rhn_os.sql
@@ -27,18 +27,3 @@ insert into rhn_os(recid,os_name)
commit;
-
---
---Revision 1.4  2004/06/17 20:25:18  kja
---bugzilla 124620 -- Include only approved probes.  Fixed data referential
---integrity errors.  Only approved operating systems.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_os_commands_xref.sql b/schema/spacewalk/common/data/rhn_os_commands_xref.sql
index e47613d..ca1af8b 100644
--- a/schema/spacewalk/common/data/rhn_os_commands_xref.sql
+++ b/schema/spacewalk/common/data/rhn_os_commands_xref.sql
@@ -125,27 +125,3 @@ insert into rhn_os_commands_xref(os_id,commands_id) values ( 4,304);
commit;
-
---
---Revision 1.7  2004/11/15 23:18:13  nhansen
---bug 138411: Drop the Check Alive probe.
---
---Revision 1.6  2004/07/26 16:01:43  nhansen
---bug 128448: Drop the SNMP TrapReciever check from the command list for the triumph beta
---
---Revision 1.5  2004/07/23 22:41:12  dfaraldo
---Removed current state push probe (now part of the scheduler). -dfaraldo
---
---Revision 1.4  2004/06/17 20:25:18  kja
---bugzilla 124620 -- Include only approved probes.  Fixed data referential
---integrity errors.  Only approved operating systems.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/23 18:27:47  kja
---More reference table data.
---
diff --git a/schema/spacewalk/common/data/rhn_pager_types.sql b/schema/spacewalk/common/data/rhn_pager_types.sql
index 4afcdc0..96d1929 100644
--- a/schema/spacewalk/common/data/rhn_pager_types.sql
+++ b/schema/spacewalk/common/data/rhn_pager_types.sql
@@ -22,16 +22,3 @@ insert into rhn_pager_types(recid,pager_type_name)
     values ( sequence_nextval('rhn_pager_types_recid_seq'),'All pager types');
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/23 18:27:47  kja
---More reference table data.
---
diff --git a/schema/spacewalk/common/data/rhn_physical_location.sql b/schema/spacewalk/common/data/rhn_physical_location.sql
index e8fd795..9c83029 100644
--- a/schema/spacewalk/common/data/rhn_physical_location.sql
+++ b/schema/spacewalk/common/data/rhn_physical_location.sql
@@ -21,7 +21,3 @@ insert into rhn_physical_location(recid, location_name, last_update_user, last_u
commit;
---
---Revision 1.1  2004/06/22 02:35:10  kja
---bugzilla 126462 -- create dummy physical_location data
---
diff --git a/schema/spacewalk/common/data/rhn_probe_types.sql b/schema/spacewalk/common/data/rhn_probe_types.sql
index 6dc2020..97b6964 100644
--- a/schema/spacewalk/common/data/rhn_probe_types.sql
+++ b/schema/spacewalk/common/data/rhn_probe_types.sql
@@ -36,16 +36,3 @@ insert into rhn_probe_types(probe_type,type_description)
     values ( 'suite','Check Suite Probe');
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_quanta.sql b/schema/spacewalk/common/data/rhn_quanta.sql
index 22177a0..fcd5603 100644
--- a/schema/spacewalk/common/data/rhn_quanta.sql
+++ b/schema/spacewalk/common/data/rhn_quanta.sql
@@ -74,16 +74,3 @@ last_update_date)
     'system',current_timestamp);
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_redirect_match_types.sql b/schema/spacewalk/common/data/rhn_redirect_match_types.sql
index 6347405..1ba09b8 100644
--- a/schema/spacewalk/common/data/rhn_redirect_match_types.sql
+++ b/schema/spacewalk/common/data/rhn_redirect_match_types.sql
@@ -42,16 +42,3 @@ insert into rhn_redirect_match_types(name)
     values ( 'CUSTOMER_ID');
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_redirect_types.sql b/schema/spacewalk/common/data/rhn_redirect_types.sql
index 4920a72..15e4e5a 100644
--- a/schema/spacewalk/common/data/rhn_redirect_types.sql
+++ b/schema/spacewalk/common/data/rhn_redirect_types.sql
@@ -30,16 +30,3 @@ insert into rhn_redirect_types(name,description,long_name)
     values ( 'REDIR','Specify a destination for matching alerts (overrides default recipient list)','Redirect Standard Notifications');
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_schedule_types.sql b/schema/spacewalk/common/data/rhn_schedule_types.sql
index c28832c..80ea895 100644
--- a/schema/spacewalk/common/data/rhn_schedule_types.sql
+++ b/schema/spacewalk/common/data/rhn_schedule_types.sql
@@ -28,16 +28,3 @@ insert into rhn_schedule_types(recid,description)
     values ( 3,'Rotation of Weeklies');
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_schedules.sql b/schema/spacewalk/common/data/rhn_schedules.sql
index 7a6a9ac..5b2c8a5 100644
--- a/schema/spacewalk/common/data/rhn_schedules.sql
+++ b/schema/spacewalk/common/data/rhn_schedules.sql
@@ -26,17 +26,3 @@ last_update_date,customer_id)
     values ( sequence_nextval('rhn_schedules_recid_seq'),1,'24x7','system',current_timestamp,NULL);
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 19:05:45  kja
---Added the 24 x 7 schedule data.  Corrected logic for skipping sequence numbers
---in rhn_notification_formats_data.sql and rhn_strategies_data.sql.
---
diff --git a/schema/spacewalk/common/data/rhn_semantic_data_type.sql b/schema/spacewalk/common/data/rhn_semantic_data_type.sql
index f93997c..6c44234 100644
--- a/schema/spacewalk/common/data/rhn_semantic_data_type.sql
+++ b/schema/spacewalk/common/data/rhn_semantic_data_type.sql
@@ -50,16 +50,3 @@ help_file,last_update_user,last_update_date)
     NULL,'system',current_timestamp);
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_strategies.sql b/schema/spacewalk/common/data/rhn_strategies.sql
index 9adb2a9..479b59b 100644
--- a/schema/spacewalk/common/data/rhn_strategies.sql
+++ b/schema/spacewalk/common/data/rhn_strategies.sql
@@ -56,23 +56,3 @@ ack_completed)
     'Sent>0','Failed>0|Incomplete>0','Escalate','No');
 commit;
---
---Revision 1.6  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.5  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.4  2004/05/28 22:25:50  pjones
---bugzilla: none -- no comments after ;, they don't work.
---
---Revision 1.3  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.2  2004/04/22 19:05:45  kja
---Added the 24 x 7 schedule data.  Corrected logic for skipping sequence numbers
---in rhn_notification_formats_data.sql and rhn_strategies_data.sql.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_threshold_type.sql b/schema/spacewalk/common/data/rhn_threshold_type.sql
index 27ba248..25dc810 100644
--- a/schema/spacewalk/common/data/rhn_threshold_type.sql
+++ b/schema/spacewalk/common/data/rhn_threshold_type.sql
@@ -34,16 +34,3 @@ last_update_date)
     values ( 'crit_max','Maximum',30,'system',current_timestamp);
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_units.sql b/schema/spacewalk/common/data/rhn_units.sql
index 859ecc9..38ab311 100644
--- a/schema/spacewalk/common/data/rhn_units.sql
+++ b/schema/spacewalk/common/data/rhn_units.sql
@@ -196,16 +196,3 @@ to_base_unit_fn,from_base_unit_fn,validate_fn,last_update_user,last_update_date)
     'x','x','is_number(x) and x >= 0','system',current_timestamp);
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
diff --git a/schema/spacewalk/common/data/rhn_widget.sql b/schema/spacewalk/common/data/rhn_widget.sql
index d4e0e00..cc892b0 100644
--- a/schema/spacewalk/common/data/rhn_widget.sql
+++ b/schema/spacewalk/common/data/rhn_widget.sql
@@ -28,17 +28,3 @@ insert into rhn_widget(name,description,last_update_user,last_update_date)
     values ( 'checkbox','Checkbox','system',current_timestamp);
 commit;
---
---Revision 1.4  2004/06/17 20:48:59  kja
---bugzilla 124970 -- _data is in for 350.
---
---Revision 1.3  2004/05/29 21:51:49  pjones
---bugzilla: none -- _data is not for 340, so says kja.
---
---Revision 1.2  2004/05/04 20:03:38  kja
---Added commits.
---
---Revision 1.1  2004/04/22 17:49:49  kja
---Added data for the reference tables.
---
-
diff --git a/schema/spacewalk/common/data/web_user_site_type.sql b/schema/spacewalk/common/data/web_user_site_type.sql
index 5e0fa29..2e3b96b 100644
--- a/schema/spacewalk/common/data/web_user_site_type.sql
+++ b/schema/spacewalk/common/data/web_user_site_type.sql
@@ -18,10 +18,3 @@ insert into WEB_USER_SITE_TYPE VALUES('B', 'BILL_TO');
 insert into WEB_USER_SITE_TYPE VALUES('S', 'SHIP_TO');
 insert into WEB_USER_SITE_TYPE VALUES('R', 'SERVICE');
---
--- Revision 1.2  2002/05/09 05:37:31  gafton
--- re-unify again
---
--- Revision 1.1  2002/02/13 16:20:43  pjones
--- commit these here
---
diff --git a/schema/spacewalk/common/views/rhnUserAvailableChannels.sql b/schema/spacewalk/common/views/rhnUserAvailableChannels.sql
index 27ce148..6ac6a00 100644
--- a/schema/spacewalk/common/views/rhnUserAvailableChannels.sql
+++ b/schema/spacewalk/common/views/rhnUserAvailableChannels.sql
@@ -63,21 +63,3 @@ where rhn_channel.org_channel_setting(ct.id, ct.org_id ,'not_globally_subscribab
                                 OR rhn_user.check_role(ct.user_id, 'channel_admin') = 1)
 ;
---
---
--- Revision 1.8 2008/03/26 mmccune
--- bugzilla: 439023 - making sure org and channel admins can view the channels in their org
---
--- Revision 1.7	2007/10/25 jsherrill
--- bugzilla:172796 -- modified query to obey  user channel permissions in the 
---	rhnChannelPermission table if a channel is not globally subscribable
---
--- Revision 1.6  2004/04/15 16:04:21  pjones
--- bugzilla: none -- add deps, make rhnUserAvailableChannels show org_id
---
--- Revision 1.5  2004/04/15 15:47:46  pjones
--- bugzilla: none -- make rhnUserAvailableChannels suck way less
---
--- Revision 1.4  2004/04/14 00:09:24  pjones
--- bugzilla: 120761 -- split rhnChannelPermissions into two tables, eliminating
--- a frequent full table scan
commit 18d44b300cf14ca32d689cbc74a4113fb2f75ec8
Author: Michael Mraka michael.mraka@redhat.com
Date:   Fri Nov 29 13:22:57 2013 +0100
1034742 - schema upgrade for armv6hl arch
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/036-armv6hl.sql b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/036-armv6hl.sql
new file mode 100644
index 0000000..e1fa8ef
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-2.0-to-spacewalk-schema-2.1/036-armv6hl.sql
@@ -0,0 +1,52 @@
+insert into rhnCpuArch (id, label, name) values
+(sequence_nextval('rhn_cpu_arch_id_seq'), 'armv6hl', 'ARMv6hl');
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
+(sequence_nextval('rhn_server_arch_id_seq'), 'armv6hl-redhat-linux', 'armv6hl', lookup_arch_type('rpm'));
+
+insert into rhnServerChannelArchCompat (server_arch_id, channel_arch_id) values
+(LOOKUP_SERVER_ARCH('armv6hl-redhat-linux'), LOOKUP_CHANNEL_ARCH('channel-arm'));
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('armv7l-redhat-linux'), LOOKUP_PACKAGE_ARCH('armv6hl'), 25);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('armv6hl-redhat-linux'), LOOKUP_PACKAGE_ARCH('armv6hl'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('armv6hl-redhat-linux'), LOOKUP_PACKAGE_ARCH('armv6l'), 10);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('armv6hl-redhat-linux'), LOOKUP_PACKAGE_ARCH('armv5tel'), 20);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('armv6hl-redhat-linux'), LOOKUP_PACKAGE_ARCH('noarch'), 1000);
+
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('sw_mgr_entitled'));
+
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('enterprise_entitled'));
+
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('provisioning_entitled'));
+
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('monitoring_entitled'));
+
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('virtualization_host'));
+
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('virtualization_host_platform'));
commit f00b51cb858aab62a1d32b2435a118aeb4a43079
Author: Michael Mraka michael.mraka@redhat.com
Date:   Fri Nov 29 13:10:09 2013 +0100
1034742 - support for new Raspberry Pi arch (armv6hl)
diff --git a/schema/spacewalk/common/data/rhnCpuArch.sql b/schema/spacewalk/common/data/rhnCpuArch.sql
index 9da1ebd..e1970ff 100644
--- a/schema/spacewalk/common/data/rhnCpuArch.sql
+++ b/schema/spacewalk/common/data/rhnCpuArch.sql
@@ -70,6 +70,8 @@ insert into rhnCpuArch (id, label, name) values
 (sequence_nextval('rhn_cpu_arch_id_seq'), 'armv5tejl', 'ARMv5tejl');
 insert into rhnCpuArch (id, label, name) values
 (sequence_nextval('rhn_cpu_arch_id_seq'), 'armv6l', 'ARMv6l');
+insert into rhnCpuArch (id, label, name) values
+(sequence_nextval('rhn_cpu_arch_id_seq'), 'armv6hl', 'ARMv6hl');
 commit;
--
diff --git a/schema/spacewalk/common/data/rhnServerArch.sql b/schema/spacewalk/common/data/rhnServerArch.sql
index cfd0b5d..1382115 100644
--- a/schema/spacewalk/common/data/rhnServerArch.sql
+++ b/schema/spacewalk/common/data/rhnServerArch.sql
@@ -77,6 +77,9 @@ insert into rhnServerArch (id, label, name, arch_type_id) values
 (sequence_nextval('rhn_server_arch_id_seq'), 'armv6l-redhat-linux', 'armv6l', lookup_arch_type('rpm'));
insert into rhnServerArch (id, label, name, arch_type_id) values
+(sequence_nextval('rhn_server_arch_id_seq'), 'armv6hl-redhat-linux', 'armv6hl', lookup_arch_type('rpm'));
+
+insert into rhnServerArch (id, label, name, arch_type_id) values
 (sequence_nextval('rhn_server_arch_id_seq'), 'powerpc-debian-linux', 'powerpc Debian', lookup_arch_type('deb'));
insert into rhnServerArch (id, label, name, arch_type_id) values
diff --git a/schema/spacewalk/common/data/rhnServerChannelArchCompat.sql b/schema/spacewalk/common/data/rhnServerChannelArchCompat.sql
index 29c9d77..9762e18 100644
--- a/schema/spacewalk/common/data/rhnServerChannelArchCompat.sql
+++ b/schema/spacewalk/common/data/rhnServerChannelArchCompat.sql
@@ -88,6 +88,9 @@ insert into rhnServerChannelArchCompat (server_arch_id, channel_arch_id) values
 (LOOKUP_SERVER_ARCH('armv6l-redhat-linux'), LOOKUP_CHANNEL_ARCH('channel-arm'));
insert into rhnServerChannelArchCompat (server_arch_id, channel_arch_id) values
+(LOOKUP_SERVER_ARCH('armv6hl-redhat-linux'), LOOKUP_CHANNEL_ARCH('channel-arm'));
+
+insert into rhnServerChannelArchCompat (server_arch_id, channel_arch_id) values
 (LOOKUP_SERVER_ARCH('sparc-sun4m-solaris'), LOOKUP_CHANNEL_ARCH('channel-sparc-sun-solaris'));
insert into rhnServerChannelArchCompat (server_arch_id, channel_arch_id) values
diff --git a/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql b/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
index 2a400c8..de32069 100644
--- a/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
+++ b/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
@@ -95,6 +95,10 @@ insert into rhnServerPackageArchCompat
insert into rhnServerPackageArchCompat
 (server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('armv7l-redhat-linux'), LOOKUP_PACKAGE_ARCH('armv6hl'), 25);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
 (LOOKUP_SERVER_ARCH('armv7l-redhat-linux'), LOOKUP_PACKAGE_ARCH('armv6l'), 30);
insert into rhnServerPackageArchCompat
@@ -128,6 +132,23 @@ insert into rhnServerPackageArchCompat
 (LOOKUP_SERVER_ARCH('armv6l-redhat-linux'), LOOKUP_PACKAGE_ARCH('noarch'), 1000);
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('armv6hl-redhat-linux'), LOOKUP_PACKAGE_ARCH('armv6hl'), 0);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('armv6hl-redhat-linux'), LOOKUP_PACKAGE_ARCH('armv6l'), 10);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('armv6hl-redhat-linux'), LOOKUP_PACKAGE_ARCH('armv5tel'), 20);
+
+insert into rhnServerPackageArchCompat
+(server_arch_id, package_arch_id, preference) values
+(LOOKUP_SERVER_ARCH('armv6hl-redhat-linux'), LOOKUP_PACKAGE_ARCH('noarch'), 1000);
+
+
insert into rhnServerPackageArchCompat
 (server_arch_id, package_arch_id, preference) values
diff --git a/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql b/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql
index 703872b..5fc1f36 100644
--- a/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql
+++ b/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql
@@ -97,6 +97,10 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
             lookup_sg_type('sw_mgr_entitled'));
insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('sw_mgr_entitled'));
+
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
    values (lookup_server_arch('s390-debian-linux'),
             lookup_sg_type('sw_mgr_entitled'));
@@ -233,6 +237,10 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
             lookup_sg_type('enterprise_entitled'));
insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('enterprise_entitled'));
+
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
    values (lookup_server_arch('s390-debian-linux'),
             lookup_sg_type('enterprise_entitled'));
@@ -385,6 +393,10 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
             lookup_sg_type('provisioning_entitled'));
insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('provisioning_entitled'));
+
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
    values (lookup_server_arch('s390-debian-linux'),
             lookup_sg_type('provisioning_entitled'));
@@ -521,6 +533,10 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
             lookup_sg_type('monitoring_entitled'));
insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('monitoring_entitled'));
+
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
    values (lookup_server_arch('s390-debian-linux'),
             lookup_sg_type('monitoring_entitled'));
@@ -642,6 +658,10 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
         values (lookup_server_arch('armv6l-redhat-linux'),
             lookup_sg_type('virtualization_host'));
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('virtualization_host'));
+
 insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type)
     values (lookup_server_arch('s390-debian-linux'),
             lookup_sg_type('virtualization_host'));
@@ -698,6 +718,10 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
         values (lookup_server_arch('armv6l-redhat-linux'),
             lookup_sg_type('virtualization_host_platform'));
+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
+        values (lookup_server_arch('armv6hl-redhat-linux'),
+            lookup_sg_type('virtualization_host_platform'));
+
 insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type)
     values (lookup_server_arch('athlon-redhat-linux'),
             lookup_sg_type('virtualization_host_platform'));

    

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

4 commits - rel-eng/packages schema/spacewalk