wp_um_metadata
StaticStores additional metadata (key-value pairs) for um metadata records.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑umeta_id | bigint(20) unsigned | NO |
| user_id | bigint(20) unsigned | NO |
| um_key | varchar(255) | YES |
| um_value | longtext | YES |
CREATE TABLE Statement
CREATE TABLE wp_um_metadata ( umeta_id bigint(20) unsigned NOT NULL auto_increment, user_id bigint(20) unsigned NOT NULL default '0', um_key varchar(255) default NULL, um_value longtext default NULL, PRIMARY KEY (umeta_id), KEY user_id_indx (user_id), KEY meta_key_indx (um_key), KEY meta_value_indx (um_value(191)) ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );
Safe to delete?
If you have uninstalled Ultimate Member – User Profile, Registration, Login, Member Directory, Content Restriction & Membership 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_um_metadata`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Ultimate Member – User Profile, Registration, Login, Member Directory, Content Restriction & Membership Plugin