[wp-hackers] Thoughts on Ultimate Tag Warrior

[Doug Stewart]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Peter Westwood wrote:
> On Tue, September 5, 2006 2:22 pm, Doug Stewart wrote:
>> Mike Purvis wrote:
>>> I don't actually use UTW, but I got annoyed that Typo had both
>>> categories and tags built into the core, when it seemed like a lot of
>>> duplication of functionality. Can't you do an awfully good facsimile
>>> of tags by simply having two top-level categories for "Category
>>> Parent" and "Tag Parent", and then working from there?
>>>
>> Implementation-wise, that's actually a pretty dang good idea IMNSHO.
>>
> 
> It sounds a bit clunky to me as it means we need to force a db upgrade of
> everyones categories on update to reparent them under this hidden root.
> 

No different than what you propose below via a column addition to the
wp_cats table.

> Can we not extend the schema for the wp_cats table to have a cat_type
> field which could be set to category|tag|keyword|something else to allow
> for multiple types of information to be stored in the one table much in
> the same way we support posts|pages
> 

Would you store this as a VARCHAR or as an ENUM?  The advantage of
Mike's suggestion is that, in order to add further category/tag/etc.
types, all one need do is add a parent node and then make all
cats/tags/etc. that they add from then on children of that node.  Plugin
auths could then automatically take advantage of this capability simply
by specifying a category as a root node and working their namespaces off
of said node.




- --
- ----------
Doug Stewart
Senior Systems Administrator/Web Applications Developer
Lockheed Martin Advanced Technology Labs
dstewart at atl.lmco.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE/ZAAN50Q8DVvcvkRAlc5AJ0crA0JL+wU86Dgk/a86rZDBj49qwCfaZC+
T6hexEAcxaRx3IIbZPLzx3k=
=0eUV
-----END PGP SIGNATURE-----