create table problem

[Spiffware]

echo '<div align="center">Installing Table</div>'; vbflush();
$db->hide_errors();
$db->query_write("
CREATE TABLE " .TABLE_PREFIX. "spnews
(
spdate date NOT NULL default
'',
sptype varchar(32) NOT NULL default
'',
spmain varchar(10000) NOT NULL default
'',
PRIMARY KEY (spdate)
)
");
$db->show_errors();

is what i got whats the problem or what am i missing?

[Spiffware]

can some one help me im in need.