_gwm_favorite_courses - GolfWithMe/Master GitHub Wiki

Description

This table holds the favorite courses for each member.

Field Descriptions

uid

The unique record ID

MemberID

This is the Joomla user ID for the user.

CourseID

This is the uid of the course that is to be on the Favorites list.

Table Layout

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

Creation Script

create table _gwm_member_favorite_courses (uid int auto_increment, MemberID int, CourseID int, primary key(uid));