wp_asnp_wepo_waitlist
StaticStores asnp wepo waitlist data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| product_id | BIGINT(20) UNSIGNED | NO |
| variation_id | BIGINT(20) UNSIGNED | NO |
| user_id | BIGINT(20) UNSIGNED | NO |
| VARCHAR(200) | NO | |
| type | VARCHAR(20) | NO |
| status | VARCHAR(20) | NO |
| consent | TINYINT(1) UNSIGNED | NO |
| language | VARCHAR(20) | NO |
| ip_address | VARCHAR(100) | NO |
| date_created | DATETIME | YES |
| date_notified | DATETIME | YES |
| name | VARCHAR(200) | NO |
| status | TINYINT(1) UNSIGNED | NO |
| type | VARCHAR(50) | NO |
| targets | LONGTEXT | YES |
| schedule | LONGTEXT | YES |
| options | LONGTEXT | YES |
CREATE TABLE Statement
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 );Safe to delete?
If you have uninstalled RestockBeacon Preorder & Back in Stock for WooCommerce, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_asnp_wepo_waitlist`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from RestockBeacon Preorder & Back in Stock for WooCommerce