I have a table which needs to store "points" for 8 groups. It gets a new entry weekly, but the points are updated many times daily. There may be more groups added in the future, but I would know about it first, and have the change to add a new column to the table. This is how it currently looks:
CREATE TABLE `weeklyPoints` (
`weekID` int(10) unsigned NOT NULL auto_increment,
`start` int(11) NOT NULL default '0',
`end` int(11) NOT NULL default '0',
`winner` int(11) NOT NULL default '0',
`genre_1` int(11) NOT NULL default '0',
`genre_2` int(11) NOT NULL default '0',
`genre_3` int(11) NOT NULL default '0',
`genre_4` int(11) NOT NULL default '0',
`genre_5` int(11) NOT NULL default '0',
`genre_6` int(11) NOT NULL default '0',
`genre_7` int(11) NOT NULL default '0',
`genre_8` int(11) NOT NULL default '0',
PRIMARY KEY (`weekID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
I was trying to decide between that, or adding yet another table to store just genreID and points, so that when I add a new genre I don't have to update the table. Not sure if it's reasonable, or worth it.
Thoughts?