Project

General

Profile

Feature #7114

Rename session_rel_course_rel_user.status and user.status to "role"

Added by Yannick Warnier almost 5 years ago. Updated almost 5 years ago.

Status:
New
Priority:
High
Assignee:
-
Category:
Database & API changes
Target version:
2.0
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

#1

Updated by Julio Montoya almost 5 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)

Also available in: Atom PDF