Role Table

Purpose

This table represents roles for Melody's role-based authentication system.

Fields

• role_id - int(11) - Table primary key.
• role_created_by - int(11) - User who created the role.
• role_created_on - datetime - When the role was created.
• role_description - mediumtext - A detailed description of the role.
• role_is_system - tinyint(4) - A boolean flag saying whether or not this is a system-wide role versus a blog-only role.
• role_modified_by - int(11) - The user who last modified the role.
• role_modified_on - datetime - When the role was last modified.
• role_name - varchar(255) - The role's name.
• role_permissions - A comma-separated list of permissions that this role can execute.
• role_role_mask - int(11) - TODO: document
• role_role_mask2 - int(11) - TODO: document
• role_role_mask3 - int(11) - TODO: document
• role_role_mask4 - int(11) - TODO: document

Indexes

• mt_role_created_on
• mt_role_is_system
• mt_role_name