CREATE TABLE IF NOT EXISTS `comment` (
    `cid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
    `sid` smallint(5) unsigned NOT NULL,
    `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `message` varchar(255) NOT NULL,
    `parent` smallint(5) unsigned DEFAULT NULL,
    `children` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `author_name` varchar(40) NOT NULL,
    `author_email` varchar(255) NOT NULL,
    PRIMARY KEY (`cid`),
    KEY `parent` (`parent`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
--
-- Constraints for dumped tables
--
-- Constraints for table `comment`
--
ALTER TABLE `comment`
    ADD CONSTRAINT `comment_ibfk_2` FOREIGN KEY (`parent`) REFERENCES `comment` (`cid`);