{"slug":"ultimate-member","name":"Ultimate Member – User Profile, Registration, Login, Member Directory, Content Restriction & Membership Plugin","description":"Membership & community plugin with user profiles, registration & login, member directories, content restriction, user roles and much more.","author":"Ultimate Member","active_installs":200000,"version":"2.11.3","wp_org_url":"https://wordpress.org/plugins/ultimate-member/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"um_groups_members","full_table_name":"wp_um_groups_members","description":"Stores um groups members data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"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","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}],"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 );"}],"table_count":4}