Thread: Fine Grained Role Based Access Control (RBAC) system
View Single Post
  #28 (permalink)  
Old 07-23-2007, 11:19 PM
ben ben is offline
Administrator
  
Join Date: Mar 2007
Posts: 87
ben has disabled reputation
Default Re: Fine Grained Role Based Access Control (RBAC) system
Quote:
Originally Posted by herschwolf View Post
Code:
UNIQUE and INDEX keys should not both be set for column `users_id`
I get this error in MySQL 5.0.41 when viewing the rbac_users_has_roles table. I'm not that versed in index and unique setups in a MySQL database so I'm not sure entirely why this error would pop up and what it really means in the operational structure of the system.

Can anyone explain this to me and propose a fix if needed?

-Nathan
You can delete the INDEX keyword as UNIQUE fields are automatically indexed.
I will fix the SQL when I get back (I don't have the time right now.)
Reply With Quote