[wp-hackers] Thoughts on Ultimate Tag Warrior

[Peter Westwood]

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

Doug Stewart wrote:
> 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.
> 

Yes and No. You remove the need for extra entries in the table just an
extra field.

>> 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

Varchar all the way - the same as the posts tables post_type (in 2.1 at
least) - if you go  down the enum route plugin's have to do table
upgrades to extend it and it gets broken by the db upgrade stuff on a
WordPress upgrade

westi
- --
Peter Westwood
http://blog.ftwr.co.uk
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE/egSVPRdzag0AcURAivwAKCxNKknAPjEBrPiqapOwQl0fnchSACeMRcI
Irxdh4nEqXsHErEcCB+Gc0c=
=eu8k
-----END PGP SIGNATURE-----