Access from Control Panel, see section Web hosting. Click on “phpMyAdmin”, top left item in panel DATABASES. It will take a few seconds for this to open.
Now click on the + sign beside “gentsinn” in the left hand panel. It will expand to show 2 databases: “gentsinn_gin_club_db” and “gentsinn_wrdp1”. Click on the + sign beside each one to display the list of tables.
gentsinn_gin_club_db database
This is the non-WordPress database. Several of the tables are created afresh each time a member accesses the web site. These are:
- gin_members
- gin_organisers
- gin_headers
The logic used to create the gin_members table is shown below
A description of each table is shown below
This is small text and may be difficult to read to I’ve added a pdf printout of the Excel sheet as a download below.
gentsinn_wrdp1 database
This is the WordPress database. However 3 of the tables, “wp_cimy_uef_…” are not standard WordPress but belong to a plugin that enables us to store each member’s phone numbers and addresses.
Table wp_posts contains all the pages and blog posts that have been entered.
Table wp_users, not surprisingly, contains the names and email addresses of all members. It also stores all passwords in an encrypted format.
Beware
Do not make changes to the databases All changes are made through the website. One exception to this is deleting an activity. I’ve left this as a manual task directly in the database since you need to first remove any reference to this activity from gin_member_activities. Deleting an activity is such a rare event (never done so far) that I couldn’t be bothered to program it.