{"table_name":"inpipe_subscription_log","full_table_name":"wp_inpipe_subscription_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"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\", );","columns":[{"name":"id","type":"BIGINT(20)","nullable":false,"primary_key":true},{"name":"subscription_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"payment_status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"previous_status","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"subscription_expiry","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"reason","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"webhook_id","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"utm_source","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"utm_medium","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"utm_campaign","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"utm_term","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"utm_content","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"utm_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"utm_custom1_key","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"utm_custom1_value","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"utm_custom2_key","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"utm_custom2_value","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"utm_custom3_key","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"utm_custom3_value","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"full_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"coded_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"field_name","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"option_value","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"is_default","type":"BOOLEAN","nullable":true,"primary_key":false},{"name":"FALSE","type":"for","nullable":true,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"subscription_key","type":"VARCHAR(40)","nullable":true,"primary_key":false},{"name":"subscription_creation","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"subscription_expiry","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"subscription_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"subscription_type","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"subscription_status","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"subscription_user","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"plugin_install","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"event_tracking_url","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"last_valid_tracking_url_test","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"client_id","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"plan_type","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"utm_processing_enabled","type":"BOOLEAN","nullable":true,"primary_key":false},{"name":"utm_tracking_enabled","type":"BOOLEAN","nullable":true,"primary_key":false},{"name":"auto_clear_utm_records","type":"BOOLEAN","nullable":true,"primary_key":false},{"name":"utm_retention_days","type":"INT","nullable":true,"primary_key":false},{"name":"payment_status","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"last_payment_date","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"next_payment_date","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"billing_address","type":"TEXT","nullable":true,"primary_key":false},{"name":"contact_email","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"last_activity","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"api_key","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"event_categories","type":"JSON","nullable":true,"primary_key":false},{"name":"user_role","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"webhook_secret_unhashed","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"webhook_secret_hashed","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"trial_expiry_date","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"last_login_date","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"last_verification","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"next_verification","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"verification_failures","type":"INT","nullable":true,"primary_key":false},{"name":"plugin_version","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"code","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"last_check","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"attempts","type":"INT","nullable":false,"primary_key":false},{"name":"verify_date","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"site_url","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"TIMESTAMP","nullable":true,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":true,"primary_key":false}],"plugin":{"slug":"inpipe-by-seresa","name":"inPIPE by Seresa","active_installs":0,"version":"1.1.1","wp_org_url":"https://wordpress.org/plugins/inpipe-by-seresa/"}}