Re: 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