AW: can't read SQL dump from MySQL

thanks for help,
I fixed this with:

CREATE TABLE Adresse (
pid_adresse INT8 DEFAULT NEXTVAL('seqAdresse') PRIMARY KEY,
id_person int4 DEFAULT '0' NOT NULL,
PLZ varchar(50),
id_ort int4 DEFAULT '0',
strasse varchar(50),
id_postcode int4,
hausnummer int4,
zusatz varchar(25),
postfach varchar(20),
leitcode varchar(18),
strassen_code char(3),
FZ char(3),
adresszusatz varchar(50)
);

Cheers,
Andreas

::-----Ursprngliche Nachricht-----
::Von: Patrick Welche [mailto:prlw1(at)newn(dot)cam(dot)ac(dot)uk]
::Gesendet: Montag, 11. September 2000 15:23
::An: Andreas Jerke
::Cc: Pgsql-General
::Betreff: Re: [GENERAL] can't read SQL dump from MySQL
::
::
::On Mon, Sep 11, 2000 at 12:38:54PM +0200, Andreas Jerke wrote:
::>
::> 1 CREATE TABLE Adresse (
::> 2 pid_adresse int(11) DEFAULT '0' NOT NULL auto_increment,
::> 3 id_person int(11) DEFAULT '0' NOT NULL,
::> 4 PLZ varchar(50),
::> 5 id_ort int(11) DEFAULT '0',
::> 6 strasse varchar(50),
::> 7 id_postcode int(11),
::> 8 hausnummer int(11),
::> 9 zusatz varchar(25),
::> 10 postfach varchar(20),
::> 11 leitcode varchar(18),
::> 12 strassen_code char(3),
::> 13 FZ char(3),
::> 14 adresszusatz varchar(50),
::> 15 PRIMARY KEY (pid_adresse),
::> 16 KEY id_person (id_person)
::> 17 );
::>
::> any suggestions ?
::
::I think the problem is int(11) - maybe this should be numeric
::rather than int?
::Or will integer on its own do?
::
::Not sure about the "KEY" bit at the end - maybe
::
::id_person INTEGER NOT NULL UNIQUE DEFAULT 0,
::
::is sufficient?
::
::Cheers,
::
::Patrick
::