{"table_name":"cppu_unlocks","full_table_name":"wp_cppu_unlocks","description":"Stores cppu unlocks data created by this plugin.","detection_method":"static","confidence":"medium","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 );","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}],"plugin":{"slug":"capripio-paywall-unlock","name":"Pay to Unlock WooCommerce Paywall – Capripio","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/capripio-paywall-unlock/"}}