Chapter 4. Database

Table of Contents

Preparation of database
Upgrade of database schema
Schema description
Table tig_ma_jids
Table tig_ma_msgs
Table tig_ma_tags
Table tig_ma_msgs_tags

Preparation of database

Before you will be able to use Tigase Unified Archive Component and store messages and events in particular database you need to initialize this database. We provide few schemas for this component for MySQL, PostgreSQL, SQLServer and DerbyDB.

They are placed in database/ directory of installation package and named in dbtype-unified-archive-version.sql, where dbname in name of database type which this schema supports and version is version of a Unified Archive Component for which this schema is designed.

You need to manually select schema for correct database and component and load this schema to database. For more information about loading database schema look into ??? section of ???