wp_crewcommerce_team_members

Static

Stores crewcommerce team members data created by this plugin.

Column Definitions

Column	Type	Nullable
🔑id	mediumint(9)	NO
user_id	bigint(20)	NO
company_id	bigint(20)	NO
role	varchar(50)	NO
permissions	text	YES
spending_limit	decimal(10,2)	YES
created_at	datetime	YES
updated_at	datetime	YES
order_id	bigint(20)	NO
requester_id	bigint(20)	NO
approver_id	bigint(20)	YES
status	varchar(50)	NO
notes	text	YES
created_at	datetime	YES
updated_at	datetime	YES

CREATE TABLE Statement

CREATE TABLE wp_crewcommerce_team_members ( id mediumint(9) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, company_id bigint(20) NOT NULL, role varchar(50) NOT NULL DEFAULT 'requester', permissions text, spending_limit decimal(10,2) DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY user_company (user_id, company_id), KEY user_id (user_id), KEY company_id (company_id) ) {$charset_collate};"; $workflows = "CREATE TABLE wp_crewcommerce_approval_workflows ( id mediumint(9) NOT NULL AUTO_INCREMENT, order_id bigint(20) NOT NULL, requester_id bigint(20) NOT NULL, approver_id bigint(20), status varchar(50) NOT NULL DEFAULT 'pending', notes text, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_id (order_id), KEY requester_id (requester_id), KEY approver_id (approver_id) ) {$charset_collate};"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($members);

Safe to delete?

If you have uninstalled CrewCommerce – Company Accounts & Order Approvals 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_crewcommerce_team_members`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from CrewCommerce – Company Accounts & Order Approvals for WooCommerce

wp_crewcommerce_approval_workflows