View Single Post
  #27 (permalink)  
Old 07-23-2007, 07:16 PM
herschwolf herschwolf is offline
Junior Member
 
Join Date: Jul 2007
Posts: 2
herschwolf is on a distinguished road
Default Re: Fine Grained Role Based Access Control (RBAC) system

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
Reply With Quote