-<package id = "xtmfg442"
- version = "4.4.2"
+<package id = "manufacturing-upgrade-470beta2"
+ version = "4.7.0Beta2"
developer = "xTuple"
descrip = "load PostBooks resources"
updater = "2.2.4" >
<prerequisite type = "query"
name = "Checking xTuple Edition" >
<query>SELECT fetchMetricText('Application') = 'Standard';</query>
- <message>This package must be applied to a Distribution Edition database.</message>
+ <message>This package must be applied to a Manufacturing Edition database.</message>
</prerequisite>
<prerequisite type="query"
<message>This package must be applied to an xTuple ERP database that already contains the xtmfg package.</message>
</prerequisite>
+ <prerequisite type="query" name="Checking xtmfg Package Version">
+ <query>SELECT TRUE FROM pkghead WHERE pkghead_name = 'xtmfg' AND (pkghead_version >= '4.4');</query>
+ <message>This package must be applied against the 4.4+ version of the xtmfg package.</message>
+ </prerequisite>
+
<prerequisite type = "query"
- name = "Checking xTuple ERP database version" >
- <query>SELECT fetchMetricText('ServerVersion') ~ '^4.4.';</query>
- <message>This package must be applied to a 4.4+ Manufacturing database.
+ 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+ database.
+ </message>
+ </prerequisite>
+
+<prerequisite type = "query"
+ name = "Checking for too-new xTuple ERP database version" >
+<query>SELECT NOT fetchMetricText('ServerVersion') >= '4.7.0';</query>
+ <message>This package may not be applied to a database newer than 4.7.0Beta2.
+ </message>
+</prerequisite>
+
+
+ <prerequisite type = "query"
+ name = "Checking for mobile-enabled schemas" >
+ <query>SELECT NOT EXISTS(SELECT 1 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" />
</package>