{"table_name":"crewcommerce_team_members","full_table_name":"wp_crewcommerce_team_members","description":"Stores crewcommerce team members data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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);","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"company_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"role","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"permissions","type":"text","nullable":true,"primary_key":false},{"name":"spending_limit","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"requester_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"approver_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"crewcommerce","name":"CrewCommerce – Company Accounts & Order Approvals for WooCommerce","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/crewcommerce/"}}