wp_goldtwmcp_oauth_clients
StaticStores goldtwmcp oauth clients data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| client_id | VARCHAR(80) | NO |
| client_name | VARCHAR(255) | NO |
| client_type | VARCHAR(20) | NO |
| redirect_uris | TEXT | YES |
| allowed_scopes | TEXT | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| code | VARCHAR(128) | NO |
| client_id | VARCHAR(80) | NO |
| user_id | BIGINT(20) UNSIGNED | NO |
| redirect_uri | VARCHAR(500) | YES |
| code_challenge | VARCHAR(128) | YES |
| code_challenge_method | VARCHAR(10) | YES |
| scopes | TEXT | YES |
| expires_at | DATETIME | NO |
| used_at | DATETIME | YES |
| created_at | DATETIME | NO |
| token | VARCHAR(255) | NO |
| refresh_token | VARCHAR(255) | YES |
| client_id | VARCHAR(80) | NO |
| user_id | BIGINT(20) UNSIGNED | NO |
| scopes | TEXT | YES |
| expires_at | DATETIME | NO |
| refresh_token_expires_at | DATETIME | YES |
| revoked_at | DATETIME | YES |
| created_at | DATETIME | NO |
| token_prefix | VARCHAR(16) | NO |
| user_id | BIGINT(20) UNSIGNED | NO |
| client_id | VARCHAR(80) | NO |
| scope | VARCHAR(255) | NO |
| issued_at | BIGINT(20) UNSIGNED | NO |
| expires_at | BIGINT(20) UNSIGNED | NO |
| last_used_at | BIGINT(20) UNSIGNED | YES |
| revoked_at | BIGINT(20) UNSIGNED | YES |
| revoked_by | BIGINT(20) UNSIGNED | YES |
| source | ENUM('generator','oauth','refresh') | NO |
| ip_address | VARCHAR(45) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_goldtwmcp_oauth_clients ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, client_id VARCHAR(80) NOT NULL, client_name VARCHAR(255) NOT NULL, client_type VARCHAR(20) NOT NULL DEFAULT 'public', redirect_uris TEXT DEFAULT NULL, allowed_scopes TEXT DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY client_id (client_id) ) $charset_collate;"; $sql_codes = "CREATE TABLE IF NOT EXISTS wp_goldtwmcp_oauth_codes ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, code VARCHAR(128) NOT NULL, client_id VARCHAR(80) NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, redirect_uri VARCHAR(500) DEFAULT NULL, code_challenge VARCHAR(128) DEFAULT NULL, code_challenge_method VARCHAR(10) DEFAULT NULL, scopes TEXT DEFAULT NULL, expires_at DATETIME NOT NULL, used_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY code (code), KEY expires_at (expires_at), KEY client_id (client_id), KEY user_id (user_id) ) $charset_collate;"; $sql_tokens = "CREATE TABLE IF NOT EXISTS wp_goldtwmcp_oauth_tokens ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, token VARCHAR(255) NOT NULL, refresh_token VARCHAR(255) DEFAULT NULL, client_id VARCHAR(80) NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, scopes TEXT DEFAULT NULL, expires_at DATETIME NOT NULL, refresh_token_expires_at DATETIME DEFAULT NULL, revoked_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY token (token), UNIQUE KEY refresh_token (refresh_token), KEY user_id (user_id), KEY client_id (client_id), KEY expires_at (expires_at) ) $charset_collate;"; $sql_token_registry = "CREATE TABLE IF NOT EXISTS wp_aiconnect_token_registry ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, token_prefix VARCHAR(16) NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, client_id VARCHAR(80) NOT NULL, scope VARCHAR(255) NOT NULL, issued_at BIGINT(20) UNSIGNED NOT NULL, expires_at BIGINT(20) UNSIGNED NOT NULL, last_used_at BIGINT(20) UNSIGNED DEFAULT NULL, revoked_at BIGINT(20) UNSIGNED DEFAULT NULL, revoked_by BIGINT(20) UNSIGNED DEFAULT NULL, source ENUM('generator','oauth','refresh') NOT NULL DEFAULT 'oauth', ip_address VARCHAR(45) DEFAULT NULL, PRIMARY KEY (id), KEY token_prefix (token_prefix), KEY user_id (user_id), KEY revoked_at (revoked_at) ) $charset_collate;"; dbDelta( $sql_clients );Safe to delete?
If you have uninstalled GoldT WebMCP Bridge, 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_goldtwmcp_oauth_clients`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from GoldT WebMCP Bridge