Changelog for susemanager-schema-4.0.3-1.1.noarch.rpm :

* Mon Dec 17 2018 jgonzalezAATTsuse.com- version 4.0.3-1- Add Uyuni GPG to the database- Performance improvements in channel management functionalities (bsc#1114877)- use a Salt engine to process return results (bsc#1099988)- Automatic cleanup of notification messages after a configurable lifetime- Add missing minion-action-chain-cleanup to db init scripts
* Fri Oct 26 2018 jgonzalezAATTsuse.com- version 4.0.2-1- Add index for HW address on network interface- added kickstart distribution data for RHEL 8- check valid postgresql database version- Enable auto patch updates for Salt minions
* Fri Aug 10 2018 jgonzalezAATTsuse.com- version 4.0.1-1- Bump version to 4.0.0 (bsc#1104034)- Enable system preferences for Salt minions (bsc#1098388)- Fix copyright for the package specfile (bsc#1103696)- Feat: add OS Image building with Kiwi FATE#322959 FATE#323057 FATE#323056- copy missing action-chain schema migration to correct directory (bsc#1100760)- Fix truncated result message of server actions (bsc#1039043)- Fix config channels state revision inconsistency after migration (bsc#1094543)
* Tue Jun 05 2018 jgonzalezAATTsuse.com- version 3.2.11-1- Fix migration path between 3.1 and 3.2 (bsc#1095398)
* Wed May 23 2018 jgonzalezAATTsuse.com- version 3.2.10-1- Fix issue with \"suse_img_repodigest_idx\" index if multiple image tags (bsc#1090664)
* Thu May 17 2018 jgonzalezAATTsuse.com- version 3.2.9-1- Fix: migration from 3.0 to 3.1 related to rhnServerNetwork (bsc#1086996)
* Mon Apr 23 2018 jgonzalezAATTsuse.com- version 3.2.8-1- add SLE15 distribution (bsc#1090205)- fix a race condition on lookup_evr (bsc#1090059)- Clean up SUSE Studio credentials from the DB- fix schema migration by creating correct not null column (bsc#1074642)- fix invalid name for quartz migration file (bsc#1088870)- fix migration error with not null column (bsc#1088818)
* Thu Mar 29 2018 jgonzalezAATTsuse.com- version 3.2.7-1- SLE15 support: recommended/required flag for products and channels- remove update of not existing table (bsc#1087131)- handle duplicate rhnserverpackage (bsc#1075345)
* Mon Mar 26 2018 jgonzalezAATTsuse.com- version 3.2.6-1- Enable upgrades from 3.1- Allow scheduling the change of software channels as an action. The previous channels remain accessible to the registered system until the action is executed.- handle duplicate serverpackage entries while fixing duplicate evr ids (bsc#1075345)- Add Adelaide timezone to selectable timezones (bsc#1063891)- Add schema migration to support Action Chain for Minions.- Prevent migration failure when multiple empty file contents are present (bsc#1083706, bsc#1083937)
* Mon Mar 05 2018 jgonzalezAATTsuse.com- version 3.2.5-1- support SLE15 product family- remove clean section from spec (bsc#1083294)
* Wed Feb 28 2018 jgonzalezAATTsuse.com- version 3.2.4-1- Make migration idempotent (bsc#1078749)- Fix: schema with proper extension (bsc#1079820)- 1542287 - purge records that would be violating unique constraint during fixup- 1542287 - we don\'t have solaris table anymore- 1541955 - Clone of an erratum doesn\'t have original erratum\'s severity
* Mon Feb 05 2018 jgonzalezAATTsuse.com- version 3.2.3-1- Allow scheduling the change of software channels as an action. The previous channels remain accessible to the registered system until the action is executed.
* Fri Feb 02 2018 jgonzalezAATTsuse.com- version 3.2.2-1- Migrate old custom states to state channels, assign systems to these new channels, delete old custom-state-to-system assignments, delete the custom states from the db; Before migrating, rename custom states with same name as existing configuration channel labels.- Update queries for global channels- Check if channel is already subscribed even before checking if parent channel is subscribed or not (bsc#1072797)- support multiple FQDNs per system (bsc#1063419)- avoid use of the potentially-slow rhnServerNeededPackageCache view
* Wed Jan 17 2018 jgonzalezAATTsuse.com- version 3.2.1-1- Update to Quartz 2.3.0 (bsc#1049431)- fix duplicate entries in channel listings- handle nevra not found case while fixing duplicate evr ids (bsc#1074508)- Added a script which will remove existing server locks against minions (bsc#1064258)- Add column to store the \'test\' option for state apply actions- Adding initial version of web ui notifications
* Tue Nov 28 2017 jgonzalezAATTsuse.com- version 3.1.13-1- Add Adelaide timezone to selectable timezones (bsc#1063891)- Added new relationships for Salt config management- Added new config channel type(state) and file type(sls)- Enable \'Power Management\' features on Salt minions.- enablement of the package profile feature for minions- re-create unique index on minion_id (bsc#1059568, bsc#1056358)- increase max length of hardware address to 32 byte (bsc#989991)- fix unique index for evr and capability and remove duplicates during migration (bsc#1058110)- rhnServerNetwork refactoring (bsc#1063419)
* Thu Sep 14 2017 mcAATTsuse.de- version 3.1.12-1- provide schema upgrade path from 3.0.21 to 3.1
* Thu Sep 14 2017 mcAATTsuse.de- version 3.1.11-1- DB objects for Kubernetes integration
* Wed Aug 30 2017 mcAATTsuse.de- version 3.1.10-1- Backend for importing images- Fix unsetting of image build host when a related action is deleted
* Tue Aug 08 2017 fkobzikAATTsuse.de- version 3.1.9-1- Adapt for the new gpgcheck flag for the channels
* Mon Jun 12 2017 mcAATTsuse.de- version 3.1.8-1- Correct overly-broad comparison in the fixup-functions Set ORA back to INDEX from CONSTRAINT (bsc#1043778)
* Mon May 29 2017 mcAATTsuse.de- version 3.1.7-1- support schema upgrade from 3.0.20 to 3.1- add base column to suseProducts- add channel_family_id column to suseProducts (bsc#1031716)- Add inspect status and reinspect button to image overview page- Teach Postgres to correctly-unique-ify rhnConfigInfo rows- recreate possible missing data (bsc#1032798)- add logging to can_entitle_server function to write out the reason of a failure (bsc#1032798)- fix index behaviour on NULL org- drop filters while deleting repository- postgresql 8.4 doesn\'t support WITH and DELETE combination- remove links between errata and files from different orgs- allow sync of the same erratum to more orgs
* Wed May 03 2017 michele.bolognaAATTsuse.com- version 3.1.6-1- Version 2.7.16-1- take care that capability name exists (bsc#1035724)- copy missing migrations from 3.0
* Mon Apr 03 2017 mcAATTsuse.de- version 3.1.5-1- DB: create suseCVEImageChannel table for CVE Audit on Images- drop obsolete logging trigger if they still exist (bsc#1031266)- rename image tag to image version- fix constraint name in suseImageInfo- fix removing images and profiles with custom values- Add SQL scripts for scheduling in Quartz- add number of installed packages to ImageOverview- link ImageInfo checksum to Checksum table- add registry credentials type during schema upgrade- Some of monitoring data are not removed from DB- connect 3.0 to 3.1 schema upgrade
* Tue Mar 07 2017 mcAATTsuse.de- version 3.1.4-1- grant minions scap capability- add modified trigger for suseImageInfo- add table suseImageInfoInstalledProduct- add image inspect action- schema upgrade for suseImageOverview and ImageNeededChache views- create views, tables and procs for counting available updates on images- DB: move target store to image profile- add image_admin to existing organizations- Migrating Fedorahosted to GitHub- show update message only when updating the schema package (bsc#1024456)- Remove legacy audit logging database code- fix deduplicate to work with more than two duplicates- merge valid column migration with create table- fix error on channel delete with tokens bsc#1024471- save ssl in separate table again, now allow to have multiple ssl sets per content source- Create token index- Add AccessToken.valid column and use it to reject tokens
* Tue Feb 07 2017 michele.bolognaAATTsuse.com- version 3.1.2.1-1- drop index before it gets re-created and use if exists for postgres (bsc#1021381)
* Wed Jan 11 2017 michele.bolognaAATTsuse.com- version 3.1.2-1- Version 3.1.1
* Fri Dec 16 2016 michele.bolognaAATTsuse.com- version 3.0.17-1- Schema upgrade for live patching (FATE#319519)
* Mon Nov 07 2016 michele.bolognaAATTsuse.com- version 3.0.16-1- Create path for schema upgrade to 3.0- Add table for storing product extensions
* Thu Oct 06 2016 mcAATTsuse.de- version 3.0.15-1- Add table for storing product extensions- Add severity_id to rhnErrataTmp for consistency with rhnErrata (bsc#1000666)- Fixing suseMinionInfo.sql to make \'osFamily\' NULLABLE- delete rhnContentSourceFilter before rhnContentSource (bsc#998380)- Avoid a deadlock when deleting a server (bsc#969790)
* Mon Jul 18 2016 jrennerAATTsuse.com- version 3.0.14-1- Add missing power_management feature for bootstrap_entitlement systems- Fix HW Refresh duplicate insert (bsc#971622)- add taskomatic job to clean up minion actions- provide seperate migration scripts for oracle- shorten constaint names and fix syntax (FATE#320213)- Remove duplicates from rhnChannelContentSource (bsc#976184)
* Tue May 24 2016 kwalterAATTsuse.com- version 3.0.13-1- move machine_id from suseMinionInfo to rhnServer table- fix removing nonlinux entitlement during migration- fix migrating and cleanup system types during migration (bsc#977465)- Enable ftr_package_refresh for minions
* Wed Apr 06 2016 mcAATTsuse.de- version 3.0.12-1- change unique index to partial (bsc#973673)- move sql to enable refresh hardware feature (bsc#972305)- check ftr_hardware_refresh when showing \'Refresh Hardware\' button (bsc#972305)- trigger metadata generation for all channels (bsc#972972)
* Tue Mar 22 2016 mcAATTsuse.de- fix schema upgrade using if exists for dropping a sequence
* Mon Mar 21 2016 mcAATTsuse.de- version 3.0.11-1- add missing database commit- adding missing Oracle upgrade- delete sync probe task- sequnce rhn_org_entitlement_type_seq should be dropped- drop unused tables/sequences/synonyms/etc.- Rename DB migration file- Add support for package removals on minions (DB changes)- Enable \'ftr_package_updates\' on minions- support schema upgrade from schema 2.1.50.16 to 3.0.X- fix schema upgrade from Beta2 to RC1 (bsc#971543)
* Wed Mar 09 2016 mcAATTsuse.de- version 3.0.10-1- add tables for State Apply- add tables for Subscription Pinning- Declare the base entitlements permanent- fixing upgrade on Oracle- Allow null for the state names in the DB (meaning highstate)- rename KSInstallTypes to SUSE Linux Enterprise- db tables for minion state selection- Rename \'unmatched systems\' CSV report to \'unmatched products\'- add Chile to the list of timezones (bsc#959055)- Add features to enable reboot and remote commands for salt minions- enable system group ui for salt minions- Use blob as a backing db type for MatcherRunData, assign name to the constraint, fix the migration script directory- DB: Table for SubscriptionMatchingData- When deleting a server, delete all associated rhnSet entries- no need to lock table since we don\'t update entitlements
* Wed Jan 27 2016 mcAATTsuse.de- version 3.0.9-1- Create suseMinionInfo table when migrating to 3.0 (bsc#963789)
* Tue Jan 26 2016 mcAATTsuse.de- version 3.0.8-1- Fix the SCCOrderItem null quantity issue by dropping the \'not null\' constraint- Rename \'equal\' to \'any\' in the database- schema: rename saltstack_entitled to salt_entitled- Add the free flag to SUSEProduct- move the migration for bsc#959055 fix into the right schema version- add support for schema migration from 2.1 to 3.0- add schema upgrade for bsc#959055 to susemanager-schema-3.0 migration- add Chile to the list of timezones (bsc#959055)
* Sat Jan 16 2016 mcAATTsuse.de- version 3.0.7-1- delete one more obsolete table
* Thu Jan 14 2016 mcAATTsuse.de- version 3.0.6-1- Update copyright headers to 2016 for all new files- Add \'ftr_errata_updates\' to saltstack entitled systems- Add MinionServer as subclass of Server- purge duplicate uuid records during upgrade process- Use public channel families for SUSE channels (bsc#958708)- purge uuid records after deleting a system
* Wed Dec 16 2015 mcAATTsuse.de- version 3.0.5-1- Add taskomatic task for running subscription matcher- add caching table for order items- add caching table for SCCSubscriptions- create table susePinnedSubscription- Fix unique constraint name (after column was renamed)- enhance create_new_org to create the first org as well and drop create_first_org- during installation insert default SSL crypto key with null org
* Thu Dec 10 2015 mcAATTsuse.de- version 3.0.4-1 Initial sql to create the suseServerState table- SQL files for package states- get rid of pltcl by disabling upstream logging.
* Mon Nov 30 2015 mcAATTsuse.de- version 3.0.3-1- avoid cascade at function dropping- When deleting a server, delete all associated rhnSet entries, even if it was migrated to a different Org (bsc#950748)- drop obsolete postgresql functions on schema_upgrade- drop removed functions from rhn_channel and rhn_entitlements- remove current_members and available_members from rhnAvailableChannels view- Add new foreign and saltstack server groups during schema update- Enlarge rhnServer.digital_server_id size to 1024 characters- clear log_id also for postgresql DB
* Thu Oct 22 2015 mcAATTsuse.de- version 3.0.2-1- Fix license header- Taskomatic job for gatherer- add new foreign_entitled entitlement and migrations for it- create a unique index on suseServerVirtualHostManager- add new foreign_entitled entitlement- Add migrations for Virtual Host Manager- Add tables for Virtual Host Manager- Set job to run every minute if old schedule still active (bsc#918994)- adding on delete cascade to sppf_pid_fk (bsc#948238)
* Wed Oct 07 2015 mcAATTsuse.de- version 3.0.1-1- drop monitoring- replace upstream subscription counting with new subscription matching (FATE#311619)- integrate SaltStack for configuration management (FATE#312447)- drop monitoring- replace upstream subscription counting with new subscription matching (FATE#311619)- integrate SaltStack for configuration management (FATE#312447)- support password-recovery-tokens- remove solaris support
* Sun Sep 27 2015 mcAATTsuse.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 2015 jrennerAATTsuse.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 2015 mcAATTsuse.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 2015 mcAATTsuse.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 2014 mcAATTsuse.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 2014 mcAATTsuse.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 2014 mcAATTsuse.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 2014 mcAATTsuse.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 2014 jrennerAATTsuse.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 2014 mcAATTsuse.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 2014 mcAATTsuse.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 2014 mcAATTsuse.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 2014 fcastelliAATTsuse.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 2014 fcastelliAATTsuse.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 2014 mcAATTsuse.de- version 2.1.43.2-1- bugfix for locking rhnServerNeededCache table with oracle DB
* Thu Feb 13 2014 mcAATTsuse.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 2014 mcAATTsuse.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 2014 mcAATTsuse.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 2013 mcAATTsuse.de- version 2.1.30.1-1- support bare-metal registration (FATE#312329)- provide schema update to 2.1
* Wed Dec 04 2013 mcAATTsuse.de- version 1.7.56.22-2- fix invalid syntax for postgresql migration
* Thu Nov 28 2013 mcAATTsuse.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 2013 mcAATTsuse.de- version 1.7.56.21-1- removing bad initial condition from max(evr_t)
* Wed Aug 21 2013 mcAATTsuse.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 2013 mcAATTsuse.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 02 2013 mcAATTsuse.de- version 1.7.56.18-2- Fix table name typo in DB migration
* Thu Apr 04 2013 mcAATTsuse.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 2013 mcAATTsuse.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 2012 jrennerAATTsuse.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 2012 mcAATTsuse.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 2012 mcAATTsuse.de- version 1.7.56.14-1- fix insert pxt session when not logged-in
* Mon Aug 06 2012 mcAATTsuse.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 2012 mcAATTsuse.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 2012 ugAATTsuse.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 2012 ugAATTsuse.de- added mac_address column to rhnactionkickstartguest
* Mon Jun 25 2012 mcAATTsuse.de- version 1.7.56.11-1- Make the .postgresql schema upgrade script actually use the PostgreSQL syntax.
* Thu Jun 21 2012 jrennerAATTsuse.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 2012 mcAATTsuse.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 2012 mcAATTsuse.de- add missing schema migration for rhnErrataBuglistTmp (bnc#764544)
* Mon May 14 2012 mcAATTsuse.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 2012 mcAATTsuse.de- make values in suseProductChannel unique before adding a unique index (bnc#760306)
* Wed May 09 2012 mcAATTsuse.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 2012 mcAATTsuse.de- version 1.7.56.6-1- make columns unique before adding a unique index - copy from sw1.6
* Wed May 02 2012 mcAATTsuse.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 2012 mcAATTsuse.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 2012 mcAATTsuse.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 2012 mcAATTsuse.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 2012 mcAATTsuse.de- version to 1.2.74- add indexes for suseServerInstalledProduct and suseProductChannel
* Wed Mar 21 2012 mcAATTsuse.de- version 1.7.56.1-1- Bumping package version
* Thu Mar 15 2012 jrennerAATTsuse.de- Add support for studio image deployments
* Mon Dec 19 2011 mcAATTsuse.de- new tables for storing package products (bnc#644678)
* Thu Nov 24 2011 iartarisiAATTsuse.cz- allow setting VARCHAR2 size in CHARs and BYTEs explicitly
* Fri Sep 23 2011 mcAATTsuse.de- add index on rhnPackage checksum_id
* Thu Sep 08 2011 iartarisiAATTsuse.cz- set result_message SQL column size in CHARs instead of BYTEs (bnc#700016)
* Wed Aug 10 2011 kkaempfAATTnovell.com- add sles-10-i686 and sles-10-i686 to suseostarget bnc#711429- version to 1.2.73
* Mon Aug 08 2011 ugAATTsuse.de- fixed syntax error in schema upgrade (bnc#711007)
* Wed Jul 20 2011 iartarisiAATTsuse.cz- set result_message SQL column size in BYTEs instead of CHARs (bnc#700016)
* Wed Jun 08 2011 mcAATTsuse.de- version to 1.2.72- provide SLE 10 ostargets (fate#312377, bnc#693104)
* Fri Mar 25 2011 ugAATTsuse.de- version to 1.2.71
* Thu Mar 24 2011 mantelAATTsuse.de- more debranding of kickstart to auto installation
* Thu Mar 24 2011 mantelAATTsuse.de- fix schema updates; debrand initial values for rhnactiontype
* Thu Mar 24 2011 mantelAATTsuse.de- debrand errata to patch (bnc#670318)
* Wed Mar 16 2011 ugAATTsuse.de- debranding some text in the database (bnc#673810)
* Thu Mar 10 2011 ugAATTsuse.de- Registration of REHL4 clients fails due to incomplete database table (bnc#678110)
* Thu Feb 17 2011 mcAATTsuse.de- fix copyright- fix checksums
* Thu Feb 17 2011 mantelAATTsuse.de- rename \"Satellite Administrator\" to \"SUSE Manager Administrator\" (bnc#662077)
* Thu Feb 10 2011 jrennerAATTsuse.de- fix subscribe_server subs handling (bnc#670551)
* Fri Jan 28 2011 ugAATTsuse.de- rhntemplatestring table data changed to SUSE Manager
* Mon Jan 17 2011 mcAATTsuse.de- rename sm-register to mgr-register
* Mon Jan 17 2011 mcAATTsuse.de- change suseServer ostarget to a foreign key to suseOSTarget(id)- fix data for suseOSTarget
* Wed Jan 12 2011 mcAATTsuse.de- add suseOSTarget table
* Wed Jan 12 2011 mcAATTsuse.de- add RES GPG Key to DB
* Tue Jan 11 2011 mcAATTsuse.de- add SUSE and Novell GPG Keys to DB
* Wed Sep 15 2010 mantelAATTsuse.de- fix post-build-checks
* Wed Sep 15 2010 mantelAATTsuse.de- Initial release of spacewalk-schema