openvpn/openvpn-auth_mysql/vpnauth.sql

-- 
-- 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;

1	--
2	-- Structure-dump of `vpnauth` table
3	--
4
5	-- Field description:
6	-- user = user account name
7	-- pass = users password in clear-text
8	-- locked = if the locked field is zero the account is NOT locked
9	-- for all other values, the user is denied access
10	-- expires =
11	-- failcount = how many times has the user tried to login, but with the
12	-- wrong password. User is denied access if >= 3.
13	-- This field is reset to 0 on successfull login.
14
15	CREATE TABLE vpnauth (
16	id int(11) NOT NULL auto_increment,
17	user varchar(40) NOT NULL,
18	pass varchar(40) NOT NULL,
19	locked tinyint(4) NOT NULL default '0',
20	expires date NOT NULL default '0000-00-00',
21	failcount int(11) NOT NULL default '0',
22	lastlogin datetime,
23	PRIMARY KEY (id),
24	KEY user (user)
25	) TYPE=MyISAM;
26