[Nss-mysql-users] examples/sample.sql

[Mario Ohnewald]

Hello!
I just found out that there is a mini bug in the sample.sql. I just 
thought i should post it here, in case some other users have this 
problem in the future, too.


CREATE TABLE user (
 user_id int(11) NOT NULL auto_increment primary key,
 user_name varchar(50) DEFAULT '' NOT NULL,
 realname varchar(32) DEFAULT '' NOT NULL,
 shell varchar(20) DEFAULT '/bin/sh' NOT NULL,
 password varchar(40) DEFAULT '' NOT NULL,
 status char(1) DEFAULT 'N' NOT NULL,
 uid int(11) NOT NULL,
 gid int(11) DEFAULT '65534' NOT NULL,
 homedir varchar(32) DEFAULT '/bin/sh' NOT NULL,
 lastchange varchar(50) NOT NULL default '',
 min int(11) NOT NULL default '0',
 max int(11) NOT NULL default '0',
 warn int(11) NOT NULL default '7',
 inact int(11) NOT NULL default '-1',
 expire int(11) NOT NULL default '-1',
 PRIMARY KEY  (user_id)
);


The last 3 lines should look like this:
 inact int(11) NOT NULL default '-1',
 expire int(11) NOT NULL default '-1'
);


Cheers, Mario