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