[haiku-web] Re: Trac (reevaluated)

On 2006-06-09 at 15:14:38 [+0200], Charlie Clark <charlie@xxxxxxxxxxxxxx> 
wrote:
> 
> On 2006-06-09 at 11:58:31 [+0200], "Mikael Jansson (mailing lists)"
> <lists@xxxxxxxxxxxxxxxxx> wrote:
> > The general idea though, what do you think?
> 
> Do you need an answer on this? Relational Trac implements the same kind of
> logic for users so doing it with components is not difficult and allows
> reconfiguration when required. Let the database do the work.

Mikael,

didn't I give you my sources at BeGeistert? Anyway you've got access to the 
server now.

My model already has a components relation just needs a 
component_parent relation

CREATE TABLE component_parent
(component text,
parent text,
UNIQUE (component, parent)
#should also have
FOREIGN KEY (component) REFERENCES component(name),
FOREIGN KEY (parent) REFERENCE component(name),
CHECK component != name)

Charlie
-----------------------------------------------------------------------
haiku-web@xxxxxxxxxxxxx - Haiku Web & Developer Support Discussion List

Other related posts: