TS2 - MySQL create_clients.sql Security mod - disallows duplicate user names

[Computerman]

This create_clients.sql sets s_client_name column as a UNIQUE KEY so that each user name must be unique. Attached to this message.

I've also attached an sql file (altertablemake_s_client_name_UNIQUE.sql) to this to run as a patch until the new sql file is included in the next release.

Just in case the attachments don't work, I'll post the raw data here:

--------------------------------------------------------------
create_clients.sql :
--------------------------------------------------------------

CREATE TABLE `ts2_clients` (
`i_client_id` int(11) NOT NULL auto_increment,
`i_client_server_id` int(11) default NULL,
`b_client_privilege_serveradmin` int(11) default NULL,
`s_client_name` varchar(40) default NULL,
`s_client_password` varchar(80) default NULL,
`dt_client_created` varchar(20) default NULL,
`dt_client_lastonline` varchar(20) default NULL,
PRIMARY KEY (`i_client_id`)
UNIQUE KEY (`s_client_name`)
) TYPE=MyISAM


--------------------------------------------------------------
altertablemake_s_client_name_UNIQUE.sql :
--------------------------------------------------------------

ALTER TABLE `ts2_clients` ADD UNIQUE (
`s_client_name`
)