Re: Installing LedgerSMB into a schema?

[David Tangye <..hidden..>]

On Mon, 2006-11-06 at 14:26 -0800, Chris Travers wrote:
> Right now there seems to be some thought that moving LSMB into a
> separate schema makes sense.  I am all for this idea.  However, I am
> not sure it makes sense for multi-company setups to have companies as
> schemas in part because it would prevent us from securely breaking the
> reporting functionality into its own schema.
Agreed.
I guess one reasonable way to cater for multi-companies, given
everything else so far discussed, is to move them into the logical model
as a highest-order key. Ie several tables get company-id as part of the
primary key. It all depends on who is using this app.

I suppose we need to figure out pros and cons a bit like this.

It probably OK if :
 - If its a bookkeeper or accountant with several small clients.
 - Its any user creating play/test companies

Its probably not OK if:
 - Its an 'app provider' setting LSMB up on a single hosted server on
behalf of several clients who do their own bookkeeping.

I think the important thing to do is to figure out who LSMB is designed
for.