{"slug":"wp-user-avatar","name":"Paid Membership Plugin, Ecommerce, User Registration Form, Login Form, User Profile & Restrict Content – ProfilePress","description":"Setup paid membership, accept payment, sell subscription & digital product, paywall, create login & registration form, user profile & member directory","author":"properfraction","active_installs":100000,"version":"4.16.14","wp_org_url":"https://wordpress.org/plugins/wp-user-avatar/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"ppress_sessions","full_table_name":"wp_ppress_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"code","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"description","type":"mediumtext","nullable":true,"primary_key":false},{"name":"coupon_application","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"amount","type":"mediumtext","nullable":false,"primary_key":false},{"name":"unit","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"plan_ids","type":"mediumtext","nullable":true,"primary_key":false},{"name":"usage_limit","type":"mediumint(8) unsigned","nullable":true,"primary_key":false},{"name":"status","type":"enum('true','false')","nullable":false,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"private_note","type":"longtext","nullable":true,"primary_key":false},{"name":"total_spend","type":"decimal(18,9)","nullable":false,"primary_key":false},{"name":"purchase_count","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"last_login","type":"datetime","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":false,"primary_key":false},{"name":"session_key","type":"char(32)","nullable":false,"primary_key":false},{"name":"session_value","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"session_expiry","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"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');"}],"table_count":1}