{"slug":"wp-accounts","name":"Web:D Accounts","description":"Manage your Clients, Invoices, Receipts and Payments. Send Invoices and Receipts to clients via email.","author":"Oliver Campion","active_installs":10,"version":"2.0.1","wp_org_url":"https://wordpress.org/plugins/wp-accounts/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"accounts_clients","full_table_name":"wp_accounts_clients","description":"Stores accounts clients data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"company","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"address2","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address3","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"town","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"county","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"postcode","type":"varchar(13)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"contact","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"telephone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"mobile","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false}],"create_sql":"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;\" );"},{"table_name":"accounts_countries","full_table_name":"wp_accounts_countries","description":"Stores accounts countries data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"country_code","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_accounts_countries ( ID int(11) NOT NULL AUTO_INCREMENT, country_code varchar(2) NOT NULL, country varchar(255) NOT NULL, PRIMARY KEY (ID) ) {$wpdb->get_charset_collate()} AUTO_INCREMENT=1;\" );"},{"table_name":"accounts_expense_types","full_table_name":"wp_accounts_expense_types","description":"Stores accounts expense types data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"expense_type","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"expense","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"Postage","type":"and","nullable":true,"primary_key":false}],"create_sql":"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' ) );"},{"table_name":"accounts_invoice_status","full_table_name":"wp_accounts_invoice_status","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"status","type":"varchar(9)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_accounts_invoice_status ( ID int(11) NOT NULL AUTO_INCREMENT, status varchar(9) NOT NULL, PRIMARY KEY (ID) ) {$wpdb->get_charset_collate()} AUTO_INCREMENT=1;\", 'insert_row' => 'status', 'insert' => array( 1 => 'Unpaid', 2 => 'Paid', 3 => 'Cancelled' ) );"},{"table_name":"accounts_invoices","full_table_name":"wp_accounts_invoices","description":"Stores accounts invoices data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"client","type":"int(11)","nullable":false,"primary_key":false},{"name":"invoice_date","type":"date","nullable":false,"primary_key":false},{"name":"monthly","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"yearly","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"item1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"price1","type":"decimal(10, 2)","nullable":false,"primary_key":false},{"name":"item2","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"price2","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"item3","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"price3","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"item4","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"price4","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"item5","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"price5","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"invoice_status","type":"int(11)","nullable":false,"primary_key":false},{"name":"date_paid","type":"date","nullable":true,"primary_key":false},{"name":"payment_method","type":"int(11)","nullable":true,"primary_key":false},{"name":"mileage","type":"int(11)","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_accounts_invoices ( ID int(11) NOT NULL AUTO_INCREMENT, client int(11) NOT NULL, invoice_date date NOT NULL, monthly tinyint(1) NOT NULL DEFAULT '0', yearly tinyint(1) NOT NULL DEFAULT '0', item1 varchar(255) NOT NULL, price1 decimal(10, 2) NOT NULL, item2 varchar(255) DEFAULT NULL, price2 decimal(10, 2) DEFAULT NULL, item3 varchar(255) DEFAULT NULL, price3 decimal(10, 2) DEFAULT NULL, item4 varchar(255) DEFAULT NULL, price4 decimal(10, 2) DEFAULT NULL, item5 varchar(255) DEFAULT NULL, price5 decimal(10, 2) DEFAULT NULL, invoice_status int(11) NOT NULL DEFAULT '1', date_paid date DEFAULT NULL, payment_method int(11) DEFAULT NULL, mileage int(11) DEFAULT '0', notes text DEFAULT NULL, PRIMARY KEY (ID), KEY client (client), KEY payment_method (payment_method), KEY invoice_status (invoice_status) ) {$wpdb->get_charset_collate()} AUTO_INCREMENT=1;\" );"},{"table_name":"accounts_payment_methods","full_table_name":"wp_accounts_payment_methods","description":"Stores accounts payment methods data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"payment_method","type":"varchar(12)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_accounts_payment_methods ( ID int(11) NOT NULL AUTO_INCREMENT, payment_method varchar(12) NOT NULL, PRIMARY KEY (ID) ) {$wpdb->get_charset_collate()} AUTO_INCREMENT=1;\", 'insert_row' => 'payment_method', 'insert' => array( 1 => 'Paypal', 2 => 'BACS', 3 => 'Cheque', 4 => 'Cash', 5 => 'Credit Card', 6 => 'Debit Card', 7 => 'Direct Debit' ) );"},{"table_name":"accounts_payments","full_table_name":"wp_accounts_payments","description":"Stores accounts payments data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"int(11)","nullable":false,"primary_key":true},{"name":"supplier","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"invoice_date","type":"date","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10, 2)","nullable":false,"primary_key":false},{"name":"reference","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"expense_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"date_paid","type":"date","nullable":false,"primary_key":false},{"name":"payment_method","type":"int(11)","nullable":false,"primary_key":false},{"name":"mileage","type":"int(11)","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_accounts_payments ( ID int(11) NOT NULL AUTO_INCREMENT, supplier varchar(255) NOT NULL, invoice_date date NOT NULL, amount decimal(10, 2) NOT NULL, reference varchar(255) DEFAULT NULL, expense_type int(11) NOT NULL, date_paid date NOT NULL, payment_method int(11) NOT NULL, mileage int(11) DEFAULT '0', notes text DEFAULT NULL, PRIMARY KEY (ID) ) {$wpdb->get_charset_collate()} AUTO_INCREMENT=1;\" );"}],"table_count":7}