[icinga-checkins] icinga.org: icinga-core/r1.4: downgrade db schema version in idoutils, no changes introduces

git at icinga.org git at icinga.org
Wed Jun 29 10:53:04 CEST 2011


Module: icinga-core
Branch: r1.4
Commit: 27ba5cbda9b4e843393daf93aa8ee9b5902be1d9
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=27ba5cbda9b4e843393daf93aa8ee9b5902be1d9

Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Wed Jun 29 10:51:50 2011 +0200

downgrade db schema version in idoutils, no changes introduces

---

 module/idoutils/db/mysql/mysql.sql      |    2 +-
 module/idoutils/db/oracle/oracle.sql    |    2 +-
 module/idoutils/db/scripts/installdb.in |    2 +-
 module/idoutils/db/scripts/upgradedb.in |    6 +++---
 4 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/module/idoutils/db/mysql/mysql.sql b/module/idoutils/db/mysql/mysql.sql
index cf4094a..baa98e9 100644
--- a/module/idoutils/db/mysql/mysql.sql
+++ b/module/idoutils/db/mysql/mysql.sql
@@ -1555,6 +1555,6 @@ CREATE INDEX statehist_i_id_o_id_s_ty_s_ti on icinga_statehistory(instance_id, o
 -- -----------------------------------------
 -- set dbversion
 -- -----------------------------------------
-INSERT INTO icinga_dbversion (name, version) VALUES ('idoutils', '1.4.1') ON DUPLICATE KEY UPDATE version='1.4.1';
+INSERT INTO icinga_dbversion (name, version) VALUES ('idoutils', '1.4.0') ON DUPLICATE KEY UPDATE version='1.4.0';
 
 
diff --git a/module/idoutils/db/oracle/oracle.sql b/module/idoutils/db/oracle/oracle.sql
index 9f8a8da..772100d 100644
--- a/module/idoutils/db/oracle/oracle.sql
+++ b/module/idoutils/db/oracle/oracle.sql
@@ -21,7 +21,7 @@
 -- -- --------------------------------------------------------
 */
 
-DEFINE ICINGA_VERSION=1.4.1
+DEFINE ICINGA_VERSION=1.4.0
 
 -- -----------------------------------------
 -- set defines
diff --git a/module/idoutils/db/scripts/installdb.in b/module/idoutils/db/scripts/installdb.in
index d138078..51cef88 100755
--- a/module/idoutils/db/scripts/installdb.in
+++ b/module/idoutils/db/scripts/installdb.in
@@ -45,7 +45,7 @@ my $dbh = DBI->connect("DBI:mysql:database=$database;host=$hostname",
 		or die "Cannot connect to database";
 
 # Current database version
-my $thisversion="1.4.1";
+my $thisversion="1.4.0";
 
 # Create version table if it doesn't exist
 eval { $dbh->do("SELECT * FROM icinga_dbversion LIMIT 1") };
diff --git a/module/idoutils/db/scripts/upgradedb.in b/module/idoutils/db/scripts/upgradedb.in
index a271c71..fc8fd88 100755
--- a/module/idoutils/db/scripts/upgradedb.in
+++ b/module/idoutils/db/scripts/upgradedb.in
@@ -53,9 +53,9 @@ if ($@) {
 
 # Get current database version
 my $version;
-my $thisversion="1.4.1";
-my $lastversion="1.4.1";
-my $legacyversion="1.4.1";
+my $thisversion="1.4.0";
+my $lastversion="1.4.0";
+my $legacyversion="1.4.0";
 
 $version = $dbh->selectrow_array("SELECT version FROM icinga_dbversion WHERE name='idoutils'");
 if ($version eq "") {





More information about the icinga-checkins mailing list