wp_accounts_expense_types
StaticStores accounts expense types data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ID | int(11) | NO |
| expense_type | varchar(255) | NO |
| expense | tinyint(1) | NO |
| Postage | and | YES |
CREATE TABLE Statement
CREATE TABLE wp_accounts_expense_types ( ID int(11) NOT NULL AUTO_INCREMENT, expense_type varchar(255) NOT NULL, expense tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (ID) ) {$wpdb->get_charset_collate()} AUTO_INCREMENT=1;", 'insert_row' => 'expense_type', 'insert' => array( 1 => 'Capital', 2 => 'Accounting', 3 => 'Director\'s Loan', 4 => 'Telephone', 5 => 'Web Servers and Domain Names', 6 => 'Sub-Contract Work', 7 => 'Supplies', 8 => 'Advertising and Marketing', 9 => 'Sundries', 10 => 'Printing, Postage and Stationery', 11 => 'Bounced Cheques', 12 => 'Wages', 13 => 'Dividends', 14 => 'Subscriptions', 15 => 'Repairs and Renewals', 16 => 'Business Trip Expenses', 17 => 'HMRC', 18 => 'Entertaining', 19 => 'Insurance', 20 => 'Legal and Professional', 21 => 'Vehicle Running', 22 => 'Purchases', 23 => 'Bank / eBay / Paypal Charges' ) );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_expense_types`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Web:D Accounts