Re: Denormalization to allow use UNQIUE index?

[Victor Porton]

Here are example table creating statements:

CREATE TABLE `Post` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`body` TEXT NOT NULL,
`issue_id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`)
);

CREATE TABLE `Comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`body` text COLLATE utf8_bin NOT NULL,
`comment_id` int(10) unsigned NOT NULL,
`Comment` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_Comment_1_idx` (`Comment`),
CONSTRAINT `fk_Comment_1` FOREIGN KEY (`Comment`) REFERENCES `Comment` (`id`)
);

--
http://freesoft.portonvictor.org