{"table_name":"id4me_authorities","full_table_name":"wp_id4me_authorities","description":"Stores id4me authorities data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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 );","columns":[{"name":"authority_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"authority_hostname","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"authority_registered","type":"datetime","nullable":false,"primary_key":false},{"name":"authority_expired","type":"datetime","nullable":true,"primary_key":false},{"name":"authority_configuration","type":"text","nullable":false,"primary_key":false},{"name":"client_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"client_secret","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"client","type":"TEXT","nullable":true,"primary_key":false}],"plugin":{"slug":"id4me","name":"ID4me","active_installs":10,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/id4me/"}}