Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DNN "Best or Recommended Practices"DNN "Best or Recommended Practices"
Previous
 
Next
New Post
12/11/2007 1:48 PM
 

Our site will have several databases besides the DNN master db.  I've spent considerable time reviewing the DNN core db's schema and would appreciate opinions on the likes of the following:

1) should we leave the DNN master for only core DNN tables and data and for add-on modules that have been "approved"?  In other words, is there a generally accepted rule that says "Don't Mess with the Core Database?"

2) asked another way:  if we wish to capture more data than the core db does, should we keep our extra fields in separate tables?  Even in separate databases?  For example, we want to expand UserProfiles (which are Property/PropertyValue-driven).  Is it ok and common practice to add our own properties and values?  Or, should we not "touch" the DNN tables?   If we shouldn't touch the DNN tables, is it still ok to add our supplemental tables to the DNN core db?  Or, should they live in a totally separate db properly linked (e.g. UserId, UserName, additional data, etc.)

3)  We're also thinking of customizing the "Roles".  If we add new roles in the core db, will checkboxes automatically show up on the many DNN and Module forms for any new roles we add?   If not, how difficult and how risky is it to modify those pages?   (We can accomplish what we're thinking of outside the DNN db if necessary).

 

 
New Post
12/11/2007 2:07 PM
 

modules usually place their data in own tables inside the DotNetNuke database, but it is a NO GO to extend core tables by added fields, constraints or references, as this might affect future upgrades. Besides there are tables - or better business objects - that are provided to be extensible by the core, like User Profiles, Roles (add specific roles), lists permissions and settings.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
12/12/2007 11:26 AM
 

Thank you, Sebastian ...  here's what I understand from your reply:

1)  Do NOT touch the schema of any core tables

2)  It's OK to for us to add our own tables, pages, etc. as long as we're extremely careful and don't touch the DNN "core"

3) Many of the DNN features/parameters/options/definitions are designed in such a way that we can easily extend/expand them without messing with the database 

 
New Post
12/12/2007 2:41 PM
 

Yes, you are correct.  As sebastian mentioned it is VERY IMPORTANT to not mess with the Core DNN tables, nor the structure of any core modules tables as you can and most likely will break the upgrade process.  Adding extra tables is no problem at all, I would be cautious with foreign key constraints to core tables as well as you can have "issues" that arise during upgrades as well.


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...DNN "Best or Recommended Practices"DNN "Best or Recommended Practices"


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out