wp_dreamcore_monitor_logins

Static

A logging table that records activity, events, or audit history.

Column Definitions

ColumnTypeNullable
🔑idBIGINT UNSIGNEDYES
usernameVARCHAR(100)NO
user_idBIGINT UNSIGNEDYES
user_roleVARCHAR(50)YES
statusVARCHAR(20)NO
ip_addressVARCHAR(45)NO
user_agentTEXTYES
countryVARCHAR(100)YES
created_atDATETIMEYES
exportedTINYINT(1)YES
exported_atDATETIMEYES
batch_idVARCHAR(100)YES

CREATE TABLE Statement

CREATE TABLE wp_dreamcore_monitor_logins ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(100) NOT NULL, user_id BIGINT UNSIGNED NULL, user_role VARCHAR(50) NULL, status VARCHAR(20) NOT NULL, ip_address VARCHAR(45) NOT NULL, user_agent TEXT NULL, country VARCHAR(100) DEFAULT 'Unknown', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, exported TINYINT(1) DEFAULT 0, exported_at DATETIME NULL, batch_id VARCHAR(100) NULL, INDEX idx_status (status), INDEX idx_created_at (created_at), INDEX idx_username (username), INDEX idx_ip_address (ip_address), INDEX idx_exported (exported), INDEX idx_exported_at (exported_at), INDEX idx_batch_id (batch_id) ) {$charset_collate}"; // Safe loading of upgrade.php with proper path handling $upgrade_file = wp_normalize_path( ABSPATH . 'wp-admin/includes/upgrade.php' );

Safe to delete?

If you have uninstalled DreamCore Monitor, 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_dreamcore_monitor_logins`;

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

Other tables from DreamCore Monitor