{"slug":"ezy-quotation-builder","name":"ezy Quotation Builder","description":"A modern and easy quotation builder – create, send and manage professional quotations with PDF attachments.","author":"Mohammad Abubakar Siddique","active_installs":0,"version":"1.0.1","wp_org_url":"https://wordpress.org/plugins/ezy-quotation-builder/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ezyqb_clients","full_table_name":"wp_ezyqb_clients","description":"Stores ezyqb 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_ezyqb_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":"ezyqb_products","full_table_name":"wp_ezyqb_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_ezyqb_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_name":"ezyqb_quotation_items","full_table_name":"wp_ezyqb_quotation_items","description":"Stores ezyqb quotation items data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"quotation_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_ezyqb_quotation_items ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, quotation_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 quotation_id (quotation_id) ) $c;\" );"},{"table_name":"ezyqb_quotations","full_table_name":"wp_ezyqb_quotations","description":"Stores ezyqb quotations data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"quote_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":"valid_until","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_ezyqb_quotations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, quote_number varchar(50) NOT NULL DEFAULT '', client_id bigint(20) unsigned NOT NULL DEFAULT 0, issue_date date NOT NULL DEFAULT '0000-00-00', valid_until 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 quote_number (quote_number), KEY client_id (client_id) ) $c;\" );"}],"table_count":4}