View Single Post
Old 02-23-2008, 01:41 AM   #3 (permalink)
SOCK
The Acquainted
 
Join Date: Nov 2007
Posts: 154
Thanks: 31
SOCK is on a distinguished road
Default

I agree with DeMo, you need to consider the `password` field and how it relates to what hash you're storing there.

In addition, make sure you add a UNIQUE index on the `name` field.

SMALLINT is probably enough for your application, but using INT isn't going to hurt anything.
__________________
I reject your reality, and substitute my own.
SOCK is offline  
Reply With Quote
The Following User Says Thank You to SOCK For This Useful Post:
Aaron (02-23-2008)