Create the Database Schema

Converged Application Server includes a SQL script, callstate.sql, that you can use to create the tables necessary for storing call state information. The script is installed to the user_staged_config subdirectory of the domain directory when you configure a replicated domain using the Configuration Wizard.

The contents of the callstate.sql SQL script are shown below.

Example 1-6 callstate.sql Script for Call State Storage Schema

drop table callstate;

create table callstate (
  key1 int,
  key2 int,
  bytes blob default empty_blob(),
  constraint pk_callstate primary key (key1, key2)
);

Follow these steps to execute the script commands using SQL*Plus:

Move to the Converged Application Server utils directory, in which the SQL Script is stored:
```
cd ~/WL_HOME/common/templates/scripts/db/oracle
```
where WL_HOME is the path to the directory where the WebLogic Server component of Converged Application Server is installed.
Start the SQL*Plus application, connecting to the Oracle database in which you will create the required tables. Connect to the database using the user name, password and database name that you specified when you installed the database software. For example:
```
sqlplus username/password@connect_identifier
```
where connect_identifier connects to the database identified in the JDBC connection pool.
Execute the Converged Application Server SQL script, callstate.sql:
```
START callstate.sql
```
Exit SQL*Plus:
```
EXIT
```