The EuroCMS Databases

Author	Version	Date
Imri Paloja	1	31-05-2022

The EuroCMS database structure

This is the default structure of the EuroCMS database tables.

{tablename}_id	domain_id	user_id	group_id	user_lock	status
1	[0-9]	[0-9]	[0-9]	1	enabled
2	[0-9]	[0-9]	[0-9]	null	disabled
3	[0-9]	[0-9]	[0-9]	null	enabled

{tablename}_id: [0-9] - required; auto increment, not empty

If the table name is Files with an S, plural, the ID name would be file_id, singular. If the table name is singular, content, the ID name should also be content_id.

domain_id: [0-9] - required

The ID of the domain that is currently being visited.

user_id: [0-9] - required

The ID of the user that created the row.

group_id: [0-9] - required

The ID of the group that has access to this row of data.

...
Everything in between can be anything that the developer wants it to be.
...
user_lock: [0-9] - required

This needs to exists, but doesn't have to be used.

IDs of users that are able to modify this data. When to many user are in the group that can edit the data, and you want to only allow certain users, you can use the user lock.