Brekeke SIP Server Wiki

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);