wp_tlwp_activity_logs
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| alert_id | BIGINT(20) | YES |
| object | VARCHAR(255) | NO |
| action | VARCHAR(255) | NO |
| user_roles | VARCHAR(255) | NO |
| username | VARCHAR(255) | YES |
| user_id | BIGINT(20) | YES |
| post_status | VARCHAR(255) | NO |
| post_type | VARCHAR(255) | NO |
| post_id | BIGINT(20) | NO |
| created_on | DOUBLE | NO |
| client_ip | VARCHAR(255) | NO |
| user_agent | VARCHAR(255) | NO |
| activity_log_id | BIGINT(20) UNSIGNED | NO |
| meta_key | VARCHAR(255) | YES |
| meta_value | LONGTEXT | YES |
| data | longtext | NO |
| identifier | char(13) | NO |
CREATE TABLE Statement
CREATE TABLE `wp_tlwp_activity_logs` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `alert_id` BIGINT(20) DEFAULT NULL, `object` VARCHAR(255) NOT NULL, `action` VARCHAR(255) NOT NULL, `user_roles` VARCHAR(255) NOT NULL, `username` VARCHAR(255) NULL, `user_id` BIGINT(20) NULL, `post_status` VARCHAR(255) NOT NULL, `post_type` VARCHAR(255) NOT NULL, `post_id` BIGINT(20) NOT NULL, `created_on` DOUBLE NOT NULL, `client_ip` VARCHAR(255) NOT NULL, `user_agent` VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) $collate; CREATE TABLE `wp_tlwp_activity_logs_meta` ( `meta_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `activity_log_id` BIGINT(20) UNSIGNED NOT NULL, `meta_key` VARCHAR(255) DEFAULT NULL, `meta_value` LONGTEXT DEFAULT NULL, PRIMARY KEY (meta_id), KEY activity_log_id (activity_log_id), KEY meta_key (meta_key) ) $collate; "; return $tables; } public static function get_tlwp_193_schema( $collate = '' ) { global $wpdb; $tables = " CREATE TABLE wp_tlwp_user_temp_import ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `data` longtext NOT NULL, `identifier` char(13) NOT NULL, PRIMARY KEY (ID) ) $collate; "; return $tables; } /** * Collect multiple version schema * * @param string $collate * * @return string * * @since 4.2.0 */ private static function get_schema( $collate = '' ) { $tables = self::get_tlwp_192_schema( $collate );Safe to delete?
If you have uninstalled Temporary Login Without Password, 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_tlwp_activity_logs`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Temporary Login Without Password