[Zope] SQL

[Markus Hochreiter]

Hi,
How I can create a table with a primary key? I have tried the following:

CREATE TABLE adressbook
(nr INTEGER PRIMARY KEY,
vorname VARCHAR(30)
)

what's wrong?
I get always a error message:

Error, exceptions.SyntaxError: unexpected token sequence.near :: 'ook\012(nr
INTEGER'*' PRIMARY KEY,\012v' ******************************* current state
= 163 expects: ',', ')', ('nomatch1',) current token = ((-8,
'user_defined_name'), 'PRIMARY')


thanks for your help!

mex