Jump to content

Archived

This topic is now archived and is closed to further replies.

Xallien

Best format for cms's user table?

Recommended Posts

I am quite aware that this is more of a design issue than anything, but I\'m creating Yet Another CMS and wondering what the best format for the storage of a user\'s data would be. Any insights people have had on this topic?

 

A few example questions to express what I mean:

- What should be the maximum size of the user-id field?

- The efficiency of creation, modification, and access dates?

- Password / encrypt / md5?

- Reasonable signature length cap?

- Avatar BLOBs?

- Seperate user-prefs table?

- etc.

 

I hope you get what I mean. I just want to see what the most efficient design would be before I commit any user table to being the core of the system.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.