Example

If you have installed the software as described in Installing the Escenic Community Expansion software, you may follow this example on how to install all the VCE database scripts on a mysql database running on a server called dbhostwith the schema ecedb, user name eceuser and password ecepassword:

  $ for el in tables tables-stats constants constants-stats views-stats; do
  for ele in `find -L /opt/escenic/community-engine/ -name "$el.sql" | grep mysql`; do
    mysql -u eceuser -pecepassword -h dbhost ecedb < $ele
  done
done

The equivalent for Oracle DB would be:

  $ for el in tables tables-stats constants constants-stats views-stats; do
  for ele in `find -L /opt/escenic/community-engine/ -name "$el.sql" | grep oracle`; do
     sqlplus eceuser/ecepassword @$ele
  done
done