Advanced Extension Database Schema
Advanced server extension supplied with the ClearBox Server uses predefined
database schema consisting of two tables.
Users
This table containing user accounts.
| Column name |
Data type |
Description |
| ID |
Counter |
Unique key field used to identify a record in the
table. |
| Name |
Text(50) |
User name (or "login"). |
| Password |
Text(50) |
User password. |
| Enabled |
Boolean |
Flag specifying whether the user account is enabled
or disabled. If Enabled is false, user is always rejected. |
| ValidSince |
Date-Time |
Specifies the date when user account becomes valid.
If this value is greater than current time then user is rejected.
If this field is NULL then it's not checked. |
| ValidTill |
Date-Time |
Specifies the date when user account becomes invalid.
If current time is greater than this field then user is rejected.
If this field is NULL then it's not checked. |
| TimeCredit |
Integer |
Specifies amount of time (in seconds) that user is
allowed to stay connected to a NAS. If it's > 0 then user session
timeout is set to this value. If it's 0, no timeout is applied. If
it's less than 0 then user is rejected. |
Accounting
This tables is filled by the server automatically if LogType key
is Database.
| Column name |
Data type |
Description |
| ID |
Counter |
Unique value identifying a record. |
| UserID |
Integer |
Points to a record in Users table. It's 0 if
no user was found in Users table from user name. |
| DateInserted |
Date/time |
Time when this record was inserted into the table. |
| SessionTime |
Integer |
Duration of a user session in seconds. |
| BytesIn |
Integer |
Number of input bytes transferred during the connection. |
| BytesOut |
Integer |
Number of input bytes transferred during the connection. |
| IPAddress |
char(50) |
IP address that was assigned to a user during his
session. |
| CallerID |
char(50) |
Value of Caller-ID attribute. |
© 2001-2003 XPerience Technologies. www.xperiencetech.com
|