MySQL Forums
Forum List  »  General

Help with table design
Posted by: RecoilUK
Date: November 30, 2004 09:35AM

Hello everyone.

I,m trying to design a user group system, for something which I hope to be an open source project, and was wondering if anyone could help me.

I,m basically trying to develope a website content management system.

To start with, it has to have a good user/group/module system with permissions.

So far I have the following tables...

Users (1 - M) UserGroups (M - 1) Groups.

I also have a Modules table, this represents all the different area,s in a website, and every page must belong to a Module (this will hard coded into a page).

Then there is a Permissions table, this holds all the information relating to any possible permission that will be needed.

How would you firstly, devise a table that lists a Modules available permissions, and then also have another table which controls what module permissions a specific group has for that module.

I hope you understand what I mean.

Thankyou.

Options: ReplyQuote


Subject
Written By
Posted
Help with table design
November 30, 2004 09:35AM
November 30, 2004 10:51AM
November 30, 2004 11:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.