View Single Post
Old 06-25-2009, 05:21 AM   #3 (permalink)
ryanmr
The Contributor
 
ryanmr's Avatar
 
Join Date: Jun 2008
Location: Twin Cities, Minnesota, USA
Posts: 44
Thanks: 3
ryanmr is on a distinguished road
Default

I didn't put too much time into my list so it's basic.

users table
---
id
username
email
password
last_login
date_registered
role_id

roles
-----
id
role_name
role_level
Basically, you get your user table and then a secondary roles table. A user can only have a single role but presumably a user with a higher level can do more things, with Admin's being the highest.

Or you could have a little table containing Admin usernames/emails and whenever someone goes to the Admin login page, it'll cross check that table. It depends on the number of differing role levels. You might want only visitors who can't do anything but view unless they login, members can favorite things, maybe, moderators could help fix book labeling problems but not add new books and finally admins could do everything.
__________________
blog twitter ifupdown
ryanmr is offline  
Reply With Quote