[sqlite] primary, secondary keys

[Mark Wyszomierski]

Hi all,
 Does sqlite allow multiple keys? When I created a table I did:
  CREATE TABLE test (name, address, fav_color, primary key(name, address))
 Is that valid? I would like to not have any duplicate name + address
entries. There
was no error reported but later I tried modifying the table in SQLite
Database Browser
and it complained that the table has multiple primary fields.
 Thanks,
Mark