[development] One-to-one tables considered harmful

[Earl Miles]

Mark Fredrickson wrote:
> Flame war aside, I think there are some good points in this thread.
> Perhaps someone can clarify two points:
> 
> 1. Is it kosher to add columns to other modules' tables? E.g. Is it ok
> for comment to add it's statistics to the node table. Similarly, I
> could imagine the stats module would want to add summary information,
> and perhaps other modules as well.

At one point we had a 'field' op to nodeapi that let modules add fields to the 
node table. I would like to see this restored. Then we could justify never ever 
having a 1::1 relationship table for 'node'. This was taken out when the 
node_revisions table was added.

Which leads me to another question: Should the 'current' node_revision be 
reflected in the node table, to eliminate that join if we need to sort/query on 
something in that table?