Cisco Cisco IP Contact Center Release 4.6.1 Installation Guide
5-8
WebView Installation and Administration Guide for Cisco Enterprise & Hosted Editions, Release 7.0(0)
Chapter 5 The WebView Database
WebView Database Tables
Redirect to a Failover WebView Database
Log in as administrator on the WebView server, and follow the steps below:
Step 1
Click Start > Programs > Administrative Tools > Data Sources (ODBC).
Step 2
Click the System DSN tab.
Step 3
Select wvdb ODBC DSN
(<instancename>WVDB_wv)
and click Configure.
Step 4
Change the server name and click Apply.
Step 5
Test WebView to verify the access to the new WebView database.
WebView Database Tables
The WebView database consists of four database tables. The sections that follow describe the structure
of these database tables:
of these database tables:
•
The WebViewVersion Table, page 4-12
•
The Print Jobs Table, page 4-13
•
The Report Table, page 4-15
•
The User Preferences Table, page 4-17
The WebViewVersion Table
This table is used by WebView software for version checking of the WebView database. It describes the
current schema of the database and shows the schema history.
current schema of the database and shows the schema history.
Note
A composite primary key (WebViewVersion, LastUpdateDate) provides an event history of every time
the customer runs or reruns the upgrade script.
the customer runs or reruns the upgrade script.
Table 5-1
WebViewVersion Table
Field Name
Type
Allow
Nulls
Nulls
Constraint/Index
Database Table
Header
Database Table
Header
Description
WebViewVersion
Real
No
Primary Key
The version of WebView database
LastUpdateDate
DateTime
No
Primary Key
The date and time that the database
was last created or upgraded
was last created or upgraded