sedat ciftci wrote: > 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.
Thanks. No problem. > > 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? If website is null, it means the aggregate is for the whole server. > > 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? Performance. Less joins. > > 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? Sorry. I did not look at this. > > Thanks, > Sedat > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com >
