-- 
-- Structure-dump of `vpnauth` table
-- 

-- Field description:
--  user      = user account name
--  pass      = users password in clear-text
--  locked    = if the locked field is zero the account is NOT locked
--              for all other values, the user is denied access
--  expires   = 
--  failcount = how many times has the user tried to login, but with the
--              wrong password. User is denied access if >= 3.
--              This field is reset to 0 on successfull login.

CREATE TABLE vpnauth (
  id int(11) NOT NULL auto_increment,
  user varchar(40) NOT NULL,
  pass varchar(40) NOT NULL,
  locked tinyint(4) NOT NULL default '0',
  expires date NOT NULL default '0000-00-00',
  failcount int(11) NOT NULL default '0',
  lastlogin datetime, 
  PRIMARY KEY  (id),
  KEY user (user)
) TYPE=MyISAM;