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? 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. 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. 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
Archived
This topic is now archived and is closed to further replies.