[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] AUTOINCREMENT of a not PRIMARY KEY
From:       "Serge Ratke" <info.serge.ratke () gmx ! de>
Date:       2005-01-30 21:36:11
Message-ID: opslfqalawodzb8f () localhost
[Download RAW message or body]

On Sat, 29 Jan 2005 09:56:03 -0800, Will Leshner <will.leshner@gmail.com>  
wrote:

> On Sat, 29 Jan 2005 12:07:31 +0100, Serge Ratke  
> <info.serge.ratke@gmx.de> 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
[prev in list] [next in list] [prev in thread] [next in thread]