how to organize MySQL for portfolio site.

[eluser]Iván Argulo[/eluser]
Hi generalsalt.

I'd do this:


CREATE TABLE `portfolio` (
`id_portfolio` bigint(20) unsigned NOT NULL auto_increment,
`title` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
`description` mediumtext character set latin1 collate latin1_general_ci NOT NULL,
`thumbnail` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id_portfolio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `portfolio_images` (
`id_image` bigint(20) unsigned NOT NULL auto_increment,
`id_portfolio` bigint(20) unsigned NOT NULL,
`image_path` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id_image`),
KEY `k_id_portfolio` (`id_portfolio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;