_gwm_group_options - GolfWithMe/Master GitHub Wiki

Description

This table holds the additional group details that are needed to enable the Gold With Me functionality. Instead of changing the JomSocial tables, new tables were created so that if in the future JomSocial changes their tables, it does not affect our tables.

Field Descriptions

uid

The unique record ID

MasterGroupID

This is the group id from JomSocial.

GroupType

This is the group type (Open, Closed, etc)

HomeCourseID

If this is a group that only plays at one course then the home course ID is in here. If there is no home course id in here then the group can schedule at any course.

Table Layout

+---------------+---------+------+-----+---------+----------------+
| Field         | Type    | Null | Key | Default | Extra          |
+---------------+---------+------+-----+---------+----------------+
| uid           | int(11) | NO   | PRI | NULL    | auto_increment |
| MasterGroupID | int(11) | YES  |     | NULL    |                |
| GroupType     | int(11) | YES  |     | NULL    |                |
| HomeCourseID  | int(11) | YES  |     | NULL    |                |
+---------------+---------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

Creation Script

create table akzwy_gwm_group_options (uid int auto_increment, MasterGroupID int, GroupType int, HomeCourseID int, primary key(uid));