wp_id4me_authorities

Static

Stores id4me authorities data created by this plugin.

Column Definitions

Column	Type	Nullable
🔑authority_id	bigint(20) unsigned	NO
authority_hostname	varchar(150)	NO
authority_registered	datetime	NO
authority_expired	datetime	YES
authority_configuration	text	NO
client_id	varchar(255)	NO
client_secret	varchar(255)	NO
client	TEXT	YES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `wp_id4me_authorities` ( `authority_id` bigint(20) unsigned NOT NULL auto_increment, `authority_hostname` varchar(150) NOT NULL, `authority_registered` datetime NOT NULL default '0000-00-00 00:00:00', `authority_expired` datetime NULL, `authority_configuration` text NOT NULL, `client_id` varchar(255) NOT NULL, `client_secret` varchar(255) NOT NULL, `client` TEXT, PRIMARY KEY (`authority_id`), UNIQUE (`authority_hostname`) ) $charset_collate;" // phpcs:ignore );

Safe to delete?

If you have uninstalled ID4me, 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_id4me_authorities`;

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