Rank: Enthusiast
Joined: 7/26/2006
Posts: 29
|
Hi,
Even though I'm danish, I'll just keep to english... juuust to be polite and follow "the style" ;)
I've been sitting and staring at the umbraco database and after some time I am still just one big question mark.
I'm looking for MemberGroups, but I'm able to only find cmsMember2MemberGroup, which is the table giving the relation between Members and MemberGroups. There are, however, no table called cmsMemberGroup, only cmsMember and cmsMemberType.
At this point I noticed something else... My table cmsMemberType is empty (!?). I do have 2 MemberTypes though. "Luck" was with me and I succeeded in finding those MemberTypes in the cmsContentType table.
Straaaaaange.... but I still have no luck finding MemberGroups :/
When it comes to Users, I see that there is a table for both Users and UserGroups, although members doesn't seem to follow the same convention ;)
The closest/warmest I got was the nodeId field in cmsMember2MemberGroup, but that's all.
Are member groups some magic entity or am I just blind? ;)
BTW.... Is there a specific reason why no relations have been created between the tables? ... and what about primary key definitions?
/Bo
|
Rank: Addict
Joined: 3/17/2008
Posts: 953
Location: Nyborg, Denmark
|
The Membergroup is stored in the umbracoNode table just like most of other node based types. The reason you don't see a membergroup table, is because a membergroup doesn't have any other properties than its name and the umbracoNode table therefore contains all the necessary information.
Regarding the key issue, there's definately a lot of improvements that could be done in the db design. But as the db only is used for storing and all logic is in the businesslogic of umbraco it's not the biggest issue, thus of low priority. But if anyone want's to improve the schema (not naming or structuring of tables) we'd be happy :)
Jeeeez, did I really start this :-)
|
Rank: Enthusiast
Joined: 7/26/2006
Posts: 29
|
Ooooookay... Found it... I do have another question though.
In the umbracoNode table, the nodeObjectType is a unique identifier, where MemberGroups have "{366E63B9-880F-4E13-A61C-98069B029728}". Is this a pre-defined id that will hold true even on a new installation? If not, where does this id come from?
javascript:insertTag(document.getElementById('AutoForm3_bodyText'), 'strong', '')
A little Perspective:
javascript:insertTag(document.getElementById('AutoForm3_bodyText'), 'strong', '')
My task in the end is essentially that I'm developing some controls for use on a website. The controls takes its data from an IStorage, which in my case is an implementation in the form of a MemberStorage, which in the case of our Support Website happens to be using Umbraco as the framework... a back-end for the whole Member, MemberGroup, and MemberType data-structure and of course for controlling the general content of the website. Thus I need to be sure of the whole structure of this storage.
This way we're able to create a complete Files section, Advanced Discussion Forum, and many other modules in form of user controls that has the exact same member-details as the website and therefore 100% integrated.
The development of the forum has still not started, so if anyone know of a good, free, and full-featured forum, which is able to 100% integrate with umbraco and the members and templates via eg. User Controls, then I would really really like to hear from you :D
NB: This forum could use a preview function or wysiwyg (when inserting eg. bold or italics). An edit function would be appreciated too I think ;)
|
Rank: Enthusiast
Joined: 7/26/2006
Posts: 29
|
I knew it.... I'm too incompetent to even use the bold-function in this forum ;)
javascript:insertTag(document.getElementById('AutoForm3_bodyText'), 'strong', 'Test')
Hmmm.... I guess you all know what I meant in the previous post ;)
|