------------------------------------------------------------------- Mon Dec 07 12:50:31 CET 2015 - mc@suse.de - version 2.1.50.15-1 - When deleting a server, delete all associated rhnSet entries, even if it was migrated to a different Org (bsc#950748) - adding on delete cascade to sppf_pid_fk (bsc#948238) ------------------------------------------------------------------- Sun Sep 27 14:42:36 CEST 2015 - mc@suse.de - version 2.1.50.14-1 - Set errata-cache job to run every minute if old schedule still active (bsc#918994) ------------------------------------------------------------------- Mon Jun 22 15:40:54 CEST 2015 - jrenner@suse.de - version 2.1.50.13-1 - Fix rpm version compare in DB (bsc#927940) - Prevent from inserting duplicate update_server_errata_cache tasks - Move auto-errata updates into separate taskomatic task - Do not ignore errata with same package version ------------------------------------------------------------------- Tue Mar 31 14:43:34 CEST 2015 - mc@suse.de - version 2.1.50.12-1 - Fix ORA-01403: no data found in update_needed_cache during re-registrations - Avoid a deadlock when changing channel assignments (bsc#918549) - update adding aarch64 support to fix 1.7 to 2.1 update (bsc#922468) - delete cached metadata and regenerate them (bsc#920400) ------------------------------------------------------------------- Tue Feb 03 12:08:01 CET 2015 - mc@suse.de - version 2.1.50.11-1 - some values can be already present at the time of upgrade - fix NPE by setting max_members to 0 instead of NULL (bsc#912035) - SCCRepository: save SCC ID in the database as well - SCCRepository: save to database with proper sequence - Fix old migration for future reference (bsc#911180) - Avoid NPE when migrating to SCC on Oracle migrated from 1.7 (bsc#911180) - renamed package upgrade scripts to .sql - fixed double-counting systems subscribed to more than one channel - Getting rid of Tabs and trailing spaces ------------------------------------------------------------------- Thu Dec 04 16:27:47 CET 2014 - mc@suse.de - version 2.1.50.10-1 - fix migration script names to fix bare-metal registration (bsc#896109) - add virt-host-plat entitlement mappings for new arches - Create regular index instead and have one migration per DB (bsc#905072) - Drop unique index on package ids (bsc#905072) - drop unused column product_list in suseProducts table - drop unused column channel_family_id in suseProducts ------------------------------------------------------------------- Fri Nov 07 13:20:08 CET 2014 - mc@suse.de - version 2.1.50.9-1 - add SLE12 distro targets to DB - randomize mgr-sync refresh task schedule - add aarch64 server to noarch package mapping ------------------------------------------------------------------- Tue Oct 14 15:17:50 CEST 2014 - mc@suse.de - version 2.1.50.8-1 - increase source_url column size to 2048 - fix evr_t schema upgrade (bnc#881111) - Speed up satellite-sync by avoiding commonly-called dblink_exec - rhnDistChannelMap index needs to handle nulls on postgresql - allow null for user_id in suseCredentials - add scc credential type ------------------------------------------------------------------- Fri Sep 12 16:02:16 CEST 2014 - mc@suse.de - version 2.1.50.7-1 - implement tilde compare for 1.0~beta1 in version numbers - force character set and numerical separators to good known defaults. - increase size of update_tag column - fixing order of commands - make config file deletion faster if there are lots of snapshots - make future installs run ErrataCache task more often - add Fedora 21 GPG keys - add CentOS 7 GPG key - Fix rhnKickstartableTree trigger, 'null = null' is not true in sql - Add support to ppc64le arch - add Korea to the list of timezones - Allow evr_t to be compared with NULL in Oracle (bnc#881111) ------------------------------------------------------------------- Tue Jun 17 10:06:46 CEST 2014 - jrenner@suse.de - version 2.1.50.6-1 - Index for user_id on wupi table speeds up errata mailer - Copy upstream schema migration to SUSE Manager schema upgrade ------------------------------------------------------------------- Fri May 16 13:14:25 CEST 2014 - mc@suse.de - version 2.1.50.5-1 - DB: update tables dep file - Rename suseEulas table to suseEula. - EULA support: fix constraint name - DB: Added tables required by the SUSE EULA ------------------------------------------------------------------- Thu May 08 16:55:05 CEST 2014 - mc@suse.de - version 2.1.50.4-1 - move web_contact_log migration to pre Beta3 - rename schema migration directories to support Beta 3 to Beta4 migration - add migration dir for latest 1.7 schema version to 2.1 - add SLE12 GPG Package Key ------------------------------------------------------------------- Tue May 06 15:18:35 CEST 2014 - mc@suse.de - version 2.1.50.3-1 - DB: backport fixes for web_contact triggers - reset package to avoid ORA-0406* errors - schema upgrade for web_contact_log - Backporting fix for web_contact migration - fixing web_contact upgrade script - rhnActionChain.id: explicitly name the primary index constraint - Schema bugfix: Oracle doesn't like empty lines ------------------------------------------------------------------- Thu Mar 27 10:22:30 CET 2014 - fcastelli@suse.com - version 2.1.50.2-1 - SUMA db migration: reflect changes made by bb84025a - Extending cron_expr length to 120 - SUMA db migration: change size of cron_expr - Extending cron_expr column within the rhnTaskoSchedule table - SUMA DB migration: change size of web_contact-password - Extend length of web_contact.password to 110 - Missing aarch64 in rhnServerArch - SUMA db update migration: add support for aarch64 - Schema upgrade for ARM aarch64 architecture support - Support for ARM aarch64 architecture - SUMA db upgrade migrations: drop web_contact-old_password - Drop web_contact.old_password column from schema ------------------------------------------------------------------- Thu Feb 27 16:25:04 CET 2014 - fcastelli@suse.com - version 2.1.50.1-1 - enable migration from 1.7 to 2.1 - increase length of rhnCVE name column - fix invalid syntax for postgresql migration - write insert of bootstrap entitlement in a way, that it can be called multiple times - copy upstream schema migrations to SUSE Manager schema upgrade - replacing view must have the same number of columns (in postgresql) - updated rhnServerOutdatePackages to include arch - rhnServerOutdatedPackages schema upgrade script - improved performance of system.listLatestUpgradeablePackages and UpgradableList.do - Merged upgrade migrations from master - update rhnServer after queue_server to avoid a deadlock - copy upstream schema migration to SUSE Manager schema upgrade - fix ORA-01422 error when removing a channel - copy upstream schema changes to SUSE Manager schema upgrade - fix ORA-01403: no data found, when unsubscribing a system - rename upgrade scripts to be included in schema upgrade - fix ORA-01403: no data found, during system registration ------------------------------------------------------------------- Fri Feb 14 10:23:24 CET 2014 - mc@suse.de - version 2.1.43.2-1 - bugfix for locking rhnServerNeededCache table with oracle DB ------------------------------------------------------------------- Thu Feb 13 15:15:12 CET 2014 - mc@suse.de - version 2.1.43.1-1 - New tables and upgrade scripts added for Action chaining - lock rhnServerNeededCache to avoid a db deadlock - Add missing GMT+3 timezone as Saudi Arabia - fix rhn_channel.update_needed_cache() deadlock - avoid deadlocks when altering base channels via ssm - Add missing timezone schema migration into 1.7 to 2.1 (bnc#862406) - Fix GMT+3 timezone missing (bnc#862406) ------------------------------------------------------------------- Fri Feb 07 13:23:08 CET 2014 - mc@suse.de - version 2.1.39.1-1 - upgrade script for Fedora 20 GPG key - rename one and add another rhnConfiguration key - update rhnUserExtGroupMapping triggers - increase length of rhnCVE name column - Tables to have mapping from external groups to internal roles (rhnUserGroupType). - introduce rhnConfiguration table - Changed gpg keys so they match reality. - Moved package lock schema changes to proper location ------------------------------------------------------------------- Mon Jan 13 09:46:05 CET 2014 - mc@suse.de - version 2.1.30.2-1 - add reboot action cleanup task (FATE#312591) - add rhnLockedPackages table. (FATE#312359) - changes to rhnActionType (FATE#312359) - updated rhnActionPackage parameter constraint (FATE#312359) ------------------------------------------------------------------- Mon Dec 09 17:02:58 CET 2013 - mc@suse.de - version 2.1.30.1-1 - support bare-metal registration (FATE#312329) - provide schema update to 2.1 ------------------------------------------------------------------- Wed Dec 04 09:49:35 CET 2013 - mc@suse.de - version 1.7.56.22-2 - fix invalid syntax for postgresql migration ------------------------------------------------------------------- Thu Nov 28 16:23:12 CET 2013 - mc@suse.de - version 1.7.56.22-1 - fix oracle syntax and provide seperate update script for postgres DB (bnc#846436) - Regenerate the metadata for rpm enhances dependency (bnc#846436) - add support for enhances rpm weak dependency (schema) (bnc#846436) ------------------------------------------------------------------- Fri Aug 23 11:23:47 CEST 2013 - mc@suse.de - version 1.7.56.21-1 - removing bad initial condition from max(evr_t) ------------------------------------------------------------------- Wed Aug 21 16:02:08 CEST 2013 - mc@suse.de - version 1.7.56.20-1 - rpm version comparison function was broken for alphanumeric versions - Make CSV separator configurable, schema (FATE#312907) - CVE Audit schema (FATE#312907) - prevents empty values (db_host, db_port) in rhn.conf - regenerate repodata for all channels to get package installed size (bnc#825673) - make mgr-register-bunch a common bunch (bnc#824361) ------------------------------------------------------------------- Wed Jun 12 11:00:29 CEST 2013 - mc@suse.de - version 1.7.56.19-1 - Don't create index if it already exists - Don't drop rhn_ram_sid_idx if it does not exist. - No line break at the end of the package summary (bnc#821968) - fixed filename length in rhnErrataFileTmp - switch deferred segment creation off during installation - extend length of rhnPackageCapability.version ------------------------------------------------------------------- Thu May 2 18:08:24 CEST 2013 - mc@suse.de - version 1.7.56.18-2 - Fix table name typo in DB migration ------------------------------------------------------------------- Thu Apr 04 15:16:41 CEST 2013 - mc@suse.de - version 1.7.56.18-1 - Quote the password we pass to sqlplus so that special characters can be used. - Support recovery of failed schema upgrades (FATE#314644) - SSH Server Push (schema) (FATE#312909) ------------------------------------------------------------------- Fri Feb 08 11:23:44 CET 2013 - mc@suse.de - version 1.7.56.17-1 - rebrand help text for mail domain - correct olson name for Australia Western timezone - support for Australia EST/EDT timezones - take care that all migrations will be applied (bnc#797890) - fix schema upgrade for rhnPackageCapability (bnc#793415) ------------------------------------------------------------------- Thu Nov 22 15:57:59 CET 2012 - jrenner@suse.de - version 1.7.56.16-1 - fix timezone problem while comparing reboot needed dates with oracle DB (bnc#790305) - fix unique constraint violation occuring during schema upgrade - add new openSUSE gpg keyid (bnc#789817) - update descriptions in rhnKickstartSessionState (bnc#780270) - SP migration DB schema changes ------------------------------------------------------------------- Mon Oct 01 09:39:56 CEST 2012 - mc@suse.de - version 1.7.56.15-1 - create view allServerKeywordSinceReboot - extending rhnPackageCapability.version. - oracles sql parser doesn't like comments after semicolon - fix unique constraint violation (bnc#780913) - schema upgrade for rhnChannelNewestPackageView - make list of newest packages unique ------------------------------------------------------------------- Wed Aug 15 14:57:17 CEST 2012 - mc@suse.de - version 1.7.56.14-1 - fix insert pxt session when not logged-in ------------------------------------------------------------------- Mon Aug 6 09:47:02 CEST 2012 - mc@suse.de - version 1.7.56.13-1 - add schema upgrade for SUSE Manager 1.7 Beta3 to RC1 - add schema upgrade for SUSE Manager 1.7 RC1 to GMC ------------------------------------------------------------------- Thu Aug 02 16:53:31 CEST 2012 - mc@suse.de - fix schema upgrade scripts - Properly name the primary index constraint/index for rhnActionImageDeploy. - provide schema migration to full version - check if cleanup-data-bunch exists and create it if not (bnc#772620) - 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. ------------------------------------------------------------------- Mon Jul 16 15:23:34 CEST 2012 - ug@suse.de - version 1.7.56.12-1 - Add the PostgreSQL specific mad_address upgrade script. - We mustn't serialize object into string in lookup_evr, we need to only create it once within the link. - Allow user to set MAC Address when provisioning a virtual guest - Make the resulting data order more deterministic. ------------------------------------------------------------------- Wed Jul 11 10:34:50 CEST 2012 - ug@suse.de - added mac_address column to rhnactionkickstartguest ------------------------------------------------------------------- Mon Jun 25 10:25:52 CEST 2012 - mc@suse.de - version 1.7.56.11-1 - Make the .postgresql schema upgrade script actually use the PostgreSQL syntax. ------------------------------------------------------------------- Thu Jun 21 11:04:11 CEST 2012 - jrenner@suse.de - version 1.7.56.10-1 - Add index on ident_id for better performance - Add index on testresult_id for better performance. - We cannot use markup in formatted text (synopsis). - lookup_tag: schema upgrade - lookup_tag: don't call lookup_tag_name twice - remove rhnRedHatCanonVersion table during upgrade - removed support for Red Hat Linux 6.2 and 7.[0123] - Temporarily disable triggers during schema upgrades ------------------------------------------------------------------- Thu May 31 10:48:40 CEST 2012 - mc@suse.de - version 1.7.56.9-1 - get rid of out parameters in user_role_check_debug - forgotten rhnPackageSource update - Schema upgrade script for the rhn_versioninfo_nid_eid_uq drop. - No need to enforce unique (name_id, evr_id) on rhnVersionInfo. - Database migration files for studio integration (suseCredentialsType etc.) - fix various issues in PG variant of rhn_channel.convert_to_fve - Improve upgrade time_series data move - Fix rhnPackageChangeLog upgrade logic. - remove unused cursor - store suse metadata keywords ------------------------------------------------------------------- Tue May 29 17:43:10 CEST 2012 - mc@suse.de - add missing schema migration for rhnErrataBuglistTmp (bnc#764544) ------------------------------------------------------------------- Mon May 14 10:44:12 CEST 2012 - mc@suse.de - version 1.7.56.8-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 - Remove unnecessary UNIQUE constraint (on user_id in suseCredentials) - fix rhn_time_zone_names upgrade scripts - dropping unused rhn_time_zone_names - Fix credentials type ID to not be unique (studio integration) ------------------------------------------------------------------- Fri May 11 11:44:25 CEST 2012 - mc@suse.de - make values in suseProductChannel unique before adding a unique index (bnc#760306) ------------------------------------------------------------------- Wed May 09 13:45:17 CEST 2012 - mc@suse.de - version 1.7.56.7-1 - use persistent dblink connection - Completely remove the image type from deployment action details - rename suse_credentialstype index and sequence names (bnc#764532) - fix table dependencies (bnc#764532) - Normalize image types by creating new table suseImageType (bnc#764532) - Normalize credentials types by creating new table suseCredentialsType (bnc#764532) ------------------------------------------------------------------- Thu May 03 17:43:31 CEST 2012 - mc@suse.de - version 1.7.56.6-1 - make columns unique before adding a unique index - copy from sw1.6 ------------------------------------------------------------------- Wed May 02 14:25:48 CEST 2012 - mc@suse.de - version 1.7.56.5-1 - Update existing rhn_notification_formats with the new newlines matching Oracle. - Using PostgreSQL version of rhn_org.delete_org in upgrade scripts. - We cannot specify tablespace for PostgreSQL. ------------------------------------------------------------------- Fri Apr 27 16:08:16 CEST 2012 - mc@suse.de - version 1.7.56.4-1 - fixing postgresql schema and adding appropriate schema upgrade scripts - remove rhnContentSource row when delete row in oracle pkg - add unique constraint on rhnChannelArch.name - make sure that rows are unique before creating unique index - 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. - assign number of free slots ------------------------------------------------------------------- Fri Apr 20 15:38:41 CEST 2012 - mc@suse.de - version 1.7.56.3-1 - Make the records in rhnPackageUpgradeArchCompat -- no need to have duplicates. - bring the schema version as recorded in the database in sync with the installed rpms, even if the difference is just the dist tag. - the Log Size actually checks Log Size Growth. - fix PG lookup_transaction_package stored procedure - fix procedure dependencies ------------------------------------------------------------------- Fri Mar 30 15:16:13 CEST 2012 - mc@suse.de - version 1.7.56.2-1 - copy spacewalk schema updates 1.3, 1.4, 1.5, 1.6, 1.7 to susemanager schema 1.7 update - copy some current upstream schema migrations - fix spacewalk-schema-upgrade tool ------------------------------------------------------------------- Fri Mar 23 10:16:38 CET 2012 - mc@suse.de - version to 1.2.74 - add indexes for suseServerInstalledProduct and suseProductChannel ------------------------------------------------------------------- Wed Mar 21 18:12:33 CET 2012 - mc@suse.de - version 1.7.56.1-1 - Bumping package version ------------------------------------------------------------------- Thu Mar 15 17:17:28 CET 2012 - jrenner@suse.de - Add support for studio image deployments ------------------------------------------------------------------- Mon Dec 19 15:36:54 CET 2011 - mc@suse.de - new tables for storing package products (bnc#644678) -------------------------------------------------------------------- Thu Nov 24 12:35:34 CET 2011 - iartarisi@suse.cz - allow setting VARCHAR2 size in CHARs and BYTEs explicitly ------------------------------------------------------------------- Fri Sep 23 10:04:17 CEST 2011 - mc@suse.de - add index on rhnPackage checksum_id ------------------------------------------------------------------- Thu Sep 8 16:21:55 CEST 2011 - iartarisi@suse.cz - set result_message SQL column size in CHARs instead of BYTEs (bnc#700016) ------------------------------------------------------------------- Wed Aug 10 09:07:05 UTC 2011 - kkaempf@novell.com - add sles-10-i686 and sles-10-i686 to suseostarget bnc#711429 - version to 1.2.73 ------------------------------------------------------------------- Mon Aug 8 16:36:27 CEST 2011 - ug@suse.de - fixed syntax error in schema upgrade (bnc#711007) ------------------------------------------------------------------- Wed Jul 20 13:48:34 CEST 2011 - iartarisi@suse.cz - set result_message SQL column size in BYTEs instead of CHARs (bnc#700016) ------------------------------------------------------------------- Wed Jun 8 15:31:43 CEST 2011 - mc@suse.de - version to 1.2.72 - provide SLE 10 ostargets (fate#312377, bnc#693104) ------------------------------------------------------------------- Fri Mar 25 14:51:16 CET 2011 - ug@suse.de - version to 1.2.71 ------------------------------------------------------------------- Thu Mar 24 14:35:49 CET 2011 - mantel@suse.de - more debranding of kickstart to auto installation ------------------------------------------------------------------- Thu Mar 24 14:28:43 CET 2011 - mantel@suse.de - fix schema updates; debrand initial values for rhnactiontype ------------------------------------------------------------------- Thu Mar 24 12:22:45 CET 2011 - mantel@suse.de - debrand errata to patch (bnc#670318) ------------------------------------------------------------------- Wed Mar 16 10:52:10 CET 2011 - ug@suse.de - debranding some text in the database (bnc#673810) ------------------------------------------------------------------- Thu Mar 10 17:04:04 CET 2011 - ug@suse.de - Registration of REHL4 clients fails due to incomplete database table (bnc#678110) ------------------------------------------------------------------- Thu Feb 17 13:13:27 CET 2011 - mc@suse.de - fix copyright - fix checksums ------------------------------------------------------------------- Thu Feb 17 12:14:43 CET 2011 - mantel@suse.de - rename "Satellite Administrator" to "SUSE Manager Administrator" (bnc#662077) ------------------------------------------------------------------- Thu Feb 10 11:17:14 CET 2011 - jrenner@suse.de - fix subscribe_server subs handling (bnc#670551) ------------------------------------------------------------------- Fri Jan 28 12:45:44 CET 2011 - ug@suse.de - rhntemplatestring table data changed to SUSE Manager ------------------------------------------------------------------- Mon Jan 17 16:30:10 CET 2011 - mc@suse.de - rename sm-register to mgr-register ------------------------------------------------------------------- Mon Jan 17 12:25:25 CET 2011 - mc@suse.de - change suseServer ostarget to a foreign key to suseOSTarget(id) - fix data for suseOSTarget ------------------------------------------------------------------- Wed Jan 12 17:23:13 CET 2011 - mc@suse.de - add suseOSTarget table ------------------------------------------------------------------- Wed Jan 12 10:37:28 CET 2011 - mc@suse.de - add RES GPG Key to DB ------------------------------------------------------------------- Tue Jan 11 18:04:58 CET 2011 - mc@suse.de - add SUSE and Novell GPG Keys to DB ------------------------------------------------------------------- Wed Sep 15 12:22:26 CEST 2010 - mantel@suse.de - fix post-build-checks ------------------------------------------------------------------- Wed Sep 15 09:53:07 CEST 2010 - mantel@suse.de - Initial release of spacewalk-schema -------------------------------------------------------------------