Re: [sqlite] Table with 2 primary keys... what's the problem?

At 11:37 PM +0100 5/12/07, Paulo J. Matos wrote: Moreover, active in table product is a boolean but I'm using an int since I don't know if there's a boolean type, is there? SQLite has just these types: Int, Real, Text, Blob, Null. SQLite does not have a boolean data type, though I think it

[sqlite] Table with 2 primary keys... what's the problem?

Hello, I have something like this: Table Product asin : text PK active : integer title : text Table Info -- id : int PK AUTOINC price : int date : date Now, since each product can have 1 .. n infos, I have yet this table: Table ProductInfo -