You can think of a content repository item as consisting of content and metadata. For example, if your content repository includes repository items that are news stories, the metadata might include a story’s byline, dateline, length, and keywords, while the content includes the text of the story itself. You can adopt one of two basic architectural styles when you set up an SQL content repository:

As with other repositories, setting up an SQL content repository involves the following steps:

A repository that contains content items must include item descriptors flagged with the folder and content attributes of the <item-descriptor> tag in the SQL repository definition.