Symlinking MySQL Fields?
I run a PostNuke site, and we have a phpBB plugin to do forums. The problem is that each wants its own tables, and there's some overlap of information. (Most of it integrates in PostNuke properly, but things like user signatures and avatars don't.)
What I'd like to be able to do is 'symlink' the old fields to the new ones -- in other words, if you changed your avatar in the forums, it'd change in the PostNuke ones too, and vice versa. A one-time copy of the data isn't too hard (just select it and insert it into the other one), but what about later on when someone changes it? I want them 'symlinked'?
Is there some magic MySQL function that I'm unaware of that would actaully work? (And, assuming not, do other databases support something like this? I'm not going to install Oracle on a 300 MHz box just because it'd make my life slightly easier, but I'm wondering if this feature exists anywhere or not.)
Thanks for putting up with my SQL illiteracy.
