Hello, First of all, congratulations for roller 3.1 release. I want to ask some questions about roller (ver 3.1) database. Note that, I do not look at the codes. I only look at the db design.
1. roller_weblogentrytagagg table, for each tag name, there are two records one of which has website id as null and the other one is id of one of website id. is one of these records redundant or not? 2. roller_weblogentrytag table contains websiteid,userid and time fields. Can't we reach these values by looking at the corresponding weblogentry record (by using entryid field)? Is the reason for the existence of these fields performance? or are they redundant? 3. a new table (let me call it) roles that contains role id and role name can be inserted and in userrole table, instead of rolename field, a roleid field can be used (as a foreign key). Or, again is it implemented in that way for performance reasons? Thanks, Sedat __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
