acctman Posted February 23, 2009 Share Posted February 23, 2009 I need to store banned user information after a user has been removed from the site. My options are 1. edited/update the rate_members table and add a ban_type (int's 1-3) field. Or, 2. create a rate_banned table with ban_id ban_userid ban_time ban_ip ban_type (note rate_members table has similar fields different names) ok about the database, currently have 45 tables some people says thats too many. The rate_members table has 50 fields already. any suggestions? Quote Link to comment https://forums.phpfreaks.com/topic/146559-should-i-create-another-table/ Share on other sites More sharing options...
Maq Posted February 23, 2009 Share Posted February 23, 2009 any suggestions? Yes, you should take a look at Database Normalization. Quote Link to comment https://forums.phpfreaks.com/topic/146559-should-i-create-another-table/#findComment-769406 Share on other sites More sharing options...
fenway Posted February 24, 2009 Share Posted February 24, 2009 Or the related stickies. Quote Link to comment https://forums.phpfreaks.com/topic/146559-should-i-create-another-table/#findComment-770167 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.