wp_asnp_weuc_upsell_cross_sell
StaticStores asnp weuc upsell cross sell data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| name | varchar(200) | NO |
| status | TINYINT UNSIGNED | NO |
| items | longtext | YES |
| targets | longtext | YES |
| filters | longtext | YES |
| conditions | longtext | YES |
| schedule | longtext | YES |
| styles | longtext | YES |
| upsell_type | varchar(200) | NO |
| position | varchar(200) | NO |
| css_selector | varchar(200) | NO |
| type | varchar(200) | NO |
| theme | varchar(200) | NO |
| theme_size | varchar(200) | NO |
| trigger_name | varchar(200) | NO |
| custom_trigger | varchar(200) | NO |
| options | longtext | YES |
CREATE TABLE Statement
CREATE TABLE wp_asnp_weuc_upsell_cross_sell ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', status TINYINT UNSIGNED NOT NULL DEFAULT '1', items longtext NULL, targets longtext NULL, filters longtext NULL, conditions longtext NULL, schedule longtext NULL, styles longtext NULL, upsell_type varchar(200) NOT NULL DEFAULT '', position varchar(200) NOT NULL DEFAULT '', css_selector varchar(200) NOT NULL DEFAULT '', type varchar(200) NOT NULL DEFAULT '', theme varchar(200) NOT NULL DEFAULT '', theme_size varchar(200) NOT NULL DEFAULT '', trigger_name varchar(200) NOT NULL DEFAULT '', custom_trigger varchar(200) NOT NULL DEFAULT '', options longtext NULL, PRIMARY KEY (id) ) $collate;"; return $tables; } /** * Update plugin version to current. */ private static function update_version() { update_option( self::VERSION_OPTION, get_plugin()->version );Safe to delete?
If you have uninstalled Easy Upsells, Related Products & Product Recommendations 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_weuc_upsell_cross_sell`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.