wp_inpipe_subscription_log

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_inpipe_subscription_log ( id BIGINT(20) NOT NULL AUTO_INCREMENT, subscription_type VARCHAR(50) NOT NULL, payment_status VARCHAR(20) NOT NULL, previous_status VARCHAR(20) DEFAULT NULL, subscription_expiry TIMESTAMP NULL DEFAULT NULL, reason VARCHAR(255) DEFAULT NULL, webhook_id VARCHAR(50) DEFAULT NULL, created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_created_at (created_at), KEY idx_payment_status (payment_status), KEY idx_subscription_type (subscription_type) ) $charset_collate", // UTM tracking for free version. 'inpipe_utm_codes' => "CREATE TABLE wp_inpipe_utm_codes ( id CHAR(5) NOT NULL, utm_source VARCHAR(255) DEFAULT NULL, utm_medium VARCHAR(255) DEFAULT NULL, utm_campaign VARCHAR(255) DEFAULT NULL, utm_term VARCHAR(255) DEFAULT NULL, utm_content VARCHAR(255) DEFAULT NULL, utm_id VARCHAR(255) DEFAULT NULL, utm_custom1_key VARCHAR(30) DEFAULT NULL, utm_custom1_value VARCHAR(255) DEFAULT NULL, utm_custom2_key VARCHAR(30) DEFAULT NULL, utm_custom2_value VARCHAR(255) DEFAULT NULL, utm_custom3_key VARCHAR(30) DEFAULT NULL, utm_custom3_value VARCHAR(255) DEFAULT NULL, full_url TEXT DEFAULT NULL, coded_url TEXT DEFAULT NULL, created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_utm_source (utm_source), KEY idx_utm_medium (utm_medium), KEY idx_utm_campaign (utm_campaign) ) $charset_collate", // UTM dropdown options management - added in 1.1.1. 'inpipe_utm_options' => "CREATE TABLE wp_inpipe_utm_options ( id BIGINT(20) UNSIGNED AUTO_INCREMENT, field_name VARCHAR(20) NOT NULL COMMENT 'UTM field: source, medium, campaign, term, content, id', option_value VARCHAR(255) NOT NULL COMMENT 'Custom dropdown option value', is_default BOOLEAN DEFAULT FALSE COMMENT 'TRUE for seeded defaults, FALSE for user-added', created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY idx_field_value (field_name, option_value), KEY idx_field_name (field_name), KEY idx_is_default (is_default) ) $charset_collate", // Core settings table - enhanced for free version. 'inpipe_pluginsettings' => "CREATE TABLE wp_inpipe_pluginsettings ( id CHAR(5) NOT NULL, subscription_key VARCHAR(40) DEFAULT NULL, subscription_creation TIMESTAMP NULL DEFAULT NULL, subscription_expiry TIMESTAMP NULL DEFAULT NULL, subscription_name VARCHAR(100) DEFAULT NULL, subscription_type VARCHAR(20) DEFAULT 'free', subscription_status VARCHAR(20) DEFAULT 'inactive', subscription_user VARCHAR(10) DEFAULT NULL, plugin_install TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, event_tracking_url VARCHAR(255) DEFAULT NULL, last_valid_tracking_url_test TIMESTAMP NULL DEFAULT NULL, client_id VARCHAR(50) DEFAULT NULL, plan_type VARCHAR(50) DEFAULT NULL, utm_processing_enabled BOOLEAN DEFAULT FALSE, utm_tracking_enabled BOOLEAN DEFAULT FALSE, auto_clear_utm_records BOOLEAN DEFAULT FALSE, utm_retention_days INT DEFAULT 30, payment_status VARCHAR(20) DEFAULT 'inactive', last_payment_date TIMESTAMP NULL DEFAULT NULL, next_payment_date TIMESTAMP NULL DEFAULT NULL, billing_address TEXT DEFAULT NULL, contact_email VARCHAR(255) DEFAULT NULL, last_activity TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, api_key VARCHAR(255) DEFAULT NULL, event_categories JSON DEFAULT NULL, user_role VARCHAR(50) DEFAULT 'viewer', webhook_secret_unhashed VARCHAR(255) DEFAULT NULL, webhook_secret_hashed VARCHAR(255) DEFAULT NULL, trial_expiry_date TIMESTAMP NULL DEFAULT NULL, last_login_date TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, last_verification TIMESTAMP NULL DEFAULT NULL, next_verification TIMESTAMP NULL DEFAULT NULL, verification_failures INT DEFAULT 0, plugin_version VARCHAR(20) DEFAULT NULL, created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_subscription_type (subscription_type), KEY idx_subscription_status (subscription_status), KEY idx_payment_status (payment_status) ) $charset_collate", // License verification data. 'inpipe_verification_data' => "CREATE TABLE wp_inpipe_verification_data ( id BIGINT(20) UNSIGNED AUTO_INCREMENT, code VARCHAR(50) NOT NULL, status VARCHAR(20) NOT NULL DEFAULT '', last_check BIGINT(20) NOT NULL DEFAULT 0, attempts INT NOT NULL DEFAULT 0, verify_date TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, site_url VARCHAR(255) NOT NULL, created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_code (code), KEY idx_status (status) ) $charset_collate", );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_inpipe_subscription_log`;

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

Other tables from inPIPE by Seresa