Auto Provisioning Administrator’s Guide
Appendix C Auto Provisioning Server Database Description
81
A
P P E N D I X
C
Auto Provisioning Server Database
Description
In some advanced scenarios, you might want to move the provisioning server’s database to
another server. The auto provisioning server uses a MySQL-based database.
The following tables describe the auto provisioning server’s database structure.
Table 10
LockedDevice
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
timestamp
Yes
CURRENT_TIMESTAMP When the device was
locked
5
LockMinutes
int(11)
0
How long the device
will be locked
Table 11
LoginLog
ID
COLUMN NAME DATATYPE
NULL KEY DEFAULT VALUE
DESCRIPTION
1
RowID
Int(11)
PRI
Auto_increment
2
SessionID
Varchar(100)
Account’s session ID
3
LoginID
Varchar(100)
Account ID
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 12
LoginLog
ID
COLUMN NAME DATATYPE
NULL KEY DEFAULT VALUE
DESCRIPTION
1
RowID
Int(11)
PRI
Auto_increment
2
SessionID
Varchar(100)
Account’s session ID
3
LoginID
Varchar(100)
Account ID
Содержание APS 1.0
Страница 1: ...Auto Provisioning For VoIP Devices Administrator s Guide Version 2 0 3 2006...
Страница 2: ......
Страница 6: ...Auto Provisioning Administrator s Guide 6 Customer Support...
Страница 10: ...Auto Provisioning Administrator s Guide 10 Table of Contents...
Страница 14: ...Auto Provisioning Administrator s Guide 14 List of Tables...
Страница 42: ...Auto Provisioning Administrator s Guide 42 Chapter 3 Provisioning Utility...
Страница 72: ...Auto Provisioning Administrator s Guide 72 Chapter 5 Using the Auto Provisioning Server...
Страница 74: ...Auto Provisioning Administrator s Guide 74 Chapter 6 Using the Auto Provisioning Server...
Страница 78: ...Auto Provisioning Administrator s Guide 78 Appendix A Auto Provisioning Service Flowchart...
Страница 80: ...Auto Provisioning Administrator s Guide 80 Appendix B Auto Provisioning Server System Configuration...
Страница 86: ...Auto Provisioning Administrator s Guide 86 Appendix C Auto Provisioning Server Database Description...