CodePlex
Open Source Community
Register | Sign In | CodePlex Home
Search
25
votes
closed
Add relations to Database

Description

Since not all column names are super-easy to understand, and since I hate building inner joins by hand I suggest that the DB is updated with relations such as foreign keys etc...

If the relations is added, selecting data will become a breeze as the SQL manager generates all INNER JOIN s based on the registered relations...

// Kalle

File Attachments

No files are attached

Closed Jun 14 2010 at 4:04 PM by

Comments

wrote Jun 14 2010 at 4:04 PM
Resolved with changeset 68510.

Hendy wrote Jan 10 2009 at 9:27 AM
I've just started looking into the structure of the db, and there seem to be fields where it appears that the the data is related, but there are no relationships specified. (I've been adding them as non-enforacable, as I find it helps to understand the db looking at diagrams)

bwakkie wrote Apr 1 2008 at 4:16 PM
http://forum.umbraco.org/9749 is a dead link

bwakkie wrote Apr 1 2008 at 4:15 PM
Unless the data is corrupted, which happened a few times on our side, you sometimes need to get in to fix it.

RubenV wrote Jan 17 2008 at 11:25 PM
I believe there's a need for a total restructuring of the database for version 4. As simple as that. Plus a real data layer (not SQL wrapper as it is now).

duckie wrote May 8 2007 at 10:32 PM
Moved from deleted structure v3 RC1 Release Candidate

duckie wrote Apr 12 2007 at 11:51 AM
thread about it herehttp://forum.umbraco.org/9749

hartvig wrote Mar 5 2007 at 11:28 AM
I agree, for best practice and performance!

However one must NEVER access the data outside the objects of umbraco. If you depend your solution directly on sql, an update to umbraco might break your installation!

Sign in to add a comment
Updating...
© 2006-2012 Microsoft | Get Help | Privacy Statement | Terms of Use | Code of Conduct | Advertise With Us | Version 2012.2.7.18398