installed and deployed the mysql standard 5.0.15 server for MacOS X 10.4 Tiger powerpc on my PowerMac G4 MDD.

I'm trying to create a database on the server that my TA created for a class (BioIT Genome and Proteome analysis), but for some reason, mysql is complaining that there are syntax errors near 2 parenthesis in the database code. Specifically in the creation of the table 'Chain.' I can't seem to find the errors. It is an extremely simple and small database:

Code:
drop database hw6;

create database hw6;

use hw6;


create table Chain
(
    chain_id  integer        NOT NULL PRIMARY KEY AUTO_INCREMENT,
    pdb_chain varchar(5) BINARY NOT NULL,
    chainLen  smallint   UNSIGNED,
    seqPDB    text,
    INDEX chain_idx(chain_id),
    UNIQUE INDEX chian_pdb_idx(pdb_chain)
);


create table BLAST_ali
(
    ali_id           integer NOT NULL PRIMARY KEY AUTO_INCREMENT,
    chain_id         integer NOT NULL,
    date             datetime,
    identity         float,
    alignment_length smallint UNSIGNED,
    mismatches       smallint UNSIGNED,
    gap_openings     smallint UNSIGNED,
    q_start          smallint,
    q_end            smallint,
    s_start          smallint,
    s_end            smallint,
    e_value          float,
    bit_score        float,
    FOREIGN KEY (chain_id) references Chain(chain_id) ON DELETE CASCADE,
    INDEX chain_idx(chain_id),
);


create table FASTA_ali
(
    ali_id           integer NOT NULL PRIMARY KEY AUTO_INCREMENT,
    chain_id         integer NOT NULL,
    date             datetime,
    Length           smallint,
    Identity         float,
    Ungapped         float,
    Overlap          smallint,
    E                float,
    FOREIGN KEY (chain_id) references Chain(chain_id) ON DELETE CASCADE,
    INDEX chain_idx(chain_id),
);

**I made some changes: Specifically, I changed my TA's use of 'int' to 'integer'.

My TA created the database in class and deployed it on our Suse Linux x86 IA-32 cluster. The mysql version running on the cluster is 4.0.12.

Can anyone running a mysql 5.0.15 server test this out?