#8 A small problem is in Sample SQL.

[Tadashi Jokagi]

A small problem is in Sample SQL.
In the present SQL, two or more users of a same name
can create.
A problem is below avoidable.

CREATE TABLE users (
username varchar(16) NOT NULL default '',
uid int(11) NOT NULL auto_increment,
gid int(11) NOT NULL default '5000',
gecos varchar(128) NOT NULL default '',
homedir varchar(255) NOT NULL default '',
shell varchar(64) NOT NULL default '/bin/bash',
password varchar(34) NOT NULL default 'x',
lstchg bigint(20) NOT NULL default '1',
min bigint(20) NOT NULL default '0',
max bigint(20) NOT NULL default '99999',
warn bigint(20) NOT NULL default '0',
inact bigint(20) NOT NULL default '0',
expire bigint(20) NOT NULL default '-1',
flag bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
- KEY username (username),
+ UNIQUE KEY `username` (`username`),
KEY username (username),
KEY uid (uid)
) TYPE=MyISAM AUTO_INCREMENT=5000;

Please check.
Regards.

[Ben Goodwin]

Logged In: YES
user_id=550319

I've changed the key type to UNIQUE in all sample databases
in the current CVS tree. This will be included in the 1.3
release.
Thanks!