April 2009 - spacewalk-commits - Fedora Mailing-Lists

by Brad Buckingham

java/code/src/com/redhat/rhn/frontend/xmlrpc/system/SystemHandler.java | 10 ++++++++++ 1 file changed, 10 insertions(+) New commits: commit 8fa2b65fedf786fc8841633cd456a3f4131acaa6 Author: Brad Buckingham <bbuckingham(a)redhat.com> Date: Thu Apr 30 11:44:36 2009 -0400 498275 - api - system.obtainReactivationKey updated to replace existing key In the UI, if a user generates a reactivation key, the new key replaces the old one; however, with the current API it simply creates a new key. As a result, there will be multiple reactivation keys for the system; however, only one is seen from the UI. This update will remove any existing reactivation keys for the system before creating the new one. diff --git a/java/code/src/com/redhat/rhn/frontend/xmlrpc/system/SystemHandler.java b/java/code/src/com/redhat/rhn/frontend/xmlrpc/system/SystemHandler.java index 508bff4..067167f 100644 --- a/java/code/src/com/redhat/rhn/frontend/xmlrpc/system/SystemHandler.java +++ b/java/code/src/com/redhat/rhn/frontend/xmlrpc/system/SystemHandler.java @@ -79,6 +79,7 @@ import com.redhat.rhn.domain.server.ServerGroupFactory; import com.redhat.rhn.domain.server.VirtualInstance; import com.redhat.rhn.domain.server.VirtualInstanceFactory; import com.redhat.rhn.domain.token.ActivationKey; +import com.redhat.rhn.domain.token.ActivationKeyFactory; import com.redhat.rhn.domain.user.User; import com.redhat.rhn.frontend.dto.ActivationKeyDto; import com.redhat.rhn.frontend.dto.ErrataOverview; @@ -161,6 +162,15 @@ public class SystemHandler extends BaseHandler { if (!SystemManager.serverHasFeature(server.getId(), "ftr_agent_smith")) { throw new PermissionCheckFailureException(); } + + // if there are any existing reactivation keys, remove them before + // creating a new one... there should only be 1; however, earlier + // versions of the API did not remove the existing reactivation keys; + // therefore, it is possible that multiple will be returned... + List<ActivationKey> existingKeys = ActivationKeyFactory.lookupByServer(server); + for (ActivationKey key : existingKeys) { + ActivationKeyFactory.removeKey(key); + } String note = "Reactivation key for " + server.getName() + "."; ActivationKey key = ActivationKeyManager.getInstance().

15 years

1
0
0 / 0

Branch 'pgsql' - schema/spacewalk

by Jeff Ortel

schema/spacewalk/postgres/triggers/rhnBeehivePathMap.sql | 13 ++ schema/spacewalk/postgres/triggers/rhnBlacklistObsoletes.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnChannelArch.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnChannelComps.sql | 20 +++ schema/spacewalk/postgres/triggers/rhnChannelErrata.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnChannelFamily.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnChannelFamilyLicense.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnChannelFamilyLicenseConsent.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnChannelFamilyMembers.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnChannelPackageArchCompat.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnChannelPermission.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnChannelPermissionRole.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnClientCapability.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnConfigContent.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnConfigFile.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnConfigFileState.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnConfigFileType.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnConfigInfo.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnCpu.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnCpuArch.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnCryptoKeyType.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnCustomDataKey.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnDevice.sql | 17 +++ schema/spacewalk/postgres/triggers/rhnDownloads.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnEmailAddress.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnEmailAddressState.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnErrataBuglist.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnErrataBuglistTmp.sql | 17 +++ schema/spacewalk/postgres/triggers/rhnErrataCloned.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnErrataTmp.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnFAQ.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnFileList.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnFileListMembers.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnKSData.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnKSInstallType.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnKSTreeFile.sql | 18 +++ schema/spacewalk/postgres/triggers/rhnKickstartChildChannel.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnKickstartCommand.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnKickstartDefaultRegToken.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnKickstartDefaults.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnKickstartIPRange.sql | 17 +++ schema/spacewalk/postgres/triggers/rhnKickstartPackage.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnKickstartPreserveFileList.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnKickstartScript.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnKickstartSessionHistory.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnKickstartSessionState.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnKickstartableTree.sql | 20 +++ schema/spacewalk/postgres/triggers/rhnMessage.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnOrgChannelSettings.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnOrgChannelSettingsType.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnOrgEntitlementType.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnOrgEntitlements.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnOrgInfo.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnPackage.sql | 20 +++ schema/spacewalk/postgres/triggers/rhnPackageArch.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnPackageCapability.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnPackageChangeLog.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnPackageChangeLog_triggers.sql | 18 +++ schema/spacewalk/postgres/triggers/rhnPackageConflicts.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnPackageDelta.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnPackageFile.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnPackageGroup.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnPackageKey.sql | 17 +++ schema/spacewalk/postgres/triggers/rhnPackageKeyType.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnPackageObsoletes.sql | 17 +++ schema/spacewalk/postgres/triggers/rhnPackageProvider.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnPackageProvides.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnPackageRequires.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnPackageSource.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnPackageSyncBlacklist.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnPathChannelMap.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnProduct.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnProductLine.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnProductName.sql | 17 +++ schema/spacewalk/postgres/triggers/rhnPushClient.sql | 17 +++ schema/spacewalk/postgres/triggers/rhnPushClientState.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnPushDispatcher.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnRam.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnRepoRegenQueue.sql | 17 +++ schema/spacewalk/postgres/triggers/rhnSatelliteChannelFamily.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnSatelliteInfo.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnSatelliteServerGroup.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerActionPackageResult.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerActionScriptResult.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerActionVerifyMissing.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnServerActionVerifyResult.sql | 13 ++ schema/spacewalk/postgres/triggers/rhnServerChannelArchCompat.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnServerConfigChannel.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerCustomDataValue.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnServerDMI.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnServerEvent.sql | 30 +++++ schema/spacewalk/postgres/triggers/rhnServerGroupNotes.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerHistory.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnServerInfo.sql | 33 ++++++ schema/spacewalk/postgres/triggers/rhnServerInstallInfo.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnServerLocation.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerMessage.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerNetInterface.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnServerNetwork.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerNotes.sql | 14 ++ schema/spacewalk/postgres/triggers/rhnServerPackageArchCompat.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerPath.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerPreserveFileList.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnServerProfileType.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnServerServerGroupArchCompat.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnSnapshotChannel.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnSnapshotConfigChannel.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnSnapshotConfigRevision.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnSnapshotInvalidReason.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnSnapshotPackage.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnSnapshotServerGroup.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnSnapshotTag.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnSolarisPatch.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnSolarisPatchSet.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnSolarisPatchSetMembers.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnSsmOperation.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnTag.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnTagName.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnTemplateCategory.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnTemplateString.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnTextMessage.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnUserReserved.sql | 15 ++ schema/spacewalk/postgres/triggers/rhnUserServerPrefs.sql | 16 +++ schema/spacewalk/postgres/triggers/rhnVersionInfo.sql | 16 +++ schema/spacewalk/postgres/triggers/rhn_contact_methods.sql | 52 ++++++++++ schema/spacewalk/postgres/triggers/web_user_contact_permission.sql | 16 +++ schema/spacewalk/postgres/triggers/web_user_site_info.sql | 19 +++ 127 files changed, 2012 insertions(+) New commits: commit cdc6d42049bf86fbc9f1d3a5c54275eeacbd641d Author: Jeff Ortel <jortel(a)redhat.com> Date: Thu Apr 30 10:47:53 2009 -0400 Add missing postgres triggers diff --git a/schema/spacewalk/postgres/triggers/rhnBeehivePathMap.sql b/schema/spacewalk/postgres/triggers/rhnBeehivePathMap.sql new file mode 100644 index 0000000..f91df76 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnBeehivePathMap.sql @@ -0,0 +1,13 @@ +create or replace function rhn_beehive_path_map_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_beehive_path_map_mod_trig +before insert or update on rhnBeehivePathMap +for each row +execute procedure rhn_beehive_path_map_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnBlacklistObsoletes.sql b/schema/spacewalk/postgres/triggers/rhnBlacklistObsoletes.sql new file mode 100644 index 0000000..f5e5f38 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnBlacklistObsoletes.sql @@ -0,0 +1,14 @@ +create or replace function rhn_bl_obs_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_bl_obs_mod_trig +before insert or update on rhnBlacklistObsoletes +for each row +execute procedure rhn_bl_obs_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnChannelArch.sql b/schema/spacewalk/postgres/triggers/rhnChannelArch.sql new file mode 100644 index 0000000..008f979 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnChannelArch.sql @@ -0,0 +1,14 @@ + +create or replace function rhn_carch_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_carch_mod_trig +before insert or update on rhnChannelArch +for each row +execute procedure rhn_carch_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnChannelComps.sql b/schema/spacewalk/postgres/triggers/rhnChannelComps.sql new file mode 100644 index 0000000..c11f904 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnChannelComps.sql @@ -0,0 +1,20 @@ + + +create or replace function rhn_channelcomps_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + if new.last_modified = old.last_modified then + new.last_modified := current_timestamp; + end if; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_channelcomps_mod_trig +before insert or update on rhnChannelComps +for each row +execute procedure rhn_channelcomps_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnChannelErrata.sql b/schema/spacewalk/postgres/triggers/rhnChannelErrata.sql new file mode 100644 index 0000000..5046678 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnChannelErrata.sql @@ -0,0 +1,14 @@ +create or replace function rhn_channel_errata_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_channel_errata_mod_trig +before insert or update on rhnChannelErrata +for each row +execute procedure rhn_channel_errata_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnChannelFamily.sql b/schema/spacewalk/postgres/triggers/rhnChannelFamily.sql new file mode 100644 index 0000000..72316b3 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnChannelFamily.sql @@ -0,0 +1,14 @@ +create or replace function rhn_channel_family_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_channel_family_mod_trig +before insert or update on rhnChannelFamily +for each row +execute procedure rhn_channel_family_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnChannelFamilyLicense.sql b/schema/spacewalk/postgres/triggers/rhnChannelFamilyLicense.sql new file mode 100644 index 0000000..d424937 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnChannelFamilyLicense.sql @@ -0,0 +1,14 @@ +create or replace function rhn_cf_license_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_cf_license_mod_trig +before insert or update on rhnChannelFamilyLicense +for each row +execute procedure rhn_cf_license_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnChannelFamilyLicenseConsent.sql b/schema/spacewalk/postgres/triggers/rhnChannelFamilyLicenseConsent.sql new file mode 100644 index 0000000..ca48aa8 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnChannelFamilyLicenseConsent.sql @@ -0,0 +1,14 @@ +create or replace function rhn_cfl_consent_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_cfl_consent_mod_trig +before insert or update on rhnChannelFamilyLicenseConsent +for each row +execute procedure rhn_cfl_consent_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnChannelFamilyMembers.sql b/schema/spacewalk/postgres/triggers/rhnChannelFamilyMembers.sql new file mode 100644 index 0000000..572bb4b --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnChannelFamilyMembers.sql @@ -0,0 +1,15 @@ + +create or replace function rhn_cf_member_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_cf_member_mod_trig +before insert or update on rhnChannelFamilyMembers +for each row +execute procedure rhn_cf_member_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnChannelPackageArchCompat.sql b/schema/spacewalk/postgres/triggers/rhnChannelPackageArchCompat.sql new file mode 100644 index 0000000..c1cf3e9 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnChannelPackageArchCompat.sql @@ -0,0 +1,14 @@ +create or replace function rhn_cp_ac_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_cp_ac_mod_trig +before insert or update on rhnChannelPackageArchCompat +for each row +execute procedure rhn_cp_ac_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnChannelPermission.sql b/schema/spacewalk/postgres/triggers/rhnChannelPermission.sql new file mode 100644 index 0000000..6eb05f9 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnChannelPermission.sql @@ -0,0 +1,14 @@ +create or replace function rhn_cperm_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_cperm_mod_trig +before insert or update on rhnChannelPermission +for each row +execute procedure rhn_cperm_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnChannelPermissionRole.sql b/schema/spacewalk/postgres/triggers/rhnChannelPermissionRole.sql new file mode 100644 index 0000000..b911e58 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnChannelPermissionRole.sql @@ -0,0 +1,14 @@ +create or replace function rhn_cperm_role_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_cperm_role_mod_trig +before insert or update on rhnChannelPermissionRole +for each row +execute procedure rhn_cperm_role_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnClientCapability.sql b/schema/spacewalk/postgres/triggers/rhnClientCapability.sql new file mode 100644 index 0000000..98acfcc --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnClientCapability.sql @@ -0,0 +1,14 @@ +create or replace function rhn_clientcap_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_clientcap_mod_trig +before insert or update on rhnClientCapability +for each row +execute procedure rhn_clientcap_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnConfigContent.sql b/schema/spacewalk/postgres/triggers/rhnConfigContent.sql new file mode 100644 index 0000000..b935b96 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnConfigContent.sql @@ -0,0 +1,14 @@ +create or replace function rhn_confcontent_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_confcontent_mod_trig +before insert or update on rhnConfigContent +for each row +execute procedure rhn_confcontent_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnConfigFile.sql b/schema/spacewalk/postgres/triggers/rhnConfigFile.sql new file mode 100644 index 0000000..ebd4f1f --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnConfigFile.sql @@ -0,0 +1,14 @@ +create or replace function rhn_conffile_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_conffile_mod_trig +before insert or update on rhnConfigFile +for each row +execute procedure rhn_conffile_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnConfigFileState.sql b/schema/spacewalk/postgres/triggers/rhnConfigFileState.sql new file mode 100644 index 0000000..9de54c3 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnConfigFileState.sql @@ -0,0 +1,14 @@ +create or replace function rhn_cfstate_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_cfstate_mod_trig +before insert or update on rhnConfigFileState +for each row +execute procedure rhn_cfstate_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnConfigFileType.sql b/schema/spacewalk/postgres/triggers/rhnConfigFileType.sql new file mode 100644 index 0000000..4ce4063 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnConfigFileType.sql @@ -0,0 +1,14 @@ +create or replace function rhn_conffiletype_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_conffiletype_mod_trig +before insert or update on rhnConfigFile +for each row +execute procedure rhn_conffiletype_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnConfigInfo.sql b/schema/spacewalk/postgres/triggers/rhnConfigInfo.sql new file mode 100644 index 0000000..177ec36 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnConfigInfo.sql @@ -0,0 +1,14 @@ +create or replace function rhn_confinfo_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_confinfo_mod_trig +before insert or update on rhnConfigInfo +for each row +execute procedure rhn_confinfo_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnCpu.sql b/schema/spacewalk/postgres/triggers/rhnCpu.sql new file mode 100644 index 0000000..84c6e4c --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnCpu.sql @@ -0,0 +1,15 @@ +create or replace function rhn_cpu_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + + +create trigger +rhn_cpu_mod_trig +before insert or update on rhnCpu +for each row +execute procedure rhn_cpu_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnCpuArch.sql b/schema/spacewalk/postgres/triggers/rhnCpuArch.sql new file mode 100644 index 0000000..aca3418 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnCpuArch.sql @@ -0,0 +1,15 @@ +create or replace function rhn_cpuarch_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + + +create trigger +rhn_cpuarch_mod_trig +before insert or update on rhnCpuArch +for each row +execute procedure rhn_cpuarch_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnCryptoKeyType.sql b/schema/spacewalk/postgres/triggers/rhnCryptoKeyType.sql new file mode 100644 index 0000000..5076c57 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnCryptoKeyType.sql @@ -0,0 +1,15 @@ +create or replace function rhn_cryptokeytype_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_cryptokeytype_mod_trig +before insert or update on rhnCryptoKeyType +for each row +execute procedure rhn_cryptokeytype_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnCustomDataKey.sql b/schema/spacewalk/postgres/triggers/rhnCustomDataKey.sql new file mode 100644 index 0000000..22edaeb --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnCustomDataKey.sql @@ -0,0 +1,16 @@ + +create or replace function rhn_cdatakey_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_cdatakey_mod_trig +before insert or update on rhnCustomDataKey +for each row +execute procedure rhn_cdatakey_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnDevice.sql b/schema/spacewalk/postgres/triggers/rhnDevice.sql new file mode 100644 index 0000000..5457258 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnDevice.sql @@ -0,0 +1,17 @@ + +create or replace function rhn_device_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_device_mod_trig +before insert or update on rhnDevice +for each row +execute procedure rhn_device_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnDownloads.sql b/schema/spacewalk/postgres/triggers/rhnDownloads.sql new file mode 100644 index 0000000..402f113 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnDownloads.sql @@ -0,0 +1,15 @@ +create or replace function rhn_download_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_download_mod_trig +before insert or update on rhnDownloads +for each row +execute procedure rhn_download_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnEmailAddress.sql b/schema/spacewalk/postgres/triggers/rhnEmailAddress.sql new file mode 100644 index 0000000..07c1673 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnEmailAddress.sql @@ -0,0 +1,16 @@ +create or replace function rhn_eaddress_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_eaddress_mod_trig +before insert or update on rhnEmailAddress +for each row +execute procedure rhn_eaddress_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnEmailAddressState.sql b/schema/spacewalk/postgres/triggers/rhnEmailAddressState.sql new file mode 100644 index 0000000..16bc0a0 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnEmailAddressState.sql @@ -0,0 +1,16 @@ +create or replace function rhn_eastate_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_eastate_mod_trig +before insert or update on rhnEmailAddressState +for each row +execute procedure rhn_eastate_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnErrataBuglist.sql b/schema/spacewalk/postgres/triggers/rhnErrataBuglist.sql new file mode 100644 index 0000000..19c3610 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnErrataBuglist.sql @@ -0,0 +1,15 @@ +create or replace function rhn_errata_buglist_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_errata_buglist_mod_trig +before insert or update on rhnErrataBuglist +for each row +execute procedure rhn_errata_buglist_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnErrataBuglistTmp.sql b/schema/spacewalk/postgres/triggers/rhnErrataBuglistTmp.sql new file mode 100644 index 0000000..7877942 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnErrataBuglistTmp.sql @@ -0,0 +1,17 @@ + +create or replace function rhn_errata_buglisttmp_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_errata_buglisttmp_mod_trig +before insert or update on rhnErrataBuglistTmp +for each row +execute procedure rhn_errata_buglisttmp_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnErrataCloned.sql b/schema/spacewalk/postgres/triggers/rhnErrataCloned.sql new file mode 100644 index 0000000..258354b --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnErrataCloned.sql @@ -0,0 +1,15 @@ +create or replace function rhn_errataclone_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_errataclone_mod_trig +before insert or update on rhnErrataCloned +for each row +execute procedure rhn_errataclone_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnErrataTmp.sql b/schema/spacewalk/postgres/triggers/rhnErrataTmp.sql new file mode 100644 index 0000000..19826ba --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnErrataTmp.sql @@ -0,0 +1,16 @@ +create or replace function rhn_erratatmp_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + new.last_modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_erratatmp_mod_trig +before insert or update on rhnErrataTmp +for each row +execute procedure rhn_erratatmp_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnFAQ.sql b/schema/spacewalk/postgres/triggers/rhnFAQ.sql new file mode 100644 index 0000000..b9ee131 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnFAQ.sql @@ -0,0 +1,14 @@ +create or replace function rhn_faq_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_faq_mod_trig +before insert or update on rhnFaq +for each row +execute procedure rhn_faq_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnFileList.sql b/schema/spacewalk/postgres/triggers/rhnFileList.sql new file mode 100644 index 0000000..9a6a141 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnFileList.sql @@ -0,0 +1,14 @@ +create or replace function rhn_filelist_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_filelist_mod_trig +before insert or update on rhnFileList +for each row +execute procedure rhn_filelist_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnFileListMembers.sql b/schema/spacewalk/postgres/triggers/rhnFileListMembers.sql new file mode 100644 index 0000000..01a787a --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnFileListMembers.sql @@ -0,0 +1,14 @@ +create or replace function rhn_flmembers_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_flmembers_mod_trig +before insert or update on rhnFileListMembers +for each row +execute procedure rhn_flmembers_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnKSData.sql b/schema/spacewalk/postgres/triggers/rhnKSData.sql new file mode 100644 index 0000000..00208be --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKSData.sql @@ -0,0 +1,15 @@ +create or replace function rhn_ks_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ks_mod_trig +before insert or update on rhnKSData +for each row +execute procedure rhn_ks_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnKSInstallType.sql b/schema/spacewalk/postgres/triggers/rhnKSInstallType.sql new file mode 100644 index 0000000..6c68f59 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKSInstallType.sql @@ -0,0 +1,15 @@ +create or replace function rhn_ksinstalltype_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ksinstalltype_mod_trig +before insert or update on rhnKSInstallType +for each row +execute procedure rhn_ksinstalltype_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnKSTreeFile.sql b/schema/spacewalk/postgres/triggers/rhnKSTreeFile.sql new file mode 100644 index 0000000..1115fad --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKSTreeFile.sql @@ -0,0 +1,18 @@ +create or replace function rhn_kstreefile_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + if new.last_modified = old.last_modified then + new.last_modified := current_timestamp; + end if; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_kstreefile_mod_trig +before insert or update on rhnKSTreeFile +for each row +execute procedure rhn_kstreefile_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartChildChannel.sql b/schema/spacewalk/postgres/triggers/rhnKickstartChildChannel.sql new file mode 100644 index 0000000..cf89236 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartChildChannel.sql @@ -0,0 +1,15 @@ +create or replace function rhn_ks_cc_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ks_cc_mod_trig +before insert or update on rhnKickstartChildChannel +for each row +execute procedure rhn_ks_cc_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartCommand.sql b/schema/spacewalk/postgres/triggers/rhnKickstartCommand.sql new file mode 100644 index 0000000..96a5214 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartCommand.sql @@ -0,0 +1,16 @@ +create or replace function rhn_kscommand_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_kscommand_mod_trig +before insert or update on rhnKickstartCommand +for each row +execute procedure rhn_kscommand_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartDefaultRegToken.sql b/schema/spacewalk/postgres/triggers/rhnKickstartDefaultRegToken.sql new file mode 100644 index 0000000..3a2b5d5 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartDefaultRegToken.sql @@ -0,0 +1,15 @@ +create or replace function rhn_ksdrt_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ksdrt_mod_trig +before insert or update on rhnKickstartDefaultRegToken +for each row +execute procedure rhn_ksdrt_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartDefaults.sql b/schema/spacewalk/postgres/triggers/rhnKickstartDefaults.sql new file mode 100644 index 0000000..3118d2f --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartDefaults.sql @@ -0,0 +1,15 @@ +create or replace function rhn_ksd_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ksd_mod_trig +before insert or update on rhnKickstartDefaults +for each row +execute procedure rhn_ksd_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartIPRange.sql b/schema/spacewalk/postgres/triggers/rhnKickstartIPRange.sql new file mode 100644 index 0000000..2d5af21 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartIPRange.sql @@ -0,0 +1,17 @@ + +create or replace function rhn_ksip_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ksip_mod_trig +before insert or update on rhnKickstartIPRange +for each row +execute procedure rhn_ksip_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartPackage.sql b/schema/spacewalk/postgres/triggers/rhnKickstartPackage.sql new file mode 100644 index 0000000..3b02253 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartPackage.sql @@ -0,0 +1,16 @@ +create or replace function rhn_kspackage_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_kspackage_mod_trig +before insert or update on rhnKickstartPackage +for each row +execute procedure rhn_kspackage_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartPreserveFileList.sql b/schema/spacewalk/postgres/triggers/rhnKickstartPreserveFileList.sql new file mode 100644 index 0000000..15af9a2 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartPreserveFileList.sql @@ -0,0 +1,15 @@ +create or replace function rhn_kspreservefl_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_kspreservefl_mod_trig +before insert or update on rhnKickstartPreserveFileList +for each row +execute procedure rhn_kspreservefl_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartScript.sql b/schema/spacewalk/postgres/triggers/rhnKickstartScript.sql new file mode 100644 index 0000000..b9c91a2 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartScript.sql @@ -0,0 +1,16 @@ +create or replace function rhn_ksscript_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ksscript_mod_trig +before insert or update on rhnKickstartSession +for each row +execute procedure rhn_ksscript_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartSessionHistory.sql b/schema/spacewalk/postgres/triggers/rhnKickstartSessionHistory.sql new file mode 100644 index 0000000..13a540b --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartSessionHistory.sql @@ -0,0 +1,15 @@ +create or replace function rhn_ks_sessionhist_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ks_sessionhist_mod_trig +before insert or update on rhnKickstartSessionHistory +for each row +execute procedure rhn_ks_sessionhist_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartSessionState.sql b/schema/spacewalk/postgres/triggers/rhnKickstartSessionState.sql new file mode 100644 index 0000000..b06e887 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartSessionState.sql @@ -0,0 +1,15 @@ +create or replace function rhn_ks_session_state_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ks_session_state_mod_trig +before insert or update on rhnKickstartSessionState +for each row +execute procedure rhn_ks_session_state_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnKickstartableTree.sql b/schema/spacewalk/postgres/triggers/rhnKickstartableTree.sql new file mode 100644 index 0000000..fe542b3 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnKickstartableTree.sql @@ -0,0 +1,20 @@ +create or replace function rhn_kstree_mod_trig_fun() returns trigger as +$$ +begin + if (new.last_modified = old.last_modified) or + (new.last_modified is null ) then + new.last_modified := sysdate; + end if; + + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_kstree_mod_trig +before insert or update on rhnKickstartableTree +for each row +execute procedure rhn_kstree_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnMessage.sql b/schema/spacewalk/postgres/triggers/rhnMessage.sql new file mode 100644 index 0000000..7d96266 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnMessage.sql @@ -0,0 +1,16 @@ + +create or replace function rhn_m_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_m_mod_trig +before insert or update on rhnMessage +for each row +execute procedure rhn_m_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnOrgChannelSettings.sql b/schema/spacewalk/postgres/triggers/rhnOrgChannelSettings.sql new file mode 100644 index 0000000..c4ef418 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnOrgChannelSettings.sql @@ -0,0 +1,15 @@ +create or replace function rhn_orgcsettings_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_orgcsettings_mod_trig +before insert or update on rhnOrgChannelSettings +for each row +execute procedure rhn_orgcsettings_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnOrgChannelSettingsType.sql b/schema/spacewalk/postgres/triggers/rhnOrgChannelSettingsType.sql new file mode 100644 index 0000000..c8f6c40 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnOrgChannelSettingsType.sql @@ -0,0 +1,15 @@ +create or replace function rhn_orgcsettings_type_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_orgcsettings_type_mod_trig +before insert or update on rhnOrgChannelSettingsType +for each row +execute procedure rhn_orgcsettings_type_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnOrgEntitlementType.sql b/schema/spacewalk/postgres/triggers/rhnOrgEntitlementType.sql new file mode 100644 index 0000000..4950a72 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnOrgEntitlementType.sql @@ -0,0 +1,15 @@ +create or replace function rhn_org_ent_type_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_org_ent_type_mod_trig +before insert or update on rhnOrgEntitlementType +for each row +execute procedure rhn_org_ent_type_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnOrgEntitlements.sql b/schema/spacewalk/postgres/triggers/rhnOrgEntitlements.sql new file mode 100644 index 0000000..24f7707 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnOrgEntitlements.sql @@ -0,0 +1,15 @@ +create or replace function rhn_org_ent_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_org_ent_mod_trig +before insert or update on rhnOrgEntitlements +for each row +execute procedure rhn_org_ent_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnOrgInfo.sql b/schema/spacewalk/postgres/triggers/rhnOrgInfo.sql new file mode 100644 index 0000000..6c358e7 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnOrgInfo.sql @@ -0,0 +1,15 @@ +create or replace function rhn_orginfo_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_orginfo_mod_trig +before insert or update on rhnOrgInfo +for each row +execute procedure rhn_orginfo_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackage.sql b/schema/spacewalk/postgres/triggers/rhnPackage.sql new file mode 100644 index 0000000..b2bcefa --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackage.sql @@ -0,0 +1,20 @@ +create or replace function rhn_package_mod_trig_fun() returns trigger as +$$ +begin + + if new.last_modified = old.last_modified then + new.last_modified :=current_timestamp; + end if; + + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_package_mod_trig +before insert or update on rhnPackage +for each row +execute procedure rhn_package_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageArch.sql b/schema/spacewalk/postgres/triggers/rhnPackageArch.sql new file mode 100644 index 0000000..3c4525d --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageArch.sql @@ -0,0 +1,16 @@ +create or replace function rhn_parch_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_parch_mod_trig +before insert or update on rhnPackageArch +for each row +execute procedure rhn_parch_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageCapability.sql b/schema/spacewalk/postgres/triggers/rhnPackageCapability.sql new file mode 100644 index 0000000..d706f8d --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageCapability.sql @@ -0,0 +1,15 @@ +create or replace function rhn_pkg_capability_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pkg_capability_mod_trig +before insert or update on rhnPackageCapability +for each row +execute procedure rhn_pkg_capability_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageChangeLog.sql b/schema/spacewalk/postgres/triggers/rhnPackageChangeLog.sql new file mode 100644 index 0000000..2896404 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageChangeLog.sql @@ -0,0 +1,14 @@ +create or replace function rhn_package_changelog_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_package_changelog_mod_trig +before insert or update on rhnPackageChangelog +for each row +execute procedure rhn_package_changelog_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnPackageChangeLog_triggers.sql b/schema/spacewalk/postgres/triggers/rhnPackageChangeLog_triggers.sql new file mode 100644 index 0000000..a529df6 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageChangeLog_triggers.sql @@ -0,0 +1,18 @@ +create or replace function rhn_package_changelog_id_trig_fun() returns trigger as +$$ +begin + if new.is is null then + select nextval('rhn_pkg_cl_id_seq') into new.id; + end if; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_package_changelog_id_trig +before insert or update on rhnPackageChangelog +for each row +execute procedure rhn_package_changelog_id_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageConflicts.sql b/schema/spacewalk/postgres/triggers/rhnPackageConflicts.sql new file mode 100644 index 0000000..69b88e6 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageConflicts.sql @@ -0,0 +1,15 @@ +create or replace function rhn_pkg_conflicts_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pkg_conflicts_mod_trig +before insert or update on rhnPackageConflicts +for each row +execute procedure rhn_pkg_conflicts_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageDelta.sql b/schema/spacewalk/postgres/triggers/rhnPackageDelta.sql new file mode 100644 index 0000000..d638408 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageDelta.sql @@ -0,0 +1,16 @@ + +create or replace function rhn_packagedelta_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_packagedelta_mod_trig +before insert or update on rhnPackageDelta +for each row +execute procedure rhn_packagedelta_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageFile.sql b/schema/spacewalk/postgres/triggers/rhnPackageFile.sql new file mode 100644 index 0000000..e165a05 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageFile.sql @@ -0,0 +1,15 @@ +create or replace function rhn_packagefile_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_packagefile_mod_trig +before insert or update on rhnPackageFile +for each row +execute procedure rhn_packagefile_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageGroup.sql b/schema/spacewalk/postgres/triggers/rhnPackageGroup.sql new file mode 100644 index 0000000..06c4fd1 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageGroup.sql @@ -0,0 +1,15 @@ +create or replace function rhn_package_group_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_package_group_mod_trig +before insert or update on rhnPackageGroup +for each row +execute procedure rhn_package_group_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageKey.sql b/schema/spacewalk/postgres/triggers/rhnPackageKey.sql new file mode 100644 index 0000000..652776a --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageKey.sql @@ -0,0 +1,17 @@ + + +create or replace function rhn_pkg_gpg_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pkg_gpg_mod_trig +before insert or update on rhnPackageKey +for each row +execute procedure rhn_pkg_gpg_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageKeyType.sql b/schema/spacewalk/postgres/triggers/rhnPackageKeyType.sql new file mode 100644 index 0000000..0a0d454 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageKeyType.sql @@ -0,0 +1,15 @@ +create or replace function rhn_pkg_key_type_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pkg_key_type_mod_trig +before insert or update on rhnPackageKeyType +for each row +execute procedure rhn_pkg_key_type_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageObsoletes.sql b/schema/spacewalk/postgres/triggers/rhnPackageObsoletes.sql new file mode 100644 index 0000000..e883a48 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageObsoletes.sql @@ -0,0 +1,17 @@ + +create or replace function rhn_pkg_obsoletes_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pkg_obsoletes_mod_trig +before insert or update on rhnPackageObsoletes +for each row +execute procedure rhn_pkg_obsoletes_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageProvider.sql b/schema/spacewalk/postgres/triggers/rhnPackageProvider.sql new file mode 100644 index 0000000..b8f734d --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageProvider.sql @@ -0,0 +1,14 @@ +create or replace function rhn_pkg_provider_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pkg_provider_mod_trig +before insert or update on rhnPackageProvider +for each row +execute procedure rhn_pkg_provider_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnPackageProvides.sql b/schema/spacewalk/postgres/triggers/rhnPackageProvides.sql new file mode 100644 index 0000000..ce8eda9 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageProvides.sql @@ -0,0 +1,14 @@ +create or replace function rhn_pkg_provides_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pkg_provides_mod_trig +before insert or update on rhnPackageProvides +for each row +execute procedure rhn_pkg_provides_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnPackageRequires.sql b/schema/spacewalk/postgres/triggers/rhnPackageRequires.sql new file mode 100644 index 0000000..bbf30ad --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageRequires.sql @@ -0,0 +1,15 @@ +create or replace function rhn_pkg_requires_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pkg_requires_mod_trig +before insert or update on rhnPackageRequires +for each row +execute procedure rhn_pkg_requires_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageSource.sql b/schema/spacewalk/postgres/triggers/rhnPackageSource.sql new file mode 100644 index 0000000..f4f3976 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageSource.sql @@ -0,0 +1,16 @@ +create or replace function rhn_pkgsrc_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + new.last_modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pkgsrc_mod_trig +before insert or update on rhnPackageSource +for each row +execute procedure rhn_pkgsrc_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPackageSyncBlacklist.sql b/schema/spacewalk/postgres/triggers/rhnPackageSyncBlacklist.sql new file mode 100644 index 0000000..7108888 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPackageSyncBlacklist.sql @@ -0,0 +1,15 @@ +create or replace function rhn_packagesyncbl_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_packagesyncbl_mod_trig +before insert or update on rhnPackageSyncBlacklist +for each row +execute procedure rhn_packagesyncbl_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPathChannelMap.sql b/schema/spacewalk/postgres/triggers/rhnPathChannelMap.sql new file mode 100644 index 0000000..ae4740e --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPathChannelMap.sql @@ -0,0 +1,16 @@ +create or replace function rhn_path_channel_map_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_path_channel_map_mod_trig +before insert or update on rhnPathChannelMap +for each row +execute procedure rhn_path_channel_map_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnProduct.sql b/schema/spacewalk/postgres/triggers/rhnProduct.sql new file mode 100644 index 0000000..6722bac --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnProduct.sql @@ -0,0 +1,16 @@ +create or replace function rhn_product_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + new.last_modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_product_mod_trig +before insert or update on rhnProduct +for each row +execute procedure rhn_product_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnProductLine.sql b/schema/spacewalk/postgres/triggers/rhnProductLine.sql new file mode 100644 index 0000000..a97bc15 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnProductLine.sql @@ -0,0 +1,16 @@ +create or replace function rhn_prod_line_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + new.last_modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_prod_line_mod_trig +before insert or update on rhnProductLine +for each row +execute procedure rhn_prod_line_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnProductName.sql b/schema/spacewalk/postgres/triggers/rhnProductName.sql new file mode 100644 index 0000000..980611c --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnProductName.sql @@ -0,0 +1,17 @@ + +create or replace function product_name_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +product_name_mod_trig +before insert or update on rhnProductName +for each row +execute procedure product_name_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnPushClient.sql b/schema/spacewalk/postgres/triggers/rhnPushClient.sql new file mode 100644 index 0000000..90afa53 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPushClient.sql @@ -0,0 +1,17 @@ +create or replace function rhn_pclient_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pclient_mod_trig +before insert or update on rhnPushClient +for each row +execute procedure rhn_pclient_mod_trig_fun(); + + + diff --git a/schema/spacewalk/postgres/triggers/rhnPushClientState.sql b/schema/spacewalk/postgres/triggers/rhnPushClientState.sql new file mode 100644 index 0000000..5d33cc4 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPushClientState.sql @@ -0,0 +1,15 @@ +create or replace function rhn_pclient_state_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pclient_state_mod_trig +before insert or update on rhnPushClientState +for each row +execute procedure rhn_pclient_state_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnPushDispatcher.sql b/schema/spacewalk/postgres/triggers/rhnPushDispatcher.sql new file mode 100644 index 0000000..f93e30e --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnPushDispatcher.sql @@ -0,0 +1,15 @@ +create or replace function rhn_pushdispatch_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_pushdispatch_mod_trig +before insert or update on rhnPushDispatcher +for each row +execute procedure rhn_pushdispatch_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnRam.sql b/schema/spacewalk/postgres/triggers/rhnRam.sql new file mode 100644 index 0000000..548cad5 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnRam.sql @@ -0,0 +1,16 @@ +create or replace function rhn_ram_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ram_mod_trig +before insert or update on rhnRam +for each row +execute procedure rhn_ram_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnRepoRegenQueue.sql b/schema/spacewalk/postgres/triggers/rhnRepoRegenQueue.sql new file mode 100644 index 0000000..2b8895d --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnRepoRegenQueue.sql @@ -0,0 +1,17 @@ + +create or replace function rhn_repo_regen_queue_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_repo_regen_queue_mod_trig +before insert or update on rhnRepoRegenQueue +for each row +execute procedure rhn_repo_regen_queue_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSatelliteChannelFamily.sql b/schema/spacewalk/postgres/triggers/rhnSatelliteChannelFamily.sql new file mode 100644 index 0000000..1384e29 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSatelliteChannelFamily.sql @@ -0,0 +1,16 @@ +create or replace function rhn_sat_cf_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_sat_cf_mod_trig +before insert or update on rhnSatelliteChannelFamily +for each row +execute procedure rhn_sat_cf_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSatelliteInfo.sql b/schema/spacewalk/postgres/triggers/rhnSatelliteInfo.sql new file mode 100644 index 0000000..4cfcff1 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSatelliteInfo.sql @@ -0,0 +1,16 @@ +create or replace function rhn_satellite_info_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_satellite_info_mod_trig +before insert or update on rhnSatelliteInfo +for each row +execute procedure rhn_satellite_info_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSatelliteServerGroup.sql b/schema/spacewalk/postgres/triggers/rhnSatelliteServerGroup.sql new file mode 100644 index 0000000..dc32309 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSatelliteServerGroup.sql @@ -0,0 +1,15 @@ +create or replace function rhn_satsg_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_satsg_mod_trig +before insert or update on rhnSatelliteServerGroup +for each row +execute procedure rhn_satsg_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerActionPackageResult.sql b/schema/spacewalk/postgres/triggers/rhnServerActionPackageResult.sql new file mode 100644 index 0000000..05f3c17 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerActionPackageResult.sql @@ -0,0 +1,15 @@ +create or replace function rhn_sap_result_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_sap_result_mod_trig +before insert or update on rhnServerActionPackageResult +for each row +execute procedure rhn_sap_result_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerActionScriptResult.sql b/schema/spacewalk/postgres/triggers/rhnServerActionScriptResult.sql new file mode 100644 index 0000000..f628765 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerActionScriptResult.sql @@ -0,0 +1,15 @@ +create or replace function rhn_serveras_result_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_serveras_result_mod_trig +before insert or update on rhnServerActionScriptResult +for each row +execute procedure rhn_serveras_result_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerActionVerifyMissing.sql b/schema/spacewalk/postgres/triggers/rhnServerActionVerifyMissing.sql new file mode 100644 index 0000000..4ab4d65 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerActionVerifyMissing.sql @@ -0,0 +1,14 @@ +create or replace function rhn_sactionvm_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_sactionvm_mod_trig +before insert or update on rhnServerActionVerifyMissing +for each row +execute procedure rhn_sactionvm_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerActionVerifyResult.sql b/schema/spacewalk/postgres/triggers/rhnServerActionVerifyResult.sql new file mode 100644 index 0000000..754cc4e --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerActionVerifyResult.sql @@ -0,0 +1,13 @@ +create or replace function rhn_sactionvr_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_sactionvr_mod_trig +before insert or update on rhnServerActionVerifyResult +for each row +execute procedure rhn_sactionvr_mod_trig_fun(); diff --git a/schema/spacewalk/postgres/triggers/rhnServerChannelArchCompat.sql b/schema/spacewalk/postgres/triggers/rhnServerChannelArchCompat.sql new file mode 100644 index 0000000..011e52a --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerChannelArchCompat.sql @@ -0,0 +1,14 @@ +create or replace function rhn_sc_ac_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_sc_ac_mod_trig +before insert or update on rhnServerChannelArchCompat +for each row +execute procedure rhn_sc_ac_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerConfigChannel.sql b/schema/spacewalk/postgres/triggers/rhnServerConfigChannel.sql new file mode 100644 index 0000000..2ae3759 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerConfigChannel.sql @@ -0,0 +1,15 @@ +create or replace function rhn_servercc_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_servercc_mod_trig +before insert or update on rhnServerConfigChannel +for each row +execute procedure rhn_servercc_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerCustomDataValue.sql b/schema/spacewalk/postgres/triggers/rhnServerCustomDataValue.sql new file mode 100644 index 0000000..20c64bb --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerCustomDataValue.sql @@ -0,0 +1,14 @@ +create or replace function rhn_scdv_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_scdv_mod_trig +before insert or update on rhnServerCustomDataValue +for each row +execute procedure rhn_scdv_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerDMI.sql b/schema/spacewalk/postgres/triggers/rhnServerDMI.sql new file mode 100644 index 0000000..7e14c6c --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerDMI.sql @@ -0,0 +1,14 @@ +create or replace function rhn_server_dmi_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_server_dmi_mod_trig +before insert or update on rhnServerDMI +for each row +execute procedure rhn_server_dmi_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerEvent.sql b/schema/spacewalk/postgres/triggers/rhnServerEvent.sql new file mode 100644 index 0000000..dc04a1f --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerEvent.sql @@ -0,0 +1,30 @@ + +-- +-- Copyright (c) 2008 Red Hat, Inc. +-- +-- This software is licensed to you under the GNU General Public License, +-- version 2 (GPLv2). There is NO WARRANTY for this software, express or +-- implied, including the implied warranties of MERCHANTABILITY or FITNESS +-- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +-- along with this software; if not, see +-- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +-- +-- Red Hat trademarks are not licensed under GPLv2. No permission is +-- granted to use or replicate Red Hat trademarks that are incorporated +-- in this software or its documentation. +-- + +create or replace function rhn_se_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger rhn_se_mod_trig +before insert or update +on rhnServerEvent +for each row +execute procedure rhn_se_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerGroupNotes.sql b/schema/spacewalk/postgres/triggers/rhnServerGroupNotes.sql new file mode 100644 index 0000000..79cdcd7 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerGroupNotes.sql @@ -0,0 +1,15 @@ +create or replace function rhn_servergroup_note_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_servergroup_note_mod_trig +before insert or update on rhnServerGroupNotes +for each row +execute procedure rhn_servergroup_note_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerHistory.sql b/schema/spacewalk/postgres/triggers/rhnServerHistory.sql new file mode 100644 index 0000000..d733b4a --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerHistory.sql @@ -0,0 +1,16 @@ + +create or replace function rhn_serverhistory_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_serverhistory_mod_trig +before insert or update on rhnServerHistory +for each row +execute procedure rhn_serverhistory_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerInfo.sql b/schema/spacewalk/postgres/triggers/rhnServerInfo.sql new file mode 100644 index 0000000..a945264 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerInfo.sql @@ -0,0 +1,33 @@ + +-- +-- Copyright (c) 2008 Red Hat, Inc. +-- +-- This software is licensed to you under the GNU General Public License, +-- version 2 (GPLv2). There is NO WARRANTY for this software, express or +-- implied, including the implied warranties of MERCHANTABILITY or FITNESS +-- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 +-- along with this software; if not, see +-- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. +-- +-- Red Hat trademarks are not licensed under GPLv2. No permission is +-- granted to use or replicate Red Hat trademarks that are incorporated +-- in this software or its documentation. +-- + +create or replace function rhn_server_info_mod_trig_fun() returns trigger as +$$ +begin + if new.checkin is NULL + then + new.checkin := current_timestamp; + end if; + return new; +end; +$$ language plpgsql; + +create trigger rhn_server_info_mod_trig +before insert or update +on rhnServerInfo +for each row +execute procedure rhn_server_info_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerInstallInfo.sql b/schema/spacewalk/postgres/triggers/rhnServerInstallInfo.sql new file mode 100644 index 0000000..4f83cf5 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerInstallInfo.sql @@ -0,0 +1,16 @@ + +create or replace function rhn_s_inst_info_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_s_inst_info_mod_trig +before insert or update on rhnServerInstallInfo +for each row +execute procedure rhn_s_inst_info_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerLocation.sql b/schema/spacewalk/postgres/triggers/rhnServerLocation.sql new file mode 100644 index 0000000..3fb2c3d --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerLocation.sql @@ -0,0 +1,15 @@ +create or replace function rhn_serverlocation_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_serverlocation_mod_trig +before insert or update on rhnServerLocation +for each row +execute procedure rhn_serverlocation_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerMessage.sql b/schema/spacewalk/postgres/triggers/rhnServerMessage.sql new file mode 100644 index 0000000..2cd3907 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerMessage.sql @@ -0,0 +1,15 @@ +create or replace function rhn_sm_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_sm_mod_trig +before insert or update on rhnServerMessage +for each row +execute procedure rhn_sm_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerNetInterface.sql b/schema/spacewalk/postgres/triggers/rhnServerNetInterface.sql new file mode 100644 index 0000000..f976062 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerNetInterface.sql @@ -0,0 +1,14 @@ +create or replace function rhn_srv_net_iface_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_srv_net_iface_mod_trig +before insert or update on rhnServerNetInterface +for each row +execute procedure rhn_srv_net_iface_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerNetwork.sql b/schema/spacewalk/postgres/triggers/rhnServerNetwork.sql new file mode 100644 index 0000000..ebf85f4 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerNetwork.sql @@ -0,0 +1,15 @@ +create or replace function rhn_servernetwork_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_servernetwork_mod_trig +before insert or update on rhnServerNetwork +for each row +execute procedure rhn_servernetwork_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerNotes.sql b/schema/spacewalk/postgres/triggers/rhnServerNotes.sql new file mode 100644 index 0000000..e70d47e --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerNotes.sql @@ -0,0 +1,14 @@ +create or replace function rhn_servernotes_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_servernotes_mod_trig +before insert or update on rhnServerNotes +for each row +execute procedure rhn_servernotes_mod_trig_fun(); + diff --git a/schema/spacewalk/postgres/triggers/rhnServerPackageArchCompat.sql b/schema/spacewalk/postgres/triggers/rhnServerPackageArchCompat.sql new file mode 100644 index 0000000..4da5cb3 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerPackageArchCompat.sql @@ -0,0 +1,15 @@ +create or replace function rhn_sp_ac_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_sp_ac_mod_trig +before insert or update on rhnServerPackageArchCompat +for each row +execute procedure rhn_sp_ac_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerPath.sql b/schema/spacewalk/postgres/triggers/rhnServerPath.sql new file mode 100644 index 0000000..085e6ee --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerPath.sql @@ -0,0 +1,15 @@ +create or replace function rhn_serverpath_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_serverpath_mod_trig +before insert or update on rhnServerPath +for each row +execute procedure rhn_serverpath_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerPreserveFileList.sql b/schema/spacewalk/postgres/triggers/rhnServerPreserveFileList.sql new file mode 100644 index 0000000..f324fb5 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerPreserveFileList.sql @@ -0,0 +1,15 @@ +create or replace function rhn_serverpfl_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_serverpfl_mod_trig +before insert or update on rhnServerPreserveFileList +for each row +execute procedure rhn_serverpfl_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerProfileType.sql b/schema/spacewalk/postgres/triggers/rhnServerProfileType.sql new file mode 100644 index 0000000..6298870 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerProfileType.sql @@ -0,0 +1,16 @@ + +create or replace function rhn_sproftype_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_sproftype_mod_trig +before insert or update on rhnServerProfileType +for each row +execute procedure rhn_sproftype_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnServerServerGroupArchCompat.sql b/schema/spacewalk/postgres/triggers/rhnServerServerGroupArchCompat.sql new file mode 100644 index 0000000..7eee31b --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnServerServerGroupArchCompat.sql @@ -0,0 +1,16 @@ +create or replace function rhn_ssg_ac_mod_trig_fun() returns trigger as +$$ +begin + new.modified := current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ssg_ac_mod_trig +before insert or update on rhnServerServerGroupArchCompat +for each row +execute procedure rhn_ssg_ac_mod_trig_fun(); + + + diff --git a/schema/spacewalk/postgres/triggers/rhnSnapshotChannel.sql b/schema/spacewalk/postgres/triggers/rhnSnapshotChannel.sql new file mode 100644 index 0000000..535085c --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSnapshotChannel.sql @@ -0,0 +1,15 @@ +create or replace function rhn_snapchan_mod_trig_fun() returns trigger as +$$ +begin + update rhnSnapshot set modified = current_timestamp where id = new.snapshot_id; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_snapchan_mod_trig +before insert or update on rhnSnapshotChannel +for each row +execute procedure rhn_snapchan_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSnapshotConfigChannel.sql b/schema/spacewalk/postgres/triggers/rhnSnapshotConfigChannel.sql new file mode 100644 index 0000000..20816c5 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSnapshotConfigChannel.sql @@ -0,0 +1,15 @@ +create or replace function rhn_snapshotcc_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_snapshotcc_mod_trig +before insert or update on rhnSnapshotConfigChannel +for each row +execute procedure rhn_snapshotcc_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSnapshotConfigRevision.sql b/schema/spacewalk/postgres/triggers/rhnSnapshotConfigRevision.sql new file mode 100644 index 0000000..ca3e383 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSnapshotConfigRevision.sql @@ -0,0 +1,16 @@ + +create or replace function rhn_snapshotcr_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_snapshotcr_mod_trig +before insert or update on rhnSnapshotConfigRevision +for each row +execute procedure rhn_snapshotcr_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSnapshotInvalidReason.sql b/schema/spacewalk/postgres/triggers/rhnSnapshotInvalidReason.sql new file mode 100644 index 0000000..c1f0d49 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSnapshotInvalidReason.sql @@ -0,0 +1,15 @@ +create or replace function rhn_ssinvalid_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ssinvalid_mod_trig +before insert or update on rhnSnapshotInvalidReason +for each row +execute procedure rhn_ssinvalid_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSnapshotPackage.sql b/schema/spacewalk/postgres/triggers/rhnSnapshotPackage.sql new file mode 100644 index 0000000..1a82f4b --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSnapshotPackage.sql @@ -0,0 +1,16 @@ + +create or replace function rhn_snapshotpkg_mod_trig_fun() returns trigger as +$$ +begin + update rhnSnapshot set modified = current_timestamp where id = new.snapshot_id; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_snapshotpkg_mod_trig +before insert or update on rhnSnapshotPackage +for each row +execute procedure rhn_snapshotpkg_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSnapshotServerGroup.sql b/schema/spacewalk/postgres/triggers/rhnSnapshotServerGroup.sql new file mode 100644 index 0000000..4d19c19 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSnapshotServerGroup.sql @@ -0,0 +1,16 @@ + +create or replace function rhn_snapshotsg_mod_trig_fun() returns trigger as +$$ +begin + update rhnSnapshot set modified = current_timestamp where id = new.snapshot_id; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_snapshotsg_mod_trig +before insert or update on rhnSnapshotServerGroup +for each row +execute procedure rhn_snapshotsg_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSnapshotTag.sql b/schema/spacewalk/postgres/triggers/rhnSnapshotTag.sql new file mode 100644 index 0000000..2c71083 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSnapshotTag.sql @@ -0,0 +1,15 @@ +create or replace function rhn_ss_tag_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ss_tag_mod_trig +before insert or update on rhnSnapshotTag +for each row +execute procedure rhn_ss_tag_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSolarisPatch.sql b/schema/spacewalk/postgres/triggers/rhnSolarisPatch.sql new file mode 100644 index 0000000..6006d2f --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSolarisPatch.sql @@ -0,0 +1,15 @@ +create or replace function rhn_solaris_p_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_solaris_p_mod_trig +before insert or update on rhnSolarisPatch +for each row +execute procedure rhn_solaris_p_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSolarisPatchSet.sql b/schema/spacewalk/postgres/triggers/rhnSolarisPatchSet.sql new file mode 100644 index 0000000..e43e483 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSolarisPatchSet.sql @@ -0,0 +1,15 @@ +create or replace function rhn_solaris_ps_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_solaris_ps_mod_trig +before insert or update on rhnSolarisPatchSet +for each row +execute procedure rhn_solaris_ps_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSolarisPatchSetMembers.sql b/schema/spacewalk/postgres/triggers/rhnSolarisPatchSetMembers.sql new file mode 100644 index 0000000..6293f26 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSolarisPatchSetMembers.sql @@ -0,0 +1,15 @@ +create or replace function rhn_solaris_psm_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_solaris_psm_mod_trig +before insert or update on rhnSolarisPatchSetMembers +for each row +execute procedure rhn_solaris_psm_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnSsmOperation.sql b/schema/spacewalk/postgres/triggers/rhnSsmOperation.sql new file mode 100644 index 0000000..53a2c43 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnSsmOperation.sql @@ -0,0 +1,15 @@ +create or replace function rhn_ssmop_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_ssmop_mod_trig +before insert or update on rhnSsmOperation +for each row +execute procedure rhn_ssmop_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnTag.sql b/schema/spacewalk/postgres/triggers/rhnTag.sql new file mode 100644 index 0000000..d21b0d9 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnTag.sql @@ -0,0 +1,15 @@ +create or replace function rhn_tag_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_tag_mod_trig +before insert or update on rhnTag +for each row +execute procedure rhn_tag_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnTagName.sql b/schema/spacewalk/postgres/triggers/rhnTagName.sql new file mode 100644 index 0000000..ff8c7d1 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnTagName.sql @@ -0,0 +1,15 @@ +create or replace function rhn_tn_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_tn_mod_trig +before insert or update on rhnTagName +for each row +execute procedure rhn_tn_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnTemplateCategory.sql b/schema/spacewalk/postgres/triggers/rhnTemplateCategory.sql new file mode 100644 index 0000000..75c6463 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnTemplateCategory.sql @@ -0,0 +1,15 @@ +create or replace function rhn_template_cat_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_template_cat_mod_trig +before insert or update on rhnTemplateCategory +for each row +execute procedure rhn_template_cat_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnTemplateString.sql b/schema/spacewalk/postgres/triggers/rhnTemplateString.sql new file mode 100644 index 0000000..0c6350e --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnTemplateString.sql @@ -0,0 +1,15 @@ +create or replace function rhn_template_str_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_template_str_mod_trig +before insert or update on rhnTemplateString +for each row +execute procedure rhn_template_str_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnTextMessage.sql b/schema/spacewalk/postgres/triggers/rhnTextMessage.sql new file mode 100644 index 0000000..2020e4b --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnTextMessage.sql @@ -0,0 +1,15 @@ +create or replace function rhn_tm_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_tm_mod_trig +before insert or update on rhnTextMessage +for each row +execute procedure rhn_tm_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnUserReserved.sql b/schema/spacewalk/postgres/triggers/rhnUserReserved.sql new file mode 100644 index 0000000..402ba61 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnUserReserved.sql @@ -0,0 +1,15 @@ +create or replace function rhn_user_res_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + return new; +end; +$$ language plpgsql; + +create trigger +rhn_user_res_mod_trig +before insert or update on rhnUserreserved +for each row +execute procedure rhn_user_res_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnUserServerPrefs.sql b/schema/spacewalk/postgres/triggers/rhnUserServerPrefs.sql new file mode 100644 index 0000000..bae6aad --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnUserServerPrefs.sql @@ -0,0 +1,16 @@ +create or replace function rhn_u_s_prefs_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + new.value := upper (new.value); + return new; +end; +$$ language plpgsql; + +create trigger +rhn_u_s_prefs_mod_trig +before insert or update on rhnUserServerPrefs +for each row +execute procedure rhn_u_s_prefs_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhnVersionInfo.sql b/schema/spacewalk/postgres/triggers/rhnVersionInfo.sql new file mode 100644 index 0000000..e4b8d71 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhnVersionInfo.sql @@ -0,0 +1,16 @@ +create or replace function rhn_versioninfo_mod_trig_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +rhn_versioninfo_mod_trig +before insert or update on rhnVersionInfo +for each row +execute procedure rhn_versioninfo_mod_trig_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/rhn_contact_methods.sql b/schema/spacewalk/postgres/triggers/rhn_contact_methods.sql new file mode 100644 index 0000000..68867ef --- /dev/null +++ b/schema/spacewalk/postgres/triggers/rhn_contact_methods.sql @@ -0,0 +1,52 @@ +create or replace function rhn_cmeth_val_trig_fun() returns trigger as +$$ +declare + msg varchar(200); + --missing_data exception; +begin + + msg :='missing or invalid data for contact_methods table'; + + if new.method_type_id = 1 then + + --- pager fields pager_email,pager_split_long_messages should be not null + if (new.pager_email is null or new.pager_split_long_messages is null ) then + raise exception 'missing or invalid data for contact_methods table'; --missing_data; + end if; + end if; + + if new.method_type_id = 2 then + + --- the all email fields but email_reply_to should be not null + if new.email_address is null then + raise exception 'missing or invalid data for contact_methods table'; --missing_data; + end if; + end if; + + if new.method_type_id = 5 then + + --- the all sntp fields be not null + if (new.snmp_host is null or new.snmp_port is null) then + raise exception 'missing or invalid data for contact_methods table'; --missing_data; + end if; + end if; + + + + if not found then + perform rhn_exception.raise_exception(msg); + end if; + + return new; +end; +$$ language plpgsql; + + +create trigger +rhn_cmeth_val_trig +before insert or update on rhn_contact_methods +for each row +execute procedure rhn_cmeth_val_trig_fun(); + + + diff --git a/schema/spacewalk/postgres/triggers/web_user_contact_permission.sql b/schema/spacewalk/postgres/triggers/web_user_contact_permission.sql new file mode 100644 index 0000000..5775df1 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/web_user_contact_permission.sql @@ -0,0 +1,16 @@ +create or replace function web_user_cp_timestamp_fun() returns trigger as +$$ +begin + new.modified = current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +web_user_cp_timestamp +before insert or update on web_user_contact_permission +for each row +execute procedure web_user_cp_timestamp_fun(); + + diff --git a/schema/spacewalk/postgres/triggers/web_user_site_info.sql b/schema/spacewalk/postgres/triggers/web_user_site_info.sql new file mode 100644 index 0000000..c866af3 --- /dev/null +++ b/schema/spacewalk/postgres/triggers/web_user_site_info.sql @@ -0,0 +1,19 @@ + +create or replace function web_user_si_timestamp_fun() returns trigger as +$$ +begin + + new.email_uc := upper(new.email); + new.modified := current_timestamp; + + return new; +end; +$$ language plpgsql; + +create trigger +web_user_si_timestamp +before insert or update on web_user_site_info +for each row +execute procedure web_user_si_timestamp_fun(); + +

15 years

1
0
0 / 0

Branch 'VADER' - java/code

by Tomas Lestach

java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) New commits: commit f95c5addf8db9ea94b6febb9c0f729ddae17ce76 Author: Tomas Lestach <tlestach(a)redhat.com> Date: Thu Apr 30 16:25:27 2009 +0200 limiting number of chars/line to 80 diff --git a/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java b/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java index 591b3ba..6815565 100644 --- a/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java +++ b/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java @@ -66,7 +66,8 @@ public class PxtCookieManager { Cookie pxtCookie = new Cookie(cookieName, cookieValue); // BZ #454876 // when not using setDomain, default "Host" will be set for the cookie - // there's no need to use domain and besides that it causes trouble, when accessing the server within the local network (without FQDN) + // there's no need to use domain and besides that it causes trouble, + // when accessing the server within the local network (without FQDN) // pxtCookie.setDomain(request.getServerName()); pxtCookie.setMaxAge(timeout); pxtCookie.setPath(DEFAULT_PATH);

15 years

1
0
0 / 0

java/spacewalk-java.spec rel-eng/packages

by Tomas Lestach

java/spacewalk-java.spec | 4 ++-- rel-eng/packages/spacewalk-java | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) New commits: commit 6b91d4149d349accf6b03a71cc67c44cd1fd0987 Author: Tomas Lestach <tlestach(a)redhat.com> Date: Thu Apr 30 16:27:30 2009 +0200 Automatic commit of package [spacewalk-java] release [0.6.10-1]. diff --git a/java/spacewalk-java.spec b/java/spacewalk-java.spec index e34085b..907c821 100644 --- a/java/spacewalk-java.spec +++ b/java/spacewalk-java.spec @@ -11,7 +11,7 @@ Name: spacewalk-java Summary: Spacewalk Java site packages Group: Applications/Internet License: GPLv2 -Version: 0.6.9 +Version: 0.6.10 Release: 1%{?dist} URL: https://fedorahosted.org/spacewalk Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz @@ -249,7 +249,7 @@ fi %attr(644, root, root) %{_datadir}/rhn/lib/rhn.jar %changelog -* Thu Apr 30 2009 Tomas Lestach <tlestach(a)redhat.com> 0.6.9-1 +* Thu Apr 30 2009 Tomas Lestach <tlestach(a)redhat.com> 0.6.10-1 - 454876 - not setting cookie domain (tlestach(a)redhat.com) - 497458 - fixing ISE with errata cloning (jsherril(a)redhat.com) - checkstyle fix (jsherril(a)redhat.com) diff --git a/rel-eng/packages/spacewalk-java b/rel-eng/packages/spacewalk-java index 01eb852..364202f 100644 --- a/rel-eng/packages/spacewalk-java +++ b/rel-eng/packages/spacewalk-java @@ -1 +1 @@ -0.6.9-1 java/ +0.6.10-1 java/

15 years

1
0
0 / 0

Changes to 'refs/tags/spacewalk-java-0.6.10-1'

by Tomas Lestach

Tag 'spacewalk-java-0.6.10-1' created by Tomas Lestach <tlestach(a)redhat.com> at 2009-04-30 14:27 +0000 Tagging package [spacewalk-java] version [0.6.10-1] in directory [java/]. Changes since spacewalk-java-0.6.9-1-2: --- 0 files changed ---

15 years

1
0
0 / 0

java/code

by Tomas Lestach

java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) New commits: commit c128fb0a1136a18a4c37dadb940ec33788dd54eb Author: Tomas Lestach <tlestach(a)redhat.com> Date: Thu Apr 30 16:25:27 2009 +0200 limiting number of chars/line to 80 diff --git a/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java b/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java index 591b3ba..6815565 100644 --- a/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java +++ b/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java @@ -66,7 +66,8 @@ public class PxtCookieManager { Cookie pxtCookie = new Cookie(cookieName, cookieValue); // BZ #454876 // when not using setDomain, default "Host" will be set for the cookie - // there's no need to use domain and besides that it causes trouble, when accessing the server within the local network (without FQDN) + // there's no need to use domain and besides that it causes trouble, + // when accessing the server within the local network (without FQDN) // pxtCookie.setDomain(request.getServerName()); pxtCookie.setMaxAge(timeout); pxtCookie.setPath(DEFAULT_PATH);

15 years

1
0
0 / 0

Branch 'VADER' - java/code

by Shannon Hughes

java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml | 12 +++++++++- java/code/src/com/redhat/rhn/domain/channel/ChannelFactory.java | 2 - 2 files changed, 12 insertions(+), 2 deletions(-) New commits: commit 44017fd00286a9a81d03f18efc740da651a3ddf8 Author: Shannon Hughes <shughes(a)redhat.com> Date: Thu Apr 30 09:38:48 2009 -0400 498075 - block child channel creation from base channels for orgs that do not have entitlements diff --git a/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml b/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml index 623e6b1..f4ecff3 100644 --- a/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml +++ b/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml @@ -138,12 +138,22 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" AND c.parent_channel is null]]> <return alias="c" class="com.redhat.rhn.domain.channel.Channel" /> </sql-query> - +  + <sql-query name="Channel.findAllBaseChannels"> + <![CDATA[SELECT {c.*} + FROM rhnChannel {c}, + rhnChannelCloned c_1_ + WHERE c.parent_channel is null + AND c.id = c_1_.id (+) + AND 1 IN (SELECT rhn_channel.get_org_access(c.id, :org_id) from dual)]]> + <return alias="c" class="com.redhat.rhn.domain.channel.Channel" /> + </sql-query> <query name="Channel.findAllBaseChannelsOnSatellite"> <![CDATA[from com.redhat.rhn.domain.channel.Channel as c diff --git a/java/code/src/com/redhat/rhn/domain/channel/ChannelFactory.java b/java/code/src/com/redhat/rhn/domain/channel/ChannelFactory.java index b14c86b..8d9f3ec 100644 --- a/java/code/src/com/redhat/rhn/domain/channel/ChannelFactory.java +++ b/java/code/src/com/redhat/rhn/domain/channel/ChannelFactory.java @@ -755,7 +755,7 @@ public class ChannelFactory extends HibernateFactory { */ public static List<Channel> listAllBaseChannels(Org org) { Map params = new HashMap(); - params.put("org", org); + params.put("org_id", org.getId()); return singleton.listObjectsByNamedQuery( "Channel.findAllBaseChannels", params); }

15 years

1
0
0 / 0

java/code

by Shannon Hughes

java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml | 12 +++++++++- java/code/src/com/redhat/rhn/domain/channel/ChannelFactory.java | 2 - 2 files changed, 12 insertions(+), 2 deletions(-) New commits: commit 84a2913b22f8441332f8e1b1077ab7178469ff93 Author: Shannon Hughes <shughes(a)redhat.com> Date: Thu Apr 30 09:38:48 2009 -0400 498075 - block child channel creation from base channels for orgs that do not have entitlements diff --git a/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml b/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml index 623e6b1..f4ecff3 100644 --- a/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml +++ b/java/code/src/com/redhat/rhn/domain/channel/Channel.hbm.xml @@ -138,12 +138,22 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" AND c.parent_channel is null]]> <return alias="c" class="com.redhat.rhn.domain.channel.Channel" /> </sql-query> - +  + <sql-query name="Channel.findAllBaseChannels"> + <![CDATA[SELECT {c.*} + FROM rhnChannel {c}, + rhnChannelCloned c_1_ + WHERE c.parent_channel is null + AND c.id = c_1_.id (+) + AND 1 IN (SELECT rhn_channel.get_org_access(c.id, :org_id) from dual)]]> + <return alias="c" class="com.redhat.rhn.domain.channel.Channel" /> + </sql-query> <query name="Channel.findAllBaseChannelsOnSatellite"> <![CDATA[from com.redhat.rhn.domain.channel.Channel as c diff --git a/java/code/src/com/redhat/rhn/domain/channel/ChannelFactory.java b/java/code/src/com/redhat/rhn/domain/channel/ChannelFactory.java index b14c86b..8d9f3ec 100644 --- a/java/code/src/com/redhat/rhn/domain/channel/ChannelFactory.java +++ b/java/code/src/com/redhat/rhn/domain/channel/ChannelFactory.java @@ -755,7 +755,7 @@ public class ChannelFactory extends HibernateFactory { */ public static List<Channel> listAllBaseChannels(Org org) { Map params = new HashMap(); - params.put("org", org); + params.put("org_id", org.getId()); return singleton.listObjectsByNamedQuery( "Channel.findAllBaseChannels", params); }

15 years

1
0
0 / 0

Changes to 'refs/tags/spacewalk-java-0.6.9-1'

by Tomas Lestach

Tag 'spacewalk-java-0.6.9-1' created by Tomas Lestach <tlestach(a)redhat.com> at 2009-04-30 12:52 +0000 Tagging package [spacewalk-java] version [0.6.9-1] in directory [java/]. Changes since spacewalk-proxy-installer-0.6.4-1-2: --- 0 files changed ---

15 years

1
0
0 / 0

2 commits - java/code java/spacewalk-java.spec rel-eng/packages

by Tomas Lestach

java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java | 5 - java/spacewalk-java.spec | 45 +++++++++- rel-eng/packages/spacewalk-java | 2 3 files changed, 49 insertions(+), 3 deletions(-) New commits: commit e8fee0d753391069eb1e9732f551036ab1f38bfa Author: Tomas Lestach <tlestach(a)redhat.com> Date: Thu Apr 30 14:52:05 2009 +0200 Automatic commit of package [spacewalk-java] release [0.6.9-1]. diff --git a/java/spacewalk-java.spec b/java/spacewalk-java.spec index d5a1af6..e34085b 100644 --- a/java/spacewalk-java.spec +++ b/java/spacewalk-java.spec @@ -11,7 +11,7 @@ Name: spacewalk-java Summary: Spacewalk Java site packages Group: Applications/Internet License: GPLv2 -Version: 0.6.8 +Version: 0.6.9 Release: 1%{?dist} URL: https://fedorahosted.org/spacewalk Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz @@ -249,6 +249,49 @@ fi %attr(644, root, root) %{_datadir}/rhn/lib/rhn.jar %changelog +* Thu Apr 30 2009 Tomas Lestach <tlestach(a)redhat.com> 0.6.9-1 +- 454876 - not setting cookie domain (tlestach(a)redhat.com) +- 497458 - fixing ISE with errata cloning (jsherril(a)redhat.com) +- checkstyle fix (jsherril(a)redhat.com) +- 219179 - setting redhat_management_server for the system records like we do + for server (jsherril(a)redhat.com) +- 480011 - Added organization to the top header near the username. + (jason.dobies(a)redhat.com) +- 497867 - fixed bug in logic after changing hibernate mappings + (jsherril(a)redhat.com) +- 497917 - fixing issue where select all did not work on errata list/remove + packages (jsherril(a)redhat.com) +- 497867 - fixing reboots taking place even if provisioning fails + (jsherril(a)redhat.com) +- checkstyle fix (jsherril(a)redhat.com) +- 219179 - fixed some issues related to reprovisioning through proxy + (jsherril(a)redhat.com) +- 481578 - Ported manage software channels page from perl to java + (jason.dobies(a)redhat.com) +- 498208 - cobbler webui string correction (shughes(a)redhat.com) +- 461704 - clean time_series when deleting a monitoring probe + (mzazrivec(a)redhat.com) +- 497925 - we search and replace the cobbler host with proxy + (mmccune(a)gmail.com) +- Added code to ensure name is required .... (paji(a)redhat.com) +- 497872 - skip 'fake' interfaces when looking up system records. + (mmccune(a)gmail.com) +- Updated the Kickstart Advanced mode page to include edit area instead of the + standard text area for uploading kicktstart information.. (paji(a)redhat.com) +- 497964 - Made the config file create and file details page use edit area.. + Fancy editor... (paji(a)redhat.com) +- 444221 - Updated the Create/Modify and the delete snippets pages based on + Mizmo's suggestions (paji(a)redhat.com) +- 489902 - fix help links to work with rhn-il8n-guides (bbuckingham(a)redhat.com) +- Checkstyle fixes (jason.dobies(a)redhat.com) +- 494627 - Added more fine grained error messages for invalid channel data. + (jason.dobies(a)redhat.com) +- 485849 - merging RELEASE-5.1 bug into spacewalk (mmccune(a)gmail.com) +- 496259 - greatly improved errata deletion time (jsherril(a)redhat.com) +- 444221 - Cobbler Snippet Create page redesign (paji(a)redhat.com) +- 444221 - Initial improvement on Cobbler Snippets List page based on the bug.. + (paji(a)redhat.com) + * Fri Apr 24 2009 jesus m. rodriguez <jesusr(a)redhat.com> 0.6.8-1 - removing some debug statements (jsherril(a)redhat.com) - 495961 - greatly improving performance of add errata page (jsherril(a)redhat.com) diff --git a/rel-eng/packages/spacewalk-java b/rel-eng/packages/spacewalk-java index d9869dd..01eb852 100644 --- a/rel-eng/packages/spacewalk-java +++ b/rel-eng/packages/spacewalk-java @@ -1 +1 @@ -0.6.8-1 java/ +0.6.9-1 java/ commit e9715250fa3d95e562e4357ec712495691e7a66b Author: Tomas Lestach <tlestach(a)redhat.com> Date: Wed Apr 29 17:37:23 2009 +0200 454876 - not setting cookie domain - domain causes troubles, when accessing the server within the local network (without FQDN) diff --git a/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java b/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java index 3959fb8..591b3ba 100644 --- a/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java +++ b/java/code/src/com/redhat/rhn/frontend/servlets/PxtCookieManager.java @@ -64,7 +64,10 @@ public class PxtCookieManager { SessionManager.generateSessionKey(pxtSessionId.toString()); Cookie pxtCookie = new Cookie(cookieName, cookieValue); - pxtCookie.setDomain(request.getServerName()); + // BZ #454876 + // when not using setDomain, default "Host" will be set for the cookie + // there's no need to use domain and besides that it causes trouble, when accessing the server within the local network (without FQDN) + // pxtCookie.setDomain(request.getServerName()); pxtCookie.setMaxAge(timeout); pxtCookie.setPath(DEFAULT_PATH); pxtCookie.setSecure(Config.get().isSSLAvailable());

15 years

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

spacewalk-commits April 2009