Database create.

[bigal]

I am trying to create a dateabase table in my invision forum database, here is the command i am using:



CREATE table ibf_flash (
flashid bigint(20) NOT NULL auto_increment,
filename VARCHAR( 50 ) NOT NULL default '',
type VARCHAR( 50 ) NOT NULL default '',
date date NOT NULL default 'dd-mm-yyyy',
url VARCHAR( 128 ) NOT NULL default '',
views bigint(10) NOT NULL default '0'
PRIMARY KEY (flashid)

)




can anyone tell me where i am screwing up, as MySql sais i have a syntax error, i have even tried using PhpMyAdmin to manually add the data but it just wont work. This would be cool if anyone could help me. :)

thanks!

[bigal]

Is this a sort of "Outdated" way of doing syntax's
This is proberbly really simple!

[jyazell]

What was the syntax error and where did it occur?

[bigal]

Thanks for your help, but i have now got this sorted, it was a known problem! I dont know where the error was! :(
Again, thanks for all your help! ;)