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 permissionid int(11) Primary key
idrole_id int(11) Role
idmenu_id int(11) Menu
idstatus tinyint(1) status (0: Unauthorized 1
: Authorized)menu
menu tableid int(11) menu primary key
name varchar(50) menu namemodule_id int( 11) Module
idmodules varchar(20) module name (code related)controller archar(20) controller
nameaction varchar(20) action
namestatus tinyint(1) No display 0Do not display 1Display default
1sort int(11) sort field (default 99
)module
backend module grouping tableid int( 11) Primary key
idname varchar(50) module name status tinyint(1) whether to display (0not displayed 1display default 1
)sort int( 11) Sorting field (default 99
)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.
🎜 🎜
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
