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

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

Auto Provisioning Administrator’s Guide
84 Appendix C Auto Provisioning Server Database Description
Table 19 Sptgengroup
ID COLUMN NAME DATATYPE NULL KEY DEFAULT VALUE DESCRIPTION
1 RowID int (11) PRI auto_increment
2 ProductType varchar(100) Product type of
subscriber device
3 SPTGenGroupName varchar(100) Group name of product
type
4 GroupID int(11) Yes Group ID of product type
Table 20 UnLockedDevice
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 LockTime datetime CURRENT_TIMESTAMP When the device was
locked
5 LockMinutes int(11) 0 How long the device will
be locked
6 UnLockTime timestamp
7 UnLockUser varchar(20) Yes Refer to UserID in Table
21 on page 84
.
Table 21 User
ID COLUMN NAME DATATYPE NULL KEY DEFAULT VALUE DESCRIPTION
1 UserID varchar(20) Pri Account name
2 Password varchar(20) Password
3 UserName varchar(20) User name
4 EMail varchar(50) Email
5 Phone varchar(50) Yes Phone
6 Mobile varchar(50) Yes Mobile
7 Title varchar(50) Yes Title
8 UserType Char(1) 2 Account’s type
1: Admin
2: Viewer