{"table_name":"alertify_subscriptions","full_table_name":"wp_alertify_subscriptions","description":"Stores alertify subscriptions data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_alertify_subscriptions ( id bigint(20) NOT NULL AUTO_INCREMENT, product_id bigint(20) NOT NULL, variation_id bigint(20) DEFAULT NULL, email varchar(100) NOT NULL, name varchar(100) DEFAULT NULL, phone varchar(20) DEFAULT NULL, status varchar(20) DEFAULT 'pending', created_at datetime DEFAULT CURRENT_TIMESTAMP, notified_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY product_id (product_id), KEY email (email), KEY status (status) ) $charset_collate;\"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php');","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"variation_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"notified_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"alertify","name":"Alertify – Back in Stock WooCommerce Alerts & Email Notifications","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/alertify/"}}