Re: [sqlite] AUTOINCREMENT of a not PRIMARY KEY

[Serge Ratke]

On Sat, 29 Jan 2005 09:56:03 -0800, Will Leshner <[EMAIL PROTECTED]>  
wrote:

On Sat, 29 Jan 2005 12:07:31 +0100, Serge Ratke  
<[EMAIL PROTECTED]> wrote:
[...]
Couldn't you make 'id' the primary key and then create a UNIQUE index
for parent_id,name? I think, basically, PRIMARY KEY(parent_id, name)
is just creating such an index anyway.
  Thank you for your suggestion/solution. Exactly what i was searching for  
:)

--
Serge Ratke