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
Summary of Contents for APS 1.0
Page 1: ...Auto Provisioning For VoIP Devices Administrator s Guide Version 2 0 3 2006...
Page 2: ......
Page 6: ...Auto Provisioning Administrator s Guide 6 Customer Support...
Page 10: ...Auto Provisioning Administrator s Guide 10 Table of Contents...
Page 14: ...Auto Provisioning Administrator s Guide 14 List of Tables...
Page 42: ...Auto Provisioning Administrator s Guide 42 Chapter 3 Provisioning Utility...
Page 72: ...Auto Provisioning Administrator s Guide 72 Chapter 5 Using the Auto Provisioning Server...
Page 74: ...Auto Provisioning Administrator s Guide 74 Chapter 6 Using the Auto Provisioning Server...
Page 78: ...Auto Provisioning Administrator s Guide 78 Appendix A Auto Provisioning Service Flowchart...