creating columns

[eluser]TheFuzzy0ne[/eluser]
I still don't quite understand how your system works.

First of all, you should never add anything to two places in your database (unless it's an ID). If you do, you are likely to run into problems with your data integrity.

Also, adding columns with PHP should be avoided also. If you need to dynamically add columns, it's probably an indication that your database structure is wrong. I would instead suggest you look into a way of achieving the same thing, but using rows in a table, instead of columns.

I'm not entirely sure why you need to add the columns dynamically. Can you not just add them anyway, and just keep them empty until you need to store something in them?

In the privileges table and the member table, please could you explain what type of data you plan to store in your create_shit and delete_shift fields? Also, are your IDs just there for the sake of being there, or are they used elsewhere in the app?

If you can explain a bit more about what your app is supposed to do (rather than how it does it), I might be able to offer you a better solution.