Running PostgreSQL scripts in a non-sharded deployment

Edit online

Procedure

Run the following scripts in the <INSTALL_DIR>/database/postgresql/scripts directory:
  • CustomDBViews/transaction/ImportExport_View.sql
  • CustomDBViews/transaction/Interop_Views.sql
  • CustomDBViews/transaction/InvSnapshot_vw.sql
  • CustomDBViews/transaction/yfs_cross_reference_vw.sql
  • CustomDBViews/transaction/yfs_iba_ord_demand_vw.sql
  • CustomDBViews/transaction/yfs_iba_resv_demand_vw.sql
  • CustomDBViews/transaction/yfs_invtdmddtl_vw.sql
  • CustomDBViews/transaction/yfs_noPendMove_nodeInventoryDtl_vw.sql
  • CustomDBViews/transaction/yfs_onlyLPN_nodeInventoryDtl_vw.sql
  • CustomDBViews/transaction/yfs_onlyLPN_NoPendMove_nodeInventoryDtl_vw.sql
  • CustomDBViews/transaction/yfs_order_release_line.sql
  • CustomDBViews/transaction/yfs_order_release_line_vw.sql
  • CustomDBViews/transaction/yfs_nodeInventoryDtl_vw.sql
  • CustomDBViews/configuration/yfs_wave_item_vol_config_vw.sql
  • CustomDBViews/master/ycm_pricelist_vw.sql
  • CustomDBViews/master/ypm_category_item_vw.sql
  • CustomDBViews/master/ypm_item_vw.sql
Note: When you manually run the custom view scripts, ignore the wms_master_db_script.sql script.