Hey sorry, time to revive this thread as i'm needing this database design.
Instead of the one above i'm going for a more simpler approach to begin with (i have reasons)
Anyway, the simplified version will post news only, here it is;
Code:
CREATE TABLE `sjcms_users` (
`user_id` int(10) NOT NULL default '0',
`email` varchar(100) NOT NULL default '',
`password` varchar(60) NOT NULL default '',
`first_name` varchar(30) NOT NULL default '',
`last_name` varchar(30) NOT NULL default '',
PRIMARY KEY (`uid`),
UNIQUE KEY `email` (`email`)
) TYPE=MyISAM;
CREATE TABLE `sjcms_access` (
`access_id` int(10) NOT NULL default '0',
`usergroupID` int(11) NOT NULL default '0',
`access_type` int(3) NOT NULL default '0',
PRIMARY KEY (`aid`)
) TYPE=MyISAM;
CREATE TABLE `sjcms_news` (
`news_id` int(10) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(50) NOT NULL default '',
`content`
`user_id`
) TYPE=MyISAM;
I can't decide of what data type to go with for content. This is for general news remember, not masses of data. What's the best one to go for which is quickest to retrieve from the db?
Cheers