PHP background administrator permissions related table structure

adminAdministrator table

id int(11) Userid

username varchar(128) Username

password varchar(128) Administrator password

name varchar(50) Administrator’s real name

email varchar(128) Administrator email

login_time int(11) Login time

login_ip varchar(20) Login ip

create_time int(11) Creation time

salt varchar(10) Random encrypted string

role_id int(11) role id

status tinyint(4) status (0, deleted 1, disabled 2, normal)

update_time int( 11) Update Time

ip_access tinyint(4) Allow external network access (1, not allowed 2, allowed)

rolerole table

id int(11) primary keyid CName Varchar (50) character name

sort int (11) Sorting

Status Tinyint (4) Status

(0

, delete 1, disable 2, normal ) ) ) )

role_privilege

Role permission

id int(11) Primary key

id

role_id int(11) Role

id

menu_id int(11) Menu

id

status tinyint(1) status (0: Unauthorized 1

: Authorized)

menu

menu table

id int(11) menu primary key

name varchar(50) menu namemodule_id int( 11) Module

id

modules varchar(20) module name (code related)controller archar(20) controller

name

action varchar(20) action

name

status tinyint(1) No display 0Do not display 1Display default

1

sort int(11) sort field (default 99

)

module

backend module grouping table

id int( 11) Primary key

id

name varchar(50) module name status tinyint(1) whether to display (0not displayed 1display default 1

)

sort int( 11) Sorting field (default 99

)

Copyright statement: This article is an original article by the blogger and may not be reproduced without the blogger's permission.

The above introduces the table structure related to the PHP background administrator permissions, including the content. I hope it will be helpful to friends who are interested in PHP tutorials.

🎜 🎜