wp_gym_builder_members

Static

Stores gym builder members data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idINTYES
member_user_idVARCHAR(100)NO
member_nameVARCHAR(255)NO
member_addressTEXTNO
member_emailVARCHAR(100)YES
member_phoneVARCHAR(30)NO
member_ageINTYES
membership_statusTINYINT(1)YES
member_joining_dateDATEYES
membership_duration_startDATEYES
membership_duration_endDATEYES
member_genderVARCHAR(10)YES
attendance_countint(100)YES
package_name_idint(100)YES
membership_package_typeVARCHAR(30)YES
membership_package_nameVARCHAR(30)YES
membership_classesTEXTYES
file_urlVARCHAR(255)YES
schedule_weekdayTEXTYES
schedule_timeVARCHAR(30)YES
class_idint(100)YES
wp_user_idINTYES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `wp_gym_builder_members` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `member_user_id` VARCHAR(100) NOT NULL, `member_name` VARCHAR(255) NOT NULL, `member_address` TEXT NOT NULL, `member_email` VARCHAR(100) DEFAULT NULL, `member_phone` VARCHAR(30) NOT NULL, `member_age` INT DEFAULT NULL, `membership_status` TINYINT(1) DEFAULT 0, `member_joining_date` DATE DEFAULT NULL, `membership_duration_start` DATE DEFAULT NULL, `membership_duration_end` DATE DEFAULT NULL, `member_gender` VARCHAR(10) DEFAULT NULL, `attendance_count` int(100) DEFAULT NULL, `package_name_id` int(100) DEFAULT NULL, `membership_package_type` VARCHAR(30) DEFAULT NULL, `membership_package_name` VARCHAR(30) DEFAULT NULL, `membership_classes` TEXT DEFAULT NULL, `file_url` VARCHAR(255) DEFAULT NULL, `schedule_weekday` TEXT DEFAULT NULL, `schedule_time` VARCHAR(30) DEFAULT NULL, `class_id` int(100) DEFAULT NULL, `wp_user_id` INT DEFAULT NULL ) $charset_collate;"; dbDelta( $sql_query );

Safe to delete?

If you have uninstalled Gym Builder – Fitness Studio Booking, Class Schedule, Trainer Profiles, BMI Calculator & Member Management Plugin, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_gym_builder_members`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Gym Builder – Fitness Studio Booking, Class Schedule, Trainer Profiles, BMI Calculator & Member Management Plugin