New keys for post2cat

[Xmion]

Have you guys seen this, is this something that can improve somewere on wordpress as it does on Lyceum look over at this url, damn hot for lyceum anyway. ​http://source.ibiblio.org/trac/lyceum/changeset/1012

[ryan]

Looks like we need to change dbDelta to handle the upgrade.

WordPress database error: [Duplicate key name 'link_id']
ALTER TABLE wp_link2cat ADD UNIQUE link_id (link_id,category_id)


WordPress database error: [Duplicate key name 'post_id']
ALTER TABLE wp_post2cat ADD UNIQUE post_id (post_id,category_id)

[rob1n]

Unless I'm misunderstanding something, wouldn't that force post_id or category_id to be unique? What if a post has more than one category assigned to it, and thus more than one entry in post2cat with the same post_id's?

I'm not great with SQL, so there's probably something I'm missing...

[ryan]

The pair has to be unique, so a post can't have the same category more than once in the post2cat table, which would be pointless anyway.

[rob1n]

Ah. +1 then. Anybody interested in benchmarking the differences?

[rob1n]

Working on dbDelta stuff.

[ryan]

post2cat is gone in 2.3.