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