// Copyright (c) 2004 Kurt M. Brown.
// This file is subject to the terms and conditions of the GNU General Public
// License. See the file COPYING for more details.

Do setup a foreign key to site table for "siteId" columns. This then
requires the SI to have a at least copy of each site table or a
smaller "siteBasic" table..

customer (add code to move customer to new site if not "all" for sharing)
    customerId pk -- must be unique per schema and orginates at
                  -- origin site: <siteId><zero padded seq of 6 or more>
                  -- 1555777 222333444 have setup rule for max customer digits 
                  -- max = 6, siteId = 4567, 4567000001 (first customerId)
    siteOwnerId (could be null if "all")
    siteCreaterId

customerHistory
    customerId
    siteId, (orderId, tranId, ...)
    // summary

siteCustomerShare (rule to allow for "all" (within same conceptId))
    siteId
    shareId (a siteId)


customerId
    siteId should be 1 - 5000 < 10k
        (if a chain > 10k sites, then is does not want this software)
    <per site id><zero padded site id>
        10012
        20012
    534320012
     19974321
       780321