Sitefinity Blogs

Little known Sitefinity configuration settings
More detailed examples for Sitefinity component usage
Work-arounds for Sitefinity limitations
Discoveries and Ah-Ha moments

Sampling of the Sitefinity Database Structure

by Rich Winslow | Jul 24, 2010

I haven't created a complete mapping, but wanted to capture what I have discovered with updates over time as more is discovered:

SELECT *

FROM sf_PageContentBase pcb left outer join sf_PageBase pb on pb.ID = pcb.id 

left outer join sf_CmsPageContent pc on pc.ID = pcb.id 

left outer join sf_CmsCtrlLinks link on link.PageID = pcb.id 

left outer join sf_CmsUrl cu on cu.ID = pcb.id 

left outer join sf_CmsPageProps pp on pp.ID = pcb.id 

left outer join sf_CmsBinaryContent binc on binc.ID = pcb.ID 

left outer join sf_CmsPageTemplate pt on pt.ID = pcb.id 

left outer join sf_CmsCategory catc on catc.ID = pcb.id 

left outer join sf_CmsTemplContent tc on tc.ID = pcb.id 

left outer join sf_CmsTextContent txtc on txtc.ID = pcb.id 

left outer join sf_CmsContentBase cb on cu.ID = pcb.id 

left outer join sf_CmsWebControl wc on wc.ID = pcb.id 

left outer join sf_CmsContentThumbnail thumb on thumb.ID = pcb.id 

left outer join sf_CmsRootPage root on root.ID = pcb.ID 

left outer join sf_CmsComment comc on comc.ID = pcb.id 

left outer join sf_CmsContentVersion vers on vers.ID = pcb.id

1 Comment

1 air jordans 26 Apr
interview <a href="http://www.buylvbagonline.com/shoes-C50.html">louis vuitton shoes price</a> <a href="http://www.buylvbagonline.com/shoes-C50.html">louis vuitton red shoes</a> in the factory, <a href="http://www.buylvbagonline.com/">lv bags</a> the factory <a href="http://www.buylvbagonline.com/nomade-leather-C26.html">louis vuitton nomade leather</a> in full of parked vehicles in various departments. By the local government sector-led <a href="http://www.buylvbagonline.com/shoes-C50.html">lv shoes men</a> on-site. <a href="http://www.buylvbagonline.com/shoes-C50.html">louis vuitton shoes online</a>

Comment

Your name Click to add
Email (optional) Click to add
Website (optional) Click to add

Comment

Why Give Our Secrets Away?

I often get asked why I'm willing to journal all of my Sitefinity discoveries. People think I'm insane to give away for free what I labored over at some point.

Let me answer that in 2 parts:

Why journal my discoveries?

Because I forget and I want to a library of knowledge to refer back to. Oh but it is far worse than that... THREE TIMES now, I've gone to Google and searched for a solution to a problem, only to find MY OWN BLOG entry is #1 in Google and viola! there's the solution!
Why give it away for free?

Because others have been kind enough to do it for us; what goes around, comes around.

There are all levels of experience, thus someone with less experience may defer to us when needed.

The lines of 'competition' are very much blurred; in our minds competition is a potential customer or partnership in the right situation.

We maintain healthy partnerships with one of our competitors; they come to us when they need help and visa versa.

There is plenty of work out there for everyone if you are putting out quality work and you are straightforward with clients and competition.

Talk to us about how we can help YOU!

Drop us an email
Give us a call: 828-862-6667 x300

Don't miss out!

Keep up with our Sitefinity discoveries!
Click on the RSS feed icon below or sign up for our newsletter.

Email Address: