wp_accounts_clients
StaticStores accounts clients data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ID | int(11) | NO |
| company | varchar(255) | YES |
| address1 | varchar(255) | NO |
| address2 | varchar(255) | YES |
| address3 | varchar(255) | YES |
| town | varchar(255) | NO |
| county | varchar(255) | YES |
| postcode | varchar(13) | NO |
| country | varchar(255) | YES |
| contact | varchar(255) | NO |
| telephone | varchar(20) | YES |
| mobile | varchar(20) | YES |
| varchar(255) | YES | |
| notes | text | YES |
CREATE TABLE Statement
CREATE TABLE wp_accounts_clients ( ID int(11) NOT NULL AUTO_INCREMENT, company varchar(255) DEFAULT NULL, address1 varchar(255) NOT NULL, address2 varchar(255) DEFAULT NULL, address3 varchar(255) DEFAULT NULL, town varchar(255) NOT NULL, county varchar(255) DEFAULT NULL, postcode varchar(13) NOT NULL, country varchar(255) DEFAULT 'GB', contact varchar(255) NOT NULL, telephone varchar(20) DEFAULT NULL, mobile varchar(20) DEFAULT NULL, email varchar(255) DEFAULT NULL, notes text DEFAULT NULL, PRIMARY KEY (ID), KEY company (company) ) {$wpdb->get_charset_collate()} AUTO_INCREMENT=1;" );Safe to delete?
If you have uninstalled Web:D Accounts, 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_accounts_clients`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Web:D Accounts