-- Table structure for table `blog_post`
-- 
CREATE TABLE `blog_post` (
`id` int( 10 ) NOT NULL AUTO_INCREMENT ,
`url-title` varchar( 250 ) NOT NULL ,
`title` varchar( 250 ) NOT NULL ,
`date` timestamp NOT NULL default '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP ,
`content` longtext NOT NULL ,
`user_id` int( 10 ) NOT NULL ,
`comments` int( 10 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `user_id` ( `user_id` ) ,
KEY `comments` ( `comments` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =34;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax near 'on update CURRENT_TIMESTAMP,
  `content` longtext NOT NULL,
  `user_id` int(10) ' at line 8