{"id":1282,"date":"2020-03-27T00:59:50","date_gmt":"2020-03-26T23:59:50","guid":{"rendered":"http:\/\/ginclub.website\/home2\/gentsinnyon\/?page_id=1282"},"modified":"2021-09-01T19:40:13","modified_gmt":"2021-09-01T18:40:13","slug":"databases","status":"publish","type":"page","link":"https:\/\/ginclub.website\/home2\/gentsinnyon\/gin-club-home\/user-guide\/administrators-guide\/databases\/","title":{"rendered":"Databases"},"content":{"rendered":"\n<p> Access from Control Panel,  see section <a href=\"http:\/\/ginclub.website\/home2\/gentsinnyon\/gin-club-home\/user-guide\/administrators-guide\/web-hosting\/\">Web hosting<\/a>. Click on &#8220;phpMyAdmin&#8221;, top left item in panel DATABASES. It will take a few seconds for this to open. <\/p>\n\n\n\n<p>Now click on the + sign beside &#8220;gentsinn&#8221; in the left hand panel. It will expand to show 2 databases: &#8220;gentsinn_gin_club_db&#8221; and &#8220;gentsinn_wrdp1&#8221;. Click on the + sign beside each one to display the list of tables.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"736\" height=\"702\" src=\"http:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Databases.jpg\" alt=\"\" class=\"wp-image-1283\" srcset=\"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Databases.jpg 736w, https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Databases-300x286.jpg 300w\" sizes=\"auto, (max-width: 736px) 85vw, 736px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">gentsinn_gin_club_db database<\/h2>\n\n\n\n<p>This is the non-WordPress database. Several of the tables are created afresh each time a member accesses the web site. These are:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>gin_members<\/li><li>gin_organisers<\/li><li>gin_headers<\/li><\/ul>\n\n\n\n<p>The logic used to create the gin_members table is shown below<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"461\" src=\"http:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/CoD-Tables.jpg\" alt=\"\" class=\"wp-image-1278\" srcset=\"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/CoD-Tables.jpg 751w, https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/CoD-Tables-300x184.jpg 300w\" sizes=\"auto, (max-width: 751px) 85vw, 751px\" \/><\/figure>\n\n\n\n<p>A description of each table is shown below<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"462\" src=\"http:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Database-tables-1024x462.jpg\" alt=\"\" class=\"wp-image-1285\" srcset=\"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Database-tables-1024x462.jpg 1024w, https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Database-tables-300x135.jpg 300w, https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Database-tables-768x347.jpg 768w, https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Database-tables-1200x542.jpg 1200w, https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Database-tables.jpg 1533w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p>This is small text and may be difficult to read to I&#8217;ve added a pdf printout of the Excel sheet as a download below. <\/p>\n\n\n\n<div class=\"wp-block-file\"><a href=\"http:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Description-of-tables-1.pdf\">Description-of-tables-1<\/a><a href=\"http:\/\/ginclub.website\/home2\/gentsinnyon\/wp-content\/uploads\/2020\/03\/Description-of-tables-1.pdf\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">gentsinn_wrdp1 database<\/h2>\n\n\n\n<p>This is the WordPress database. However 3 of the tables, &#8220;wp_cimy_uef_&#8230;&#8221; are not standard WordPress but belong to a plugin that enables us to store each member&#8217;s phone numbers and addresses.<\/p>\n\n\n\n<p>Table wp_posts contains all the pages and blog posts that have been entered.<\/p>\n\n\n\n<p>Table wp_users, not surprisingly, contains the names and email addresses of all members. It also stores all passwords in an encrypted format.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Beware<\/h2>\n\n\n\n<p>Do not make changes to the databases All changes are made through the website. One exception to this is deleting an activity. I&#8217;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&#8217;t be bothered to program it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Access from Control Panel, see section Web hosting. Click on &#8220;phpMyAdmin&#8221;, top left item in panel DATABASES. It will take a few seconds for this to open. Now click on the + sign beside &#8220;gentsinn&#8221; in the left hand panel. It will expand to show 2 databases: &#8220;gentsinn_gin_club_db&#8221; and &#8220;gentsinn_wrdp1&#8221;. Click on the + sign &hellip; <a href=\"https:\/\/ginclub.website\/home2\/gentsinnyon\/gin-club-home\/user-guide\/administrators-guide\/databases\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Databases&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":490,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1282","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-json\/wp\/v2\/pages\/1282","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-json\/wp\/v2\/comments?post=1282"}],"version-history":[{"count":3,"href":"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-json\/wp\/v2\/pages\/1282\/revisions"}],"predecessor-version":[{"id":2414,"href":"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-json\/wp\/v2\/pages\/1282\/revisions\/2414"}],"up":[{"embeddable":true,"href":"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-json\/wp\/v2\/pages\/490"}],"wp:attachment":[{"href":"https:\/\/ginclub.website\/home2\/gentsinnyon\/wp-json\/wp\/v2\/media?parent=1282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}