{"table_name":"um_metadata","full_table_name":"wp_um_metadata","description":"Stores additional metadata (key-value pairs) for um metadata records.","detection_method":"static","confidence":"high","create_sql":"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 );","columns":[{"name":"umeta_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"um_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"um_value","type":"longtext","nullable":true,"primary_key":false}],"plugin":{"slug":"ultimate-member","name":"Ultimate Member – User Profile, Registration, Login, Member Directory, Content Restriction & Membership Plugin","active_installs":200000,"version":"2.11.3","wp_org_url":"https://wordpress.org/plugins/ultimate-member/"}}