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.