Re: Users link to LBF

[Jason Pincin <jpincin@linuxkb.org>]

I agree with ya.  Limit it to the LBF.  

In that case, you'll need to add a Table or two to the LBF.

I can help if you'd like.  Or you can add em and I'll check em out to see
if we could do any further good things with em... anyway - here's what
you'll need:

You'll need a CompanyKBUserRef table... and in there you'll have two
columns only which combined will be your primary key, as well as an index
on each column.  One will be CompnayID and the other will be KBObjectID.  

That will track what users belong to what company eventually... We'll have
to figure out how you want to handle that in the long run since I don't
think ya wanna code the KB portion in Perl - since all the objects are in
PHP... and if I change the DB structure everything would be fine 'cpet the
LBF.

But, put that table in place and that should be all we need... we can work
out the rest.

Jason
 

On Wed, Aug 18, 1999 at 06:31:55AM -0700, Aaron Turner wrote:
> 
> On Wed, 18 Aug 1999, Jason Pincin wrote:
> 
> > > <warning Aaron is talking about DB's>
> > > I was thinking of adding a table to the LBF DB, which is basically a
> > > UserCompanyXref table which Xrefs the Users table in the linuxkb DB.
> > 
> > Problem 1:  
> > You cannot Xref across DB's.  No can do, no way around.
> 
> Bummer.
>  
> > Question 1: 
> > Do we want people to be able to give credit to non-linux
> > companies?  If so, that would change things a little since the LBF will
> > only containe Linux companies.  Just a question/thought - I don't really
> > care if we exclude non-linux companies from the credit - but I can also
> > see the benefits... so I'm 6 to one, half dozen the other.
> 
> I don't see any benefit to our users if they can find out how many
> articles employees of McDonald's or Macy's wrote.  I wouldn't care.  I
> say limit it to LBF companies.
> 
> > If you answer that Q, I'll tell you what I think would be the best
> > solution to accomplish what your asking.
> 
> Thanks.
> 
> --
> Aaron Turner, Core Developer       http://vodka.linuxkb.org/~aturner/
> Linux Knowledge Base Organization  http://linuxkb.org/
> Because world domination requires quality open documentation.