3. Create the Users Table – MySQL – Brekeke SIP Server Wiki

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

Was this helpful? Yes No

« 2. Create the Registered Table - MySQL 4. Create the Alias Table - MySQL »