wp_b2b_quotes
StaticStores b2b quotes data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| quote_number | VARCHAR(32) | NO |
| customer_id | BIGINT UNSIGNED | NO |
| customer_name | VARCHAR(200) | NO |
| customer_email | VARCHAR(200) | NO |
| status | VARCHAR(50) | NO |
| subtotal | DECIMAL(20,6) | NO |
| discount | DECIMAL(20,6) | NO |
| total | DECIMAL(20,6) | NO |
| currency | VARCHAR(10) | NO |
| note_customer | LONGTEXT | YES |
| note_admin | LONGTEXT | YES |
| expires_at | DATETIME | YES |
| converted_order_id | BIGINT UNSIGNED | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| quote_id | BIGINT UNSIGNED | NO |
| product_id | BIGINT UNSIGNED | NO |
| variation_id | BIGINT UNSIGNED | NO |
| name | VARCHAR(200) | NO |
| sku | VARCHAR(100) | NO |
| quantity | DECIMAL(10,2) | NO |
| unit_price | DECIMAL(20,6) | NO |
| line_total | DECIMAL(20,6) | NO |
| meta_data | LONGTEXT | YES |
| quote_id | BIGINT UNSIGNED | NO |
| author_id | BIGINT UNSIGNED | NO |
| type | VARCHAR(20) | NO |
| content | LONGTEXT | NO |
| created_at | DATETIME | NO |
| rule_type | VARCHAR(50) | NO |
| role | VARCHAR(100) | NO |
| user_id | BIGINT UNSIGNED | NO |
| product_id | BIGINT UNSIGNED | NO |
| category_id | BIGINT UNSIGNED | NO |
| min_qty | DECIMAL(10,2) | NO |
| max_qty | DECIMAL(10,2) | NO |
| discount_type | VARCHAR(20) | NO |
| discount_value | DECIMAL(20,6) | NO |
| fixed_price | DECIMAL(20,6) | NO |
| priority | INT | NO |
| created_at | DATETIME | NO |
| user_id | BIGINT UNSIGNED | NO |
| company_name | VARCHAR(200) | NO |
| vat_number | VARCHAR(100) | NO |
| phone | VARCHAR(50) | NO |
| country | VARCHAR(10) | NO |
| status | VARCHAR(20) | NO |
| notes | LONGTEXT | YES |
| documents | LONGTEXT | YES |
| reviewed_by | BIGINT UNSIGNED | NO |
| reviewed_at | DATETIME | YES |
| created_at | DATETIME | NO |
| type | VARCHAR(50) | NO |
| name | VARCHAR(200) | NO |
| VARCHAR(200) | NO | |
| phone | VARCHAR(100) | NO |
| product_id | BIGINT UNSIGNED | NO |
| message | LONGTEXT | YES |
| source | VARCHAR(100) | NO |
| utm_source | VARCHAR(100) | NO |
| utm_medium | VARCHAR(100) | NO |
| utm_campaign | VARCHAR(100) | NO |
| status | VARCHAR(20) | NO |
| assigned_to | BIGINT UNSIGNED | NO |
| crm_contact_id | VARCHAR(200) | NO |
| meta | LONGTEXT | YES |
| created_at | DATETIME | NO |
| user_id | BIGINT UNSIGNED | NO |
| label | VARCHAR(200) | NO |
| cart_data | LONGTEXT | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| rule_key | VARCHAR(100) | NO |
| object_id | BIGINT UNSIGNED | NO |
| object_type | VARCHAR(50) | NO |
| status | VARCHAR(20) | NO |
| meta | LONGTEXT | YES |
| created_at | DATETIME | NO |
| event_type | VARCHAR(100) | NO |
| user_id | BIGINT UNSIGNED | NO |
| object_id | BIGINT UNSIGNED | NO |
| object_type | VARCHAR(50) | NO |
| value | DECIMAL(20,6) | NO |
| meta | LONGTEXT | YES |
| created_at | DATETIME | NO |
| rep_user_id | BIGINT UNSIGNED | NO |
| customer_id | BIGINT UNSIGNED | NO |
| team | VARCHAR(100) | NO |
| commission | DECIMAL(5,2) | NO |
| created_at | DATETIME | NO |
| user_id | BIGINT UNSIGNED | NO |
| type | VARCHAR(50) | NO |
| title | VARCHAR(255) | NO |
| message | LONGTEXT | NO |
| link | VARCHAR(500) | NO |
| read_at | DATETIME | YES |
| created_at | DATETIME | NO |
| name | VARCHAR(255) | NO |
| start_date | DATE | YES |
| end_date | DATE | YES |
| status | VARCHAR(20) | NO |
| priority | INT | NO |
| created_at | DATETIME | NO |
| price_book_id | BIGINT UNSIGNED | NO |
| item_type | VARCHAR(20) | NO |
| object_id | BIGINT UNSIGNED | NO |
| price_type | VARCHAR(30) | NO |
| value | DECIMAL(20,6) | NO |
| created_at | DATETIME | NO |
| price_book_id | BIGINT UNSIGNED | NO |
| user_id | BIGINT UNSIGNED | NO |
| company_id | BIGINT UNSIGNED | NO |
| created_at | DATETIME | NO |
| user_id | BIGINT UNSIGNED | NO |
| credit_limit | DECIMAL(20,6) | NO |
| balance_used | DECIMAL(20,6) | NO |
| terms | VARCHAR(20) | NO |
| status | VARCHAR(20) | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| name | VARCHAR(255) | NO |
| admin_user_id | BIGINT UNSIGNED | NO |
| vat_number | VARCHAR(100) | NO |
| credit_limit | DECIMAL(20,6) | NO |
| status | VARCHAR(20) | NO |
| created_at | DATETIME | NO |
| company_id | BIGINT UNSIGNED | NO |
| user_id | BIGINT UNSIGNED | NO |
| member_role | VARCHAR(20) | NO |
| joined_at | DATETIME | NO |
| rule_type | VARCHAR(20) | NO |
| object_id | BIGINT UNSIGNED | NO |
| roles | LONGTEXT | YES |
| companies | LONGTEXT | YES |
| action | VARCHAR(10) | NO |
| priority | INT | NO |
| created_at | DATETIME | NO |
| order_id | BIGINT UNSIGNED | NO |
| invoice_number | VARCHAR(50) | NO |
| user_id | BIGINT UNSIGNED | NO |
| total | DECIMAL(20,6) | NO |
| status | VARCHAR(20) | NO |
| issued_at | DATETIME | NO |
| due_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_b2b_quotes ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, quote_number VARCHAR(32) NOT NULL UNIQUE, customer_id BIGINT UNSIGNED NOT NULL DEFAULT 0, customer_name VARCHAR(200) NOT NULL DEFAULT '', customer_email VARCHAR(200) NOT NULL DEFAULT '', status VARCHAR(50) NOT NULL DEFAULT 'pending', subtotal DECIMAL(20,6) NOT NULL DEFAULT 0, discount DECIMAL(20,6) NOT NULL DEFAULT 0, total DECIMAL(20,6) NOT NULL DEFAULT 0, currency VARCHAR(10) NOT NULL DEFAULT 'USD', note_customer LONGTEXT NULL, note_admin LONGTEXT NULL, expires_at DATETIME NULL, converted_order_id BIGINT UNSIGNED NULL DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_customer (customer_id), KEY idx_status (status), KEY idx_created (created_at) ) $charset; CREATE TABLE wp_b2b_quote_items ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, quote_id BIGINT UNSIGNED NOT NULL, product_id BIGINT UNSIGNED NOT NULL, variation_id BIGINT UNSIGNED NOT NULL DEFAULT 0, name VARCHAR(200) NOT NULL DEFAULT '', sku VARCHAR(100) NOT NULL DEFAULT '', quantity DECIMAL(10,2) NOT NULL DEFAULT 1, unit_price DECIMAL(20,6) NOT NULL DEFAULT 0, line_total DECIMAL(20,6) NOT NULL DEFAULT 0, meta_data LONGTEXT NULL, PRIMARY KEY (id), KEY idx_quote (quote_id) ) $charset; CREATE TABLE wp_b2b_quote_notes ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, quote_id BIGINT UNSIGNED NOT NULL, author_id BIGINT UNSIGNED NOT NULL DEFAULT 0, type VARCHAR(20) NOT NULL DEFAULT 'admin', content LONGTEXT NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_quote (quote_id) ) $charset; CREATE TABLE wp_b2b_pricing_rules ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, rule_type VARCHAR(50) NOT NULL DEFAULT 'role', role VARCHAR(100) NOT NULL DEFAULT '', user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, product_id BIGINT UNSIGNED NOT NULL DEFAULT 0, category_id BIGINT UNSIGNED NOT NULL DEFAULT 0, min_qty DECIMAL(10,2) NOT NULL DEFAULT 0, max_qty DECIMAL(10,2) NOT NULL DEFAULT 0, discount_type VARCHAR(20) NOT NULL DEFAULT 'percentage', discount_value DECIMAL(20,6) NOT NULL DEFAULT 0, fixed_price DECIMAL(20,6) NOT NULL DEFAULT 0, priority INT NOT NULL DEFAULT 10, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_role (role), KEY idx_product (product_id), KEY idx_category (category_id), KEY idx_rule_type (rule_type) ) $charset; CREATE TABLE wp_b2b_registrations ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, company_name VARCHAR(200) NOT NULL DEFAULT '', vat_number VARCHAR(100) NOT NULL DEFAULT '', phone VARCHAR(50) NOT NULL DEFAULT '', country VARCHAR(10) NOT NULL DEFAULT '', status VARCHAR(20) NOT NULL DEFAULT 'pending', notes LONGTEXT NULL, documents LONGTEXT NULL, reviewed_by BIGINT UNSIGNED NOT NULL DEFAULT 0, reviewed_at DATETIME NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_user (user_id), KEY idx_status (status) ) $charset; CREATE TABLE wp_b2b_leads ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, type VARCHAR(50) NOT NULL DEFAULT 'inquiry', name VARCHAR(200) NOT NULL DEFAULT '', email VARCHAR(200) NOT NULL DEFAULT '', phone VARCHAR(100) NOT NULL DEFAULT '', product_id BIGINT UNSIGNED NOT NULL DEFAULT 0, message LONGTEXT NULL, source VARCHAR(100) NOT NULL DEFAULT '', utm_source VARCHAR(100) NOT NULL DEFAULT '', utm_medium VARCHAR(100) NOT NULL DEFAULT '', utm_campaign VARCHAR(100) NOT NULL DEFAULT '', status VARCHAR(20) NOT NULL DEFAULT 'new', assigned_to BIGINT UNSIGNED NOT NULL DEFAULT 0, crm_contact_id VARCHAR(200) NOT NULL DEFAULT '', meta LONGTEXT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_status (status), KEY idx_product (product_id), KEY idx_email (email(100)) ) $charset; CREATE TABLE wp_b2b_saved_carts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, label VARCHAR(200) NOT NULL DEFAULT '', cart_data LONGTEXT NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_user (user_id) ) $charset; CREATE TABLE wp_b2b_automation_logs ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, rule_key VARCHAR(100) NOT NULL DEFAULT '', object_id BIGINT UNSIGNED NOT NULL DEFAULT 0, object_type VARCHAR(50) NOT NULL DEFAULT '', status VARCHAR(20) NOT NULL DEFAULT 'sent', meta LONGTEXT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_rule (rule_key), KEY idx_object (object_id, object_type) ) $charset; CREATE TABLE wp_b2b_analytics_events ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, event_type VARCHAR(100) NOT NULL DEFAULT '', user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, object_id BIGINT UNSIGNED NOT NULL DEFAULT 0, object_type VARCHAR(50) NOT NULL DEFAULT '', value DECIMAL(20,6) NOT NULL DEFAULT 0, meta LONGTEXT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_event (event_type), KEY idx_user (user_id), KEY idx_created (created_at) ) $charset; CREATE TABLE wp_b2b_sales_reps ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, rep_user_id BIGINT UNSIGNED NOT NULL, customer_id BIGINT UNSIGNED NOT NULL DEFAULT 0, team VARCHAR(100) NOT NULL DEFAULT '', commission DECIMAL(5,2) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_rep (rep_user_id), KEY idx_customer (customer_id) ) $charset; CREATE TABLE wp_b2b_notifications ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, type VARCHAR(50) NOT NULL DEFAULT '', title VARCHAR(255) NOT NULL DEFAULT '', message LONGTEXT NOT NULL, link VARCHAR(500) NOT NULL DEFAULT '', read_at DATETIME NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_user (user_id), KEY idx_read (read_at), KEY idx_created (created_at) ) $charset; CREATE TABLE wp_b2b_price_books ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL DEFAULT '', start_date DATE NULL, end_date DATE NULL, status VARCHAR(20) NOT NULL DEFAULT 'active', priority INT NOT NULL DEFAULT 10, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_status (status) ) $charset; CREATE TABLE wp_b2b_price_book_items ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, price_book_id BIGINT UNSIGNED NOT NULL, item_type VARCHAR(20) NOT NULL DEFAULT 'product', object_id BIGINT UNSIGNED NOT NULL DEFAULT 0, price_type VARCHAR(30) NOT NULL DEFAULT 'fixed', value DECIMAL(20,6) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_book (price_book_id), KEY idx_object (object_id, item_type) ) $charset; CREATE TABLE wp_b2b_price_book_assignments ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, price_book_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, company_id BIGINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_book (price_book_id), KEY idx_user (user_id), KEY idx_company (company_id) ) $charset; CREATE TABLE wp_b2b_credit_accounts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, credit_limit DECIMAL(20,6) NOT NULL DEFAULT 0, balance_used DECIMAL(20,6) NOT NULL DEFAULT 0, terms VARCHAR(20) NOT NULL DEFAULT 'net30', status VARCHAR(20) NOT NULL DEFAULT 'active', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY user_id (user_id) ) $charset; CREATE TABLE wp_b2b_companies ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL DEFAULT '', admin_user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, vat_number VARCHAR(100) NOT NULL DEFAULT '', credit_limit DECIMAL(20,6) NOT NULL DEFAULT 0, status VARCHAR(20) NOT NULL DEFAULT 'active', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset; CREATE TABLE wp_b2b_company_members ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, company_id BIGINT UNSIGNED NOT NULL, user_id BIGINT UNSIGNED NOT NULL, member_role VARCHAR(20) NOT NULL DEFAULT 'buyer', joined_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY user_id (user_id), KEY idx_company (company_id) ) $charset; CREATE TABLE wp_b2b_visibility_rules ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, rule_type VARCHAR(20) NOT NULL DEFAULT 'product', object_id BIGINT UNSIGNED NOT NULL DEFAULT 0, roles LONGTEXT NULL, companies LONGTEXT NULL, action VARCHAR(10) NOT NULL DEFAULT 'hide', priority INT NOT NULL DEFAULT 10, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_type (rule_type), KEY idx_object (object_id) ) $charset; CREATE TABLE wp_b2b_invoices ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT UNSIGNED NOT NULL, invoice_number VARCHAR(50) NOT NULL, user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, total DECIMAL(20,6) NOT NULL DEFAULT 0, status VARCHAR(20) NOT NULL DEFAULT 'issued', issued_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, due_at DATETIME NULL, PRIMARY KEY (id), UNIQUE KEY order_id (order_id), UNIQUE KEY invoice_number (invoice_number), KEY idx_user (user_id) ) $charset; "; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );
Safe to delete?
If you have uninstalled CodeAtoZ B2B Suite 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_b2b_quotes`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from CodeAtoZ B2B Suite for WooCommerce