User`s guide

SQL D ATABASE S CRIPT D EFINITIONS
OVERVIEW
This chapter contains the SQL Database script definitions used to install the SFVRA database. With
this information, an advanced SQL administrator may run queries in the ISQL_w application. For
example, the administrator may find it convenient to change one field in the database for all users
or CyberSWITCH systems with one command, instead of opening each entry in the Client interface.
Refer to the SQL Server Administrator’s Companion for information on how to run queries.
Note: This chapter contains information about the SFVRA Database Version 4.0 only. Ensure that
the version of the SFVRA Database is equivalent.
SFVRA DATABASE TABLES
ACCESS_SERVER
Entries are created in this table by the Client interface when a user configures a CyberSWITCH. The
SFVRA Service will only connect via TCP/IP to devices defined in this table.
SERVER_NAME
A string used to identify the name of the CyberSWITCH.
SERVER_IP_ADDR
The IP address SFVRA-CONN uses to create a TCP/IP connection to the CyberSWITCH.
SERVER_SECRET
A string used to do CHAP authentication between the CyberSWITCH and the SFVRA Service.
SERVER_SECRET is not currently supported.
NAME_LAST
Identifies a responsible person for the CyberSWITCH. The SFVRA Service does not use this
information. NAME_LAST is not currently supported.
NAME_FIRST
Identifies a responsible person for the CyberSWITCH. The SFVRA Service does not use this
information. NAME_FIRST is not currently supported.
ADDR1
Identifies the address of a responsible person for the CyberSWITCH. The SFVRA Service does not
use this information. ADDR1 is not currently supported.
ADDR2
Identifies the address of a responsible person for the CyberSWITCH. The SFVRA Service does not
use this information. ADDR2 is not currently supported.
POST_CODE
Identifies the ZIP code of a responsible person for the CyberSWITCH. The SFVRA Service does not
use this information. POST_CODE is not currently supported.