wp_bsxfe_pairs

Column Definitions

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_bsxfe_pairs ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, host_user_id BIGINT(20) UNSIGNED NOT NULL, guest_user_id BIGINT(20) UNSIGNED NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'active', notes 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 unique_pair (host_user_id, guest_user_id), KEY idx_host (host_user_id), KEY idx_guest (guest_user_id), KEY idx_status (status) ) $charset;"; // ── pd_files ──────────────────────────────────────────────────────── // Every file belongs to a pair. Both sides can upload. // filepath is relative to BSXFE_UPLOAD_DIR — never a public URL. // access_token is the only way to download; it is single-use-safe via // activity logging + permission check on every request. $sql_files = "CREATE TABLE IF NOT EXISTS wp_bsxfe_files ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, pair_id BIGINT(20) UNSIGNED NOT NULL, uploader_id BIGINT(20) UNSIGNED NOT NULL, original_name VARCHAR(255) NOT NULL, stored_name VARCHAR(255) NOT NULL, filepath VARCHAR(500) NOT NULL, filesize BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, filetype VARCHAR(20) NOT NULL DEFAULT '', mime_type VARCHAR(100) NOT NULL DEFAULT '', message TEXT DEFAULT NULL, access_token VARCHAR(64) NOT NULL, uploaded_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, expires_at DATETIME DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY idx_token (access_token), KEY idx_pair (pair_id), KEY idx_uploader (uploader_id), KEY idx_uploaded (uploaded_at) ) $charset;"; // ── pd_notifications ──────────────────────────────────────────────── // One row per email sent. Tracks delivery and read state. $sql_notifications = "CREATE TABLE IF NOT EXISTS wp_bsxfe_notifications ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, file_id BIGINT(20) UNSIGNED NOT NULL, recipient_id BIGINT(20) UNSIGNED NOT NULL, type VARCHAR(50) NOT NULL DEFAULT 'new_file', status VARCHAR(20) NOT NULL DEFAULT 'sent', sent_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, read_at DATETIME DEFAULT NULL, PRIMARY KEY (id), KEY idx_file (file_id), KEY idx_recipient (recipient_id), KEY idx_status (status) ) $charset;"; // ── pd_activity ───────────────────────────────────────────────────── // Audit log: upload, download, delete, view events. $sql_activity = "CREATE TABLE IF NOT EXISTS wp_bsxfe_activity ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, file_id BIGINT(20) UNSIGNED NOT NULL, user_id BIGINT(20) UNSIGNED NOT NULL, action VARCHAR(50) NOT NULL, ip_address VARCHAR(45) NOT NULL DEFAULT '', user_agent VARCHAR(255) NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_file (file_id), KEY idx_user (user_id), KEY idx_action (action), KEY idx_created (created_at) ) $charset;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql_pairs );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_bsxfe_pairs`;

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

Other tables from BSX File Exchange