Brekeke SIP Server Wiki

4. Create the Alias Table - MySQL

This table stores alias data.

Note: Alias Database is available in Advanced Edition only


1. Create a table “t_alias” using the command below:
mysql> CREATE TABLE t_alias (
       alias_name VARCHAR(100) NOT NULL,
       group_id VARCHAR(100),
       entity_name VARCHAR(100) NOT NULL


2. Create indexes using the commands below:
mysql> CREATE INDEX idx_aliasdb_alias ON t_alias(alias_name,group_id);
mysql> CREATE INDEX idx_aliasdb_entity ON t_alias(entity_name);


Yes No
Suggest Edit