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