Im trying to figure out how to create a users table but giving each different user different permissions.
Heres what im thinking…
We need a users table to hold all the users
We also need a permissions table to hold all the folders to be given permission.
Lastly I’ll need a users-permissions table to link the two (so is it ok to have 2 foreign keys only in this table?
I think the structure of the tables will be like
CREATE TABLE users
id INT UNSIGNED NOT NULL AUTO_INCREMENT),
PRIMARY KEY (id)