A MySQL database is used to store data for your Pligg site. Within that database are several tables which group the data into easy to understand fields. Stories, for example, are all stored in the same database table.
This wiki article will outline all of the MySQL database tables that Pligg uses to store data.
Database Prefix
When installing Pligg you have the option to change the default prefix used in your table names. By default pligg uses the prefix pligg_, but you could change this value to anything you want. Because of this I will be referring to the table name that comes after that prefix in the table outline below.
Table categories
This table is used to store the categories on your Pligg site. It stores the following data:
- Category name
- Category description
- Keywords associated with the category
- Author levels allowed to submit to the category
- Groups allowed to submit to the category
- Data that determines how it should be ordered
Table comments
This table contains details about
:
- What story the comment belongs to
- The comment content.
- Who was the author
- Whether it was a reply to another comment or an original comment
- How many positive or negative votes the comment received
Table config
This table holds the data that is used for Pligg's "Configure" admin page. It contains a variety of information that changes your site's settings.
Table groups
This table is used to store data about groups that belong to your Pligg site. Some of the fields found in this MySQL table are:
- Group ID (auto incrementing number assigned to each group)
- Group Creator (who created the group)
- Group Status (enable/disable)
- Group Members
- Group Date (last updated the group settings)
- Group Name
- Group Description
- Group Privacy (determines who can join the group, who can see the users/content)
- Group Avatar
- Group Votes to Publish (how many votes make the Group's published homepage)
02-16-2009, 12:44 PM
Similar Threads 
Linear Mode
