_gwm_member_blacklist - GolfWithMe/Master GitHub Wiki

Description

This table holds the list of golfers that members do not want to golf with again.

Field Descriptions

uid

The unique record ID

MemberID

This is the joomla ID of the owner of this blacklist.

BlacklistID

This is the joomla ID of the player that the member does not want to golf with again.

Table Layout

+-------------+---------+------+-----+---------+----------------+
| Field       | Type    | Null | Key | Default | Extra          |
+-------------+---------+------+-----+---------+----------------+
| uid         | int(11) | NO   | PRI | NULL    | auto_increment |
| MemberID    | int(11) | YES  |     | NULL    |                |
| BlacklistID | int(11) | YES  |     | NULL    |                |
+-------------+---------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

Creation Script

create table _gwm_member_blacklist (uid int auto_increment, MemberID int, BlacklistID int, primary key(uid));