bump to 4.7.0 final

[xtuple] / scripts / xml / postbooks_package.xml

diff --git a/scripts/xml/postbooks_package.xml b/scripts/xml/postbooks_package.xml
index b3b8d93..464f2b8 100644 (file)
--- a/scripts/xml/postbooks_package.xml
+++ b/scripts/xml/postbooks_package.xml
@@ -1,5 +1,5 @@
-<package id        = "postbooks-upgrade-450"
-         version   = "4.5.0"
+<package id        = "postbooks-upgrade-470"
+         version   = "4.7.0"
          developer = "xTuple"
          descrip   = "load PostBooks resources"
          updater   = "2.2.4" >
@@ -11,16 +11,16 @@
   </prerequisite>
 
   <prerequisite type = "query"
-                name = "Checking xTuple ERP database version" >
+                name = "Checking for too-old xTuple ERP database version" >
     <query>SELECT fetchMetricText('ServerVersion') > '4.4.';</query>
-    <message>This package must be applied to a 4.4+ PostBooks database.
+    <message>This package must be applied to a 4.4+ database.
     </message>
   </prerequisite>
 
   <prerequisite type = "query"
-                name = "Checking for bad xTuple ERP database version" >
-    <query>SELECT NOT fetchMetricText('ServerVersion') > '4.5.0' AND fetchMetricText('ServerVersion')!='4.5.0Beta' AND fetchMetricText('ServerVersion')!='4.5.0RC';</query>
-    <message>This package may not be applied to a 4.5+ Postbooks database.
+                name = "Checking for too-new xTuple ERP database version" >
+    <query>SELECT NOT fetchMetricText('ServerVersion') >= '4.8.0';</query>
+    <message>This package may not be applied to a database newer than 4.7.0.
     </message>
   </prerequisite>
 
@@ -31,14 +31,14 @@
     </message>
   </prerequisite>
 
-  <prerequisite type = "query"
+ <prerequisite type = "query"
                name = "Checking for duplicate Credit Card payments on Sales Orders" >
     <query>
       WITH counter AS (SELECT COUNT(*) AS freq
                         FROM payco
                         GROUP BY payco_ccpay_id, payco_cohead_id
                         ORDER BY 1)
-      SELECT COALESCE(MAX(freq), 1) <= 1
+      SELECT (COALESCE(MAX(freq), 1) = 0 OR COALESCE(MAX(freq), 1) = 1)
       FROM counter;
     </query>
     <message>There are duplicate payco_ccpay_id and payco_cohead_id on the payco table. Please see your system administrator or contact xTuple.