[Pkg-nagios-changes] [icinga] 01/02: Fix postgresql upgrade script for 1.11.3

[Alexander Wirt]

This is an automated email from the git hooks/post-receive script.

formorer pushed a commit to branch master
in repository icinga.

commit e315571f8bc6fd2cc3229a1ec17224443eb6564a
Author: Alexander Wirt <formorer at debian.org>
Date:   Wed May 28 14:23:17 2014 +0200

    Fix postgresql upgrade script for 1.11.3
    
    Closes: #749581
---
 debian/patches/00list                              |  1 +
 debian/patches/96_fix_postgres_11.3_upgrade.dpatch | 21 +++++++++++++++++++++
 2 files changed, 22 insertions(+)

diff --git a/debian/patches/00list b/debian/patches/00list
index 2d4d220..c386960 100644
--- a/debian/patches/00list
+++ b/debian/patches/00list
@@ -3,3 +3,4 @@
 52_icinga.cfg-debianize.dpatch
 70_fix_eventhandler_paths.dpatch
 95_fix_db_upgrade.dpatch
+96_fix_postgres_11.3_upgrade.dpatch
diff --git a/debian/patches/96_fix_postgres_11.3_upgrade.dpatch b/debian/patches/96_fix_postgres_11.3_upgrade.dpatch
new file mode 100755
index 0000000..129b63f
--- /dev/null
+++ b/debian/patches/96_fix_postgres_11.3_upgrade.dpatch
@@ -0,0 +1,21 @@
+#! /bin/sh /usr/share/dpatch/dpatch-run
+## 96_fix_postgres_11.3_upgrade.dpatch by Alexander Wirt <formorer at debian.org>
+##
+## All lines beginning with `## DP:' are a description of the patch.
+## DP: No description.
+
+ at DPATCH@
+diff -urNad '--exclude=CVS' '--exclude=.svn' '--exclude=.git' '--exclude=.arch' '--exclude=.hg' '--exclude=_darcs' '--exclude=.bzr' pkg-icinga~/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.11.3.sql pkg-icinga/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.11.3.sql
+--- pkg-icinga~/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.11.3.sql	2014-05-28 14:22:02.000000000 +0200
++++ pkg-icinga/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.11.3.sql	2014-05-28 14:22:41.262944849 +0200
+@@ -14,8 +14,8 @@
+ ALTER TABLE icinga_servicegroups ADD COLUMN notes_url TEXT default NULL;
+ ALTER TABLE icinga_servicegroups ADD COLUMN action_url TEXT default NULL;
+ 
+-ALTER TABLE icinga_hoststatus ADD COLUMN is_reachable smallint(6) DEFAULT NULL;
+-ALTER TABLE icinga_servicestatus ADD COLUMN is_reachable smallint(6) DEFAULT NULL;
++ALTER TABLE icinga_hoststatus ADD COLUMN is_reachable INTEGER DEFAULT NULL;
++ALTER TABLE icinga_servicestatus ADD COLUMN is_reachable INTEGER DEFAULT NULL;
+ 
+ -- -----------------------------------------
+ -- update dbversion

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/pkg-nagios/icinga.git