{"slug":"restockbeacon-preorder-back-in-stock-for-woocommerce","name":"RestockBeacon Preorder & Back in Stock for WooCommerce","description":"Preorder, backorder & back in stock waitlist for WooCommerce. Email a \"Notify Me\" alert the moment out of stock products are available again.","author":"AsanaPlugins","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/restockbeacon-preorder-back-in-stock-for-woocommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"asnp_wepo_campaigns","full_table_name":"wp_asnp_wepo_campaigns","description":"Stores asnp wepo campaigns data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"asnp_wepo_waitlist","full_table_name":"wp_asnp_wepo_waitlist","description":"Stores asnp wepo waitlist data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"product_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"variation_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"consent","type":"TINYINT(1) UNSIGNED","nullable":false,"primary_key":false},{"name":"language","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":true,"primary_key":false},{"name":"date_notified","type":"DATETIME","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"status","type":"TINYINT(1) UNSIGNED","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"targets","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"schedule","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"options","type":"LONGTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_asnp_wepo_waitlist ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, product_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, variation_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, email VARCHAR(200) NOT NULL DEFAULT '', type VARCHAR(20) NOT NULL DEFAULT 'back_in_stock', status VARCHAR(20) NOT NULL DEFAULT 'pending', consent TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, language VARCHAR(20) NOT NULL DEFAULT '', ip_address VARCHAR(100) NOT NULL DEFAULT '', date_created DATETIME NULL DEFAULT NULL, date_notified DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), KEY product_id (product_id), KEY variation_id (variation_id), KEY user_id (user_id), KEY email (email(191)), KEY status (status) ) $collate; CREATE TABLE wp_asnp_wepo_campaigns ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(200) NOT NULL DEFAULT '', status TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, type VARCHAR(50) NOT NULL DEFAULT 'preorder', targets LONGTEXT NULL, schedule LONGTEXT NULL, options LONGTEXT NULL, PRIMARY KEY (id), KEY type (type), KEY status (status) ) $collate;\"; return $tables; } /** * Update the stored plugin version. * * @since 1.0.0 * @return void */ private static function update_version() { update_option( self::VERSION_OPTION, get_plugin()->version );"}],"table_count":2}