mySQL coding assistance.

[herbal_lavender]

I am in need of assistance with this code. I'm attempting to

make a table for a community. It seems everything is ok when

I upload the .sql file except for this line.

create table bugs(bugid bigint primary key auto_increment,

memberid bigint references members, bugtext text, type

integer, bugdate DATE)

And this is what shows when I try to upload the file.

You have an error in your SQL syntax. Check the manual that

corresponds to your MySQL server version for the right syntax

to use near 'create table bugs(bugid bigint primary key

auto_increment, memb

Could someone help me.

Thanks.

Herbal_Lavender