{"slug":"ezy-e-invoice","name":"ezy E Invoice","description":"A modern and easy e-invoice plugin – create, send and manage professional PDF invoices directly from your WordPress admin.","author":"Mohammad Abubakar Siddique","active_installs":0,"version":"2.2.4","wp_org_url":"https://wordpress.org/plugins/ezy-e-invoice/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ezy_clients","full_table_name":"wp_ezy_clients","description":"Stores ezy clients data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"company_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"contact_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"address_line1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"address_line2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"city","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"state_province","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"postal_code","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"tax_number","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"notes","type":"text","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_ezy_clients ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, company_name varchar(200) NOT NULL DEFAULT '', contact_name varchar(200) NOT NULL DEFAULT '', email varchar(200) NOT NULL DEFAULT '', phone varchar(50) NOT NULL DEFAULT '', address_line1 varchar(255) NOT NULL DEFAULT '', address_line2 varchar(255) NOT NULL DEFAULT '', city varchar(100) NOT NULL DEFAULT '', state_province varchar(100) NOT NULL DEFAULT '', country varchar(100) NOT NULL DEFAULT '', postal_code varchar(20) NOT NULL DEFAULT '', tax_number varchar(100) NOT NULL DEFAULT '', notes text NOT NULL, status varchar(20) NOT NULL DEFAULT 'active', created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY email (email(50)) ) $c;\" );"},{"table_name":"ezy_invoice_items","full_table_name":"wp_ezy_invoice_items","description":"Stores ezy invoice items data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"invoice_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"item_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"item_description","type":"text","nullable":false,"primary_key":false},{"name":"unit_price","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"quantity","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"line_total","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_ezy_invoice_items ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, invoice_id bigint(20) unsigned NOT NULL DEFAULT 0, product_id bigint(20) unsigned DEFAULT NULL, item_name varchar(255) NOT NULL DEFAULT '', item_description text NOT NULL, unit_price decimal(15,2) NOT NULL DEFAULT 0.00, quantity decimal(10,2) NOT NULL DEFAULT 1.00, line_total decimal(15,2) NOT NULL DEFAULT 0.00, sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY invoice_id (invoice_id) ) $c;\" );"},{"table_name":"ezy_invoices","full_table_name":"wp_ezy_invoices","description":"Stores ezy invoices data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"invoice_number","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"client_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"issue_date","type":"date","nullable":false,"primary_key":false},{"name":"due_date","type":"date","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"subtotal","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"tax_rate","type":"decimal(5,2)","nullable":false,"primary_key":false},{"name":"tax_amount","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"service_charge_rate","type":"decimal(5,2)","nullable":false,"primary_key":false},{"name":"service_charge_amount","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"discount_amount","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"total","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"notes","type":"text","nullable":false,"primary_key":false},{"name":"pdf_path","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"email_sent_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_ezy_invoices ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, invoice_number varchar(50) NOT NULL DEFAULT '', client_id bigint(20) unsigned NOT NULL DEFAULT 0, issue_date date NOT NULL DEFAULT '0000-00-00', due_date date NOT NULL DEFAULT '0000-00-00', status varchar(20) NOT NULL DEFAULT 'draft', subtotal decimal(15,2) NOT NULL DEFAULT 0.00, tax_rate decimal(5,2) NOT NULL DEFAULT 0.00, tax_amount decimal(15,2) NOT NULL DEFAULT 0.00, service_charge_rate decimal(5,2) NOT NULL DEFAULT 0.00, service_charge_amount decimal(15,2) NOT NULL DEFAULT 0.00, discount_amount decimal(15,2) NOT NULL DEFAULT 0.00, total decimal(15,2) NOT NULL DEFAULT 0.00, notes text NOT NULL, pdf_path varchar(500) NOT NULL DEFAULT '', email_sent_at datetime DEFAULT NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY invoice_number (invoice_number), KEY client_id (client_id) ) $c;\" );"},{"table_name":"ezy_products","full_table_name":"wp_ezy_products","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"sku","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"price","type":"decimal(15,2)","nullable":false,"primary_key":false},{"name":"unit","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"wc_product_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_ezy_products ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, description text NOT NULL, sku varchar(100) NOT NULL DEFAULT '', price decimal(15,2) NOT NULL DEFAULT 0.00, unit varchar(50) NOT NULL DEFAULT 'unit', wc_product_id bigint(20) unsigned DEFAULT NULL, status varchar(20) NOT NULL DEFAULT 'active', created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id) ) $c;\" );"}],"table_count":4}