Remove field fkRoleID in users table

Project:OpenETD - Rutgers Electronics Thesis and Dissertations Platform
Version:1.1.0-beta
Component:Code
Category:bug report
Priority:normal
Assigned:chadmills
Status:closed
Description

In database table users the field named 'fkRoleID' no longer seems to be used for establishing user roles in the system. The existing tables users2roles and roles provide this functionality. Remove users.fkRoleID field from table.

Comments

#1

Status:active» test

Drop field from user table and removed use in the functions in library/functions.php that are used during account creation. Role is solely defined in the `users2roles` table now. Test by creating accounts with varying roles and logging in and seeing they function as expected. Also change account roles and see that they are stored and work properly.

#2

Version:1.0.0-beta» 1.1.0-beta

#3

Status:test» fixed

fkRoleID field is no longer in the users table. During RUetd testing, student, reviewer, and administrator accounts were created and the system functioned as expected.

#4

Status:fixed» closed

Back to top