Improve the users/roles design in the database

CCAFS / ccafs-ap

CCAFS P&R is a platform to assist in the planning and reporting of CCAFS-related research projects. Migrated from https://code.google.com/p/ccafs-ap/

GNU General Public License v3.0

2 stars 1 forks source link

Improve the users/roles design in the database #339

Closed hernandcb closed 9 years ago

hernandcb commented 9 years ago

Currently we have the design showed in the image to manage the users. However we don't use the permissions and the roles tables yet.

We need to improve the design of this part of the database in order to allow more flexibility.

hernandcb commented 9 years ago

I have changed the way in which we assign permissions to the web site elements, the change proposed is in the image below. Please keep in mind that it doesn't contain all the fields used in the real database nor the links to another tables:

htobon commented 9 years ago

Please add a new Column for the roles table named "description", type TEXT.