wp_ppress_sessions

Static

Stores session data for tracking user or visitor state.

Column Definitions

Column	Type	Nullable
🔑id	bigint(20) unsigned	NO
code	varchar(50)	NO
description	mediumtext	YES
coupon_application	varchar(50)	NO
type	varchar(50)	NO
amount	mediumtext	NO
unit	varchar(50)	NO
plan_ids	mediumtext	YES
usage_limit	mediumint(8) unsigned	YES
status	enum('true','false')	NO
start_date	date	YES
end_date	date	YES
user_id	bigint(20) unsigned	YES
private_note	longtext	YES
total_spend	decimal(18,9)	NO
purchase_count	bigint(20) unsigned	NO
last_login	datetime	YES
date_created	datetime	NO
session_key	char(32)	NO
session_value	LONGTEXT	NO
session_expiry	BIGINT(20) UNSIGNED	NO

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS $coupons_table ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, code varchar(50) NOT NULL, description mediumtext, coupon_application varchar(50) NOT NULL, type varchar(50) NOT NULL, amount mediumtext NOT NULL, unit varchar(50) NOT NULL, plan_ids mediumtext, usage_limit mediumint(8) unsigned DEFAULT NULL, status enum('true','false') NOT NULL DEFAULT 'true', start_date date DEFAULT NULL, end_date date DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY code (code), KEY type (type), KEY status (status) ) $collate; "; $sqls[] = "CREATE TABLE IF NOT EXISTS $customers_table ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned DEFAULT NULL, private_note longtext, total_spend decimal(18,9) NOT NULL DEFAULT '0.000000000', purchase_count bigint(20) unsigned NOT NULL DEFAULT '0', last_login datetime DEFAULT NULL, date_created datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY user_id (user_id), KEY date_created (date_created) ) $collate; "; $sqls[] = "CREATE TABLE wp_ppress_sessions ( session_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, session_key char(32) NOT NULL, session_value LONGTEXT NOT NULL, session_expiry BIGINT(20) UNSIGNED NOT NULL, PRIMARY KEY (session_key), UNIQUE KEY session_id (session_id) ) $collate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

Safe to delete?

If you have uninstalled Paid Membership Plugin, Ecommerce, User Registration Form, Login Form, User Profile & Restrict Content – ProfilePress, 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_ppress_sessions`;

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