[drupal-devel] Folksonomy: No taxonomy.module Changes / URL Design

[Gerhard Killesreiter]

On Sun, 13 Mar 2005, Julian Bond wrote:

> Morbus Iff <morbus at disobey.com> Thu, 10 Mar 2005 14:06:06
> > * I've started a sandbox for this: sandbox/morbus/folksonomy_shared/
> > * Only one database change is needed: adding a uid to term_node.
> >   http://lists.drupal.org/archives/drupal-devel/2005-03/msg00422.html
>
> Are you sure you need uid on term_node? It's inevitably available with a
> join to node.

Morbus took some time to explain this to me. He wants users to be able
to tag any content that they might want to tag, or at least he wants
admins to be able to enable that functionality. That is, also nodes they
haven't authored. That's why he needs (tid, nid, uid) in term_node.

> There's a slight conceptual difference in that
> term_node.uid would be all the terms I've created

"all the terms I've tagged a node with". The terms I've created would
be term_data.uid.

> whereas term_node join node.uid is all the terms I've used.

... for nodes I've created myself.

Cheers,
	Gerhard