Is there a diagram anywhere for the Umbraco 4 database schema? I'm interested to know how all the tables relate to each other. I know I can add them into a diagram via SQL Management Studio, but not all the Umbraco tables have primary/foreign key relationships. I did a Google search and came across this http://www.wabwereld.nl/db/umbracodb.pdf But it's dated Sept 2007 which I believe would be for Umbraco v3. Are there many schema diferences between v3 and v4?
Thought I'd update the schema diagram - this one has additional secondary keys added to the nodeId fields of the cmsContentType, cmsTemplate and cmsDataType tables; this allows additional relationships to be defined. All the relationships have been added as non-enforcing check constraints, so shouldn't cause any impact, although the addtional keys obviously require the nodeIds in the tables mentioned above to be unique. Will post SQL...
Umbraco Database Scheme Diagram
Is there a diagram anywhere for the Umbraco 4 database schema? I'm interested to know how all the tables relate to each other. I know I can add them into a diagram via SQL Management Studio, but not all the Umbraco tables have primary/foreign key relationships. I did a Google search and came across this http://www.wabwereld.nl/db/umbracodb.pdf But it's dated Sept 2007 which I believe would be for Umbraco v3. Are there many schema diferences between v3 and v4?
Not sure this is what you are after, but Hendy has a post about the umbraco database with a database diagram.
Hi,
Thought I'd update the schema diagram - this one has additional secondary keys added to the nodeId fields of the cmsContentType, cmsTemplate and cmsDataType tables; this allows additional relationships to be defined. All the relationships have been added as non-enforcing check constraints, so shouldn't cause any impact, although the addtional keys obviously require the nodeIds in the tables mentioned above to be unique. Will post SQL...
Hope this is useful,
Hendy
is working on a reply...