schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/038-rhn_notification_formats-newlines.sql.postgresql
| 13 ++++++++++
1 file changed, 13 insertions(+)
New commits:
commit 6343d29c45e8b077c20a519b5b454ffe89044049
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Mon Apr 30 17:29:37 2012 +0200
Update existing rhn_notification_formats with the new newlines matching Oracle.
This amends the 77bccb6ec4f6c6cc878f4d6978668325ce4462fe change.
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/038-rhn_notification_formats-newlines.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/038-rhn_notification_formats-newlines.sql.postgresql
new file mode 100644
index 0000000..cbff6e0
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/038-rhn_notification_formats-newlines.sql.postgresql
@@ -0,0 +1,13 @@
+-- oracle equivalent source none
+
+update rhn_notification_formats
+set body_format = 'This is a Spacewalk Monitoring Satellite event
notification.\\n\\nTime: ^[timestamp:"%a %b %d, %H:%M:%S %Z"]\\nState:
^[probe state]\\nHost: ^[hostname] (^[host IP])\\nCheck: ^[probe
description]\\nMessage: ^[probe output]\\nRun from: ^[satellite description]\\n\\nTo
acknowledge, reply to this message with this subject line:\\n ACK ^[alert id]\\n\\nTo
immediately escalate, reply to this message with this subject line:\\n NACK ^[alert
id]'
+where customer_id is null
+ and description = 'New Default (2.15)';
+
+update rhn_notification_formats
+set body_format = 'This is Spacewalk Monitoring Satellite notification ^[alert
id].\\n\\nTime: ^[timestamp:"%a %b %d, %H:%M:%S %Z"]\\nState: ^[probe
state]\\nHost: ^[hostname] (^[host IP])\\nCheck: ^[probe description]\\nMessage:
^[probe output]\\nRun from: ^[satellite description]',
+ reply_format = '\\n\\nTo acknowledge, reply to this message within ^[ack wait]
minutes with this subject line:\\n ACK ^[alert id]\\n\\nTo immediately escalate, reply
to this message within ^[ack wait] minutes with this subject line:\\n NACK ^[alert
id]'
+where customer_id is null
+ and description = 'New Default (2.18)';
+
Show replies by date