wp_mailmaga_x_users
StaticStores mailmaga x users data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑user_id | BIGINT( 20 ) unsigned | NO |
| user_name | VARCHAR( 100 ) | YES |
| user_email | VARCHAR( 100 ) | NO |
| user_group | VARCHAR( 100 ) | YES |
| server_name | VARCHAR( 100 ) | NO |
| type | VARCHAR( 50 ) | YES |
| sleep | INT( 2 ) | YES |
| host | VARCHAR( 50 ) | YES |
| auth | INT( 1 ) | YES |
| port | VARCHAR( 10 ) | YES |
| account | VARCHAR( 100 ) | YES |
| password | VARCHAR( 100 ) | YES |
| title | VARCHAR( 255 ) | NO |
| content | TEXT | NO |
| user_ids | TEXT | NO |
| server_ids | TEXT | NO |
| created_time | datetime | NO |
| mail_id | BIGINT( 20 ) | NO |
| user_id | VARCHAR( 50 ) | NO |
| secret_key | VARCHAR( 100 ) | NO |
| success | INT( 1 ) | YES |
| error | TEXT | YES |
| created_time | datetime | NO |
| opened_time | datetime | YES |
| is_html | INT( 1 ) | YES |
CREATE TABLE Statement
CREATE TABLE wp_mailmaga_x_users ( user_id BIGINT( 20 ) unsigned NOT NULL AUTO_INCREMENT, user_name VARCHAR( 100 ) DEFAULT NULL , user_email VARCHAR( 100 ) NOT NULL DEFAULT '' , user_group VARCHAR( 100 ) DEFAULT NULL , PRIMARY KEY (user_id) ) {$charset_collate};"; $sqls[] = "CREATE TABLE wp_mailmaga_x_servers ( server_id BIGINT( 20 ) unsigned NOT NULL AUTO_INCREMENT, server_name VARCHAR( 100 ) NOT NULL DEFAULT '' , type VARCHAR( 50 ) DEFAULT NULL , sleep INT( 2 ) DEFAULT '0' , host VARCHAR( 50 ) DEFAULT NULL , auth INT( 1 ) DEFAULT 1 , port VARCHAR( 10 ) DEFAULT NULL , account VARCHAR( 100 ) DEFAULT NULL , password VARCHAR( 100 ) DEFAULT NULL , PRIMARY KEY (server_id) ) {$charset_collate};"; $sqls[] = "CREATE TABLE wp_mailmaga_x_mails ( mail_id BIGINT( 20 ) unsigned NOT NULL AUTO_INCREMENT, title VARCHAR( 255 ) NOT NULL DEFAULT '', content TEXT NOT NULL DEFAULT '' , user_ids TEXT NOT NULL DEFAULT '' , server_ids TEXT NOT NULL DEFAULT '' , created_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00' , PRIMARY KEY (mail_id) ) {$charset_collate};"; $sqls[] = "CREATE TABLE wp_mailmaga_x_historys ( history_id BIGINT( 20 ) unsigned NOT NULL AUTO_INCREMENT, mail_id BIGINT( 20 ) NOT NULL , user_id VARCHAR( 50 ) NOT NULL , secret_key VARCHAR( 100 ) NOT NULL DEFAULT '' , success INT( 1 ) DEFAULT 0 , error TEXT DEFAULT NULL , created_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00' , opened_time datetime DEFAULT NULL , is_html INT( 1 ) DEFAULT 0 , PRIMARY KEY (history_id) ) {$charset_collate};"; $sqls[] = "INSERT INTO wp_mailmaga_x_servers ( server_id, server_name, type, sleep, host, auth, port, account, password) VALUES (NULL, '" . __('localhost') . "', 'mail', 0, 'localhost', 0, '', '', '');Safe to delete?
If you have uninstalled Mailmaga-X, 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_mailmaga_x_users`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Mailmaga-X