drizzle-discuss team mailing list archive
Mailing list archive
Re: tables must have a primary key
On Wed, 7 Apr 2010 15:56:54 +0200, Arjen Lentz <arjen@xxxxxxxxxxxxx> wrote:
> Please make a clear distinction in your head between PK and auto-inc.
> We're here agreeing that all tables should have a PK.
> They may or may not have an auto-inc field; some may just have an id
> which is a fk from another table's auto-inc, or a composite of
> multiple tables.
yep. My brain skipped a step in the thinking along the lines of a table
where someone just adds a auto_inc pkey to stop the database complaining