Brekeke SIP Server Wiki

3. Create the Users Table - MySQL

This table stores user authentication data.


1. Create a table “t_userdir” using the command below:
mysql> CREATE TABLE t_userdir (
       uid BIGINT,
       username VARCHAR(100),
       longname VARCHAR(200),
       password VARCHAR(100),
       email VARCHAR(100),
       description VARCHAR(200),
       gid BIGINT,
       timeexpire BIGINT,
       timemake BIGINT


2. Create indexes using the commands below:
mysql> CREATE INDEX idx_userdir_uid ON t_userdir(uid);
mysql> CREATE INDEX idx_userdir_username ON t_userdir(username);
mysql> CREATE INDEX idx_userdir_timeexpire ON t_userdir(timeexpire);


Yes No
Suggest Edit