Update The Database Schema
Live Center
needs some additions to be made to the Content Engine database
schema. The scripts needed to make the required additions are included
in the misc/database/
folder of the distribution.
There are two sets of scripts, one for MySql databases, in
misc/database/mysql
, and one for Oracle databases in
misc/database/oracle
. There are four scripts in each
folder:
-
constants.sql
-
constraints.sql
-
indexes.sql
-
tables.sql
To run the scripts:
-
Log in as
escenic
on your database-host. -
Copy or unpack the appropriate scripts for your database to an appropriate location (for example
/tmp/live-center/misc/database/mysql
). -
Run the scripts as follows
-
For MySql:
$
cd /tmp/live-center/misc/database/mysql/$
for el in tables.sql indexes.sql constants.sql constraints.sql; do \ mysql -u ece-user -pece-password -h dbhost db-name < $el done;
replacing db-name, dbhost, ece-user and ece-password with the correct values for your database.
-