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	torben	113	--
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