Schema:directory

Schema Summary

+-----------------+------------+------+-----+---------+----------------+
| Field           | Type       | Null | Key | Default | Extra          |
+-----------------+------------+------+-----+---------+----------------+
| directory_id    | int(11)    | NO   | PRI | NULL    | auto_increment |
| directory_mask  | int(11)    | YES  |     | NULL    |                |
| directory_index | mediumtext | YES  |     | NULL    |                |
+-----------------+------------+------+-----+---------+----------------+

Description

The directory table is used to create the online author directory. There is one entry in this table for each character in the alphabet.

• directory_id - Unique directory ID.

• directory_mask - A bitmask indicating whether or not any lastnames are present in the database whose first letter matches the value stored in directory_index. The bitmask maps onto the second letter of the last name, where 0x0001 matches the letter a, 0x0002 matches the letter b, 0x0004 matches the letter c, etc.

• directory_index - The first letter of the lastname being tracked.