1. Multi Warehouse Configuration
 
By default system is configured to support single warehouse only. To add more follow below steps

 

  • Follow \Data\ and open CommonServer.cfg
  • Search IsMultiWareHouse and set it to 1
  • Search MultiWareHouseCount and set desired count of additional warehouses (max 255)
  • Open SQL Management Studio Open New Query Window and paste into it the below script
  • Configure it by adding expected count of warehouses and execute over your MuOnline database by pressing F5

 

USE [MuOnline]
GO

-- Script adds additional columns to warehouse table
-- Edit to add more or less warehouses (depending of MultiWareHouseCount setting)
-- To add more simply add extra 'ItemsX varbinary(7680) NULL' at the end of the script (before GO statement)


ALTER TABLE [dbo].[warehouse]

ADD
Items2 varbinary(7680) NULL, -- /ware1
Items3 varbinary(7680) NULL, -- /ware2
Items4 varbinary(7680) NULL, -- /ware3
Items5 varbinary(7680) NULL, -- /ware4
Items6 varbinary(7680) NULL, -- /ware5
Items7 varbinary(7680) NULL, -- /ware6
Items8 varbinary(7680) NULL, -- /ware7
Items9 varbinary(7680) NULL, -- /ware8
Items10 varbinary(7680) NULL, -- /ware9
Items11 varbinary(7680) NULL, -- /ware10
Items12 varbinary(7680) NULL, -- /ware11
Items13 varbinary(7680) NULL, -- /ware12
Items14 varbinary(7680) NULL, -- /ware13
Items15 varbinary(7680) NULL, -- /ware14
Items16 varbinary(7680) NULL, -- /ware15
Items17 varbinary(7680) NULL, -- /ware16
Items18 varbinary(7680) NULL, -- /ware17
Items19 varbinary(7680) NULL, -- /ware18
Items20 varbinary(7680) NULL -- /ware19
GO