bzcoder
By: a guest | Feb 6th, 2010 | Syntax:
SQL | Size: 0.44 KB | Hits: 104 | Expires: Never
CREATE TABLE IF NOT EXISTS `sites` (
`site_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`url` varchar(500) NOT NULL,
`pubDate` varchar(50) NOT NULL,
`title` varchar(255) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`viewed` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
Remove TRAILING slashes AND the unmatched } at the end