It would seem to me that you'll want that field to be binary as well. Usually when I store passwords, they're stored as small blobs.
Curtis Jesse Norell said: > > Hello, > >> CREATE TABLE users ( >> user_idnr bigint(21) NOT NULL auto_increment, >> userid varchar(100) NOT NULL default '', >> passwd varchar(32) NOT NULL default '', >> client_idnr bigint(21) NOT NULL default '0', >> maxmail_size bigint(21) NOT NULL default '0', >> encryption_type varchar(20) NOT NULL default '', >> last_login datetime NOT NULL default '1979-11-03 22:05:58', >> PRIMARY KEY (user_idnr), >> UNIQUE KEY userid (userid), >> UNIQUE KEY useridnr_2 (user_idnr,userid) >> ) TYPE=InnoDB; > > > Just a heads up, you need passwd to be varchar(34) if you're > going to use md5 hash passwords. > > > -- > Jesse Norell > jesse (at) kci.net > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail
