Chapter 3. Database

Table of Contents

Preparation of database
Upgrade of database schema
Schema description
Table tig_muc_rooms
Table tig_muc_room_affiliations
Table tig_muc_room_history

Preparation of database

Before you will be able to use Tigase MUC Component 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-mucversion.sql, where dbname in name of database type which this schema supports and version is version of a MUC 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 ???