All pastes #969208 Raw Edit

Miscellany

public sql v1 · immutable
·published 2008-04-03 14:40 UTC
rendered paste body
-- 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