Schema:directory
Jump to navigation
Jump to search
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.