check to see if xm schema exists, if so, disallow upgrade

diff --git a/scripts/xml/distribution_install.xml b/scripts/xml/distribution_install.xml
index 6eaa26f..34127bc 100644 (file)
--- a/scripts/xml/distribution_install.xml
+++ b/scripts/xml/distribution_install.xml
@@ -18,12 +18,19 @@
   </prerequisite>
 
  <prerequisite type = "query"
-                name = "Checking for bad xTuple ERP database version" >
+               name = "Checking for bad xTuple ERP database version" >
     <query>SELECT fetchMetricText('ServerVersion') &lt; '4.5.0';</query>
     <message>This package may not be applied to a 4.5+ Distribution database.
     </message>
   </prerequisite>
 
+ <prerequisite type = "query"
+               name = "Checking for mobile-enabled schemas" >
+    <query>SELECT TRUE FROM pg_namespace WHERE nspname = 'xm';</query>
+    <message>This package may not be applied to a mobile-enabled database. Please see your system administrator or contact xTuple.
+    </message>
+  </prerequisite>
+
   <script file="postbooks_upgrade.sql" />
   <script file="inventory_basic_install.sql" />
   <script file="inventory_upgrade.sql" />

diff --git a/scripts/xml/distribution_package.xml b/scripts/xml/distribution_package.xml
index 856bca8..88c6a99 100644 (file)
--- a/scripts/xml/distribution_package.xml
+++ b/scripts/xml/distribution_package.xml
@@ -18,12 +18,19 @@
   </prerequisite>
 
  <prerequisite type = "query"
-                name = "Checking for bad xTuple ERP database version" >
+               name = "Checking for bad xTuple ERP database version" >
     <query>SELECT fetchMetricText('ServerVersion') &lt; '4.5.0';</query>
     <message>This package may not be applied to a 4.5+ Distribution database.
     </message>
   </prerequisite>
 
+ <prerequisite type = "query"
+               name = "Checking for mobile-enabled schemas" >
+    <query>SELECT TRUE FROM pg_namespace WHERE nspname = 'xm';</query>
+    <message>This package may not be applied to a mobile-enabled database. Please see your system administrator or contact xTuple.
+    </message>
+  </prerequisite>
+
   <script file="postbooks_upgrade.sql" />
   <script file="inventory_upgrade.sql" />
   <script file="distribution_upgrade.sql" />

diff --git a/scripts/xml/postbooks_package.xml b/scripts/xml/postbooks_package.xml
index 080c8ef..5f93bc2 100644 (file)
--- a/scripts/xml/postbooks_package.xml
+++ b/scripts/xml/postbooks_package.xml
@@ -18,12 +18,19 @@
   </prerequisite>
 
  <prerequisite type = "query"
-                name = "Checking for bad xTuple ERP database version" >
+               name = "Checking for bad xTuple ERP database version" >
     <query>SELECT fetchMetricText('ServerVersion') &lt; '4.5.0';</query>
     <message>This package may not be applied to a 4.5+ Postbooks database.
     </message>
   </prerequisite>
 
+ <prerequisite type = "query"
+               name = "Checking for mobile-enabled schemas" >
+    <query>SELECT TRUE FROM pg_namespace WHERE nspname = 'xm';</query>
+    <message>This package may not be applied to a mobile-enabled database. Please see your system administrator or contact xTuple.
+    </message>
+  </prerequisite>
+
   <script file="postbooks_upgrade.sql" />
 
 </package>

diff --git a/scripts/xml/xtmfg_install.xml b/scripts/xml/xtmfg_install.xml
index 6c44928..fb36d4a 100644 (file)
--- a/scripts/xml/xtmfg_install.xml
+++ b/scripts/xml/xtmfg_install.xml
@@ -18,12 +18,19 @@
   </prerequisite>
 
  <prerequisite type = "query"
-                name = "Checking for bad xTuple ERP database version" >
+               name = "Checking for bad xTuple ERP database version" >
     <query>SELECT fetchMetricText('ServerVersion')='4.5.0Beta';</query>
     <message>This package may not be applied to a 4.5.0Beta Distribution database.
     </message>
   </prerequisite>
 
+ <prerequisite type = "query"
+               name = "Checking for mobile-enabled schemas" >
+    <query>SELECT TRUE FROM pg_namespace WHERE nspname = 'xm';</query>
+    <message>This package may not be applied to a mobile-enabled database. Please see your system administrator or contact xTuple.
+    </message>
+  </prerequisite>
+
   <script file="postbooks_upgrade.sql" />
   <script file="inventory_basic_install.sql" />
   <script file="inventory_upgrade.sql" />

diff --git a/scripts/xml/xtmfg_package.xml b/scripts/xml/xtmfg_package.xml
index c52d8fb..3078ba1 100644 (file)
--- a/scripts/xml/xtmfg_package.xml
+++ b/scripts/xml/xtmfg_package.xml
@@ -30,6 +30,13 @@
     </message>
   </prerequisite>
 
+ <prerequisite type = "query"
+               name = "Checking for mobile-enabled schemas" >
+    <query>SELECT TRUE FROM pg_namespace WHERE nspname = 'xm';</query>
+    <message>This package may not be applied to a mobile-enabled database. Please see your system administrator or contact xTuple.
+    </message>
+  </prerequisite>
+
   <script file="postbooks_upgrade.sql" />
   <script file="inventory_upgrade.sql" />
   <script file="manufacturing_upgrade.sql" />