I want to make an association type "a message can have zero or more comment" but I have no idea how to do it. I managed to lay it after my research but I am not sure that it do what I want:
Code:
CREATE TABLE `messageboard` {
`id_messageboard` int UNSIGNED NOT NULL AUTO_INCREMENT,
`ip` varchar(15) NOT NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`pseudo` varchar(20) NOT NULL,
`mess` text NOT NULL,
PRIMARY KEY (`id_messageboard`)
} ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `comments` {
`id_comments` int UNSIGNED NOT NULL AUTO_INCREMENT,
`id_messageboard` int UNSIGNED NOT NULL,
`ip` varchar(15) NOT NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`pseudo` varchar(20) NOT NULL,
`message` text NOT NULL,
PRIMARY KEY (`id_comments`),
FOREIGN KEY (`id_messageboard`) REFERENCES `messageboard` (`id_messageboard`) ON DELETE NO ACTION ON UPDATE NO ACTION
} ENGINE=InnoDB DEFAULT CHARSET=utf8;
So now, I am or not?
Bookmarks