Chapter 2. Database Backend, Midgard Functions

The 1.4 version of Midgard uses a MySQL database backend to store and quickly retrieve content, template elements, user information or code libraries. This data is easily managed through a PHP API whose functions are mostly organized around the database structure.

This manual is populated with entity-relationship diagrams which will help you grasp Midgard's simple and powerful concepts. The full description of all records is in Part IV in Midgard Manual.

The database structure has been designed to meet a majority of content management requirements. In addition, specific needs can be adressed by attaching named values to any record thanks to the Parameter table and functions. Parameters can be grouped by domain. See Figure 2-1 and Chapter 65.

The sitegroup field will be dealt with in the section called Sitegroups in Chapter 8. There is one such field in every table of the Midgard database (but the Sitegroup table).