Auto Provisioning Administrator’s Guide
Appendix C Auto Provisioning Server Database Description
83
Table 16
ServerConfiguration
ID
COLUMN NAME DATATYPE
NULL KEY DEFAULT VALUE DESCRIPTION
1
Protocal
varchar(100)
Provisioning protocol
2
PIN
varchar(100)
Encrypted pin? (reserved)
3
MaximumBackup Int(11)
0
Maximum backup file
(reserved)
4
Userlockedtime
varchar(100)
How long the subscriber
device will be locked
5
IsDefault
varchar(100)
0
This setting is default or not.
Table 17
SpecifySetting
ID COLUMN NAME DATATYPE
NULL KEY DEFAULT VALUE DESCRIPTION
1
RowID
int (11)
PRI
auto_increment
2
UserID
varchar(50)
Subscriber ID
3
ProductType
varchar(100)
Subscriber device product
type
4
PhoneNumber
varchar(50)
U
Phone number
5
Password
varchar(50)
Password
6
PINCode
varchar(50)
PIN code
7
MACAddress
varchar(100)
MAC address
8
Flag
Char(1)
0
Provisioned or not
(reserved)
0: un-provisioned
1: provisioned
9
SIPOrder
Int(11)
1
SIP order (CPE Port#)
Table 18
Sptgen
ID COLUMN NAME DATATYPE
NULL KEY DEFAULT VALUE DESCRIPTION
1
AttributeNO
varchar(100) Yes
Attribute number
2
Attribute
varchar(250) Yes
Attribute
3
AttributeValue
varchar(250) Yes
Attribute value
4
ProductType
varchar(100) Yes
P2002
Subscriber device product
type
5
GroupID
int (11)
Yes
Product type group ID. Refer
to
GroupID
in
6
RowID
int (11)
PRI
auto_increment
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...