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
