On Sun, 2005-11-06 at 23:01 +0100, [EMAIL PROTECTED] wrote: [kc wrote] > btw, found a lot of unique index based on (physmessage_id, id). Since id > is primary, it already ensured uniqueness.
Like this: UNIQUE(id, physmessage_id)? That would make sense in the case that either id or physmessage_id is not UNIQUE. physmessage_id is a foreign key into the physmessage table, and id is the unique id of the current table. Right? Yeah, sounds useless. Aaron