Feature #7114
Rename session_rel_course_rel_user.status and user.status to "role"
Start date:
30/04/2014
Due date:
% Done:
0%
Estimated time:
Complexity:
Normal
SCRUM pts - complexity:
?
Description
The "status" column in session_rel_course_rel_user is really not a state or a status of anything. It represents the role the user has inside this course-session.
As such, it is confusing to keep it as "status". It should be renamed to "role".
The same is true for the user.status column.
History
Updated by Julio Montoya over 6 years ago
In 10, the user.status column is not used. Instead there's a new table for that:
mysql> describe users_roles; +---------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------+------+-----+---------+-------+ | user_id | int(11) | NO | PRI | NULL | | | role_id | int(11) | NO | PRI | NULL | | +---------+---------+------+-----+---------+-------+ 2 rows in set (0.00 sec) mysql> describe roles; +-------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(255) | YES | | NULL | | | role | varchar(255) | YES | UNI | NULL | | +-------+--------------+------+-----+---------+----------------+ 3 rows in set (0.00 sec)