{"table_name":"accounts_clients","full_table_name":"wp_accounts_clients","description":"Stores accounts clients data created by this plugin.","detection_method":"static","confidence":"high","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;\" );","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}],"plugin":{"slug":"wp-accounts","name":"Web:D Accounts","active_installs":10,"version":"2.0.1","wp_org_url":"https://wordpress.org/plugins/wp-accounts/"}}