From de82e5d9824e3e168cb436d776ab8a75dad05af0 Mon Sep 17 00:00:00 2001
From: Greg Pazo <gpazo@xtuple.com>
Date: Mon, 29 Sep 2014 14:45:25 -0400
Subject: [PATCH] update pre-req checks

---
 scripts/xml/distribution_package.xml | 2 +-
 scripts/xml/postbooks_package.xml    | 2 +-
 scripts/xml/xtmfg_install.xml        | 2 +-
 scripts/xml/xtmfg_package.xml        | 2 +-
 4 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/scripts/xml/distribution_package.xml b/scripts/xml/distribution_package.xml
index 09dcb4295..48cdd945a 100644
--- a/scripts/xml/distribution_package.xml
+++ b/scripts/xml/distribution_package.xml
@@ -19,7 +19,7 @@
 
   <prerequisite type = "query"
                 name = "Checking for too-new xTuple ERP database version" >
-    <query>SELECT NOT fetchMetricText('ServerVersion') >= '4.7.0';</query>
+    <query>SELECT fetchMetricText('ServerVersion') < '4.7.0Beta2' AND fetchMetricText('ServerVersion') != '4.7.0';</query>
     <message>This package may not be applied to a database newer than 4.7.0Beta.
     </message>
   </prerequisite>
diff --git a/scripts/xml/postbooks_package.xml b/scripts/xml/postbooks_package.xml
index 6753129b2..8d857d6cf 100644
--- a/scripts/xml/postbooks_package.xml
+++ b/scripts/xml/postbooks_package.xml
@@ -19,7 +19,7 @@
 
   <prerequisite type = "query"
                 name = "Checking for too-new xTuple ERP database version" >
-    <query>SELECT NOT fetchMetricText('ServerVersion') >= '4.7.0';</query>
+    <query>SELECT fetchMetricText('ServerVersion') < '4.7.0Beta2' AND fetchMetricText('ServerVersion') != '4.7.0';</query>
     <message>This package may not be applied to a database newer than 4.7.0Beta.
     </message>
   </prerequisite>
diff --git a/scripts/xml/xtmfg_install.xml b/scripts/xml/xtmfg_install.xml
index ef8c0271f..90ab85b3e 100644
--- a/scripts/xml/xtmfg_install.xml
+++ b/scripts/xml/xtmfg_install.xml
@@ -19,7 +19,7 @@
 
   <prerequisite type = "query"
                 name = "Checking for too-new xTuple ERP database version" >
-    <query>SELECT NOT fetchMetricText('ServerVersion') >= '4.7.0';</query>
+    <query>SELECT fetchMetricText('ServerVersion') < '4.7.0Beta2' AND fetchMetricText('ServerVersion') != '4.7.0';</query>
     <message>This package may not be applied to a database newer than 4.7.0Beta.
     </message>
   </prerequisite>
diff --git a/scripts/xml/xtmfg_package.xml b/scripts/xml/xtmfg_package.xml
index ff70b82de..7fa1a8f92 100644
--- a/scripts/xml/xtmfg_package.xml
+++ b/scripts/xml/xtmfg_package.xml
@@ -30,7 +30,7 @@
 
 <prerequisite type = "query"
                name = "Checking for too-new xTuple ERP database version" >
-<query>SELECT NOT fetchMetricText('ServerVersion') >= '4.7.0';</query>
+<query>SELECT fetchMetricText('ServerVersion') < '4.7.0Beta2' AND fetchMetricText('ServerVersion') != '4.7.0';</query>
     <message>This package may not be applied to a database newer than 4.7.0Beta2.
     </message>
 </prerequisite>
-- 
2.39.2