ZyXEL Communications APS 1.0, Руководство администратора

Страница: 82 / 116

Auto Provisioning Administrator’s Guide
82 Appendix C Auto Provisioning Server Database Description
4 LoginName Varchar(100) Account name
5 LoginTime Datetime 0000-00-00 00:00:00 Login time
6 LogoutTime Datetime Yes 0000-00-00 00:00:00 Logout time
Table 13 PinFailLog
ID COLUMN
NAME
DATATYPE NULL KEY DEFAULT VALUE DESCRIPTION
1 RowID int (11) PRI Auto_increment
2 macAddress varchar(100) Subscriber device MAC
address
3 phoneNumber varchar(50) Yes Phone number
4 PinFailTime timestamp Yes CUPPENT_TIMESTAMP Pin fail time
5 PinErrMsg varchar(200) Yes Pin fail error message
Table 14 ProductType
ID COLUMN NAME DATATYPE NULL KEY DEFAULT VALUE DESCRIPTION
1 ProductType varchar(100) PRI Subscriber device product
type
2 Memo varchar(100) Yes Product type memo (reserved)
Table 15 RequestLog
ID COLUMN NAME DATATYPE NULL KEY DEFAULT VALUE DESCRIPTION
1 RowID int (11) PRI auto_increment
2 RequestDate timestamp Yes CUPPENT_TIMESTAMP Request date
3 RequestPage varchar(100) The page which is
requested(reserved)
4 MACAddress varchar(100) Yes Mac address of
subscriber device
(reserved)
Table 12 LoginLog (continued)
ID COLUMN NAME DATATYPE NULL KEY DEFAULT VALUE DESCRIPTION