1 <package id = "manufacturing-upgrade-450"
4 descrip = "load PostBooks resources"
7 <prerequisite type = "query"
8 name = "Checking xTuple Edition" >
9 <query>SELECT fetchMetricText('Application') = 'Standard';</query>
10 <message>This package must be applied to a Manufacturing Edition database.</message>
13 <prerequisite type="query"
14 name ="Checking xtmfg package" >
15 <query>SELECT TRUE FROM pkghead WHERE pkghead_name = 'xtmfg';</query>
16 <message>This package must be applied to an xTuple ERP database that already contains the xtmfg package.</message>
19 <prerequisite type = "query"
20 name = "Checking xTuple ERP database version" >
21 <query>SELECT fetchMetricText('ServerVersion') > '4.4.';</query>
22 <message>This package must be applied to a 4.4+ Manufacturing database.
26 <prerequisite type = "query"
27 name = "Checking for bad xTuple ERP database version" >
28 <query>SELECT NOT fetchMetricText('ServerVersion') > '4.5.0' AND fetchMetricText('ServerVersion')!='4.5.0Beta' AND fetchMetricText('ServerVersion')!='4.5.0RC';</query>
29 <message>This package may not be applied to a 4.5+ Manufacturing database.
34 <prerequisite type = "query"
35 name = "Checking for mobile-enabled schemas" >
36 <query>SELECT NOT EXISTS(SELECT 1 FROM pg_namespace WHERE nspname = 'xm');</query>
37 <message>This package may not be applied to a mobile-enabled database. Please see your system administrator or contact xTuple.
41 <script file="postbooks_upgrade.sql" />
42 <script file="inventory_upgrade.sql" />
43 <script file="manufacturing_upgrade.sql" />