CREATE TABLE `comments` (
  `CommentID` int(11) NOT NULL auto_increment,
  `FlickrID` bigint(11) NOT NULL default '0',
  `PhotoID` int(11) NOT NULL,
  `UserName` varchar(100) NOT NULL,
  `UserEmail` varchar(200) NOT NULL,
  `UserURL` varchar(200) NOT NULL,
  `Comment` longtext NOT NULL,
  `DateCreated` datetime NOT NULL,
  `IP` varchar(15) NOT NULL,
  PRIMARY KEY  (`CommentID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;