Use your existing user table, and only import user_id in to blog_cat.cat = 1001 eg
REPLACE INTO blog_cat(cat,name,info) VALUES
(1001,'blog_staff','{"1":[1,2],"181130":[102,108]}');
staff user id is a json of: catetory and user ids, above means:
cat = 1 (all categories i.e. Admin staff)
user_id = 1, 2
cat = 181130 (i.e. staff or moderators for cat = 181130)
user_id = 102, 108 etc
Cat:
Blog |
Read: 22493
| 25/01/2019
| Like: 3
Today we are going to make a user system, which will be used for login, user management, role permission, page access control etc.
1 - team
CREATE TABLE team (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
id_up int NOT NULL DEFAULT 0, -- parent team id
name varch
Cat:
CMS |
Read: 1141
| 05/06/2022