{"slug":"capripio-paywall-unlock","name":"Pay to Unlock WooCommerce Paywall – Capripio","description":"Sell premium parts of any post in minutes. Lock content sections and charge readers to unlock them instantly via WooCommerce.","author":"Asif","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/capripio-paywall-unlock/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"cppu_analytics","full_table_name":"wp_cppu_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cppu_unlocks","full_table_name":"wp_cppu_unlocks","description":"Stores cppu unlocks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"post_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"section_key","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"order_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"token","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"section_key","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"event","type":"ENUM('view','unlock')","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cppu_unlocks ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, section_key VARCHAR(64) NOT NULL DEFAULT '', user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, order_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, email VARCHAR(200) NOT NULL DEFAULT '', token VARCHAR(64) NOT NULL DEFAULT '', expires_at DATETIME NULL DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY section_key (section_key), KEY user_id (user_id), KEY token (token), KEY order_id (order_id) ) $charset_collate;\"; // Analytics table. $sql_analytics = \"CREATE TABLE wp_cppu_analytics ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, section_key VARCHAR(64) NOT NULL DEFAULT '', event ENUM('view','unlock') NOT NULL DEFAULT 'view', created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY section_key (section_key), KEY event (event) ) $charset_collate;\"; dbDelta( $sql_unlocks );"}],"table_count":2}