N2 Open Source CMS for ASP.NET > Documentation > The database
The database
N2's database is composed of four tables:
- n2item - contains all items (pages, data items and versions of these)
- n2detail - value bag of for items
- n2detailCollection - connection to multiple values with the same name
- n2allowedRole - roles authorized to view a page
Basically it's a table for containing all content items (pages, versions of pages and parts) and a property table for any additional data needed by the CMS implementation. In the domain layer this schema is hidden behind a clr class that expose data as properties.
This schema works well for the web site CMS scenario such as the enterprise web site where clients read most of the time and few updates. The main benefit is less database work and easier deployment of new features (schema changes).
This database schema can be created through /edit/install of your n2 site. If you want to create the database tables yourself you can use one of these scripts:
The SQL Server scripts have been optimized for performance by maqdev.
Go here for help configuring the connection string in web.config.