[ol6_spacewalk27_server] spacewalk-schema-2.7.28-1.0.2.el6.noarch

spacewalk-schema is the SQL schema for the Spacewalk server.

Changelog (Show File list) (Show related packages)

• Fri Jan 29 2021 Laurence Rochfort <laurence.rochfort@oracle.com> 2.7.28-1.0.2

  - Bring OL6 schema package inline with OL7 to allow OL6->OL7 migration [Orabug: 32436381]
  - Add the following from OL7:
  - Added Oracle Linux 7 distributions 
  - Added Oracle Linux distributions (Keshav Sharma)
  - Added Oracle Linux 6 signing key patch (Avi Miller)

• Wed Jun 26 2019 Laurence Rochfort <laurence.rochfort@oracle.com> 2.7.28-1.0.1

  - Allow longer scap rules to be processed [Orabug: 29759777]

• Wed Aug 09 2017 Tomas Kasparek <tkasparek@redhat.com> 2.7.28-1

  - there's no table rhnOrgEntitlementType in Spacewalk anymore

• Tue Aug 08 2017 Tomas Kasparek <tkasparek@redhat.com> 2.7.27-1

  - 1466493 - oracle equivalent source sha1 is missing

• Tue Aug 08 2017 Tomas Kasparek <tkasparek@redhat.com> 2.7.26-1

  - 1466493 - delete remainder of nonlinux entitlement

• Mon Jul 31 2017 Eric Herget <eherget@redhat.com> 2.7.25-1

  - update copyright year

• Wed May 31 2017 Grant Gainey 2.7.24-1

  - 1381857 - Correct overly-broad comparison in the fixup-functions
    Set ORA back to INDEX from CONSTRAINT - consistency is important...

• Thu May 11 2017 Grant Gainey 2.7.23-1

  - 1381857 - add empty .oracle to make schema-upgrade happy

• Mon May 08 2017 Grant Gainey 2.7.22-1

  - 1381857 - Teach Postgres to correctly-unique-ify rhnConfigInfo rows

• Thu May 04 2017 Michael Mraka <michael.mraka@redhat.com> 2.7.21-1

  - 1444519 - update schema definition and shorten index name

• Wed May 03 2017 Michael Mraka <michael.mraka@redhat.com> 2.7.20-1

  - 1444519 - fix index behaviour on NULL org

• Wed May 03 2017 Tomas Kasparek <tkasparek@redhat.com> 2.7.19-1

  - Revert "1444375 - instert package keys only if they exist"
  - 1444072 - drop filters while deleting repository

• Tue May 02 2017 Jan Dobes 2.7.18-1

  - 1434336 - postgresql 8.4 doesn't support WITH and DELETE combination

• Tue May 02 2017 Michael Mraka <michael.mraka@redhat.com> 2.7.17-1

  - 1444047 - remove links between errata and files from different orgs
  - 1444519 - allow sync of the same erratum to more orgs
  - 1444375 - insert package keys only if they exist

• Wed Apr 05 2017 Jan Dobes 2.7.16-1

  - 1434336 - adding postgresql upgrade
  - 1434336 - on postgresql it's needed to define multiple unique indexes because
    of null values
  - 1436567 - add warning that satellite service should be stopped before upgrade

• Wed Mar 22 2017 Tomas Lestach <tlestach@redhat.com> 2.7.15-1

  - 1434900 - fixing typo in spacewalk-schema-upgrade

• Tue Mar 21 2017 Jiri Dostal <jdostal@redhat.com> 2.7.14-1

  - 1433029 SHA1 Oracle fix

• Fri Mar 17 2017 Jiri Dostal <jdostal@redhat.com> 2.7.13-1

  - 1433029 - Some of monitoring data are not removed from DB

• Thu Mar 16 2017 Jiri Dostal <jdostal@redhat.com> 2.7.12-1

  - 1433029 - Some of monitoring data are not removed from DB
  - Use HTTPS in all Github links
  - Migrating Fedorahosted to GitHub

• Thu Mar 02 2017 Tomas Kasparek <tkasparek@redhat.com> 2.7.11-1

  - 1427530 - fix sha1

• Thu Mar 02 2017 Tomas Kasparek <tkasparek@redhat.com> 2.7.10-1

  - 1427530 - solaris channels can have non-solaris child channels

• Fri Feb 24 2017 Jan Dobes 2.7.9-1

  - drop create_first_org

• Thu Feb 09 2017 Jan Dobes 2.7.8-1

  - 1401497 - upgrades
  - 1401497 - save ssl in separate table again, now allow to have multiple ssl
    sets per content source

• Wed Jan 25 2017 Jiri Dostal <jdostal@redhat.com> 2.7.7-1

  - 1332805 - The problematic editing of kickstart profile - custom options

• Mon Jan 23 2017 Jan Dobes 2.7.6-1

  - Drop code used from the Perl stack to 'trickle' OSAD

• Tue Dec 20 2016 Tomas Kasparek <tkasparek@redhat.com> 2.7.5-1

  - 1402437 - update sha1

• Tue Dec 20 2016 Tomas Kasparek <tkasparek@redhat.com> 2.7.4-1

  - 1402437 - drop child channels first
  - rhnServerGroupTypeFeature table is dependant on rhnServerGroupType

• Tue Dec 13 2016 Tomas Kasparek <tkasparek@redhat.com> 2.7.3-1

  - 1402437 - delete all solaris related records in database

• Fri Nov 25 2016 Tomas Kasparek <tkasparek@redhat.com> 2.7.2-1

  - delete records from rhnArchTypeActions before deleting architecture types

• Wed Nov 23 2016 Tomas Kasparek <tkasparek@redhat.com> 2.7.1-1

  - delete from solaris from rhnArchType table
  - Bumping package versions for 2.7.

• Mon Nov 14 2016 Tomas Kasparek <tkasparek@redhat.com> 2.6.16-1

  - delete solaris architecture during upgrade
  - remove solaris compatibility mappings
  - don't populate db with solaris architectures

• Thu Nov 10 2016 Gennadii Altukhov <galt@redhat.com> 2.6.15-1

  - add Fedora 24 key into schema upgrade

• Tue Nov 08 2016 Gennadii Altukhov <galt@redhat.com> 2.6.14-1

  - Added repo urls and gpg keys for Fedora 24

• Mon Oct 24 2016 Jan Dobes 2.6.13-1

  - fixing ORA-00904: : invalid identifier

• Fri Oct 21 2016 Jan Dobes 2.6.12-1

  - adding missing dependency

• Thu Oct 20 2016 Jan Dobes 2.6.11-1

  - drop rhnContentSourceSsl completely

• Tue Oct 04 2016 Jan Dobes 2.6.10-1

  - splitting oracle and postgresql upgrade

• Fri Sep 02 2016 Grant Gainey 2.6.9-1

  - Avoid a deadlock when deleting a server

• Wed Aug 24 2016 Grant Gainey 2.6.8-1

  - 1369559 - adjust pgres autovacuum settings for rhnChannelPackage to make
    rapid, large, size-changes more performant

• Fri Aug 12 2016 Jan Dobes 2.6.7-1

  - enable deb type

• Fri Jun 17 2016 Jan Dobes 2.6.6-1

  - we already have unbreakable linux network reposync plugin

• Mon Jun 13 2016 Grant Gainey 2.6.5-1

  - spacewalk-schema: build on openSUSE

• Mon Jun 13 2016 Jan Dobes 2.6.4-1

  - sequence is still there

• Mon Jun 13 2016 Jan Dobes 2.6.3-1

  - fixing invalid syntax

• Fri Jun 10 2016 Jan Dobes 2.6.2-1

  - change rhnContentSourceSsl table to possibly connect to channel family
    (instead of content source) and rename to rhnContentSsl

• Thu Jun 09 2016 Jan Dobes 2.6.1-1

  - fix dropping unused entitlements when multiple orgs are available
  - Bumping package versions for 2.6.

• Wed May 25 2016 Tomas Kasparek <tkasparek@redhat.com> 2.5.21-1

  - updating copyright years
  - 1303886 - remove Oracle from summary

• Thu Apr 14 2016 Jiri Precechtel <jprecech@redhat.com> 2.5.20-1

  - 1320119 - added delete of data in referrenced table

• Fri Mar 18 2016 Jan Dobes 2.5.19-1

  - add missing database commit

• Thu Mar 17 2016 Jan Dobes 2.5.18-1

  - adding missing Oracle upgrade
  - delete sync probe task
  - populate uuid cleanup task on clean installation
  - drop column from _log table too
  - sequnce rhn_org_entitlement_type_seq should be dropped
  - dropping functions after entitlements removal in upgrade

• Fri Mar 11 2016 Jan Dobes 2.5.17-1

  - Revert "fix oracle sha1 for 017-drop_monitoring_tables.sql"

• Fri Mar 11 2016 Jan Dobes 2.5.16-1

  - make sure people already on 2.4 will get missed 2.2 -> 2.3 upgrades
  - fixing missing 2.2 -> 2.3 upgrades
  - Revert "delete one more table"

• Wed Mar 09 2016 Tomas Kasparek <tkasparek@redhat.com> 2.5.15-1

  - fixing oracle sha1
  - taskomatic records for uuid cleanup

• Wed Mar 09 2016 Tomas Kasparek <tkasparek@redhat.com> 2.5.14-1

  - remove uuid cleanup from database level

• Mon Mar 07 2016 Jan Dobes 2.5.13-1

  - fixing upgrade on Oracle - it's function
  - fixing upgrade on Oracle - invalid end of file
  - fixing upgrade on Oracle
  - add Chile to the list of timezones (bsc#959055)

• Fri Feb 12 2016 Jan Dobes 2.5.12-1

  - fixing missing upgrade

• Tue Feb 09 2016 Tomas Kasparek <tkasparek@redhat.com> 2.5.11-1

  - delete trigger if does exist before creating it

• Tue Feb 02 2016 Grant Gainey 2.5.10-1

  - When deleting a server, delete all associated rhnSet entries
  - 1303886 - update %description of spacewalk-schema package

• Fri Jan 29 2016 Jan Dobes 2.5.9-1

  - 1301611 - no need to lock table since we don't update entitlements

• Fri Jan 22 2016 Tomas Kasparek <tkasparek@redhat.com> 2.5.8-1

  - fix oracle sha1 for 017-drop_monitoring_tables.sql

• Thu Jan 14 2016 Jan Dobes 2.5.7-1

  - delete one more table

• Mon Jan 11 2016 Tomas Kasparek <tkasparek@redhat.com> 2.5.6-1

  - purge duplicate uuid records during upgrade process

• Fri Jan 08 2016 Tomas Kasparek <tkasparek@redhat.com> 2.5.5-1

  - purge uuid records after deleting a system

• Mon Dec 07 2015 Jan Dobes 2.5.4-1

  - first org needs id = 1

• Fri Dec 04 2015 Jan Dobes 2.5.3-1

  - when installing insert default SSL crypto key with null org

• Tue Nov 24 2015 Jan Dobes 2.5.2-1

  - fixing sha
  - schema upgrade: org entitlement related tables
  - schema: remove org_entitlement(sw_mgr_enterprise) from rhnInfoPane
  - schema: drop rhnOrgEntitlements and rhnOrgEntitlementType tables
  - schema: fix shas
  - schema upgrade: drop max_members from rhnServerGroupType
  - schema upgrade: delete_server proc
  - schema upgrade: views
  - schema upgrade: delete unused rhnExceptions
  - schema upgrade: rhn_server package
  - schema upgrade: rhn_org package
  - schema upgrade: rhn_enttitlements package
  - schema upgrade: create_org procs
  - schema upgrade: drop rhnSatelliteCert
  - schema upgrade: drop the sat-check Taskomatic task
  - schema: assign org entitlements when creating a new organization
  - schema: create config_admin user group while creating a new organization
  - schema: remove repoll parameter from
    rhn_entitlements.remove_server_entitlement()
  - schema: drop rhn_entitlements.repoll_virt_guest_entitlements()
  - schema: remove rhn_server.can_server_consume_virt_slot() and count
    current_members like normal server groups
  - schema: remove max_members from rhnServerGroupOverview view
  - schema: drop unused rhnVisServerGroupOverviewLite view
  - schema: remove use of max_members in views
  - schema: remove max_members from rhnServerGroup table
  - schema: remove unused not_enough_entitlements_in_base_org exception
  - schema: remove unused exception servergroup_max_members
  - schema: do not set max_members in create_first_org and create_new_org
  - schema: modify rhn_server.insert_into_servergroup() to not use max_members
  - schema: drop modify_org_service, set_customer_enterprise,
    unset_customer_enterprise from rhn_entitlements
  - schema: drop rhn_entitlements.entitle_last_modified_servers()
  - schema: drop rhn_entitlements.activate_system_entitlement()
  - schema: drop rhn_entitlements.assign_system_entitlement()
  - schema: drop rhn_entitlements.set_server_group_count()
  - schema: drop rhn_entitlements.prune_group()
  - schema: remove handling of max_members from
    rhn_entitlements.repoll_virt_guest_entitlements()
  - schema: drop rhn_entitlements.remove_org_entitlements()
  - schema: add virtualization host entitlement and enterprise entitlement to SP
    for creating organizations
  - db: drop rhnSatelliteCert
  - sat-cert-check Taskomatic task dropped
  - rhn_server migrations: drop provisioning, update,
    virtualization_host_platform entitlements
  - rhn_entitlements migrations: drop provisioning, update, nonlinux and
    virtualization_host_platform entitlements
  - migration for create_first_org and create_new_org SP: don't add update
    entitlement for new orgs
  - rhnEntitledServers view migration: remove reference to update entitlements
  - db migration: remove references to rhnVirtSubLevel, rhnSGTypeVirtSubLevel and
    rhnChannelFamilyVirtSubLevel
  - delete_server stored procedure migration: remove references to virtualization
    host platform entitlements
  - data migration: remove references to virtualization host platform
    entitlements
  - data migration: remove references to nonlinux entitlements
  - data migration: remove references to update entitlements
  - db: remove references to rhnVirtSubLevel, rhnSGTypeVirtSubLevel and
    rhnChannelFamilyVirtSubLevel
  - data: remove references to virtualization host platform entitlements
  - rhn_server: remove references to virtualization host platform entitlements
  - rhn_entitlements: remove references to virtualization host platform
    entitlements
  - delete_server: remove references to virtualization host platform entitlements
  - data: remove references to nonlinux entitlements
  - rhn_entitlements: remove references to nonlinux entitlements
  - rhnEntitledServers: remove reference to update entitlements
  - data: remove references to update entitlements
  - rhn_server: don't expect update entitlement
  - rhn_entitlements: update shas
  - rhn_entitlements.entitle_server: remove update entitlement references
  - rhn_entitlements.remove_server_entitlement: delete default function value,
    callers always specify it
  - rhn_entitlements.entitle_server: delete default function value, callers
    always specify it
  - rhn_entitlements: drop unused create_entitlement_group function
  - rhn_entitlements: drop unused lookup_entitlement_group function
  - create_new_org and create_first_org: remove automatically added update
    entitlement server group
  - schema upgrades: fix to the dropping of provisioning entitlements
  - db: upgrade scripts
  - rhnEntitledServers view: remove references to provisioning
  - db data: remove references to provisioning
  - rhn_server: remove provisioning references
  - create_new_org and create_first_org: remove outdated comment
  - rhn_entitlements: remove provisioning references
  - Remove unused rhn_host_monitoring and its oracle synonym
  - Remove unused rhn_customer_monitoring view and its oracle synonym
  - Removed unused rhn_contact_monitoring and its oracle synonym
  - Remove monitoring_admin role from users, remove monitoring_admin row from
    rhnUserGroupType
  - Remove populating rhn_config_macro table as it doesn't exist anymore
  - Drop the rhn_config_macro table
  - db: Remove monitoring entitlement from insert/delete to/from server group
  - db: Remove rhn_monitoring from the database
  - schema: drop parameter from clear_subscriptions in delete_server
  - schema migration: drop not_enough_flex_entitlements exception
  - schema migration: drop not_enough_flex_entitlements_in_base_org exception
  - schema migration: remove server_cannot_convert_to_flex exception
  - schema: drop not_enough_flex_entitlements exception
  - schema: drop not_enough_flex_entitlements_in_base_org exception
  - schema: remove server_cannot_convert_to_flex exception
  - schema migration: remove unused invalid_channel_family exception
  - schema: remove unused invalid_channel_family exception
  - schema migration: drop software channel subscription counting
  - schema: drop unused rhnChannelFamilyServerPhysical view
  - schema: drop is_fve column from rhnServerChannel
  - schema: remove unused rhn_entitlements.subscribe_newest_servers()
  - schema: fix syntax error in rhn_channel
  - schema: remove member columns from rhnPrivateChannelFamily
  - schema: remove channel entitlement setting from remove_org_entitlements in
    rhn_entitlements
  - schema: remove maxMembers, currentMembers, maxFlex and currentFlex from
    rhnChannelFamilyPermissions view
  - schema: remove member check from rhn_channel.get_org_access()
  - schema: remove members from rhnOrgChannelFamilyPermissions and
    rhnUserChannelFamilyPerms views
  - schema: drop rhnChannelFamilyServerVirtual view
  - schema: drop unused view rhnChannelFamilyServers
  - schema: drop rhnChannelFamilyServerFve view
  - schema: remove unused vars from [un]subscribe_server in rhn_channel
  - schema: remove unused virt_guest_orgs from repoll_virt_guest_entitlements in
    rhn_entitlements
  - schema: remove delete_server_channels from rhn_channel and delete_server
    proceedure
  - schema: remove rhnChannelFamilyOverview view
  - schema: remove channel_family_no_subscriptions exception
  - schema: drop unused view rhnServerFveCapable
  - schema: drop channel_family_no_subscriptions exception
  - schema: remove channel_family_current_members from rhn_channel
  - schema: remove prune_family from rhn_entitlements
  - schema: remove set_family_count from rhn_entitlements
  - schema: remove channel entitlement handling from
    repoll_virt_guest_entitlements in rhn_entitlements
  - schema: remove assign_channel_entitlement from rhn_entitlements
  - schema: remove available_family_subscriptions from rhn_channel
  - schema: remove available_fve_family_subs from rhn_channel
  - schema: remove unused available_fve_chan_subs from rhn_channel
  - schema: remove unused available_chan_subscriptions from rhn_channel
  - schema: remove unused rhnUserAvailableChannels view
  - remove current_members and available_members from rhnAvailableChannels view
  - schema: remove unused can_server_consume_fve from rhn_channel
  - schema: remove unused can_server_consume_virt_channl from rhn_channel
  - schema: remove channel entitlement checks on subscribe_server
  - schema: drop convert_to_fve and can_convert_to_fve from rhn_channel
  - schema: whitespace fixes
  - schema: remove unused activate_channel_entitlement from rhn_entitlements
  - schema: remove unused function cfam_curr_fve_members from rhn_channel
  - schema: remove usage of update_group_family_counts from rhn_entitlements
  - schema: remove update_family_counts from rhn_entitlements
  - schema: remove update_family_counts and update_group_family_counts

• Wed Sep 30 2015 Tomas Kasparek <tkasparek@redhat.com> 2.5.1-1

  - fix delete user by deleting the reference to rhnResetPassword
  - Bumping package versions for 2.5.

• Tue Sep 29 2015 Jan Dobes 2.4.23-1

  - fix schema migration error - trigger must be created after the table

• Thu Sep 24 2015 Jan Dobes 2.4.22-1

  - Bumping copyright year.

• Wed Sep 16 2015 Grant Gainey 2.4.21-1

  - 608355 - missed updating a checksum
  - 608355 - Support 2.3-to-2.4 upgrade
  - 608355 - rhnResetPassword to support password-recovery-tokens

• Fri Jul 31 2015 Grant Gainey 2.4.20-1

  - 1249219 - Fix file-naming error for upgrade

• Fri Jul 31 2015 Grant Gainey 2.4.19-1

  - 1249219 - Fix postgres rpm.rpmstrcmp to exhibit same behavior as original
    Oracle functionality

• Thu Jul 23 2015 Tomas Lestach <tlestach@redhat.com> 2.4.18-1

  - unify schema comment message

• Wed Jul 22 2015 Tomas Lestach <tlestach@redhat.com> 2.4.17-1

  - update the oracle equivalent sha1s
  - removing outdated revision information for schema files

• Mon Jul 20 2015 Tomas Lestach <tlestach@redhat.com> 2.4.16-1

  - ensure appropriate table entries are avaialble for newly created
    organizations
  - introduce rhnOrgAdminManagement table
  - add errata_emails_enabled column to the rhnOrgConfiguration table

• Tue Jun 30 2015 Grant Gainey 2.4.15-1

  - 1234604 - teach oracle to do update_needed_cache async as well

• Mon Jun 22 2015 Grant Gainey 2.4.14-1

  - 1234604 - Fix oracle-sha1sum for 007- upgrade

• Mon Jun 22 2015 Grant Gainey 2.4.13-1

  - 1234604 - Make rhn_channel.update_needed_cache hand off servers to Taskomatic

• Fri Jun 12 2015 Jan Dobes 2.4.12-1

  - prevent inserting duplicate update_server_errata_cache tasks

• Thu May 21 2015 Tomas Lestach <tlestach@redhat.com> 2.4.11-1

  - extend label in rhnContentSource table

• Mon May 18 2015 Tomas Lestach <tlestach@redhat.com> 2.4.10-1

  - we need to run cleanup-packagechangelog-data as the 1st task of the template

• Fri May 15 2015 Stephen Herr <sherr@redhat.com> 2.4.9-1

  - Remove monitoring cleanup taskomatic task - monitoring longer exists

• Wed May 13 2015 Stephen Herr <sherr@redhat.com> 2.4.8-1

  - Add spacewalk-2015 and Fedora 23 gpg key fingerprints
  - Add package key for Spacewalk 2014 (RPM-GPG-KEY-spacewalk-2014)

• Tue May 12 2015 Grant Gainey 2.4.7-1

  - 1220361 - clean up upgrade with empty .sql.oracle file

• Mon May 11 2015 Grant Gainey 2.4.6-1

  - 1220361 - Use GREATEST to insure LIMIT is >= 0

• Wed Apr 29 2015 Stephen Herr <sherr@redhat.com> 2.4.5-1

  - 1215671 - move auto-errata updates into separate taskomatic task

• Mon Apr 27 2015 Grant Gainey 2.4.4-1

  - Update 021 postgres to new oracle sha1

• Mon Apr 27 2015 Grant Gainey 2.4.3-1

  - 1215151 - Update 021-rhnServerNetwork-trigger.sql.oracle

• Thu Apr 02 2015 Tomas Kasparek <tkasparek@redhat.com> 2.4.2-1

  - Oracle alter table xxx add column syntax differs from PostgreSQL one

• Wed Apr 01 2015 Jan Dobes 2.4.1-1

  - 1205328 - do not ignore errata with same package version
  - Bumping package versions for 2.4.

• Fri Mar 27 2015 Tomas Lestach <tlestach@redhat.com> 2.3.41-1

  - Fix ORA-01403: no data found in update_needed_cache during re-registrations

• Thu Mar 19 2015 Grant Gainey 2.3.40-1

  - Automatic commit of package [osad] release [5.11.56-1].
  - Updating copyright info for 2015

• Thu Mar 05 2015 Stephen Herr <sherr@redhat.com> 2.3.39-1

  - add the EPEL 7 key to new db installation scripts, move upgrade script
  - Add EPEL 7 package key

• Wed Mar 04 2015 Stephen Herr <sherr@redhat.com> 2.3.38-1

  - Avoid a deadlock when changing channel assignments (bsc#918549)

• Tue Mar 03 2015 Tomas Kasparek <tkasparek@redhat.com> 2.3.37-1

  - 1128989 - allow users to set taskomatic mail preferences - schema changes

• Mon Mar 02 2015 Stephen Herr <sherr@redhat.com> 2.3.36-1

  - remove monitoring server groups from servers before deleting the sg

• Fri Feb 13 2015 Stephen Herr <sherr@redhat.com> 2.3.35-1

  - 1192437 - add armv7l-debian server arch

• Thu Jan 15 2015 Matej Kollar <mkollar@redhat.com> 2.3.34-1

  - Getting rid of Tabs and trailing spaces in Python
  - Getting rid of trailing spaces in Perl
  - Getting rid of Tabs and trailing spaces in LICENSE, COPYING, and README files

• Thu Jan 08 2015 Tomas Kasparek <tkasparek@redhat.com> 2.3.33-1

  - arm related sutff can be present in db before upgrade
  - don't instert values that can be already present
  - some values can be insterted multiple times - don't do that
  - some values can be already present at the time of upgrade

• Tue Dec 23 2014 Stephen Herr <sherr@redhat.com> 2.3.32-1

  - Fixing duplicated 'drop rhn_probe' statement

• Mon Dec 22 2014 Stephen Herr <sherr@redhat.com> 2.3.31-1

  - Fixing order of tables to be dropped

• Fri Dec 19 2014 Stephen Herr <sherr@redhat.com> 2.3.30-1

  - add schema upgrade scripts to fix triggers on rhnServerNetwork

• Thu Dec 18 2014 Stephen Herr <sherr@redhat.com> 2.3.29-1

  - don't add sync-probe taskomatic task, but handle upgrades that have it

• Thu Dec 18 2014 Stephen Herr <sherr@redhat.com> 2.3.28-1

  - Monitoring Panes on YourRHN no longer exist, remove schema references to them

• Thu Dec 18 2014 Stephen Herr <sherr@redhat.com> 2.3.27-1

  - rhn_method_types table no longer exists, don't insert data into it

• Wed Dec 17 2014 Stephen Herr <sherr@redhat.com> 2.3.26-1

  - fixing oracle sha1source

• Wed Dec 17 2014 Stephen Herr <sherr@redhat.com> 2.3.25-1

  - remove monitoring server group type
  - Fix upgrade schema script that drops monitoring tables

• Wed Dec 17 2014 Stephen Herr <sherr@redhat.com> 2.3.24-1

  - fixing upgrade script ordering after perl-removal merge

• Wed Dec 17 2014 Stephen Herr <sherr@redhat.com> 2.3.23-1

  - Removing solaris tables
  - drop monitoring code and monitoring schema
  - removing monitoring from spacewalk-schema

• Wed Dec 17 2014 Tomas Kasparek <tkasparek@redhat.com> 2.3.22-1

  - armv6hl could be present at the time of upgrade

• Fri Dec 05 2014 Michael Mraka <michael.mraka@redhat.com> 2.3.21-1

  - 1021057 - renamed package upgrade scripts to .sql

• Fri Dec 05 2014 Michael Mraka <michael.mraka@redhat.com> 2.3.20-1

  - 1021057 - schema upgrade scripts
  - 1021057 - fixed double-counting systems subscribed to more than one channel

• Thu Nov 13 2014 Stephen Herr <sherr@redhat.com> 2.3.19-1

  - 1163977 - add virt-host-plat entitlement mappings for new arches

• Fri Oct 10 2014 Tomas Kasparek <tkasparek@redhat.com> 2.3.18-1

  - increase source_url column size to 2048

• Wed Oct 08 2014 Tomas Lestach <tlestach@redhat.com> 2.3.17-1

  - use fedora18 as fedora kickstart type

• Thu Oct 02 2014 Stephen Herr <sherr@redhat.com> 2.3.16-1

  - 1148911 - add aarch64 server to noarch package mapping

• Fri Sep 26 2014 Tomas Lestach <tlestach@redhat.com> 2.3.15-1

  - 1145478 - enhance rhnWebContactEnabled view

• Mon Sep 22 2014 Stephen Herr <sherr@redhat.com> 2.3.14-1

  - 1114687 - rhnDistChannelMap index needs to handle nulls on postgresql

• Wed Sep 17 2014 Stephen Herr <sherr@redhat.com> 2.3.13-1

  - 1138708, 1142110 - make child channel architecture check universal

• Thu Sep 11 2014 Michael Mraka <michael.mraka@redhat.com> 2.3.12-1

  - RHEL7 contains PostgreSQL 9

• Fri Sep 05 2014 Michael Mraka <michael.mraka@redhat.com> 2.3.11-1

  - 1021057 - system can consume only one flex entitlement

• Fri Aug 29 2014 Michael Mraka <michael.mraka@redhat.com> 2.3.10-1

  - 1128735 - force character set and numerical separators to good known
    defaults.

• Fri Aug 08 2014 Jan Dobes 2.3.9-1

  - adding missing upgrade

• Thu Aug 07 2014 Jan Dobes 2.3.8-1

  - fixing order of commands

• Fri Aug 01 2014 Michael Mraka <michael.mraka@redhat.com> 2.3.7-1

  - add Korea to the list of timezones

• Fri Aug 01 2014 Michael Mraka <michael.mraka@redhat.com> 2.3.6-1

  - there's no bootstrap entitlement in spacewalk

• Thu Jul 31 2014 Stephen Herr <sherr@redhat.com> 2.3.5-1

  - 1125428 - make config file deletion faster if there are lots of snapshots

• Thu Jul 31 2014 Michael Mraka <michael.mraka@redhat.com> 2.3.4-1

  - Add support to the ppc64le architecture

• Thu Jul 31 2014 Michael Mraka <michael.mraka@redhat.com> 2.3.3-1

  - 1066432 - make future installs run ErrataCache task more often

• Tue Jul 22 2014 Tomas Kasparek <tkasparek@redhat.com> 2.3.2-1

  - 1023557 - Speed up satellite-sync by avoiding commonly-called dblink_exec

• Fri Jul 18 2014 Miroslav Suchý <msuchy@redhat.com> 2.3.1-1

  - add Fedora 21 GPG keys
  - Bumping package versions for 2.3.

• Fri Jul 11 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.2.33-1

  - add CentOS 7 GPG key
  - fix copyright years

• Tue Jul 08 2014 Michael Mraka <michael.mraka@redhat.com> 2.2.32-1

  - 1103813 - fixed order of tables in upgrade script

• Fri Jul 04 2014 Michael Mraka <michael.mraka@redhat.com> 2.2.31-1

  - 1103813 - armhf support for "arm Debian" channel

• Tue Jul 01 2014 Stephen Herr <sherr@redhat.com> 2.2.30-1

  - 1109276 - Fix Distro syncing in CobblerSyncTask, force one sync to fix arch

• Fri Jun 27 2014 Stephen Herr <sherr@redhat.com> 2.2.29-1

  - Fix rhnKickstartableTree trigger, 'null = null' is not true in sql

• Thu Jun 26 2014 Stephen Herr <sherr@redhat.com> 2.2.28-1

  - Moving schema upgrade to appropriate dir
  - rhnSsmOperationServer: note column added

• Thu May 29 2014 Stephen Herr <sherr@redhat.com> 2.2.27-1

  - 1077365 - index for user_id on wupi table speeds up errata mailer

• Fri May 23 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.2.26-1

  - spec file polish

• Wed Apr 23 2014 Stephen Herr <sherr@redhat.com> 2.2.25-1

  - Schema typo fixed

• Mon Apr 14 2014 Michael Mraka <michael.mraka@redhat.com> 2.2.24-1

  - schema: new action type, clientcert.update_client_cert

• Fri Apr 04 2014 Michael Mraka <michael.mraka@redhat.com> 2.2.23-1

  - 903068 - update scripts for schema
  - 903068 - fixed debian repo generation

• Thu Apr 03 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.2.22-1

  - rhnActionChain.id: explicitly name the primary index constraint

• Tue Apr 01 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.2.21-1

  - triggers to be recreated consistently with a new schema

• Tue Apr 01 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.2.20-1

  - Drop rhn_actchainent_cid_sid_so_uq constraint from rhnActionChainEntry

• Mon Mar 31 2014 Stephen Herr <sherr@redhat.com> 2.2.19-1

  - renaming upgrade scripts to put them in the proper place in the order
  - New tables and upgrade scripts added
  - add reboot action cleanup task

• Fri Mar 28 2014 Michael Mraka <michael.mraka@redhat.com> 2.2.18-1

  - rhnServer.secret extend length to 64: schema upgrade
  - extend rhnServer.secret to 64

• Tue Mar 25 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.2.17-1

  - reset package to avoid ORA-0406* errors

• Fri Mar 21 2014 Tomas Lestach <tlestach@redhat.com> 2.2.16-1

  - create rhnOrgExtGroupMapping triggers
  - change rhnUserExtGroup unique index

• Thu Mar 20 2014 Tomas Lestach <tlestach@redhat.com> 2.2.15-1

  - upgrade scripts shall end with semicolon

• Wed Mar 19 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.2.14-1

  - fixing web_contact schema upgrade script

• Wed Mar 19 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.2.13-1

  - schema upgrade for web_contact_log

• Tue Mar 18 2014 Tomas Lestach <tlestach@redhat.com> 2.2.12-1

  - add rhnUserExtGroup table dependency

• Fri Mar 14 2014 Tomas Lestach <tlestach@redhat.com> 2.2.11-1

  - add table dependency

• Fri Mar 14 2014 Tomas Lestach <tlestach@redhat.com> 2.2.10-1

  - add table dependency

• Thu Mar 13 2014 Tomas Lestach <tlestach@redhat.com> 2.2.9-1

  - introduce create_default_sg column within the rhnOrgConfiguration table
  - create rhnOrgExtGroupMapping table
  - add org_id column to rhnUserExtGroup table

• Tue Mar 11 2014 Tomas Lestach <tlestach@redhat.com> 2.2.8-1

  - 1070917 - extending cron_expr length to 120

• Mon Mar 10 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.2.7-1

  - Extend length of web_contact.password to 110

• Mon Mar 10 2014 Michael Mraka <michael.mraka@redhat.com> 2.2.6-1

  - 1055969 - missing aarch64 in rhnServerArch

• Fri Mar 07 2014 Michael Mraka <michael.mraka@redhat.com> 2.2.5-1

  - 1055969 - support for ARM aarch64 architecture

• Thu Mar 06 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.2.4-1

  - drop web_contact.old_password column from schema
  - insert new gpg key only if not exists

• Fri Feb 28 2014 Tomas Lestach <tlestach@redhat.com> 2.2.3-1

  - fix oracle equivalent source sha1

• Fri Feb 28 2014 Tomas Lestach <tlestach@redhat.com> 2.2.2-1

  - 1070917 - extending cron_expr column within the rhnTaskoSchedule table

• Tue Feb 25 2014 Tomas Lestach <tlestach@redhat.com> 2.2.1-1

  - introduce keep_roles option
  - extend rhnUserGroupMembers
  - Bumping package versions for 2.2.

• Mon Feb 24 2014 Michael Mraka <michael.mraka@redhat.com> 2.1.50-1

  - replacing view must have the same number of columns (in postgresql)

• Fri Feb 21 2014 Michael Mraka <michael.mraka@redhat.com> 2.1.49-1

  - updated rhnServerOutdatePackages to include arch

• Fri Feb 21 2014 Michael Mraka <michael.mraka@redhat.com> 2.1.48-1

  - improved performance of system.listLatestUpgradeablePackages and
    UpgradableList.do

• Tue Feb 18 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.47-1

  - 1063821 - update rhnServer after queue_server to avoid a deadlock

• Mon Feb 17 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.46-1

  - 1063821 - fix ORA-01422 error when removing a channel

• Fri Feb 14 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.45-1

  - fix ORA-01403: no data found, when unsubscribing a system

• Fri Feb 14 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.44-1

  - rename upgrade scripts to be included in schema upgrade
  - fix ORA-01403: no data found, during system registration

• Wed Feb 12 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.43-1

  - 1063821 - lock rhnServerNeededCache to avoid a db deadlock

• Wed Feb 12 2014 Tomas Kasparek <tkasparek@redhat.com> 2.1.42-1

  - Add missing GMT+3 timezone as Saudi Arabia

• Tue Feb 11 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.41-1

  - fix sha1 sums

• Tue Feb 11 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.40-1

  - 1063821 - deadlock fix

• Tue Feb 04 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.39-1

  - upgrade script for Fedora 20 GPG key

• Mon Feb 03 2014 Tomas Lestach <tlestach@redhat.com> 2.1.38-1

  - rename one and add another rhnConfiguration key
  - update rhnUserExtGroupMapping triggers

• Wed Jan 22 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.37-1

  - Revert "1053591 - refresh_newest_package: lock rhnChannel at the beginning"
  - Revert "'is' followed by 'declare' is rarely needed"

• Fri Jan 17 2014 Michael Mraka <michael.mraka@redhat.com> 2.1.36-1

  - increase length of rhnCVE name column

• Fri Jan 17 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.35-1

  - 'is' followed by 'declare' is rarely needed

• Fri Jan 17 2014 Tomas Lestach <tlestach@redhat.com> 2.1.34-1

  - rename the schema files to have the proper naming

• Thu Jan 16 2014 Tomas Lestach <tlestach@redhat.com> 2.1.33-1

  - Tables to have mapping from external groups to internal roles
    (rhnUserGroupType).
  - introduce 1st configuration key
  - introduce rhnConfiguration table

• Thu Jan 16 2014 Matej Kollar <mkollar@redhat.com> 2.1.32-1

  - Changed gpg keys so they match reality.

• Wed Jan 15 2014 Milan Zazrivec <mzazrivec@redhat.com> 2.1.31-1

  - 1053591 - refresh_newest_package: lock rhnChannel at the beginning

• Mon Dec 02 2013 Michael Mraka <michael.mraka@redhat.com> 2.1.30-1

  - 1034742 - schema upgrade for armv6hl arch
  - 1034742 - support for new Raspberry Pi arch (armv6hl)

• 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

• Thu Nov 14 2013 Michael Mraka <michael.mraka@redhat.com> 2.1.27-1

  - schema upgrade fix: explicit cast for bit-wise operand

• Mon Nov 11 2013 Michael Mraka <michael.mraka@redhat.com> 2.1.26-1

  - fixed oracle equivalent checksums

• Mon Nov 11 2013 Michael Mraka <michael.mraka@redhat.com> 2.1.25-1

  - schema upgrade for rhnServerNeededCache
  - extended update_needed_cache() to insert channel_id
  - extended rhnServerNeededCache with channel_id

• Thu Oct 24 2013 Milan Zazrivec <mzazrivec@redhat.com> 2.1.24-1

  - fix space check for Oracle schema upgrades

• Thu Oct 24 2013 Milan Zazrivec <mzazrivec@redhat.com> 2.1.23-1

  - schema upgrade fix: explicit cast for bit-wise operand

• Tue Oct 22 2013 Michael Mraka <michael.mraka@redhat.com> 2.1.22-1

  - Regenerate the metadata for rpm enhances dependency (bnc#846436)
  - add support for enhances rpm weak dependency (schema) (bnc#846436)

• Thu Oct 17 2013 Stephen Herr <sherr@redhat.com> 2.1.21-1

  - 1020497 - provide a way to order kickstart scripts

• Tue Sep 17 2013 Jan Dobes 2.1.20-1

  - 820225 - recount associated virtual guests entitlements even in other orgs

• Tue Sep 17 2013 Michael Mraka <michael.mraka@redhat.com> 2.1.19-1

  - upgrade script for Oracle Linux 6 key
  - Added Oracle GPG key used to sign Oracle Linux 6 packages.

• Tue Sep 10 2013 Stephen Herr <sherr@redhat.com> 2.1.18-1

  - 999453 - missed a sha1 hash

• Tue Sep 10 2013 Stephen Herr <sherr@redhat.com> 2.1.17-1

  - 999453 - one file removal did not make it into the original commit

• Thu Sep 05 2013 Stephen Herr <sherr@redhat.com> 2.1.16-1

  - 999453 - updating sha1 hashes

• Thu Sep 05 2013 Stephen Herr <sherr@redhat.com> 2.1.15-1

  - 999453 - move the rhnServerNeededView sql into the function for performance
  - Revert "999453 - update rhnServerNeededView to make it easier to optimize for
    fast execution"

• Thu Aug 29 2013 Stephen Herr <sherr@redhat.com> 2.1.14-1

  - 999453 - update rhnServerNeededView to make it easier to optimize for fast
    execution

• Wed Aug 21 2013 Stephen Herr <sherr@redhat.com> 2.1.13-1

  - 998424 - removing bad initial condition from max(evr_t)
  - Revert "998424 - rpm version comparison function was broken for alphanumeric
    versions"
  - Revert "998424 - naming the file properly"
  - timestamps in oracle: don't shift the dates during schema upgrades

• Tue Aug 20 2013 Stephen Herr <sherr@redhat.com> 2.1.12-1

  - 998424 - naming the file properly

• Tue Aug 20 2013 Stephen Herr <sherr@redhat.com> 2.1.11-1

  - 998424 - rpm version comparison function was broken for alphanumeric versions

• Tue Aug 20 2013 Tomas Lestach <tlestach@redhat.com> 2.1.10-1

  - fix sha1 of 014-add-column-csv-separator.sql.postgresql
  - Add a hack to allow the ';' literal in table definitions
  - Allow users to change the CSV separator (schema changes)
  - delete duplicates from rhnDistchannelMap
  - don't insert existing values twice

• Fri Aug 09 2013 Milan Zazrivec <mzazrivec@redhat.com> 2.1.9-1

  - remove duplicate pairs before creating unique index

• Tue Aug 06 2013 Tomas Lestach <tlestach@redhat.com> 2.1.8-1

  - fixing sha1 of upgrade/spacewalk-schema-2.0-to-spacewalk-
    schema-2.1/013-log.sql

• Tue Aug 06 2013 Tomas Lestach <tlestach@redhat.com> 2.1.7-1

  - name constraints on the log table

• Mon Aug 05 2013 Tomas Lestach <tlestach@redhat.com> 2.1.6-1

  - changing stamp type on log table

• Wed Jul 31 2013 Simon Lukasik <slukasik@redhat.com> 2.1.5-1

  - New OrgConfig attribute: period during which it is not possible to delete
    scan

• Fri Jul 26 2013 Michael Mraka <michael.mraka@redhat.com> 2.1.4-1

  - fixed upgrade file names

• Thu Jul 25 2013 Tomas Lestach <tlestach@redhat.com> 2.1.3-1

  - recreate logging triggers after we change the logging table column types

• Wed Jul 24 2013 Tomas Lestach <tlestach@redhat.com> 2.1.2-1

  - fix oracle equivalent source sha1
  - fix_f624b843
  - extract logging.recreate_trigger from logging.enable_logging
  - replace integer with number/ric in logging package
  - change log_id type on logged tables
  - change log table integer -> number

• Tue Jul 23 2013 Michael Mraka <michael.mraka@redhat.com> 2.1.1-1

  - 876019 - schema upgrade scripts
  - made serverchannels cursor properly parametrized
  - 876019 - fixed misplaced end loop

• Thu Jul 18 2013 Tomas Kasparek <tkasparek@redhat.com> 2.0.2-1

  - fixing oracle specific sha1
  - add upgrade path from 1.10 to 2.0

• Wed Jul 17 2013 Tomas Kasparek <tkasparek@redhat.com> 2.0.1-1

  - Bumping package versions for 2.0.

• Wed Jul 17 2013 Tomas Kasparek <tkasparek@redhat.com> 1.10.71-1

  - adding Fedora 19 gpgp key into rhnPackageKey
  - updating copyright years

• Wed Jul 17 2013 Tomas Kasparek <tkasparek@redhat.com> 1.10.70-1

  - alter table rhnServer before enabling logging to prevent possible issues

• Tue Jul 16 2013 Tomas Lestach <tlestach@redhat.com> 1.10.69-1

  - restore search path, that dblink.sql destroys

• Tue Jul 16 2013 Tomas Kasparek <tkasparek@redhat.com> 1.10.68-1

  - removing some dead code

• Mon Jul 15 2013 Tomas Lestach <tlestach@redhat.com> 1.10.67-1

  - create first package specification, then package body

• Mon Jul 15 2013 Tomas Lestach <tlestach@redhat.com> 1.10.66-1

  - trigger "web_contact_ins_trig" for relation "web_contact" already exists

• Fri Jul 12 2013 Tomas Lestach <tlestach@redhat.com> 1.10.65-1

  - fix schema sha1s

• Fri Jul 12 2013 Tomas Lestach <tlestach@redhat.com> 1.10.64-1

  - fix create logging triggers
  - web_contact_all may not reference web_customer
  - add extra check
  - remove not null constraint from web_contact_all org_id
  - populate web_contact_all log users
  - enable basic logging
  - create logging package
  - create log table
  - update web_contact triggers
  - create web_contact_all

• Fri Jul 12 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.63-1

  - 870451 - check for free space for oracle schema upgrades

• Wed Jul 03 2013 Tomas Kasparek <tkasparek@redhat.com> 1.10.62-1

  - fixing oracle equivalent source sha1

• Wed Jul 03 2013 Stephen Herr <sherr@redhat.com> 1.10.61-1

  - 977878 - ca cert path field was not long enough

• Wed Jul 03 2013 Stephen Herr <sherr@redhat.com> 1.10.60-1

  - 977878 - rhnISSMaster index needs to be different for oracle

• Wed Jul 03 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.59-1

  - Drop where from unique index creation

• Tue Jul 02 2013 Stephen Herr <sherr@redhat.com> 1.10.58-1

  - 977878 - move iss parent / ca_cert configs into database

• Tue Jul 02 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.57-1

  - Spacewalk user: add read_only flag

• Mon Jul 01 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.56-1

  - PostgreSQL schema upgrade fixes

• Mon Jul 01 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.55-1

  - fixed forgotten end loop

• Fri Jun 28 2013 Tomas Lestach <tlestach@redhat.com> 1.10.54-1

  - mark unfinished taskomatic runs as INTERRUPTED

• Fri Jun 28 2013 Dimitar Yordanov <dyordano@redhat.com> 1.10.53-1

  - fix sql syntax.

• Thu Jun 27 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.52-1

  - fix sql syntax

• Wed Jun 26 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.51-1

  - schema upgrades for rhnConfigRevision triggers

• Tue Jun 25 2013 Grant Gainey 1.10.50-1

  - ISS: mv sql-updates in prep for last(?) merge from master
  - ISS: Mapping tables shouldn't have ID columns
  - ISS: Resolve upgrade-script name conflicts
  - ISS: Fixing whitespace
  - ISS: Naming is important - clean ours up so it makes more sense
  - ISS: A master-org might not be mapped
  - ISS: Make master-to-slave-org mapping be many-to-one instead of many-to-many
  - ISS: Schema chgs for ISS Slave-side setup
  - ISS: DRAFT #2: adelton's DB changes, affects on Java, slave-to-org-mapping

• Mon Jun 24 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.49-1

  - fixed syntax error in rhn_confrevision_del_trig_fun

• Fri Jun 21 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.48-1

  - 906157 - upgrade scripts for rhn_config.delete_file() and
    rhn_confrevision_ccid_idx index
  - 906157 - index columns by which we select
  - 906157 - removed duplicate update
  - 906157 - replace number of small updates/deletes in loop

• Tue Jun 18 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.46-1

  - 820123 - prevents empty values (db_host, db_port) in rhn.conf

• Tue Jun 18 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.45-1

  - fixed oracle source checksums

• Mon Jun 17 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.44-1

  - removed old CVS/SVN version ids

• Wed Jun 12 2013 Tomas Kasparek <tkasparek@redhat.com> 1.10.43-1

  - Resolve upgrade-script naming collision

• Fri May 31 2013 Stephen Herr <sherr@redhat.com> 1.10.42-1

  - 948335 - Don't default to 1 cpu socket

• Wed May 29 2013 Simon Lukasik <slukasik@redhat.com> 1.10.41-1

  - Do not use identifiers of excessive length for constraints.

• Tue May 28 2013 Simon Lukasik <slukasik@redhat.com> 1.10.40-1

  - Store SCAP-file-limit to the database

• Mon May 27 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.39-1

  - show data_length for varchar columns

• Mon May 27 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.38-1

  - split the upgrade script for oracle and postgresql

• Thu May 23 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.37-1

  - Don't create index if it already exists
  - Don't drop rhn_ram_sid_idx if it does not exist.

• Tue May 21 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.36-1

  - schema upgrade: don't alter table views

• Tue May 21 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.35-1

  - 961547 - fixed filename lenght in rhnErrataFileTmp

• Fri May 17 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.34-1

  - shift values according to time zone

• Mon May 13 2013 Jan Dobes 1.10.33-1

  - adding lookup_package_group proc and it's upgrade files

• Tue May 07 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.32-1

  - fixed sha1 on postgresql 9.1

• Tue May 07 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.31-1

  - fixed sha1 on postgresql part

• Tue May 07 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.30-1

  - 958425 - switch deferred segment creation off during installation

• Thu May 02 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.28-1

  - fixed wrong sha1

• Thu May 02 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.27-1

  - columns can be altered with values inside

• Mon Apr 29 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.26-1

  - fixed dependency

• Tue Apr 16 2013 Stephen Herr <sherr@redhat.com> 1.10.25-1

  - 952839 - adding erroronfail option for kickstart scripts
  - add oracle equivalent source (even empty)

• Mon Apr 08 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.24-1

  - fix pl/sql if syntax

• Fri Apr 05 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.23-1

  - Insert new timezones only if they don't exist
  - Don't extend length of rhnPackageCapability.version if already extended

• Thu Apr 04 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.22-1

  - add port to dblink_connect connect string

• Wed Apr 03 2013 Stephen Herr <sherr@redhat.com> 1.10.21-1

  - renaming file to correct suffix

• Wed Apr 03 2013 Stephen Herr <sherr@redhat.com> 1.10.20-1

  - Display number of sockets in system details and spacewalk-reports

• Thu Mar 28 2013 Jan Pazdziora 1.10.19-1

  - Fixing type in schema upgrade.

• Wed Mar 27 2013 Jan Pazdziora 1.10.18-1

  - Specify default for nrsocket during upgrade as well.

• Wed Mar 27 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.17-1

  - 918333 - don't strip long path

• Tue Mar 26 2013 Jan Pazdziora 1.10.16-1

  - Use to_timestamp instead of to_date which should bring the second precision
    to PostgreSQL.
  - Fixing schema upgrade of rhnCpu.nrsocket.
  - add nrsocket to rhncpu

• Fri Mar 22 2013 Michael Mraka <michael.mraka@redhat.com> 1.10.15-1

  - 919468 - fixed path in file based Requires

• Fri Mar 22 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.14-1

  - use alter table syntax common to both postgresql and oracle

• Thu Mar 21 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.13-1

  - abrt: store crash uuid

• Fri Mar 15 2013 Jan Pazdziora 1.10.12-1

  - Add --interactive mode option to spacewalk-sql.

• Wed Mar 13 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.11-1

  - move trigger creation after respective table

• Wed Mar 13 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.10-1

  - remove extraneous alters

• Tue Mar 12 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.9-1

  - schema upgrade: add missing triggers

• Mon Mar 11 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.8-1

  - rename upgrade scripts
  - abrt: add triggers for org creation and timestamps
  - fix lengths and names of identifiers

• Mon Mar 11 2013 Jan Pazdziora 1.10.7-1

  - Fixing typo in rhnOrgConfiguration.

• Sat Mar 09 2013 Tomas Lestach <tlestach@redhat.com> 1.10.6-1

  - fix 002-web_customer.sql upgrade script
  - move upgrade scripts as 002 was pushed already

• Sat Mar 09 2013 Tomas Lestach <tlestach@redhat.com> 1.10.5-1

  - rhnServerCrashNote table upgrade scripts
  - introduce rhnServerCrashNote table

• Fri Mar 08 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.10.4-1

  - abrt: org-wide settings for crash reporting and crash file uploading
  - correct the capitalization
  - Move org configuration to a separate table

• Wed Mar 06 2013 Tomas Lestach <tlestach@redhat.com> 1.10.3-1

  - add rhn_content_cource_ssl_ins_trig triggers

• Tue Mar 05 2013 Jan Pazdziora 1.10.2-1

  - Schema upgrade script directory, so that upgrade to nightly passes.

• Tue Mar 05 2013 Jan Pazdziora 1.10.1-1

  - Simplify the schema upgrade sources now that we process them with spacewalk-
    oracle2postgresql.
  - Require the db_backend suffix.
  - Call spacewalk-oracle2postgresql on upgrades as well.

• Fri Mar 01 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.9.38-1

  - abrt: display download link only for files that are available

• Fri Mar 01 2013 Jan Pazdziora 1.9.37-1

  - Quote the password we pass to sqlplus so that special characters can be used.
  - Purging %changelog entries preceding Spacewalk 1.0, in active packages.

• Tue Feb 26 2013 Jan Pazdziora 1.9.36-1

  - Adding missing parentheses.
  - abrt: check the allowed filesize limit is >= 0

• Mon Feb 25 2013 Stephen Herr <sherr@redhat.com> 1.9.35-1

  - add sha1 sum
  - abrt: delete crash: remove content from filer

• Mon Feb 25 2013 Stephen Herr <sherr@redhat.com> 1.9.34-1

  - 915158 - need oracle specific schema upgrade script

• Mon Feb 25 2013 Stephen Herr <sherr@redhat.com> 1.9.33-1

  - 915158 - Allow kickstart profile to update to latest available tree

• Thu Feb 21 2013 Tomas Kasparek <tkasparek@redhat.com> 1.9.32-1

  - *._index.sql files can be used for definition of indexes

• Wed Feb 20 2013 Tomas Kasparek <tkasparek@redhat.com> 1.9.31-1

  - Fixing typo

• Wed Feb 20 2013 Tomas Kasparek <tkasparek@redhat.com> 1.9.30-1

  - Fixing sha1 of oracle equivavalents so packages can be built

• Wed Feb 20 2013 Tomas Kasparek <tkasparek@redhat.com> 1.9.29-1

  - Renaming conflicting files, fixing glitch in schema upgrade
  - Schema changes for setting primary network interface

• Wed Feb 20 2013 Jan Pazdziora 1.9.28-1

  - The sequence rhn_abrt_info_id_seq is also no longer used.

• Tue Feb 19 2013 Jan Pazdziora 1.9.27-1

  - The table rhnAbrtInfo is no longer in the schema, dropping from dependencies.

• Tue Feb 19 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.9.26-1

  - abrt: rhnAbrtInfo table is no longer needed
  - abrt: total & unique crash count info in webui

• Tue Feb 19 2013 Jan Pazdziora 1.9.25-1

  - Schema upgrade needs to be PostgreSQL specific.

• Mon Feb 18 2013 Miroslav Suchý <msuchy@redhat.com> 1.9.24-1

  - Buildrequire pod2man

• Fri Feb 15 2013 Milan Zazrivec <mzazrivec@redhat.com> 1.9.23-1

  - abrt: fix semantics of insert_crash_file function
  - deleting "\" from schema upgrade script
  - abrt: last_report date in rhnServerCrashCount view
  - abrt: ability to limit crashfile upload size per organization
  - abrt: view for unique and total crashes per system
  - abrt: support for client -> server crash upload

• Fri Feb 01 2013 Jan Pazdziora 1.9.22-1

  - Adding utility function epoch_seconds_to_timestamp_tz.

• Mon Jan 28 2013 Jan Pazdziora 1.9.21-1

  - Fixing PL/SQL parameter usage.

• Fri Jan 25 2013 Jan Pazdziora 1.9.20-1

  - Adding the .sql suffix so that the file gets processed during upgrade.

• Fri Jan 25 2013 Jan Pazdziora 1.9.19-1

  - Fixing typo.

• Fri Jan 25 2013 Jan Pazdziora 1.9.18-1

  - Reimplement _set_comps_for_channel as stored procedure.

• Wed Jan 23 2013 Jan Pazdziora 1.9.17-1

  - Avoid exceeding maximal identifier length.

• Tue Jan 22 2013 Jan Pazdziora 1.9.16-1

  - We need to drop rhn_download_id_seq as well.
  - We need to recreate the view from scratch.

• Tue Jan 22 2013 Jan Pazdziora 1.9.15-1

  - Adding dependency for rhnContentSourceSsl.

• Tue Jan 22 2013 Jan Pazdziora 1.9.14-1

  - When adding a column to view, we better name it as well.

• Tue Jan 22 2013 Jan Pazdziora 1.9.13-1

  - Adding rhnContentSourceSsl, to hold certificates and keys to make
    authenticated SSL connections.

• Fri Jan 18 2013 Jan Pazdziora 1.9.12-1

  - Removing no longer used rhnChannelDownloads, rhnDownloads, and
    rhnDownloadType.
  - abrt: display crash count in system overview

• Thu Jan 17 2013 Jan Pazdziora 1.9.11-1

  - 894356 - more informative spacewalk-schema-upgrade

• Wed Jan 02 2013 Jan Pazdziora 1.9.10-1

  - 889463 - correct olson name for Australia Western timezone

• Fri Dec 21 2012 Jan Pazdziora 1.9.9-1

  - 889247 - support for Australia EST/EDT timezones

• Fri Nov 30 2012 Jan Pazdziora 1.9.8-1

  - New timezones for RHEL 7
  - New installation type: RHEL 7

• Tue Nov 06 2012 Tomas Lestach <tlestach@redhat.com> 1.9.7-1

  - 1.9 upgrade scripts go to the spacewalk-schema-1.8-to-spacewalk-schema-1.9
    dir

• Tue Nov 06 2012 Tomas Lestach <tlestach@redhat.com> 1.9.6-1

  - use correct sequence name in PG rhnDistChannelMap trigger

• Thu Nov 01 2012 Jan Pazdziora 1.9.5-1

  - Fixing the equivalence SHA1.

• Thu Nov 01 2012 Jan Pazdziora 1.9.4-1

  - Cannot drop index used for enforcement of unique/primary key.

• Wed Oct 31 2012 Jan Pazdziora 1.9.3-1

  - The index might not actually exist.
  - Schema upgrade script directory, so that upgrade to nightly passes.

• Wed Oct 31 2012 Jan Pazdziora 1.9.2-1

  - Fixing syntax.

• Wed Oct 31 2012 Tomas Lestach <tlestach@redhat.com> 1.9.1-1

  - define rhnOrgDistChannelMap view dependency
  - create rhnDistChannelMap triggers in the schema
  - Bumping package versions for 1.9.

• Wed Oct 31 2012 Jan Pazdziora 1.8.85-1

  - Fixing syntax.

• Tue Oct 30 2012 Tomas Lestach <tlestach@redhat.com> 1.8.84-1

  - channel permission shall be guaranteed by the rhnOrgDistChannelMap
  - update rhn_channel package to use rhnOrgDistChannelMap
  - introduce rhnOrgDistChannelMap
  - create rhnDistChannelMap triggers to auto fill in id
  - add id and org_id to rhnDistChannelMap

• Tue Oct 30 2012 Jan Pazdziora 1.8.83-1

  - Adding the RPM-GPG-KEY-spacewalk-2012 key id.
  - Update the copyright year.

• Tue Oct 30 2012 Tomas Lestach <tlestach@redhat.com> 1.8.82-1

  - Add SAST timezone Signed-off-by: Paresh Mutha <pmutha@redhat.com>

• Thu Oct 25 2012 Milan Zazrivec <mzazrivec@redhat.com> 1.8.81-1

  - 869985 - fix unique constraint violation occuring during schema upgrade

• Mon Oct 15 2012 Michael Mraka <michael.mraka@redhat.com> 1.8.80-1

  - added Novell gpg keys
  - added gpg keys for SUSE

• Mon Oct 15 2012 Jan Pazdziora 1.8.79-1

  - Revert "Quote newlines to match the Oracle behaviour.", we use
    standard_conforming_strings now.

• Fri Oct 05 2012 Tomas Lestach <tlestach@redhat.com> 1.8.78-1

  - updating oracle source sha1

• Fri Oct 05 2012 Tomas Lestach <tlestach@redhat.com> 1.8.77-1

  - set last_modified to current_timestamp if NULL

• Wed Sep 26 2012 Jan Pazdziora 1.8.76-1

  - The rhnpackagesource also references rhnpackagegroup.

• Tue Sep 11 2012 Jan Pazdziora 1.8.75-1

  - The default can also be found in the metadata without parentheses.

• Mon Sep 10 2012 Jan Pazdziora 1.8.74-1

  - Change sysdate to current_timestamp in procedural code.
  - Change date type usage to timestamp in procedural code.
  - Update the rhn_host_monitoring.last_update_date type to TIMESTAMP WITH LOCAL
    TIME ZONE, run common/views through spacewalk-oracle2postgresql as well to
    get it converted to TIMESTAMP WITH TIME ZONE.
  - Update DATE to TIMESTAMP WITH LOCAL TIME ZONE and SYSDATE to
    CURRENT_TIMESTAMP in tables.

• Fri Sep 07 2012 Jan Pazdziora 1.8.73-1

  - Remove the postgres/tables/rhnPackage.sql, we now have the same columns.
  - Make the rhnPackage.build_time timestamp (without time zone) on both
    databases.
  - We need to recreate the index.
  - 849018 - schema upgrade scripts for extending rhnPackageCapability.version.
  - 849018 - extending rhnPackageCapability.version.
  - 854686 - Fixing the rhn_command.command_class default.
  - Make the into variable match the data type of the table column.

• Mon Sep 03 2012 Michael Mraka <michael.mraka@redhat.com> 1.8.72-1

  - oracle's sql parser doesn't like comments after semicolon

• Wed Aug 22 2012 Michael Mraka <michael.mraka@redhat.com> 1.8.71-1

  - Insert pxt session errors on postgres

• Fri Aug 10 2012 Michael Mraka <michael.mraka@redhat.com> 1.8.70-1

  - 843374 - fixed subquery in FROM must have an alias
  - 843374 - upgrade script for rhnChannelNewestPackageView
  - 843374 - make list of newest packages unique

• Tue Jul 31 2012 Tomas Lestach <tlestach@redhat.com> 1.8.69-1

  - fix PG upgrade script

• Tue Jul 31 2012 Tomas Lestach <tlestach@redhat.com> 1.8.68-1

  - rename upgrade scripts to satisfy schema differ
  - add sha1 checksum to the pg upgrade script

• Tue Jul 31 2012 Tomas Lestach <tlestach@redhat.com> 1.8.67-1

  - fix upgrade script

• Mon Jul 30 2012 Tomas Lestach <tlestach@redhat.com> 1.8.66-1

  - remove org_applicant from rhnUserGroupType table
  - remove org_applicant related triggers
  - remove org_applicant from rhn_entitlements
  - remove unused is_user_applicant function
  - remove unused org_applicant user role from creating new orgs
  - remove cert_admin from rhnUserGroupType table
  - remove rhn_support from rhnUserGroupType table
  - remove rhn_superuser from rhnUserGroupType table

• Tue Jul 24 2012 Jan Pazdziora 1.8.65-1

  - Add missing primary key, when we already have it in the schema upgrade
    scripts.

• Mon Jul 23 2012 Tomas Kasparek <tkasparek@redhat.com> 1.8.64-1

  - Preventing whole SQL string from being NULL
  - If by accident pg_dblink_exec is given NULL string (e.g concatenation of
    string and NULL in pgsql) it raises an error.

• Thu Jul 19 2012 Jan Pazdziora 1.8.63-1

  - Adding table dependency for rhnAbrtInfo.

• Wed Jul 18 2012 Jan Pazdziora 1.8.62-1

  - Fix the equivalence SHA1.

• Wed Jul 18 2012 Jan Pazdziora 1.8.61-1

  - Add schema and migration files for rhnAbrtInfo table

• Fri Jul 13 2012 Jan Pazdziora 1.8.60-1

  - Add the PostgreSQL specific mad_address upgrade script.

• Tue Jul 10 2012 Stephen Herr <sherr@redhat.com> 1.8.59-1

  - 836656 - Also add new column to initial table creation

• Wed Jul 04 2012 Jan Pazdziora 1.8.58-1

  - We mustn't serialize object into string in lookup_evr, we need to only create
    it once within the link.
  - 836656 - Allow user to set MAC Address when provisioning a virtual guest

• Fri Jun 29 2012 Jan Pazdziora 1.8.57-1

  - Make the resulting data order more deterministic.

• Wed Jun 27 2012 Jan Pazdziora 1.8.56-1

  - Besides rhnServerGroupNotes, the table source was also creating sequence --
    dropping.

• Wed Jun 27 2012 Jan Pazdziora 1.8.55-1

  - Table rhnServerGroupNotes not used, removing.

• Fri Jun 22 2012 Jan Pazdziora 1.8.54-1

  - 712313 - Add installed size to repodata

• Thu Jun 21 2012 Jan Pazdziora 1.8.53-1

  - Make the .postgresql schema upgrade script actually use the PostgreSQL
    syntax.

• Wed Jun 20 2012 Simon Lukasik <slukasik@redhat.com> 1.8.52-1

  - Add index on ident_id for better performance
  - Add index on testresult_id for better performance.
  - separate schema upgrade script for PostgreSQL

• Mon Jun 11 2012 Jan Pazdziora 1.8.51-1

  - The upgrade scripts are not processed with oracle2postgresql, making separate
    PostgreSQL scripts.

• Fri Jun 08 2012 Jan Pazdziora 1.8.50-1

  - Properly name the primary index constraint/index for rhnActionImageDeploy.

• Thu Jun 07 2012 Jan Pazdziora 1.8.49-1

  - We cannot use markup in formatted text (synopsis).
  - 803370 - lookup_tag: schema upgrade
  - 803370 - lookup_tag: don't call lookup_tag_name twice
  - Disable rhn_channel_mod_trig while updating rhnChannel, so that modified does
    not get modified.

• Tue Jun 05 2012 Michael Mraka <michael.mraka@redhat.com> 1.8.48-1

  - removed support for Red Hat Linux 6.2 and 7.[0123]

• Mon Jun 04 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.47-1

  - Add support for studio image deployments (DB files) (jrenner@suse.de)

• Sat Jun 02 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.46-1

  - 719609 - add support for RaspberryPi (armv6l) (msuchy@redhat.com)

• Thu May 31 2012 Jan Pazdziora 1.8.45-1

  - Disable rhn_pkgsrc_mod_trig while updating rhnPackageSource, so that modified
    does not get modified.
  - Disable rhn_ks_mod_trig while updating rhnKsData, so that modified does not
    get modified.
  - Disable rhn_erratafiletmp_mod_trig while updating rhnErrataFileTmp, so that
    modified does not get modified.
  - Disable rhn_errata_file_mod_trig while updating rhnErrataFile, so that
    modified does not get modified.
  - Disable rhn_channel_mod_trig while updating rhnChannel, so that modified does
    not get modified.
  - Disable rhn_confcontent_mod_trig while updating rhnConfigContent, so that
    modified does not get modified.
  - Fixing misleading comment.
  - Disable rhn_privcf_mod_trig while updating rhnPrivateChannelFamily, so that
    modified does not get modified.
  - Disable rhn_server_channel_mod_trig while updating rhnServerChannel, so that
    modified does not get modified.
  - Disable rhn_servernetwork_mod_trig while updating rhnServerNetwork, so that
    modified does not get modified.

• Wed May 30 2012 Michael Mraka <michael.mraka@redhat.com> 1.8.44-1

  - fixed build time sanity check errors

• Tue May 29 2012 Michael Mraka <michael.mraka@redhat.com> 1.8.43-1

  - changes from 001 and 048 files have been merged into 051-* upgrade file
  - upgrade scripts for user_role_check_debug() changes
  - get rid of out parameters in user_role_check_debug
  - Disable web_customer_mod_trig while updating web_customer, so that modified
    does not get modified.

• Mon May 28 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.42-1

  - 719609 - fix upgrades for arm

• Fri May 25 2012 Milan Zazrivec <mzazrivec@redhat.com> 1.8.41-1

  - forgotten rhnPackageSource update

• Thu May 24 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.40-1

  - 719609 - fix upgrades for arm

• Thu May 24 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.39-1

  - 719609 - correct channel arch for armv7

• Wed May 23 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.38-1

  - 719609 - correct server arch for armv7

• Wed May 23 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.37-1

  - 719609 - fix errors from previous ARM commits

• Tue May 22 2012 Jan Pazdziora 1.8.36-1

  - No need to enforce unique (name_id, evr_id) on rhnVersionInfo.

• Tue May 22 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.35-1

  - 719609 - set priorities between server and package arch
  - 719609 - allow upgrade from arm to noarch and vice versa
  - 719609 - add support for server arch armv5tejl
  - 719609 - for arm create channel-armhfp and channel-arm

• Mon May 21 2012 Tomas Lestach <tlestach@redhat.com> 1.8.34-1

  - 822918 - fix various issues in PG variant of rhn_channel.convert_to_fve
  - Disable rhn_srv_net_iface_mod_trig while updating rhnServerNetInterface, so
    that modified does not get modified.
  - %defattr is not needed since rpm 4.4
  - fix sha1 sum
  - Improve rhnPackageChangeLog upgrade logic.
  - Improve upgrade time_series data move
  - Fix rhnPackageChangeLog upgrade logic.

• Mon May 14 2012 Tomas Lestach <tlestach@redhat.com> 1.8.33-1

  - remove unused cursor

• Fri May 11 2012 Tomas Lestach <tlestach@redhat.com> 1.8.32-1

  - adding create_first_org upgrade scripts
  - adding rhn_org upgrade scripts
  - adding rhn_config upgrade scripts
  - remove rhnOrgQuota and its usage
  - remove rhn_schema package
  - remove usage of rhn_quota package
  - kickstartable tree shall be deleted together with the channel

• Thu May 10 2012 Tomas Lestach <tlestach@redhat.com> 1.8.31-1

  - fix rhn_time_zone_names upgrade scripts

• Wed May 09 2012 Tomas Lestach <tlestach@redhat.com> 1.8.30-1

  - dropping unused rhn_time_zone_names

• Wed May 02 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.29-1

  - 719609 - add support for armv7hnl package arch

• Mon Apr 30 2012 Jan Pazdziora 1.8.28-1

  - Update existing rhn_notification_formats with the new newlines matching
    Oracle.

• Mon Apr 30 2012 Jan Pazdziora 1.8.27-1

  - Using PostgreSQL version of rhn_org.delete_org in upgrade scripts.

• Mon Apr 30 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.26-1

  - 719609 - make arm channels compatible with noarch packages

• Mon Apr 30 2012 Jan Pazdziora 1.8.25-1

  - Fix the order for the arm schema upgrade scripts.

• Fri Apr 27 2012 Jan Pazdziora 1.8.24-1

  - We cannot specify tablespace for PostgreSQL.

• Fri Apr 27 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.23-1

  - 719609 - add support for armv5 channels
  - 719609 - Add support for armv7l cpu and armv7 channels

• Fri Apr 27 2012 Tomas Lestach <tlestach@redhat.com> 1.8.22-1

  - 807283 - fixing postgresql schema and adding appropriate schema upgrade
    scripts
  - 807283 - remove rhnContentSource row when delete row in oracle pkg
  - add unique constraint on rhnChannelArch.name

• Fri Apr 27 2012 Miroslav Suchý <msuchy@redhat.com> 1.8.21-1

  - 630953 - make sure that rows are unique before creating unique index

• Thu Apr 26 2012 Jan Pazdziora 1.8.20-1

  - We need to use to_timestamp, so that we do not miss the hour-to-second part
    on PostgreSQL.
  - Quote newlines to match the Oracle behaviour.

• Mon Apr 23 2012 Michael Mraka <michael.mraka@redhat.com> 1.8.19-1

  - 811646 - assign number of free slots

• Mon Apr 23 2012 Jan Pazdziora 1.8.18-1

  - Fixing the schema hardening trigger on rhnPackageEvr.

• Fri Apr 20 2012 Jan Pazdziora 1.8.17-1

  - Schema hardening: catch code which would update or delete rhnPackageEvr.
  - Make the records in rhnPackageUpgradeArchCompat -- no need to have
    duplicates.

• Mon Apr 16 2012 Jan Pazdziora 1.8.16-1

  - 812453 - bring the schema version as recorded in the database in sync with
    the installed rpms, even if the difference is just the dist tag.

• Fri Apr 13 2012 Jan Pazdziora 1.8.15-1

  - 787225 - the Log Size actually checks Log Size Growth.
  - fix PG lookup_transaction_package stored procedure (tlestach@redhat.com)

• Tue Apr 03 2012 Jan Pazdziora 1.8.14-1

  - fix procedure dependencies (mzazrivec@redhat.com)

• Fri Mar 30 2012 Jan Pazdziora 1.8.13-1

  - Add dependency for rhnXccdfRuleIdentMap to force order.

• Thu Mar 29 2012 Simon Lukasik <slukasik@redhat.com> 1.8.12-1

  - Fix SHA1 of oracle sources. (slukasik@redhat.com)

• Thu Mar 29 2012 Simon Lukasik <slukasik@redhat.com> 1.8.11-1

  - Schema upgrade for the new rule/ident mapping. (slukasik@redhat.com)
  - We want to store all idents per rule-result (slukasik@redhat.com)
  - Extend xccdf:ident length (slukasik@redhat.com)
  - A fast way to force the preferred_time_zone to be string. (msuchy@redhat.com)

• Mon Mar 26 2012 Miroslav Suchý 1.8.10-1

  - add requires /sbin/restorecon

• Wed Mar 21 2012 Jan Pazdziora 1.8.9-1

  - Glob returns its input when file does not exist, filter it out.

• Mon Mar 19 2012 Jan Pazdziora 1.8.8-1

  - lookup_tag: schema upgrade (mzazrivec@redhat.com)
  - fix quote_literal() syntax (mzazrivec@redhat.com)

• Wed Mar 14 2012 Jan Pazdziora 1.8.7-1

  - Fixing typo (rhn_eaddress_mod_trig_fun vs. rhn_eastate_mod_trig_fun).

• Wed Mar 14 2012 Jan Pazdziora 1.8.6-1

  - Need to drop the leftover trigger functions in schema upgrades as well.

• Wed Mar 14 2012 Jan Pazdziora 1.8.5-1

  - Fixing the rhn_user PostgreSQL schema upgrades.
  - Adding schem upgrade script for rhnChecksumView.

• Tue Mar 13 2012 Jan Pazdziora 1.8.4-1

  - let's make rhnChecksumView perform better in PG (michael.mraka@redhat.com)
  - rhn_contact_monitoring: fix schema upgrade (mzazrivec@redhat.com)

• Fri Mar 09 2012 Miroslav Suchý 1.8.3-1

  - remove more password macros
  - remove RHN_DB_USERNAME from monitoring scout configuration
  - remove RHN_DB_PASSWD from monitoring scout configuration
  - remove RHN_DB_NAME from monitoring scout configuration
  - remove tableowner from monitoring scout configuration

• Thu Mar 08 2012 Milan Zazrivec <mzazrivec@redhat.com> 1.8.2-1

  - create_pxt_session: correct insert syntax (mzazrivec@redhat.com)
  - Allow for rhnPackageKey records to preexist already. (jpazdziora@redhat.com)

• Thu Mar 08 2012 Milan Zazrivec <mzazrivec@redhat.com> 1.8.1-1

  - pxt_session_cleanup: no need for autonomous_transaction
  - removed rhnEmailAddress* objects
  - find_mailable_address is no longer needed
  - don't call rhn_user.find_mailable_address for a valid email address
  - rhn_channel.update_needed_cache does not need autonomous_transaction

• Fri Mar 02 2012 Jan Pazdziora 1.7.55-1

  - Keys for Fedora 16 -- 18.
  - Update the copyright year info.

• Thu Mar 01 2012 Milan Zazrivec <mzazrivec@redhat.com> 1.7.54-1

  - use pg_dblink_exec to execute insert inside create_pxt_session

• Thu Mar 01 2012 Jan Pazdziora 1.7.53-1

  - On Fedora 16, we need to CREATE EXTENSION dblink.

• Thu Mar 01 2012 Jan Pazdziora 1.7.52-1

  - Create the dblink* functions during schema upgrade as well.
  - lookup_xccdf_profile: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_xccdf_profile
    (mzazrivec@redhat.com)
  - use autonomous_transaction for insert only (mzazrivec@redhat.com)

• Wed Feb 29 2012 Jan Pazdziora 1.7.51-1

  - Blend is case sensitive, let's try to play by its rules.
  - remove unused data from the rhnUserGroupType table (tlestach@redhat.com)

• Wed Feb 29 2012 Milan Zazrivec <mzazrivec@redhat.com> 1.7.50-1

  - lookup_xccdf_ident: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute inserts inside lookup_xccdf_ident
    (mzazrivec@redhat.com)
  - use autonomous_transaction for insert only (mzazrivec@redhat.com)
  - lookup_xccdf_benchmark: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_xccdf_benchmark
    (mzazrivec@redhat.com)
  - use autonomous_transaction for insert only (mzazrivec@redhat.com)

• Wed Feb 29 2012 Jan Pazdziora 1.7.49-1

  - Need to stop blend from attempting to expanding the \i dblink.sql in build
    time.

• Wed Feb 29 2012 Jan Pazdziora 1.7.48-1

  - Creating the dblink function(s) upon schema population, in schema public.
  - lookup_transaction_package: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to exec insert inside lookup_transaction_package
    (mzazrivec@redhat.com)
  - use autonomous_transaction for insert only (mzazrivec@redhat.com)
  - lookup_tag_name: schema upgrade (mzazrivec@redhat.com)
  - fix proc dependencies (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_tag_name
    (mzazrivec@redhat.com)
  - fix proc dependencies (mzazrivec@redhat.com)
  - use autonomous_transaction for insert only (mzazrivec@redhat.com)
  - lookup_tag: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_tag (mzazrivec@redhat.com)
  - fix proc dependencies (mzazrivec@redhat.com)
  - use autonomous_transaction for insert only (mzazrivec@redhat.com)
  - fix sha1 sums (mzazrivec@redhat.com)
  - lookup_source_name: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_source_name
    (mzazrivec@redhat.com)
  - fix proc dependencies (mzazrivec@redhat.com)
  - use autonomous_transaction in insert only (mzazrivec@redhat.com)

• Wed Feb 29 2012 Jan Pazdziora 1.7.47-1

  - fix lookup_config_info return (mzazrivec@redhat.com)
  - no need for autonomous_transaction in lookup_snapshot_invalid_reason
    (mzazrivec@redhat.com)
  - fix sha1 sum (mzazrivec@redhat.com)
  - lookup_package_nevra: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_package_nevra
    (mzazrivec@redhat.com)
  - use autonomous_transaction for insert only (mzazrivec@redhat.com)
  - lookup_package_name: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to exec insert inside lookup_package_name
    (mzazrivec@redhat.com)
  - use autonomous_transaction for insert only (mzazrivec@redhat.com)
  - fix sha1 sums (mzazrivec@redhat.com)
  - lookup_package_delta: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_package_delta
    (mzazrivec@redhat.com)
  - fix sha1 sums (mzazrivec@redhat.com)
  - use autonomous_transaction for insert_only (mzazrivec@redhat.com)
  - lookup_package_capability: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to exec insert inside lookup_package_capability
    (mzazrivec@redhat.com)
  - use autonomous_transaction for insert only (mzazrivec@redhat.com)

• Tue Feb 28 2012 Jan Pazdziora 1.7.46-1

  - fix insert_evr's return (mzazrivec@redhat.com)
  - lookup_evr: schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_evr (mzazrivec@redhat.com)
  - lookup_evr: use autonomous_transaction for insert only (mzazrivec@redhat.com)
  - no need for autonomous_transaction in lookup_erratafile_type
    (mzazrivec@redhat.com)
  - lookup_cve: postgresql schema upgrade (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_cve (mzazrivec@redhat.com)
  - lookup_cve: oracle schema upgrade (mzazrivec@redhat.com)
  - use autonomous_transaction for insert only (mzazrivec@redhat.com)
  - we don't need the autonomous_transaction pragma in lookup_config_info anymore
    (mzazrivec@redhat.com)
  - update postgresql procs dependencies (mzazrivec@redhat.com)
  - lookup_config_info: postgresql schema ugprade (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_config_info
    (mzazrivec@redhat.com)
  - lookup_config_info: correct proc dependencies (mzazrivec@redhat.com)
  - lookup_config_info: schema upgrade (mzazrivec@redhat.com)
  - restrict autonomous_transaction to insert only (mzazrivec@redhat.com)
  - create equivalent (empty) files for postgresql (mzazrivec@redhat.com)
  - fixing oracle equivalent source sha1s for upgrade scripts 081-092
    (tlestach@redhat.com)

• Mon Feb 27 2012 Simon Lukasik <slukasik@redhat.com> 1.7.45-1

  - Correct sha1sum of oracle equivalents (slukasik@redhat.com)

• Mon Feb 27 2012 Simon Lukasik <slukasik@redhat.com> 1.7.44-1

  - OpenSCAP integration -- Database schema upgrade. (slukasik@redhat.com)
  - OpenSCAP integration -- Database schema. (slukasik@redhat.com)
  - update postgresql procs dependencies (mzazrivec@redhat.com)
  - use coalesce and proper quoting (mzazrivec@redhat.com)
  - lookup_config_filename: postgresql schema upgrade script
    (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_config_filename
    (mzazrivec@redhat.com)
  - lookup_config_filename: schema upgrade script (mzazrivec@redhat.com)
  - restrict autonomous_transaction to insert only (mzazrivec@redhat.com)
  - use 'select into strict' (mzazrivec@redhat.com)
  - lookup_client_capability: schema upgrade script (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_client_capability
    (mzazrivec@redhat.com)
  - lookup_client_capability: oracle schema upgrade script (mzazrivec@redhat.com)
  - restrict autonomous_transaction to insert only (mzazrivec@redhat.com)
  - lookup_checksum: schema upgrade files (mzazrivec@redhat.com)
  - use pg_dblink_exec to execute insert inside lookup_checksum
    (mzazrivec@redhat.com)
  - restrict autonomous_transaction to insert only (mzazrivec@redhat.com)
  - pg_dblink_exec: schema upgrade script (mzazrivec@redhat.com)
  - weird schema-source-sanity-check.pl checks (mzazrivec@redhat.com)
  - fix checksum header (mzazrivec@redhat.com)
  - Introduce pg_dblink_exec for executing SQL queries in a separate db
    connection (mzazrivec@redhat.com)

• Mon Feb 27 2012 Jan Pazdziora 1.7.43-1

  - All Oracle triggers now have their PostgreSQL counterparts.

• Thu Feb 23 2012 Jan Pazdziora 1.7.42-1

  - Since the table rhn_current_alerts is gone, do not attempt to create trigger
    on it.

• Thu Feb 23 2012 Jan Pazdziora 1.7.41-1

  - Adding missing PostgreSQL variant of the rhn_checksumtype_mod_trig trigger.
  - The table rhn_current_alerts is no longer used, removing.
  - Purge the execution of com.redhat.rhn.taskomatic.task.CleanCurrentAlerts from
    taskomatic.

• Wed Feb 22 2012 Jan Pazdziora 1.7.40-1

  - Closing filehandles keeps world tidy.
  - Avoid segfault on RHEL 5.

• Tue Feb 21 2012 Jan Pazdziora 1.7.39-1

  - Adding checks for schema sources content (table names and such).
  - Create the trigger rhn_ksscript_mod_trig correctly on the rhnKickstartScript
    table.
  - Create the trigger rhn_conffiletype_mod_trig correctly on the
    rhnConfigFileType table.
  - Create the trigger rhn_enqueue_mod_trig correctly on the
    rhnErrataNotificationQueue table.
  - Create the trigger rhn_channel_package_mod_trig correctly on the
    rhnChannelPackage table.
  - Consolidate both rhnChannelCloned triggers to one, add the new.modified
    initialization to the PostgreSQL variant.

• Tue Feb 21 2012 Jan Pazdziora 1.7.38-1

  - Table rhnAppInstallInstance no longer used, dropping.
  - Table rhnAppInstallSession no longer used, dropping.
  - Prepare for dropping rhnAppInstallSession -- no more delete from it in
    rhn_org.
  - Prepare for dropping rhnAppInstallSession -- no more delete from it in
    delete_server.
  - Table rhnAppInstallSessionData no longer used, dropping.
  - Define PostgreSQL triggers in the function - trigger - function - trigger
    order to make checks easier.

• Mon Feb 20 2012 Tomas Lestach <tlestach@redhat.com> 1.7.37-1

  - 790803 - add ip6 to rhn_sat_node (tlestach@redhat.com)
  - 790803 - add vip6 to rhn_sat_cluster (tlestach@redhat.com)

• Mon Feb 20 2012 Jan Pazdziora 1.7.36-1

  - Removing synonyms notification_formats and ntfmt_recid_seq which are not used
    at all.
  - Use rhn_command_q_inst_recid_seq instead of the synonym, also drop
    command_queue_instances which is not used at all.
  - Use rhn_command_q_comm_recid_seq instead of the synonym, also drop
    command_queue_commands which is not used at all.
  - Synonym command_parameter_threshold not used, removing.

• Mon Feb 20 2012 Jan Pazdziora 1.7.35-1

  - Removing rhnUser synonym and just using the base web_contact.
  - Dropping valid_countries_tl as it is not used in the application.
  - Dropping new_user_postop as it is not used anywhere.

• Mon Feb 20 2012 Jan Pazdziora 1.7.34-1

  - Harden the schema-source-sanity-check.pl.
  - Fix the postgres/procs/delete_server.sql oracle equivalent source sha1.

• Thu Feb 16 2012 Jan Pazdziora 1.7.33-1

  - Need to re-create the view.

• Thu Feb 16 2012 Jan Pazdziora 1.7.32-1

  - Both oracle/views/views.deps and postgres/views/views.deps are noops by now,
    removing.
  - The view rhnOrgChannelFamilyPermissions is in common, fixing the deps.
  - A fast way to force the preferred_time_zone to be string.
  - The view rhn_customer_monitoring is the same on both database backends.
  - The view rhnWebContactEnabled can be rewritten to be the same on both
    database backends.
  - The view rhnUserChannelFamilyPerms is the same on both database backends.

• Thu Feb 16 2012 Jan Pazdziora 1.7.31-1

  - View rhnServerNeededPackageView no longer used after update_cache_for_server
    was removed.

• Thu Feb 16 2012 Jan Pazdziora 1.7.30-1

  - Removing note_count column from rhnVisServerGroupOverviewLite.
  - View rhnVisServerGroupOverview not used, removing.
  - Removing note_count column from rhnServerOverview.
  - Removing note_count column from rhnServerGroupOverview.

• Wed Feb 15 2012 Jan Pazdziora 1.7.29-1

  - No SHA1 of Oracle source in common files.
  - Catch situations when common or Oracle files claim SHA1 of Oracle source.
  - Adding oracle equivalent source sha1.
  - The rhnHistoryView* views do not seem to be used, removing.

• Wed Feb 15 2012 Jan Pazdziora 1.7.28-1

  - When upgrading from 1.6, the (smallint, numeric) variant is no longer there.

• Tue Feb 14 2012 Jan Pazdziora 1.7.27-1

  - Regenerate rhn_contact_monitoring.
  - Regenerate rhnWebContactDisabled.
  - Regenerate rhnVisServerGroupMembership.
  - Regenerate rhnUserChannelTreeView.
  - Regenerate rhnUserChannel.
  - Regenerate rhnUserActionOverview.
  - Regenerate rhnSharedChannelView.
  - Regenerate rhnSharedChannelTreeView.
  - Regenerate rhnServerGroupOVLiteHelper.
  - Regenerate rhnServerGroupMembership.
  - Regenerate rhnOrgChannelTreeView.
  - Regenerate rhnOrgChannelFamilyPermissions.
  - Regenerate rhnChannelTreeView.
  - Regenerate rhnChannelPermissions.
  - Regenerate rhnChannelFamilyServers.
  - Regenerate rhnActionOverview.
  - Fix wrong Oracle source SHA1 values.
  - properly mark the delete probe (mzazrivec@redhat.com)
  - forgotten trigger: time_series_purge_mod_trig (mzazrivec@redhat.com)
  - schema upgrade: cast columns to correct data type (numeric)
    (mzazrivec@redhat.com)
  - delete orphaned monitoring data during schema upgrade (mzazrivec@redhat.com)
  - rename upgrade script to avoid numbering conflict (mzazrivec@redhat.com)
  - rename scripts to avoid number conflicts (mzazrivec@redhat.com)
  - time_series revamped: schema upgrade (mzazrivec@redhat.com)
  - time_series revamped: new schema (mzazrivec@redhat.com)
  - Fixing typo in schema upgrade script; also, rhnServerOverview is not database
    specific.

• Tue Feb 14 2012 Jan Pazdziora 1.7.26-1

  - Fixing whitespaces, replacing spaces with tabs.
  - Silence NOTICEs and stuff.
  - The types directories are no more.
  - The user_group_id_t, user_group_label_t, and user_group_name_t no longer
    used, removing.
  - Removing rhnUserTypeArray which is no longer used.
  - The id_join, label_join, and name_join no longer used, removing.
  - Removing rhnUserTypeCommaView which is no longer used.

• Wed Feb 08 2012 Jan Pazdziora 1.7.25-1

  - Use rhn_user.role_names instead of rhnUserTypeCommaView.

• Tue Feb 07 2012 Jan Pazdziora 1.7.24-1

  - The delete_server proc is the last unverified source file.
  - PostgreSQL rhn_config_channel schema is equivalent to Oracle package body.
  - PostgreSQL rhn_server schema is equivalent to Oracle package body.
  - Creating the schema (for the package) goes into .pks.
  - Package rhn_date_manip only exists in Oracle and not used, removing.
  - No need to create the stub functions, PostgreSQL will compile stuff on-demand
    anyway.
  - Fixing typo in the stub exception message.
  - Removing get_org_for_config_content and set_org_quota_total from rhn_quota as
    it is not used.

• Mon Feb 06 2012 Jan Pazdziora 1.7.23-1

  - PostgreSQL packages have the same dependencies as the Oracle ones.
  - Fixing typo.
  - Removing the last three occurrences of rhn_set.set_iterator, and the whole
    package.
  - None of the files listed in the .gitignore exists or is produced, removing.
  - The header.txt file does not seem to be used anywhere, removing.

• Wed Feb 01 2012 Jan Pazdziora 1.7.22-1

  - Fixing oracle equivalent source sha1.

• Wed Feb 01 2012 Miroslav Suchý 1.7.21-1

  - rip off SNMP notification method

• Wed Jan 25 2012 Michael Mraka <michael.mraka@redhat.com> 1.7.20-1

  - 756918 - fix data for package_group

• Mon Jan 23 2012 Jan Pazdziora 1.7.19-1

  - Dropping rhn_bl_obs_mod_trig_fun which was not dropped when
    rhnBlacklistObsoletes was being removed.

• Mon Jan 23 2012 Jan Pazdziora 1.7.18-1

  - Drop any three-parameter rhn_prepare_install.

• Mon Jan 23 2012 Jan Pazdziora 1.7.17-1

  - 783223 - we need to drop the original smallint-ish functions.

• Mon Jan 23 2012 Jan Pazdziora 1.7.16-1

  - 783223 - We need to regenerate rhn_install_satellite and rhn_prepare_install.

• Mon Jan 23 2012 Michael Mraka <michael.mraka@redhat.com> 1.7.15-1

  - 756918 - fix data for package_group

• Wed Jan 18 2012 Michael Mraka <michael.mraka@redhat.com> 1.7.14-1

  - drop old refresh_newest_package prototype

• Tue Jan 17 2012 Michael Mraka <michael.mraka@redhat.com> 1.7.13-1

  - fixed checksums

• Tue Jan 17 2012 Michael Mraka <michael.mraka@redhat.com>

  - fixed checksums

• Tue Jan 17 2012 Jan Pazdziora 1.7.11-1

  - 782430 - avoid no_data_found from propagating out.

• Tue Jan 17 2012 Michael Mraka <michael.mraka@redhat.com> 1.7.10-1

  - enhanced procedure refresh_newest_package

• Tue Jan 17 2012 Jan Pazdziora 1.7.9-1

  - Fully qualify the rhn_cache.update_perms_for_user call.

• Mon Jan 16 2012 Miroslav Suchý 1.7.8-1

  - Revert "Avoing rhnChecksum_seq.nextval Oracle syntax."
  - Revert "Avoid using CURRENT_ALERTS_RECID_SEQ.NEXTVAL Oracle syntax."

• Fri Jan 13 2012 Miroslav Suchý 1.7.7-1

  - Avoid using CURRENT_ALERTS_RECID_SEQ.NEXTVAL Oracle syntax.
  - Avoing rhnChecksum_seq.nextval Oracle syntax.

• Fri Jan 13 2012 Tomas Lestach <tlestach@redhat.com> 1.7.6-1

  - 701767 - fixing sha1 of PG upgrade file (tlestach@redhat.com)

• Fri Jan 13 2012 Tomas Lestach <tlestach@redhat.com> 1.7.5-1

  - 701767 - an org shall access a channel even with a flex entitlement
    (tlestach@redhat.com)

• Fri Jan 06 2012 Jan Pazdziora 1.7.4-1

  - Dropping the prune_group procedure with the old prototype.

• Tue Jan 03 2012 Jan Pazdziora 1.7.3-1

  - Upon drop, the default must not be specified.

• Tue Jan 03 2012 Jan Pazdziora 1.7.2-1

  - Prevent output from being printed out for the second time to STDERR upon
    error, for direct mode.

• Mon Jan 02 2012 Jan Pazdziora 1.7.1-1

  - The rhn_entitlements.set_group_count is always called with type S in our
    code, removing the user group calls.

• Thu Dec 22 2011 Jan Pazdziora 1.6.42-1

  - Fix typo in source file name, add oracle equivalent source sha1.

• Wed Dec 21 2011 Tomas Lestach <tlestach@redhat.com> 1.6.41-1

  - update rhn_tasko_run_id_seq sequence number according to
    rhn_tasko_template_id_seq (tlestach@redhat.com)

• Wed Dec 21 2011 Milan Zazrivec <mzazrivec@redhat.com> 1.6.40-1

  - update sha1 sums
  - update copyright info

• Wed Dec 14 2011 Jan Pazdziora 1.6.39-1

  - For select_direct, print out immediatelly.

• Tue Dec 06 2011 Milan Zazrivec <mzazrivec@redhat.com> 1.6.38-1

  - pgsql schema upgrade: syntax fix & fix index names

• Mon Dec 05 2011 Milan Zazrivec <mzazrivec@redhat.com> 1.6.37-1

  - pgsql: consistent unique constraints
  - pgsql: consistent not null constraint

• Fri Dec 02 2011 Jan Pazdziora 1.6.36-1

  - 633975 - mark probe as updated if server IP address changed.

• Fri Dec 02 2011 Milan Zazrivec <mzazrivec@redhat.com> 1.6.35-1

  - schema sanity check: use newer Digest::SHA module

• Fri Dec 02 2011 Milan Zazrivec <mzazrivec@redhat.com> 1.6.34-1

  - spacewalk-sql: use exec to launch psql in direct mode
  - schema upgrade: run spacewalk-sql in direct mode
  - pgsql schema upgrade fix

• Thu Dec 01 2011 Milan Zazrivec <mzazrivec@redhat.com> 1.6.33-1

  - update oracle equivalent sha1 sums

• Wed Nov 30 2011 Milan Zazrivec <mzazrivec@redhat.com> 1.6.32-1

  - pgsql: schema upgrade fixes

• Tue Nov 29 2011 Miroslav Suchý 1.6.31-1

  - IPv6: in tables rhnRam, rhnCpu and rhnServerDMI allow only one record per
    server
  - IPv6: insert id from sequence using trigger
  - IPv6: get_hw_info_as_clob schema upgrade script (mzazrivec@redhat.com)
  - IPv6: upgrade script for rhn_server.pkb (mzazrivec@redhat.com)
  - IPv6: schema upgrade
  - IPv6: get_hw_info_as_clob: adapt to IPv6 changes (mzazrivec@redhat.com)
  - IPv6: update rhn_server.get_ip_address() to reflect IPv6 changes
    (mzazrivec@redhat.com)
  - IPv6: schema change

• Fri Nov 25 2011 Jan Pazdziora 1.6.30-1

  - Fix the in out parameter handling.

• Wed Nov 23 2011 Jan Pazdziora 1.6.29-1

  - Fixing wrong plpgsql code.

• Wed Nov 16 2011 Milan Zazrivec <mzazrivec@redhat.com> 1.6.28-1

  - pgsql: varchar2 -> varchar

• Fri Nov 04 2011 Milan Zazrivec <mzazrivec@redhat.com> 1.6.27-1

  - 679335 - store osa-dispatcher jabber password in DB

• Thu Nov 03 2011 Jan Pazdziora 1.6.26-1

  - On PostgreSQL, use varchar instead of varchar2.

• Wed Nov 02 2011 Tomas Lestach <tlestach@redhat.com> 1.6.25-1

  - introducing name for scripts in kickstart profiles in the webinterface
    (berendt@b1-systems.de)

• Thu Oct 20 2011 Miroslav Suchý 1.6.24-1

  - 745102 - add missing constraint to upgrade script

• Wed Oct 19 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.23-1

  - fixed rhnContentSourceFilter upgrade to match freshly created table

• Tue Oct 18 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.22-1

  - rhnContentSourceFilter stores package filters for repos

• Thu Oct 13 2011 Jan Pazdziora 1.6.21-1

  - Unspecified SHA1s have to be reported for upgrades.

• Tue Oct 11 2011 Miroslav Suchý 1.6.20-1

  - 745102 - add ip6addr column to rhnServerNetwork

• Fri Sep 30 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.19-1

  - 741782 - fixed data types in view

• Tue Sep 27 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.18-1

  - drop function must be inside package body
  - fixed table alias in update query
  - fixed clear_subscriptions() call with optional parameters

• Fri Sep 23 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.17-1

  - synced rhn_channel with oracle
  - synced rhn_entitlement with oracle

• Thu Sep 15 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.16-1

  - 529064 - fixed update_needed_cache which wrongly updated cache if a package
    was in more erratas

• Fri Sep 09 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.15-1

  - added EPEL to the list of package providers
  - added rpm signing keys for F15, CentOS 6, Scientfic Linux 6 and EPEL

• Wed Sep 07 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.14-1

  - create constraints out of table so new and upgraded schemas are equal

• Tue Sep 06 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.13-1

  - rhn_command_queue_instances.recid is not smallint anymore

• Fri Sep 02 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.12-1

  - upgrade scripts for SMALLINT -> NUMERIC
  - upgrade script for FLOAT -> NUMERIC fix
  - don't translate NUMBER(X) to SMALLINT or FLOAT

• Wed Aug 31 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.11-1

  - removed obsoleted warning
  - Fedora 15 needs explicit BuildRequires for python

• Tue Aug 30 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.10-1

  - fixed rhnReleaseChannelMap upgrade from 0.5 to 0.6

• Tue Aug 30 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.9-1

  - fixed rhn_command upgrade for schema <0.6
  - upgrade script for rhn_service_probe_origins
  - create contraint and its index at once
  - specify NOLOGGING directly
  - added sed script replacement for chameleon

• Wed Aug 17 2011 Tomas Lestach <tlestach@redhat.com> 1.6.8-1

  - 722189 - adding upgrade script (tlestach@redhat.com)
  - 722189 - omit updates for packages installed in several versions (like
    kernel) (tpapaioa@redhat.com)

• Tue Aug 16 2011 Simon Lukasik <slukasik@redhat.com> 1.6.7-1

  - Drop the old function, when creating a new one with different argumeters
    (slukasik@redhat.com)

• Mon Aug 15 2011 Michael Mraka <michael.mraka@redhat.com> 1.6.6-1

  - 700385 - schema upgrade scripts
  - 700385 - replaced synonym with original table_name
  - 700385 - created compatibility views for monitoring
  - 700385 - added all_tab_columns compatibility view

• Thu Aug 11 2011 Simon Lukasik <slukasik@redhat.com> 1.6.5-1

  - Do not confuse people by filename, this is not an upgrade of package
    (slukasik@redhat.com)
  - Apply necessary flex changes needed for submitting
    OrgSoftwareSubscriptions.do (slukasik@redhat.com)

• Thu Aug 11 2011 Tomas Lestach <tlestach@redhat.com> 1.6.4-1

  - 722189 - rewrite rhnServerNeededView to reflect all available errata
    (tlestach@redhat.com)

• Wed Aug 10 2011 Jan Pazdziora 1.6.3-1

  - We missed ON DELETE CASCADE in the past schema upgrade scripts -- fixing now.

• Fri Jul 29 2011 Jan Pazdziora 1.6.2-1

  - Adding empty directory for upgrades to 1.6.

• Fri Jul 29 2011 Jan Pazdziora 1.6.1-1

  - When versions match, it really is not an error.

• Fri Jul 15 2011 Jan Pazdziora 1.5.6-1

  - 711064 - flip the order of iscsi and iscsiname in the kickstart file.

• Tue May 24 2011 Jan Pazdziora 1.5.5-1

  - 679333 - update rhnPushClient when deleting server (mzazrivec@redhat.com)

• Wed Apr 20 2011 Michael Mraka <michael.mraka@redhat.com> 1.5.4-1

  - in postgres we should upgrade only the affected function

• Mon Apr 18 2011 Michael Mraka <michael.mraka@redhat.com> 1.5.3-1

  - added available_fve_chan_subs to postgresql rhn_channel.pkb

• Mon Apr 18 2011 Jan Pazdziora 1.5.2-1

  - Need to have separate schema upgrade for PostgreSQL, we do not process schema
    upgrades with chameleon.

• Fri Apr 15 2011 Jan Pazdziora 1.5.1-1

  - Fix the oracle equivalent source sha1s for the weak dependencies schema
    sources.
  - The schema upgrade for the weak dependencies is for Spacewalk 1.5.
  - database tables for weak dependencies (mc@suse.de)

• Fri Apr 08 2011 Jan Pazdziora 1.4.18-1

  - Adding missing rhnErrataBuglistTmp schema upgrade scripts.

• Fri Apr 08 2011 Jan Pazdziora 1.4.17-1

  - Add 'from' to Errata and 'href' to ErrataBuglist in database schema
    (ug@suse.de)

• Fri Apr 08 2011 Michael Mraka <michael.mraka@redhat.com> 1.4.16-1

  - fixed checksum

• Fri Apr 08 2011 Michael Mraka <michael.mraka@redhat.com> 1.4.15-1

  - added schema upgrade for rhn_config.pkb on postgresql (PG)
  - postgresql doesn't support aliases in update query

• Tue Apr 05 2011 Jan Pazdziora 1.4.14-1

  - Forcing strict order of processing in rhn_sg_del_trig, to avoid deadlock.

• Wed Mar 30 2011 Tomas Lestach <tlestach@redhat.com> 1.4.13-1

  - 671450 - delete rhel private channel families, if there're no certificate
    entitlements available (tlestach@redhat.com)

• Wed Mar 23 2011 Jan Pazdziora 1.4.12-1

  - In update, the column names should not contain table name (PostgreSQL).

• Tue Mar 22 2011 Jan Pazdziora 1.4.11-1

  - There is no cursor() function for inline cursors in PostgreSQL, using custom
    function get_hw_info_as_clob instead.

• Thu Mar 10 2011 Jan Pazdziora 1.4.10-1

  - Using sequence_nextval instead of the .nextval.
  - update database to support SUSE distributions (ug@suse.de)
  - suse breed added to ksinstalltype (ug@suse.de)

• Wed Mar 09 2011 Jan Pazdziora 1.4.9-1

  - Make the filename absolute so that it works even after we cd to root.

• Fri Mar 04 2011 Michael Mraka <michael.mraka@redhat.com> 1.4.8-1

  - added schema upgrade script for rhnBlacklistObsoletes
  - removed rhnBlacklistObsoletes table
  - created postgresql upgrade script for or rhnVirtualization.uuid index

• Thu Mar 03 2011 Michael Mraka <michael.mraka@redhat.com> 1.4.7-1

  - upgrade script for rhnVirtualization.uuid index
  - 468690 - added index to rhnVirtualization.uuid

• Fri Feb 25 2011 Jan Pazdziora 1.4.6-1

  - Need to return new at the end of a trigger function.

• Thu Feb 24 2011 Jan Pazdziora 1.4.5-1

  - Adding a schema upgrade script for the sat_node_probe drop.
  - Adding a schema upgrade script for the web_cust_notif_seq drop.

• Wed Feb 23 2011 Michael Mraka <michael.mraka@redhat.com> 1.4.4-1

  - schema upgrade script for dropped tables

• Tue Feb 22 2011 Michael Mraka <michael.mraka@redhat.com> 1.4.3-1

  - removed unused rhn_sat_node_probe table
  - rhn_synch_probe_state doesn't depend on rhn_satellite_state
  - removed unused table web_customer_notification

• Fri Feb 18 2011 Jan Pazdziora 1.4.2-1

  - Make the index on rhnActionErrataUpdate (action_id, errata_id) unique.

• Mon Feb 07 2011 Jan Pazdziora 1.4.1-1

  - Fixed rhn_ugm_applicant_fix_fun trigger function.

• Thu Jan 27 2011 Michael Mraka <michael.mraka@redhat.com> 1.3.18-1

  - 671464 - added schema upgrade for new keys 
  - added Fedora 14 key
  - added Fedora 13 key
  - added new Spacewalk key
  - 671464 - added RHEL6 key
  - For upgrades, missing PostgreSQL equivalent is an error.
  - Catch situation when both .sql and .sql.oracle or .sql.postgresql schema
    upgrade scripts exist.

• Tue Jan 25 2011 Jan Pazdziora 1.3.17-1

  - Add PostgreSQL schema upgrade scripts for 1.2 -> 1.3 upgrade.

• Fri Jan 21 2011 Jan Pazdziora 1.3.16-1

  - The evr_t_as_vre_simple is not available on old Spacewalks, fixed.

• Fri Jan 21 2011 Jan Pazdziora 1.3.15-1

  - Changed spacewalk-schema-upgrade to use spacewalk-sql, to run on PostgreSQL.

• Thu Jan 20 2011 Tomas Lestach <tlestach@redhat.com> 1.3.14-1

  - updating Copyright years for year 2011 (tlestach@redhat.com)
  - The maximum pagesize is 50000 -- this will prevent the headings to be
    repeated. (jpazdziora@redhat.com)
  - Add linesize 4000 to allow long enough lines to be returned.
    (jpazdziora@redhat.com)

• Wed Jan 19 2011 Jan Pazdziora 1.3.13-1

  - Using array should be faster than appending string.
  - Added --select-mode-direct option to print out the sqlplus/psql output right
    when we get it.
  - Show --verbose and --select-mode options in usage; also show usage when
    Getopt::Long::GetOptions fails.

• Wed Jan 19 2011 Michael Mraka <michael.mraka@redhat.com> 1.3.12-1

  - fixed failed 1.1 -> 1.3 upgrade test

• Tue Jan 18 2011 Jan Pazdziora 1.3.11-1

  - The table rhnPackageChangelog is dropped in 103-rhnPackageChangeLog-
    refactoring.sql, no need to alter it here.

• Tue Jan 11 2011 Jan Pazdziora 1.3.10-1

  - Add spacewalk-sql which unifies sqlplus and psql invocation.

• Fri Jan 07 2011 Michael Mraka <michael.mraka@redhat.com> 1.3.9-1

  - 662563 - rhn_sndpb_pid_ptype_idx was used for rhn_sndpb_probe_id_pk enforcement
  - 662563 - rhn_efilectmp_cid_efid_idx was used for rhn_efilectmp_efid_cid_uq enforcement
  - 662563 - web_contact_id_oid_cust_luc was used for web_contact_pk enforcement
  - 662563 - rhn_package_path_idx was used for rhn_package_id_pk enforcement
  - 653510 - deleting a virt host had a virtual entitlement that would not properly
    move its guests to flex entitled if it was available
  - 667232 - fixing issue where balancing of guests between flex an regular
    entitlements did would not work correctly, making certificates very difficult
    to activate

• Thu Dec 23 2010 Jan Pazdziora 1.3.8-1

  - Mark PostgreSQL rhn_user schema as equivalent to the Oracle package.
  - Dropping rhn_user.add_users_to_usergroups as it is now used anymore.
  - Dropping rhn_user.remove_users_from_servergroups as it is not used anywhere.

• Thu Dec 23 2010 Jan Pazdziora 1.3.7-1

  - Marking PostgreSQL rpm schema equivalent to the Oracle package.
  - Fix PostgreSQL rpm.vercmp to handle empty string epoch gracefully.
  - Removing vercmpCounter and vercmpResetCounter from rpm package as they are
    not used anywhere.
  - Procedure channel_name_join not used anywhere, removing (together with the
    channel_name_t type).
  - View rhnUsersInOrgOverview does not use web_user_site_info, fixing the deps.
  - Mark postgres/end.sql as equivalent to the oracle variant (even if they do
    different things).
  - Function rhn_org.find_server_group_by_type not used anywhere, removing.
  - The rhn_package database package is not used, removing.

• Wed Dec 22 2010 Jan Pazdziora 1.3.6-1

  - Fixed the rhnPackage.build_time type on PostgreSQL to
    address rhnpush error.

• Tue Dec 14 2010 Jan Pazdziora 1.3.5-1

  - 661109 - the schema upgrade script has to have extension .sql.

• Tue Dec 14 2010 Jan Pazdziora 1.3.4-1

  - 661109 - fixing issue where channel subscription would not use a flex guest
    subscription if the system already was using  a flex guest subscription for a
    different channel (jsherril@redhat.com)

• Wed Dec 01 2010 Jan Pazdziora 1.3.3-1

  - 650129 - don't change last_modified values during schema upgrade
    (mzazrivec@redhat.com)
  - drop unused rhnDaemonState table (tlestach@redhat.com)

• Mon Nov 22 2010 Michael Mraka <michael.mraka@redhat.com> 1.3.2-1

  - 655509 - fixed namespace

• Thu Nov 18 2010 Lukas Zapletal 1.3.1-1

  - Replacing rownum with limit-offset syntax 
  - 645694 - introducing cleanup-packagechangelog-data task 
  - Bumping package versions for 1.3.

• Sun Nov 14 2010 Tomas Lestach <tlestach@redhat.com> 1.2.69-1

  - create oracle compatible set of 'instr' functions for postgres(PG)
    (tlestach@redhat.com)

• Sat Nov 13 2010 Tomas Lestach <tlestach@redhat.com> 1.2.68-1

  - better call stored functions with correct parameter order
    (tlestach@redhat.com)

• Fri Nov 12 2010 Tomas Lestach <tlestach@redhat.com> 1.2.67-1

  - remove 2 extra params from the stored proc and include oracle equivalent sha1
    (tlestach@redhat.com)
  - fix typo: rh_config -> rhn_config (tlestach@redhat.com)
  - change filemode_in type in stored proc to match the DB type
    (tlestach@redhat.com)

• Thu Nov 11 2010 Lukas Zapletal 1.2.66-1

  - Putting packages/rhn_org.pkb in sync with ORA (PG)

• Wed Nov 10 2010 Lukas Zapletal 1.2.65-1

  - Adding missing PLSQL function update_needed_cache (PG)

• Wed Nov 03 2010 Jan Pazdziora 1.2.64-1

  - correct the rule for rhnUser (mzazrivec@redhat.com)
  - define rhnUser as a view of web_customer (mzazrivec@redhat.com)

• Tue Nov 02 2010 Jan Pazdziora 1.2.63-1

  - Update copyright years in schema/.

• Tue Nov 02 2010 Jan Pazdziora 1.2.62-1

  - Generally, we use sequence_nextval when populating tables, we will just
    require it for all tables.
  - Removing sqlplus-specific pieces.
  - Replace sysdate with current_timestamp now that common/data is not processed
    by chameleon.
  - Replace .nextval notation with sequence_nextval now that common/data is not
    processed by chameleon.
  - Turn off chameleon processing for common/data.
  - Merging the db-specific data/ sources to common/data.
  - fixed typo in upgrade script (tlestach@redhat.com)
  - Fixing typo in comment.
  - Cannot use the .nextval notation in PostgreSQL sources (which became
    .sequence_nextval with the previous substitution).
  - Replace sydate with current_timestamp in Oracle sources.
  - Replace nextval with sequence_nextval in PostgreSQL sources.
  - Replace .nextval with sequence_nextval in Oracle sources.
  - Fixed the oracle equivalent source sha1 of rhnTaskoSchedule.sql.

• Mon Nov 01 2010 Tomas Lestach <tlestach@redhat.com> 1.2.61-1

  - adding new TimeSeriesCleanUp taskomatic task (tlestach@redhat.com)

• Mon Nov 01 2010 Tomas Lestach <tlestach@redhat.com> 1.2.60-1

  - 645702 - adding upgrade script for delete_errata procedure
    (tlestach@redhat.com)
  - updating sha1 in postgres procs/delete_errata.sql file (tlestach@redhat.com)

• Mon Nov 01 2010 Tomas Lestach <tlestach@redhat.com> 1.2.59-1

  - 645702 - remove rhnPaidErrataTempCache temporary table (tlestach@redhat.com)

• Mon Nov 01 2010 Jan Pazdziora 1.2.58-1

  - Missed drop of rhnSatelliteChannelFamily in schema upgrades, dropping now.

• Fri Oct 29 2010 Jan Pazdziora 1.2.57-1

  - The Oracle version and use of find_compatible_sg was changed in
    b6832310938382e6f4e0f3c2d26807f4594ae96d, the comment no longer true.
  - Move the source of find_compatible_sg up in the file, to match the position
    of the Oracle code.
  - Apply change 15c8aa97447223934e3e9c991b76deef466b0b9b to PostgreSQL code.
  - We have rhn_snapshotpkg_sid_nid_uq, no need to have another index on column
    snapshot_id.
  - We have rhn_sprofile_id_oid_bc_idx and rhn_server_profile_noid_uq, so
    rhn_server_profile_o_id_bc_idx is not useful, removing.
  - Clearing the ancient changelogs for rhn_channel.
  - Removing rhnSatelliteChannelFamily as it is no longer referenced.
  - Fixing dependencies for rhnRepoRegenQueue.
  - No need to have index which includes column which is in primary key and the
    first two which are in rhn_pkgnevra_nid_eid_paid_uq.

• Wed Oct 27 2010 Lukas Zapletal 1.2.56-1

  - Addresing recursion with opened cursor in PostgreSQL 
  - Function unsubscribe_server now in sync with Oracle 
  - Function numtodsinterval now accepts days, minutes, hours (incl. fix)

• Mon Oct 25 2010 Lukas Zapletal 1.2.55-1

  - Taskomatic schedule schema correction (sysdate)

• Mon Oct 25 2010 Lukas Zapletal 1.2.54-1

  - Taskomatic data being inserted in PostgreSQL schema now
  - Default cast fix for PostgreSQL

• Mon Oct 25 2010 Jan Pazdziora 1.2.53-1

  - Fix dependencies for rhnUserReceiveNotifications.

• Fri Oct 22 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.52-1

  - removed unused views
  - reviewed more indexes

• Fri Oct 22 2010 Tomas Lestach <tlestach@redhat.com> 1.2.51-1

  - 529064 - fixed update_needed_cache which wrongly updated cache if a package
    was in more erratas (michael.mraka@redhat.com)
  - We cannot touch old if tg_op is INSERT. (jpazdziora@redhat.com)
  - Use uniform eight character indents; clean trailing blanks.
    (jpazdziora@redhat.com)

• Fri Oct 22 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.50-1

  - reviewed indexes
  - rhnPrivateErrataMail is unused; dropping

• Thu Oct 21 2010 Jan Pazdziora 1.2.49-1

  - Need to add date_diff_in_days to schema upgrade scripts.
  - Missed the rhnPackageChangeLog view from schema upgrades, fixing.
  - Fixing the rhn_pkg_cld_id_seq update for situations when there is no data in
    rhnPackageChangeLogData.

• Wed Oct 20 2010 Lukas Zapletal 1.2.48-1

  - Trigger rhn_server_group_org_mapping_fun was missing return clause
  - Reformat of rhnServerGroupMembers.sql prior to next change
  - PostgreSQL function array_upper returns NULL on empty array

• Wed Oct 20 2010 Jan Pazdziora 1.2.47-1

  - Dropping rhn_package_changelog_id_trig. The id is always specified explicitly
    (it seems).
  - Fixing the SHA1 mapping.
  - Schema upgrade script for the new trigger on rhnPackageChangeLogRec.
  - Move the triggers from rhnPackageChangeLog to rhnPackageChangeLogRec.

• Wed Oct 20 2010 Jan Pazdziora 1.2.46-1

  - Process in chunks of 10000 packages, so that we do not blow the undo
    tablespace.
  - Schema upgrade script for the rhnPackageChangeLog refactoring.
  - Replace the rhnPackageChangeLog table with compatibility view, so that we do
    not have to rewrite code which just reads the table.
  - To save space for rhnPackageChangeLog data, split the table to two.

• Tue Oct 19 2010 Jan Pazdziora 1.2.45-1

  - 644349 - do not update/delete all errata entries when the erratum affects
    multiple channels (tlestach@redhat.com)
  - Fixing the date_diff_in_days source.
  - Use numtodsinterval instead of the arithmetics.

• Mon Oct 18 2010 Jan Pazdziora 1.2.44-1

  - Remove the timestamptz_minus_int and minus operator -- we want the interval
    issue addressed properly.
  - Fixing typo; also making the nextval call hopefully faster by not going to SQL.
  - We cannot touch old if tg_op is INSERT.

• Mon Oct 18 2010 Lukas Zapletal 1.2.43-1

  - Fixed rhnServerOverview VIEW to return numeric

• Mon Oct 18 2010 Lukas Zapletal 1.2.42-1

  - Universal function date_diff_in_days introduced

• Mon Oct 18 2010 Jan Pazdziora 1.2.41-1

  - table rhn_host_check_suites has been removed, drop its synonym
    (michael.mraka@redhat.com)
  - table rhnSavedSearchType has been removed, drop its sequence
    (michael.mraka@redhat.com)
  - table rhnSavedSearch has been removed, drop its sequence
    (michael.mraka@redhat.com)
  - table rhnRelationshipType has been removed, drop its sequence
    (michael.mraka@redhat.com)
  - table rhnProductLine has been removed, drop its sequence
    (michael.mraka@redhat.com)
  - table rhnProduct has been removed, drop its sequence
    (michael.mraka@redhat.com)
  - table rhnMessagePriority has been removed, drop its sequence
    (michael.mraka@redhat.com)
  - table rhnMessage has been removed, drop its sequence
    (michael.mraka@redhat.com)
  - table rhnMessageType has been removed, drop its sequence
    (michael.mraka@redhat.com)
  - table rhnMonitor has been removed, drop its sequence
    (michael.mraka@redhat.com)
  - table rhnMonitorGranularity has been removed, drop its sequence
    (michael.mraka@redhat.com)
  - table rhnGrailComponents has been removed, drop its sequence
    (michael.mraka@redhat.com)

• Mon Oct 18 2010 Jan Pazdziora 1.2.40-1

  - fixed typo (michael.mraka@redhat.com)
  - fixed index name (michael.mraka@redhat.com)
  - rhn_cnp_pid_idx was not removed from schema (michael.mraka@redhat.com)
  - fixed ORA-02429: cannot drop index used for enforcement of unique/primary key
    (michael.mraka@redhat.com)
  - Default number in Postgresql views is int8 now (lzap+git@redhat.com)
  - Added update_neede_cache to Postgresql rhn_server.pkb (lzap+git@redhat.com)
  - Postgres rhn_channel.subscribe_server now in sync with Oracle
    (lzap+git@redhat.com)
  - Oracle old changelog removed from rhn_channel.pkb (lzap+git@redhat.com)

• Fri Oct 15 2010 Jan Pazdziora 1.2.39-1

  - Add support for the update_family_countsYN parameter to
    rhn_entitlements.prune_group.
  - Fix PostgreSQL rhn_entitlements.set_group_count to match the Oracle version
    (and have five arguments as well).
  - We only need one comps record per channel, adding unique constraint.
  - rhn_host_check_suites is unused; dropping (michael.mraka@redhat.com)
  - rhnSatelliteServerGroup is unused; dropping (michael.mraka@redhat.com)
  - rhnMessageType is unused; dropping (michael.mraka@redhat.com)
  - rhnMessagePriority is unused; dropping (michael.mraka@redhat.com)
  - rhnMessage is unused; dropping (michael.mraka@redhat.com)

• Thu Oct 14 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.38-1

  - 642962 - fixed issue where some of group by columns are null
  - fixed build errors
  - there are only deletes from rhnServerMessage; dropping
  - Mark the PostgreSQL rhn_exception package as equivalent to the Oracle
    version.
  - The cursor exception_details not invoked from anywhere besices
    lookup_exception, no need to have it as package interface.
  - Merging Oracle rhn_cache.pkb to PostgreSQL version.

• Thu Oct 14 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.37-1

  - removed rhnProductLine
  - removed rhnSavedSearchType
  - removed rhnPackageSense
  - removed rhnProduct
  - removed rhnMonitorGranularity
  - removed rhnServerCacheInfo
  - removed rhnSavedSearch
  - removed rhnRelationshipType
  - removed rhnProductChannel
  - removed rhnPathChannelMap
  - removed rhnPackageSenseMap
  - removed rhnMonitor
  - removed rhnGrailComponents
  - removed rhnGrailComponentChoices
  - removed rhnEmailAddressLog
  - removed rhnChannelParent
  - removed rhnActionPackageOrder
  - Use numeric instead of number in PostgreSQL. 
  - reviewed indexes for rhnErrataFileChannelTmp 
  - reviewed indexes for rhnErrataFileChannel

• Wed Oct 13 2010 Lukas Zapletal 1.2.36-1

  - Function rhn_channel.subscribe_server now in sync (Pg-Ora)

• Wed Oct 13 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.35-1

  - reviewed more indexes

• Wed Oct 13 2010 Jan Pazdziora 1.2.34-1

  - Apply necessary flex changes needed for rhn-satellite-activate.
  - Removing old changelog entries from rhn_entitlements.pkb source file.
  - Rewrite the use of find_compatible_sg to match the one in PostgreSQL sources
    (no out parameter).
  - The function find_compatible_sg is only used from within rhn_entitlements, no
    need to have it in the interface (.pks).
  - Removing prune_everything procedure as it no longer exists in the Oracle
    sources either.
  - Removing old changelog entries from rhn_entitlements.pks source file.
  - Add the flex_in and update_family_countsYN to the PostgreSQL version of
    rhn_entitlements.pks (no pkb yet).
  - The table rhn_interface_monitoring is not used anywhere (besides deleting
    from it), removing.
  - reviewed indexes for rhnCryptoKeyKickstart (michael.mraka@redhat.com)
  - The view rhn_host_monitoring just selects from rhnServer, no need to depend
    on three other objects.

• Wed Oct 13 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.33-1

  - schema upgrades for deleted tables and indexes
  - reviewed and minimized number of indexes

• Tue Oct 12 2010 Tomas Lestach <tlestach@redhat.com> 1.2.32-1

  - 630884 - send errata notifications after errata cache get's regenerated
    (tlestach@redhat.com)
  - 642287 - schema upgrade script for rhnChannelNewestPackageView
    (mzazrivec@redhat.com)
  - 642287 - restrict rhnChannelNewestPackageView to packages in channels
    (mzazrivec@redhat.com)
  - The schema sanity checking now reports (but ignores) if the PostgreSQL
    sources do not report SHA1 of the Oracle equivalent. (jpazdziora@redhat.com)
  - there were only deletes from rhnTransaction; removing
    (michael.mraka@redhat.com)
  - rhnTransactionElement is not referenced anywhere; removing
    (michael.mraka@redhat.com)
  - removing dead rhnActionTransactions table (michael.mraka@redhat.com)
  - We need to start processing .pks and .pkb files as well because we will want
    to keep the procedural sources in sync too. (jpazdziora@redhat.com)
  - We currently do no have any useful content to put to postgres/start.sql, we
    just silence the sanity checking script. (jpazdziora@redhat.com)
  - reviewed indexes for rhnActionErrataUpdate (michael.mraka@redhat.com)
  - reviewed indexes for rhnActionConfigRevision (michael.mraka@redhat.com)
  - reviewed indexes for rhnActionConfigFileName (michael.mraka@redhat.com)
  - The table rhnAllowTrust not used anywhere, removing. (jpazdziora@redhat.com)
  - The table rhnEntitlementLog not used anywhere, removing.
    (jpazdziora@redhat.com)
  - The table rhnTextMessage not used anywhere, removing. (jpazdziora@redhat.com)
  - The table rhn_command_center_state and synonym command_center_state not used
    anywhere, removing. (jpazdziora@redhat.com)
  - The table rhn_command_queue_execs_bk and synonym command_queue_execs_bk not
    used anywhere, removing. (jpazdziora@redhat.com)
  - The table rhn_command_queue_instances_bk and synonym
    command_queue_instances_bk not used anywhere, removing.
    (jpazdziora@redhat.com)
  - The table rhn_schedule_days_norm and synonym schedule_days_norm not used
    anywhere, removing. (jpazdziora@redhat.com)
  - reviewed indexes for rhnActionConfigChannel (michael.mraka@redhat.com)

• Tue Oct 12 2010 Jan Pazdziora 1.2.31-1

  - 571608 - delete duplicate kickstart_id, package_name_id pairs
    (mzazrivec@redhat.com)

• Fri Oct 08 2010 Lukas Zapletal 1.2.30-1

  - Added constriants on all varchar columns to check '' values (pg)
  - Fixed inserting of empty varchars instead of NULL

• Fri Oct 08 2010 Tomas Lestach <tlestach@redhat.com> 1.2.29-1

  - substitute '' with null (oracle believes it's the same) (tlestach@redhat.com)

• Thu Oct 07 2010 Partha Aji <paji@redhat.com> 1.2.28-1

  - 641145: Updated kickstart timezone and install information needed for Rhel 6
    profiles (paji@redhat.com)

• Thu Oct 07 2010 Jan Pazdziora 1.2.27-1

  - Since the oracle/procs/lookup_config_info.sql was changed, we need to update
    the SHA1 in the PostgreSQL source.

• Thu Oct 07 2010 Jan Pazdziora 1.2.26-1

  - nvl removal for Oracle is not necessary, reverting (lzap+git@redhat.com)
  - upgrade script for 2a3a755ed052a0c3435a00d1e6c1c6c9c3ecc470
    (michael.mraka@redhat.com)
  - Avoid the integer arithmetics with timestamps in PostgreSQL.
  - Upgrade to Satellite 5.1 from older versions put newline to proxy.deactivate
    record; we shall fix it now.

• Tue Oct 05 2010 Jan Pazdziora 1.2.25-1

  - Fixed PostgreSQL trigger rhn_channel_access_trig_fun.
  - Avoid using rhn_repo_regen_queue_id_seq.nextval Oracle syntax in
    request_repo_regen.
  - postgres header comment cleanup (lzap+git@redhat.com)
  - old changelogs from Oracle sql script(s) removed (lzap+git@redhat.com)
  - Oracle-Postgres schema synchronization (lzap+git@redhat.com)
  - The nvl source is PostgreSQL-specific.
  - PostgreSQL NVL stored procedure (colin.coe@gmail.com)
  - updated rhnServerOverview.sql for Postgres (lzap+git@redhat.com)
  - oracle rhnServerOverview old revision log deletion (lzap+git@redhat.com)
  - added upgrade script for queue_errata, rhnSNPErrataQueue and
    rhnSNPServerQueue removal (michael.mraka@redhat.com)
  - there were only deletes from rhnSNPServerQueue, no inserts/updates; thus
    removing as a dead code (michael.mraka@redhat.com)
  - after queue_errata() removal rhnSNPErrataQueue not used anymore
    (michael.mraka@redhat.com)
  - removing read queue_errata() from deps (michael.mraka@redhat.com)
  - queue_errata() not called anywhere; removing dead procedure
    (michael.mraka@redhat.com)

• Thu Sep 30 2010 Tomas Lestach <tlestach@redhat.com> 1.2.24-1

  - 638893 - removing duplicate cert-check-bunch (tlestach@redhat.com)
  - Make schema-source-sanity-check.pl happy again. (jpazdziora@redhat.com)
  - Update copyright years. (jpazdziora@redhat.com)
  - Mark the Oracle source equivalents in our PostgreSQL source files.
    (jpazdziora@redhat.com)
  - 634263 - adding upgrade for previous commit (jsherril@redhat.com)
  - 634263 - fixing issue where converting host from virt entitled to not, would
    cause guests registered in other orgs to consume a regular entitelment even
    when a flex was available (jsherril@redhat.com)

• Mon Sep 27 2010 Miroslav Suchý <msuchy@redhat.com> 1.2.23-1

  - Marked PostgreSQL schema sources that are PostgreSQL-specific.
    (jpazdziora@redhat.com)
  - The adler32 function does not seem to be used, removing.
    (jpazdziora@redhat.com)
  - 636740 - asterisks in package search fixed (lzap+git@redhat.com)

• Mon Sep 20 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.22-1

  - removed sequence used for rhnUserMessageStatus ids

• Tue Sep 14 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.21-1

  - reverted "633263 - removed sha384 from list of checksums"

• Tue Sep 14 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.20-1

  - 633263 - removed sha384 from list of checksums

• Mon Sep 13 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.19-1

  - added upgrade script for rhnUserMessageType

• Thu Sep 09 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.18-1

  - upgrade script for rhn_org.pkb

• Thu Sep 09 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.17-1

  - dead code cleanup
  - 538663 - unset references to to-be-deleted user in rhnConfigRevision

• Tue Sep 07 2010 Jan Pazdziora 1.2.16-1

  - The schema upgrade scripts have to have suffix .sql.
  - Return the syntax of constraints to the state before Spacewalk 0.5.
  - The upgrade script from 0.5 to 0.6 created the constraint
    rhn_ksscript_rawscript_ck without naming it, recreate properly now.
  - Also make sure the rhn_ks_type_ck constraint spelling matches the upgrade
    script.
  - The upgrade script from 0.3 to 0.4 did not match the constraint definition in
    0.4, fixing.
  - Also make sure the rhn_cntgp_rotate_f_ck constraint spelling matches the
    upgrade script.
  - In the past, we have changed the rhn_cntgp_rotate_f_ck to use strings instead
    of numbers; now adding the schema upgrade script.
  - Upon upgrade from Spacewalk 0.3 to 0.4, we have lost the
    rhn_package_compat_check check, adding back.
  - rhn_server.pks upgrade have to go before rhn_channel.pkb
    (michael.mraka@redhat.com)

• Tue Sep 07 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.15-1

  - 573630 - implemented update_needed_cache for channel in pl/sql
  - fixed upgrade script for rhnPackageUpgradeArchCompat-data
  - fixed query for errata mailer

• Mon Sep 06 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.14-1

  - one more upgrade compatibility map fix

• Mon Sep 06 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.13-1

  - fixed sparc and deb package upgrade compatibility map

• Mon Sep 06 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.12-1

  - 573630 - move update_needed_cache implementation to db
  - 585965 - rhnServerNeededView rewritten from scratch
  - converted dates to ISO format
  - 567178 - adding Pacific/Auckland time zone
  - 495973 - adding America/Regina time zone

• Thu Sep 02 2010 Jan Pazdziora 1.2.11-1

  - Reapply rhn_cache and rhn_org package and rhn_user package and package body,
    to make for clean schema upgrades from 0.2.
  - After running the schema upgrade, recompile the PL/SQL objects and check that
    there are no invalid objects left behind.
  - add upgrade hint for quartz tables (tlestach@redhat.com)

• Wed Sep 01 2010 Jan Pazdziora 1.2.10-1

  - 626741 - do not allow two repos with same label or repository url

• Mon Aug 30 2010 Partha Aji <paji@redhat.com> 1.2.9-1

  - Fixed a typo in the column name in rhnKsdata table (paji@redhat.com)
  - 627149 - do not return installtime via xmlrpc when not defined
    (tlestach@redhat.com)
  - 529232 - add 'no base' and 'ignore missing' options to kickstart
    (coec@war.coesta.com)

• Fri Aug 27 2010 Tomas Lestach <tlestach@redhat.com> 1.2.8-1

  - fix errata-cache-bunch template (tlestach@redhat.com)

• Thu Aug 26 2010 Michael Mraka <michael.mraka@redhat.com> 1.2.7-1

  - 593896 - schema upgrade script rewritten to pl/sql
  - 591291 - rewrite rhnChannelNewestPackageView
  - 619337 - making it so that if a packages checksum changes, the channel it is
    will have its repodata regenerated
  - location of schema overrides (for oracle) has changed
  - 627149 - adding upgrade script for rpm installation dates

• Tue Aug 24 2010 Partha Aji <paji@redhat.com> 1.2.6-1

  - removing stray semicolon (jsherril@redhat.com)

• Tue Aug 24 2010 Partha Aji <paji@redhat.com> 1.2.5-1

  - Added a number next to the upgrade script to indicate the execution pt..
    (paji@redhat.com)
  - 593896 - Moved Kickstart Parition UI logic (paji@redhat.com)

• Tue Aug 24 2010 Milan Zazrivec <mzazrivec@redhat.com> 1.2.4-1

  - remove unnecessary comments from resulting schema
  - do not schedule repo-sync-bunch by default, sice it is an org task
  - add on delete constraint to rhnTaskoRun

• Thu Aug 19 2010 Tomas Lestach <tlestach@redhat.com> 1.2.3-1

  - move RepoSyncTask from satellite to organization level (tlestach@redhat.com)
  - update description for bunches with arguments (tlestach@redhat.com)

• Tue Aug 17 2010 Justin Sherrill <jsherril@redhat.com> 1.2.2-1

  - 619337 - adding trigger to update last_modified date on channel table if the
    checksum of a package changes (jsherril@redhat.com)
  - upgrade script for truncateCacheQueue (michael.mraka@redhat.com)
  - truncateCacheQueue removed from schema deps (michael.mraka@redhat.com)
  - truncateCacheQueue isn't called anywhere (michael.mraka@redhat.com)

• Tue Aug 17 2010 Tomas Lestach <tlestach@redhat.com> 1.2.1-1

  - taskomatic schema changes (tlestach@redhat.com)
  - new type of errata file: 'OVAL' (mzazrivec@redhat.com)
  - fixed 1.1 schema upgrade (michael.mraka@redhat.com)
  - Define lookup_checksum in PostgreSQL, needed for satellite-sync.
    (jpazdziora@redhat.com)
  - 571608 - fixing schema issue that allowed multiple entries in
    rhnKickstartPackage with the same package name for the same kickstart id
    (jsherril@redhat.com)
  - 601626 - adding server-channel arch mapping to support ppc64
    (jsherril@redhat.com)
  - bumping package versions for 1.2 (mzazrivec@redhat.com)

• Mon Aug 09 2010 Milan Zazrivec <mzazrivec@redhat.com> 1.1.30-1

  - 601984 - use clob for the concatting operation, to overcome the varchar
    length limit. (jpazdziora@redhat.com)
  - 530519 - change ipaddr column from CHAR(16) to VARCHAR(16)
    (msuchy@redhat.com)

• Thu Aug 05 2010 Jan Pazdziora 1.1.29-1

  - Be strict about chameleon exit code again.
  - Do not invoke chameleon for Oracle sources.

• Thu Aug 05 2010 Milan Zazrivec <mzazrivec@redhat.com> 1.1.28-1

  - 576222 - modify rhn_kstree_mod_trig behavior

• Wed Aug 04 2010 Partha Aji <paji@redhat.com> 1.1.27-1

  - Fixed a couple of schema bloopers on config stuff (paji@redhat.com)

• Tue Aug 03 2010 Jan Pazdziora 1.1.26-1

  - Chameleon does not support the NULL clause, fix source.

• Tue Aug 03 2010 Milan Zazrivec <mzazrivec@redhat.com> 1.1.25-1

  - Do not depend on cpp when sed works just as well
  - The slash is not needed as it causes the create index command to be run for
    the second time, during raw db population
  - Underscore is not valid syntax during raw db population
  - Empty line in the create table command causes error during raw db population

• Thu Jul 29 2010 Partha Aji <paji@redhat.com> 1.1.24-1

  - fixing a few things with the new config changes for symlinks
    (jsherril@redhat.com)
  - renamed a couple of upgrade files .. (paji@redhat.com)
  - Fixed a small glitch in the upgrade script.. The column name had an extra _
    (paji@redhat.com)
  - Config Management schema update + ui + symlinks (paji@redhat.com)

• Thu Jul 29 2010 Jan Pazdziora 1.1.23-1

  - The default_db is gone, we need to set the string up for sqlplus to work.

• Wed Jul 28 2010 Jan Pazdziora 1.1.22-1

  - The rhnContentSource.sql defines unique index and not constraint, we should
    do the same in schema upgrade scripts.
  - Upgrade script for the number(12) -> number changes.
  - The return of rhn_prepare_install has to stay smallint.
  - Losen the NUMBER(12) to NUMBER, to have foreign keys happy on PostgreSQL,
    while avoiding ORA-01440.
  - Revert "Revert "Revert "Fix numeric/smallint incompatible types in
    PostgreSQL."""
  - Use the current rhn_channel.pkb in schema upgrade scripts as well.

• Tue Jul 27 2010 Michael Mraka <michael.mraka@redhat.com> 1.1.21-1

  - 618219 - more fixes

• Mon Jul 26 2010 Michael Mraka <michael.mraka@redhat.com> 1.1.20-1

  - 618219 - update family counts only once per family

• Wed Jul 21 2010 Jan Pazdziora 1.1.19-1

  - If PostgreSQL source specifies SHA1 of Oracle source equivalent, we need to
    verify it.
  - Match PostgreSQL create_first_org and create_new_org changes to Oracle
    versions from commit 10c8a7dbca8a825639979f5dcb701472dd6b1d55.
  - Add 2010 copyright for commit 10c8a7dbca8a825639979f5dcb701472dd6b1d55.
  - Remove the EXCLUDE: production, to make the diff against
    oracle/procs/create_first_org.sql smaller.
  - Check that Oracle source files have counterparts in PostgreSQL and vice versa
    (ignoring results for now).
  - Add basic sanity checking of the consistency of the schema sources.
  - schema/spacewalk/postgres/manual/* is not used anywhere, removing.
    (jpazdziora@redhat.com)

• Mon Jul 19 2010 Jan Pazdziora 1.1.18-1

  - add missing upgrade for package too
  - Remove lines starting with SQL comment, to match what blend does when
    generating main.sql.
  - It is necessary to rename the underlying index, not just the constraint.
  - The rhn_ccs_uq was never a constraint -- it was a unique index.

• Mon Jul 19 2010 Milan Zazrivec <mzazrivec@redhat.com> 1.1.17-1

  - fix schema repopulation error

• Fri Jul 16 2010 Milan Zazrivec <mzazrivec@redhat.com> 1.1.16-1

  - remove dropped objects from postgresql
  - 532423 - device name can be longer than 16 chars

• Fri Jul 16 2010 Milan Zazrivec <mzazrivec@redhat.com> 1.1.15-1

  - made the rhnc_channel upgrade script use the latest sutff
  - cleaned up web_customer, rhnPaidOrgs and rhnDemoOrgs
  - fixed a couple of typos on  web_customer schema script
  - drop unused table rhnOrgInfo
  - move column from table rhnOrgInfo to table web_customer
  - remove unused column default_group_type, add new colum staging_content

• Mon Jul 12 2010 Michael Mraka <michael.mraka@redhat.com> 1.1.14-1

  - rhn_channel depends on rhnChannelFamilyServerFve

• Fri Jul 09 2010 Michael Mraka <michael.mraka@redhat.com> 1.1.13-1

  - fixed schema dependencies

• Thu Jul 08 2010 Justin Sherrill <jsherril@redhat.com> 1.1.12-1

  - adding upgrade script for rhnAvailableChannels performance issue
    (jsherril@redhat.com)
  - 603240 - fixing performance issue with rhnAvailableChannels, since one half
    of the query looks for channels the org owns, and the other half looks for
    channels shared to the org, changing to union all should be no problem
    (jsherril@redhat.com)
  - Fixed a stored proc to only look at flex stuff (paji@redhat.com)

• Thu Jul 08 2010 Michael Mraka <michael.mraka@redhat.com> 1.1.11-1

  - fixed dependencies on rhnServerFveCapable and rhnChecksumView
  - let schema population fail if there are invalid objects
  - Made entitlement logic handle flex guests when the host is virt (un)entitled

• Wed Jul 07 2010 Justin Sherrill <jsherril@redhat.com> 1.1.10-1

  - allowing satellite-sync to juggle entitlements between flex guest and regular
    entitlement slots if it can (jsherril@redhat.com)

• Fri Jul 02 2010 Jan Pazdziora 1.1.9-1

  - bug fixes to repo sync schema upgrades and sql (shughes@redhat.com)
  - 526864 - don't allow duplicated rows in rhnServerPackage
    (michael.mraka@redhat.com)
  - Triggers that call something in rhn_email package (schema) are not useful
    because we do not have rhn_email.

• Fri Jul 02 2010 Miroslav Suchý <msuchy@redhat.com> 1.1.8-1

  - fix index creation and duplicite name of index (msuchy@redhat.com)
  - would be much better if it fails with error when something bad happens
    (michael.mraka@redhat.com)

• Fri Jul 02 2010 Miroslav Suchý <msuchy@redhat.com> 1.1.7-1

  - table rhnChannelContentSource depends on rhnContentSource (msuchy@redhat.com)
  - Match the types of parameters of create_new_user to those given to us by the
    Java code. (jpazdziora@redhat.com)

• Thu Jul 01 2010 Miroslav Suchý <msuchy@redhat.com> 1.1.6-1

  - syntax error on rhnContentSource table sql (shughes@redhat.com)
  - modify last_synced column for repo sync (shughes@redhat.com)
  - missing semicolon on sql declare block (shughes@redhat.com)
  - making links between repo objects and taskomatic (shughes@redhat.com)
  - migrate sync date from repo content source to the channel table
    (shughes@redhat.com)
  - modified repo schema to handle org_id for content source objects. migrate
    script updated too. (shughes@redhat.com)
  - adding extra column to the rhnTaskQueue to allow tracking of many2many
    objects IDs (shughes@redhat.com)
  - upgrade script for migrating channels from repo table to the new mapping
    table, rhnChannelContentSource (shughes@redhat.com)
  - initial table for mapping channel ids to content sources (yum repos)
    (shughes@redhat.com)
  - renaming to contentsource since we are moving channel out to a new mapping
    table named rhnChannelContentSource (shughes@redhat.com)
  - Fixed a goofed up merge for rhn_channel.pkb (paji@redhat.com)
  - Updated the position of rhnPackageRepodata.sql to avoid conflict in naming
    (paji@redhat.com)
  - added rhn channels and rhn_entitlements schema upgrade items
    (paji@redhat.com)
  - Consolidate virtual instance type changes to 1 file (paji@redhat.com)
  - Added code to get multiorgs org -> software channel ents page work with flex
    entitlements (paji@redhat.com)
  - Added the convert to flex plsql operation (paji@redhat.com)
  - Wiped out unused bulk procs (paji@redhat.com)
  - Removed unused stored procedures (paji@redhat.com)
  - Added an rhnException data (paji@redhat.com)
  - Added channel family permissions to upgrade (paji@redhat.com)
  - adding flex guest detection at registration time (jsherril@redhat.com)
  - Commiting the initial compilable merge of rhn_channel (paji@redhat.com)
  - Added rhnChannelFamilyServerFve in the hopes that it'll get used
    (paji@redhat.com)
  - updating rhn_entitlement package for cert activation (jsherril@redhat.com)
  - convertin rhn_entitlements.pkb to use four spaces instead of tabs
    (jsherril@redhat.com)
  - Updated some views using hosted changes (paji@redhat.com)
  - few fixes for rhn cert activation, cert activation now works and populates
    max_members correctly, but not populating fve_max_members yet
    (jsherril@redhat.com)
  - matching hosteds column names for flex guests (jsherril@redhat.com)
  - first attempt at adding flex guest to sat cert processing
    (jsherril@redhat.com)
  - adding flex guest table changes (jsherril@redhat.com)

• Mon Jun 28 2010 Jan Pazdziora 1.1.5-1

  - As the tables rhnChannelFamilyLicense and rhnChannelFamilyLicenseConsent were
    removed, so should the triggers.
  - Replace nvl and nvl2 with coalesce, to make the rhnServerNeededView view
    compatible with PostgreSQL.
  - Revert "Revert "Fix numeric/smallint incompatible types in PostgreSQL.""

• Mon Jun 28 2010 Jan Pazdziora 1.1.4-1

  - The for does not like NULL which we get for empty ents_to_process.
  - Array concatenation seems to want array_append.
  - Fix cursors in PostgreSQL version of prune_group.
  - Use AS with column alias.
  - TOP declaration seems to be needed, for Makefile to be useful at all.

• Mon Jun 21 2010 Jan Pazdziora 1.1.3-1

  - updating rhnPackageRepodata table to not use a reserved word.
    (jsherril@redhat.com)
  - Good Bye rhnChannelFamilyLicense and rhnChannelFamilyLicenseConsent tables
    schemas (paji@redhat.com)
  - Removed the bulk-subscribe and unsubscribe which is not used anywhere
    (paji@redhat.com)

• Mon May 31 2010 Michael Mraka <michael.mraka@redhat.com> 1.1.2-1

  - none of rhnDumpSnapshot* exists anymore
  - 585965 - adding upgrade schema for bug
  - 585965 - fixing issue with multilib packages and errata-cache generation
  - Fix ORA-02429 error during schema upgrade

• Mon Apr 19 2010 Michael Mraka <michael.mraka@redhat.com> 1.1.1-1

  - bumping spec files to 1.1 packages