TalkPHP - View Single Post

bdm · 12-14-2007, 01:29 PM

Good thinking bmicallef.

Quick things off the top of my head:
- There is no status table.
- Since you're using tinyint as your datatype for user_rank in your users table, you should do the same the the ID in your users_rank table. Tinyint should be more than enough, especdially if you make it unsigned since it'll go up to 255.
- In your comments table, isn't the comments_comments column a little redundant?

12-14-2007, 01:29 PM	#3 (permalink)
bdm The Acquainted Join Date: Nov 2007 Posts: 127 Thanks: 14	Good thinking bmicallef. Quick things off the top of my head: - There is no status table. - Since you're using tinyint as your datatype for user_rank in your users table, you should do the same the the ID in your users_rank table. Tinyint should be more than enough, especdially if you make it unsigned since it'll go up to 255. - In your comments table, isn't the comments_comments column a little redundant?