{"slug":"erp","name":"ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support","description":"Self-hosted ERP for WordPress with HR, CRM, accounting, and recruitment. Run your business from one dashboard and keep your data yours.","author":"weDevs","active_installs":5000,"version":"1.17.5","wp_org_url":"https://wordpress.org/plugins/erp/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"erp_ac_banks","full_table_name":"wp_erp_ac_banks","description":"Stores erp ac banks data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"erp_ac_chart_classes","full_table_name":"wp_erp_ac_chart_classes","description":"Stores erp ac chart classes data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(60)","nullable":false,"primary_key":false},{"name":"class_id","type":"tinyint(3)","nullable":false,"primary_key":false},{"name":"ledger_id","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"transaction_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"debit","type":"DECIMAL(13,4) unsigned","nullable":true,"primary_key":false},{"name":"credit","type":"DECIMAL(13,4) unsigned","nullable":true,"primary_key":false},{"name":"code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"parent","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"type_id","type":"int(3) unsigned","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"tax","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"cash_account","type":"tinyint(2) unsigned","nullable":false,"primary_key":false},{"name":"reconcile","type":"tinyint(2) unsigned","nullable":false,"primary_key":false},{"name":"system","type":"tinyint(2) unsigned","nullable":false,"primary_key":false},{"name":"active","type":"tinyint(2) unsigned","nullable":false,"primary_key":false},{"name":"created_by","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"account_number","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"bank_name","type":"varchar(30)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"form_type","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"billing_address","type":"tinytext","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"summary","type":"text","nullable":true,"primary_key":false},{"name":"issue_date","type":"date","nullable":true,"primary_key":false},{"name":"due_date","type":"date","nullable":true,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"conversion_rate","type":"decimal(2,2) unsigned","nullable":true,"primary_key":false},{"name":"sub_total","type":"DECIMAL(13,4)","nullable":true,"primary_key":false},{"name":"total","type":"DECIMAL(13,4)","nullable":true,"primary_key":false},{"name":"due","type":"DECIMAL(13,4) unsigned","nullable":true,"primary_key":false},{"name":"trans_total","type":"DECIMAL(13,4)","nullable":true,"primary_key":false},{"name":"files","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"parent","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_by","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"transaction_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"journal_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"product_id","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"qty","type":"tinyint(5) unsigned","nullable":false,"primary_key":false},{"name":"unit_price","type":"DECIMAL(13,4) unsigned","nullable":false,"primary_key":false},{"name":"discount","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"tax","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"tax_rate","type":"DECIMAL(13,4)","nullable":false,"primary_key":false},{"name":"tax_journal","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"line_total","type":"DECIMAL(13,4) unsigned","nullable":false,"primary_key":false},{"name":"order","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"transaction_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"parent","type":"int(11)","nullable":false,"primary_key":false},{"name":"child","type":"int(11)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tax_number","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"is_compound","type":"varchar(5)","nullable":true,"primary_key":false},{"name":"created_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"tax_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"component_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"agency_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tax_rate","type":"float","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erp_ac_chart_classes` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_ac_chart_types` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(60) NOT NULL DEFAULT '', `class_id` tinyint(3) NOT NULL, PRIMARY KEY (`id`), KEY `class_id` (`class_id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_ac_journals` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ledger_id` int(11) unsigned NOT NULL, `transaction_id` bigint(20) unsigned NOT NULL, `type` varchar(20) DEFAULT NULL, `debit` DECIMAL(13,4) unsigned DEFAULT NULL, `credit` DECIMAL(13,4) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `ledger_id` (`ledger_id`), KEY `transaction_id` (`transaction_id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_ac_ledger` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(10) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `description` text, `parent` int(11) unsigned NOT NULL DEFAULT '0', `type_id` int(3) unsigned NOT NULL DEFAULT '0', `currency` varchar(10) DEFAULT '', `tax` bigint(20) DEFAULT NULL, `cash_account` tinyint(2) unsigned NOT NULL DEFAULT '0', `reconcile` tinyint(2) unsigned NOT NULL DEFAULT '0', `system` tinyint(2) unsigned NOT NULL DEFAULT '0', `active` tinyint(2) unsigned NOT NULL DEFAULT '1', `created_by` bigint(20) DEFAULT 0, PRIMARY KEY (`id`), KEY `code` (`code`), KEY `type_id` (`type_id`), KEY `parent` (`parent`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_ac_banks` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ledger_id` int(10) unsigned DEFAULT NULL, `account_number` varchar(20) DEFAULT NULL, `bank_name` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`), KEY `ledger_id` (`ledger_id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_ac_transactions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(10) DEFAULT NULL, `form_type` varchar(20) DEFAULT NULL, `status` varchar(20) DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `billing_address` tinytext, `ref` varchar(50) DEFAULT NULL, `summary` text, `issue_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `currency` varchar(10) DEFAULT NULL, `conversion_rate` decimal(2,2) unsigned DEFAULT NULL, `sub_total` DECIMAL(13,4) DEFAULT '0.00', `total` DECIMAL(13,4) DEFAULT '0.00', `due` DECIMAL(13,4) unsigned DEFAULT '0.00', `trans_total` DECIMAL(13,4) DEFAULT '0.00', `files` varchar(255) DEFAULT NULL, `parent` bigint(20) unsigned NOT NULL DEFAULT '0', `created_by` int(11) unsigned DEFAULT NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `type` (`type`), KEY `status` (`status`), KEY `issue_date` (`issue_date`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_ac_transaction_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `transaction_id` bigint(20) unsigned DEFAULT NULL, `journal_id` bigint(20) unsigned DEFAULT NULL, `product_id` int(10) unsigned DEFAULT NULL, `description` text, `qty` tinyint(5) unsigned NOT NULL DEFAULT '1', `unit_price` DECIMAL(13,4) unsigned NOT NULL DEFAULT '0.00', `discount` tinyint(3) unsigned NOT NULL DEFAULT '0', `tax` tinyint(3) unsigned NOT NULL DEFAULT '0', `tax_rate` DECIMAL(13,4) NOT NULL, `tax_journal` BIGINT(20) NOT NULL, `line_total` DECIMAL(13,4) unsigned NOT NULL DEFAULT '0.00', `order` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `transaction_id` (`transaction_id`), KEY `journal_id` (`journal_id`), KEY `product_id` (`product_id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_ac_payments` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `transaction_id` int(11) NOT NULL, `parent` int(11) NOT NULL, `child` int(11) NOT NULL, PRIMARY KEY (`id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_ac_tax` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `tax_number` varchar(255) DEFAULT NULL, `is_compound` varchar(5) DEFAULT NULL, `created_by` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_ac_tax_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tax_id` bigint(20) NOT NULL, `component_name` varchar(255) DEFAULT NULL, `agency_name` varchar(255) DEFAULT NULL, `tax_rate` float NOT NULL, PRIMARY KEY (`id`) ) $collate;\", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $table_schema as $table ) { dbDelta( $table );"},{"table_name":"erp_ac_ledger","full_table_name":"wp_erp_ac_ledger","description":"Stores erp ac ledger data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"erp_ac_payments","full_table_name":"wp_erp_ac_payments","description":"Stores erp ac payments data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_ac_tax","full_table_name":"wp_erp_ac_tax","description":"Stores erp ac tax data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_ac_tax_items","full_table_name":"wp_erp_ac_tax_items","description":"Stores erp ac tax items data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_ac_transaction_items","full_table_name":"wp_erp_ac_transaction_items","description":"Stores erp ac transaction items data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"erp_ac_transactions","full_table_name":"wp_erp_ac_transactions","description":"Stores erp ac transactions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"erp_acct_bill_account_details","full_table_name":"wp_erp_acct_bill_account_details","description":"Stores erp acct bill account details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_bill_details","full_table_name":"wp_erp_acct_bill_details","description":"Stores erp acct bill details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_bills","full_table_name":"wp_erp_acct_bills","description":"Stores erp acct bills data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_cash_at_banks","full_table_name":"wp_erp_acct_cash_at_banks","description":"Stores erp acct cash at banks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_chart_of_accounts","full_table_name":"wp_erp_acct_chart_of_accounts","description":"Stores erp acct chart of accounts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_currency_info","full_table_name":"wp_erp_acct_currency_info","description":"Stores erp acct currency info data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_expense_checks","full_table_name":"wp_erp_acct_expense_checks","description":"Stores erp acct expense checks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_expense_details","full_table_name":"wp_erp_acct_expense_details","description":"Stores erp acct expense details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_expenses","full_table_name":"wp_erp_acct_expenses","description":"Stores erp acct expenses data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_financial_years","full_table_name":"wp_erp_acct_financial_years","description":"Stores erp acct financial years data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"erp_acct_invoice_account_details","full_table_name":"wp_erp_acct_invoice_account_details","description":"Stores erp acct invoice account details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_invoice_details","full_table_name":"wp_erp_acct_invoice_details","description":"Stores erp acct invoice details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_invoice_details_tax","full_table_name":"wp_erp_acct_invoice_details_tax","description":"Stores erp acct invoice details tax data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_invoice_receipts","full_table_name":"wp_erp_acct_invoice_receipts","description":"Stores erp acct invoice receipts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_invoice_receipts_details","full_table_name":"wp_erp_acct_invoice_receipts_details","description":"Stores erp acct invoice receipts details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_invoices","full_table_name":"wp_erp_acct_invoices","description":"Stores erp acct invoices data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_journal_details","full_table_name":"wp_erp_acct_journal_details","description":"Stores erp acct journal details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_journals","full_table_name":"wp_erp_acct_journals","description":"Stores erp acct journals data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_ledger_categories","full_table_name":"wp_erp_acct_ledger_categories","description":"Stores erp acct ledger categories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_ledger_details","full_table_name":"wp_erp_acct_ledger_details","description":"Stores erp acct ledger details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_ledger_settings","full_table_name":"wp_erp_acct_ledger_settings","description":"Stores erp acct ledger settings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_ledgers","full_table_name":"wp_erp_acct_ledgers","description":"Stores erp acct ledgers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"erp_acct_opening_balances","full_table_name":"wp_erp_acct_opening_balances","description":"Stores erp acct opening balances data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_pay_bill","full_table_name":"wp_erp_acct_pay_bill","description":"Stores erp acct pay bill data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_pay_bill_details","full_table_name":"wp_erp_acct_pay_bill_details","description":"Stores erp acct pay bill details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_pay_purchase","full_table_name":"wp_erp_acct_pay_purchase","description":"Stores erp acct pay purchase data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_pay_purchase_details","full_table_name":"wp_erp_acct_pay_purchase_details","description":"Stores erp acct pay purchase details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_payment_methods","full_table_name":"wp_erp_acct_payment_methods","description":"Stores erp acct payment methods data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_people_account_details","full_table_name":"wp_erp_acct_people_account_details","description":"Stores erp acct people account details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_people_trn","full_table_name":"wp_erp_acct_people_trn","description":"Stores erp acct people trn data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_people_trn_details","full_table_name":"wp_erp_acct_people_trn_details","description":"Stores erp acct people trn details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"people_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erp_acct_people_trn_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `people_id` varchar(255) DEFAULT NULL, `voucher_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(10,2) DEFAULT 0, `credit` decimal(10,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $table );"},{"table_name":"erp_acct_product_categories","full_table_name":"wp_erp_acct_product_categories","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_product_details","full_table_name":"wp_erp_acct_product_details","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_product_types","full_table_name":"wp_erp_acct_product_types","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_products","full_table_name":"wp_erp_acct_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_purchase","full_table_name":"wp_erp_acct_purchase","description":"Stores erp acct purchase data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"erp_acct_purchase_account_details","full_table_name":"wp_erp_acct_purchase_account_details","description":"Stores erp acct purchase account details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_purchase_details","full_table_name":"wp_erp_acct_purchase_details","description":"Stores erp acct purchase details data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"erp_acct_purchase_details_tax","full_table_name":"wp_erp_acct_purchase_details_tax","description":"Stores erp acct purchase details tax data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"invoice_details_id","type":"int(20)","nullable":false,"primary_key":false},{"name":"agency_id","type":"int(20)","nullable":true,"primary_key":false},{"name":"tax_rate","type":"decimal(20,2)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_by","type":"int(20)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_by","type":"int(20)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_erp_acct_purchase_details_tax ( id int(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_details_id int(20) NOT NULL, agency_id int(20) DEFAULT NULL, tax_rate decimal(20,2) NOT NULL, created_at datetime DEFAULT NULL, created_by int(20) DEFAULT NULL, updated_at datetime DEFAULT NULL, updated_by int(20) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );"},{"table_name":"erp_acct_synced_taxes","full_table_name":"wp_erp_acct_synced_taxes","description":"Stores erp acct synced taxes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"system_id","type":"bigint","nullable":false,"primary_key":false},{"name":"sync_id","type":"bigint","nullable":true,"primary_key":false},{"name":"sync_slug","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"sync_type","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"sync_source","type":"varchar(100)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_erp_acct_synced_taxes ( id int NOT NULL AUTO_INCREMENT, system_id bigint NOT NULL, sync_id bigint DEFAULT NULL, sync_slug varchar(100) DEFAULT NULL, sync_type varchar(100) DEFAULT NULL, sync_source varchar(100) DEFAULT NULL, PRIMARY KEY (id), KEY system_id (system_id), KEY sync_id (sync_id), KEY sync_slug (sync_slug), KEY sync_type (sync_type), KEY sync_source (sync_source) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $schema );"},{"table_name":"erp_acct_tax_agencies","full_table_name":"wp_erp_acct_tax_agencies","description":"Stores erp acct tax agencies data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_tax_agency_details","full_table_name":"wp_erp_acct_tax_agency_details","description":"Stores erp acct tax agency details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_tax_cat_agency","full_table_name":"wp_erp_acct_tax_cat_agency","description":"Stores erp acct tax cat agency data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_tax_categories","full_table_name":"wp_erp_acct_tax_categories","description":"Stores erp acct tax categories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_tax_pay","full_table_name":"wp_erp_acct_tax_pay","description":"Stores erp acct tax pay data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_taxes","full_table_name":"wp_erp_acct_taxes","description":"Stores erp acct taxes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_transfer_voucher","full_table_name":"wp_erp_acct_transfer_voucher","description":"Stores erp acct transfer voucher data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_trn_status_types","full_table_name":"wp_erp_acct_trn_status_types","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_acct_voucher_no","full_table_name":"wp_erp_acct_voucher_no","description":"Stores erp acct voucher no data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"currency","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"editable","type":"tinyint","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"bill_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"due_date","type":"date","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"sign","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"invoice_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"qty","type":"int(11)","nullable":true,"primary_key":false},{"name":"unit_price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"discount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"item_total","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ecommerce_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"invoice_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"due_date","type":"date","nullable":true,"primary_key":false},{"name":"billing_address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"discount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"discount_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"estimate","type":"boolean","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"voucher_amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"chart_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"parent_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"system","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"short_code","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"chart_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"code","type":"int(11)","nullable":true,"primary_key":false},{"name":"unused","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"system","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"balance","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ac_from","type":"int(11)","nullable":true,"primary_key":false},{"name":"ac_to","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"financial_year_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"chart_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"bill_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"purchase_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"people_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"people_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"parent","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"product_type_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"tax_cat_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor","type":"int(11)","nullable":true,"primary_key":false},{"name":"cost_price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"sale_price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"stock_in","type":"int(11)","nullable":true,"primary_key":false},{"name":"stock_out","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"due_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"purchase_order","type":"boolean","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"purchase_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"qty","type":"int(11)","nullable":true,"primary_key":false},{"name":"price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"tax_rate_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tax_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"default","type":"boolean","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"tax_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"component_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tax_cat_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"tax_rate","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"ecommerce_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by","type":"int(11)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"invoice_details_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"tax_rate","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"type_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"people_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"people_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"check_no","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_by","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"check_no","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"bank","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"pay_to","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erp_acct_voucher_no` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(255) DEFAULT NULL, `currency` varchar(50) DEFAULT NULL, `editable` tinyint DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_bill_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bill_no` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_bill_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_bills` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `vendor_id` int(11) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `ref` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `particulars` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_chart_of_accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_currency_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `sign` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoice_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `invoice_no` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoice_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `qty` int(11) DEFAULT NULL, `unit_price` decimal(20,2) DEFAULT 0, `discount` decimal(20,2) DEFAULT 0, `tax` decimal(20,2) DEFAULT 0, `item_total` decimal(20,2) DEFAULT 0, `ecommerce_type` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoice_receipts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `customer_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `particulars` varchar(255) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `trn_by` varchar(255) DEFAULT NULL, `trn_by_ledger_id` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoice_receipts_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `invoice_no` int(11) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `customer_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `billing_address` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `discount` decimal(20,2) DEFAULT 0, `discount_type` varchar(255) DEFAULT NULL, `tax` decimal(20,2) DEFAULT 0, `estimate` boolean DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_journal_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_journals` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_date` date DEFAULT NULL, `ref` varchar(255) DEFAULT NULL, `voucher_no` int(11) DEFAULT NULL, `voucher_amount` decimal(20,2) DEFAULT 0, `particulars` varchar(255) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_ledger_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `chart_id` int(11) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `system` tinyint(1) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_ledger_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ledger_id` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `trn_date` date DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_ledger_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ledger_id` int(11) DEFAULT NULL, `short_code` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_ledgers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `chart_id` int(11) DEFAULT NULL, `category_id` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `code` int(11) DEFAULT NULL, `unused` tinyint(1) DEFAULT NULL, `system` tinyint(1) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_cash_at_banks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ledger_id` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `balance` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_transfer_voucher` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `ac_from` int(11) DEFAULT NULL, `ac_to` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_opening_balances` ( `id` int(11) NOT NULL AUTO_INCREMENT, `financial_year_id` int(11) DEFAULT NULL, `chart_id` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `type` varchar(50) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_financial_years` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_pay_bill` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `vendor_id` int(11) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `trn_by` varchar(255) DEFAULT NULL, `trn_by_ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_pay_bill_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `bill_no` int(11) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_pay_purchase` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `vendor_id` int(11) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `trn_by` varchar(255) DEFAULT NULL, `trn_by_ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_pay_purchase_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `purchase_no` int(11) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_people_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `people_id` varchar(255) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `trn_by` varchar(255) DEFAULT NULL, `voucher_type` varchar(255) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_people_trn` ( `id` int(11) NOT NULL AUTO_INCREMENT, `people_id` varchar(255) DEFAULT NULL, `voucher_no` int(11) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `trn_date` date DEFAULT NULL, `trn_by` varchar(255) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `voucher_type` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_product_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `parent` int(11) NOT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_product_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_products` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `product_type_id` int(11) DEFAULT NULL, `category_id` int(11) DEFAULT NULL, `tax_cat_id` int(11) DEFAULT NULL, `vendor` int(11) DEFAULT NULL, `cost_price` decimal(20,2) DEFAULT 0, `sale_price` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_product_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `stock_in` int(11) DEFAULT NULL, `stock_out` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_purchase` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `vendor_id` int(11) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `ref` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `purchase_order` boolean DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_purchase_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `purchase_no` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_purchase_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `qty` int(11) DEFAULT NULL, `price` decimal(20,2) DEFAULT 0, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_tax_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_taxes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tax_rate_name` varchar(255) DEFAULT NULL, `tax_number` varchar(100) DEFAULT NULL, `default` boolean DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_tax_cat_agency` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tax_id` int(11) DEFAULT NULL, `component_name` varchar(255) DEFAULT NULL, `tax_cat_id` int(11) DEFAULT NULL, `agency_id` int(11) DEFAULT NULL, `tax_rate` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_tax_agencies` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `ecommerce_type` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_tax_pay` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `voucher_type` varchar(255) DEFAULT NULL, `trn_by` int(11) DEFAULT NULL, `agency_id` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_tax_agency_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `agency_id` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(10, 2) DEFAULT 0, `credit` decimal(10, 2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoice_details_tax` ( `id` int(11) NOT NULL AUTO_INCREMENT, `invoice_details_id` int(11) DEFAULT NULL, `agency_id` int(11) DEFAULT NULL, `tax_rate` decimal(20,2) DEFAULT 0, `tax_amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_trn_status_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type_name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_payment_methods` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_expenses` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `people_id` int(11) DEFAULT NULL, `people_name` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `ref` varchar(255) DEFAULT NULL, `check_no` varchar(255) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `trn_by` int(11) DEFAULT NULL, `trn_by_ledger_id` int(11) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_expense_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_acct_expense_checks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `check_no` varchar(255) DEFAULT NULL, `voucher_type` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `bank` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `pay_to` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $table_schema as $table ) { dbDelta( $table );"},{"table_name":"erp_audit_log","full_table_name":"wp_erp_audit_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_company_locations","full_table_name":"wp_erp_company_locations","description":"Stores erp company locations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":"CREATE TABLE `wp_erp_company_locations` ( id int(11) unsigned NOT NULL AUTO_INCREMENT, company_id int(11) unsigned DEFAULT NULL, name varchar(255) DEFAULT NULL, address_1 varchar(255) DEFAULT NULL, address_2 varchar(255) DEFAULT NULL, city varchar(100) DEFAULT NULL, state varchar(100) DEFAULT NULL, zip int(6) DEFAULT NULL, country varchar(5) DEFAULT NULL, fax varchar(20) DEFAULT NULL, phone varchar(20) DEFAULT NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id), KEY company_id (company_id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_depts` ( id int(11) unsigned NOT NULL AUTO_INCREMENT, title varchar(200) NOT NULL DEFAULT '', `description` text, `lead` int(11) unsigned DEFAULT '0', parent int(11) unsigned DEFAULT '0', `status` tinyint(1) unsigned DEFAULT '1', created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_designations` ( id int(11) unsigned NOT NULL AUTO_INCREMENT, title varchar(200) NOT NULL DEFAULT '', `description` text, `status` tinyint(1) DEFAULT '1', created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_employees` ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0', employee_id varchar(20) DEFAULT NULL, designation int(11) unsigned NOT NULL DEFAULT '0', department int(11) unsigned NOT NULL DEFAULT '0', `location` int(10) unsigned NOT NULL DEFAULT '0', hiring_source varchar(20) NOT NULL, hiring_date date NOT NULL, termination_date date NOT NULL, date_of_birth date NOT NULL, reporting_to bigint(20) unsigned NOT NULL DEFAULT '0', pay_rate decimal(20,2) unsigned NOT NULL DEFAULT '0', pay_type varchar(20) NOT NULL DEFAULT '', `type` varchar(20) NOT NULL, `status` varchar(10) NOT NULL DEFAULT '', deleted_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY employee_id (employee_id), KEY designation (designation), KEY department (department), KEY `status` (`status`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_employee_history` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0', `module` varchar(20) DEFAULT NULL, `category` varchar(20) DEFAULT NULL, `type` varchar(20) DEFAULT NULL, `comment` text, `data` longtext, `date` datetime NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `module` (`module`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_employee_notes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL DEFAULT '0', `comment` text NOT NULL, `comment_by` bigint(20) unsigned NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leaves ( id smallint(6) NOT NULL AUTO_INCREMENT, name varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, description text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_policies ( id int(10) UNSIGNED NOT NULL AUTO_INCREMENT, leave_id smallint(5) UNSIGNED NOT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `days` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', color varchar(10) DEFAULT NULL, apply_limit tinyint(3) UNSIGNED NOT NULL DEFAULT '0', employee_type enum('-1','permanent','parttime','contract','temporary','trainee') NOT NULL DEFAULT 'permanent', department_id int(11) NOT NULL DEFAULT '-1', location_id int(11) NOT NULL DEFAULT '-1', designation_id int(11) NOT NULL DEFAULT '-1', gender enum('-1','male','female','other') NOT NULL DEFAULT '-1', marital enum('-1','single','married','widowed') NOT NULL DEFAULT '-1', f_year smallint(5) UNSIGNED DEFAULT NULL, apply_for_new_users tinyint(3) UNSIGNED NOT NULL DEFAULT '0', carryover_days tinyint(3) UNSIGNED NOT NULL DEFAULT '0', carryover_uses_limit tinyint(3) UNSIGNED NOT NULL DEFAULT '0', encashment_days tinyint(3) UNSIGNED NOT NULL DEFAULT '0', encashment_based_on enum('pay_rate','basic','gross') DEFAULT NULL, forward_default enum('encashment','carryover') NOT NULL DEFAULT 'encashment', applicable_from_days smallint(5) UNSIGNED NOT NULL DEFAULT '0', accrued_amount decimal(10,2) NOT NULL DEFAULT '0.00', accrued_max_days smallint(4) UNSIGNED NOT NULL DEFAULT '0', halfday_enable tinyint(3) UNSIGNED NOT NULL DEFAULT '0', created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_id (leave_id), KEY f_year (f_year) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_policies_segregation ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_policy_id bigint(20) UNSIGNED NOT NULL, jan tinyint(3) UNSIGNED NOT NULL DEFAULT '0', feb tinyint(3) UNSIGNED NOT NULL DEFAULT '0', mar tinyint(3) UNSIGNED NOT NULL DEFAULT '0', apr tinyint(3) UNSIGNED NOT NULL DEFAULT '0', may tinyint(3) UNSIGNED NOT NULL DEFAULT '0', jun tinyint(3) UNSIGNED NOT NULL DEFAULT '0', jul tinyint(3) UNSIGNED NOT NULL DEFAULT '0', aug tinyint(3) UNSIGNED NOT NULL DEFAULT '0', sep tinyint(3) UNSIGNED NOT NULL DEFAULT '0', oct tinyint(3) UNSIGNED NOT NULL DEFAULT '0', nov tinyint(3) UNSIGNED NOT NULL DEFAULT '0', decem tinyint(3) UNSIGNED NOT NULL DEFAULT '0', created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_policy_id (leave_policy_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_entitlements ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, created_by bigint(20) UNSIGNED DEFAULT NULL, trn_id bigint(20) UNSIGNED NOT NULL, trn_type enum('leave_policies','leave_approval_status','leave_encashment_requests','leave_entitlements','unpaid_leave','leave_encashment', 'leave_carryforward', 'manual_leave_policies', 'Accounts', 'others', 'leave_accrual', 'carry_forward_leave_expired') NOT NULL DEFAULT 'leave_policies', day_in decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', day_out decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, f_year smallint(6) NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY comp_key_1 (`user_id`,leave_id,f_year,trn_type), KEY trn_id (trn_id), KEY leave_id (leave_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_requests ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, leave_entitlement_id bigint(20) UNSIGNED NOT NULL default '0', day_status_id smallint(5) UNSIGNED NOT NULL DEFAULT '1', `days` decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', `start_date` int(11) NOT NULL, end_date int(11) NOT NULL, reason text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, last_status smallint(6) UNSIGNED NOT NULL DEFAULT '2', created_by bigint(20) UNSIGNED DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY user_leave (`user_id`,leave_id), KEY user_entitlement (`user_id`,leave_entitlement_id), KEY last_status (last_status), KEY leave_entitlement_id (leave_entitlement_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_approval_status ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_request_id bigint(20) UNSIGNED NOT NULL, approval_status_id tinyint(3) UNSIGNED NOT NULL DEFAULT '0', approved_by bigint(20) UNSIGNED DEFAULT NULL, `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_request_id (leave_request_id), KEY approval_status_id (approval_status_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_request_details ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_request_id bigint(20) UNSIGNED NOT NULL, leave_approval_status_id bigint(20) UNSIGNED NOT NULL, workingday_status tinyint(3) UNSIGNED NOT NULL DEFAULT '1', `user_id` bigint(20) UNSIGNED NOT NULL, f_year smallint(6) NOT NULL, leave_date int(11) NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_request_id (leave_request_id), KEY `user_id` (`user_id`), KEY user_fyear_leave (`user_id`,f_year,leave_date) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_encashment_requests ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, approved_by bigint(20) UNSIGNED DEFAULT NULL, approval_status_id tinyint(3) UNSIGNED NOT NULL DEFAULT '1', encash_days decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', forward_days decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', amount decimal(20,2) NOT NULL DEFAULT '0.00', total decimal(20,2) NOT NULL DEFAULT '0.00', f_year smallint(5) UNSIGNED NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY leave_id (leave_id), KEY f_year (f_year) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leaves_unpaid ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_id smallint(6) UNSIGNED NOT NULL, leave_request_id bigint(20) UNSIGNED NOT NULL, leave_approval_status_id bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `days` decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', amount decimal(20,2) NOT NULL DEFAULT '0.00', total decimal(20,2) NOT NULL DEFAULT '0.00', f_year smallint(5) UNSIGNED NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY leave_id (leave_id), KEY f_year (f_year), KEY leave_request_id (leave_request_id), KEY leave_approval_status_id (leave_approval_status_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_financial_years ( id int(11) UNSIGNED NOT NULL AUTO_INCREMENT, fy_name varchar(255) COLLATE"},{"table_name":"erp_crm_activities_task","full_table_name":"wp_erp_crm_activities_task","description":"Stores erp crm activities task data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_crm_contact_group","full_table_name":"wp_erp_crm_contact_group","description":"Stores erp crm contact group data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_crm_contact_subscriber","full_table_name":"wp_erp_crm_contact_subscriber","description":"Stores erp crm contact subscriber data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_crm_customer_activities","full_table_name":"wp_erp_crm_customer_activities","description":"Stores erp crm customer activities data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_crm_customer_companies","full_table_name":"wp_erp_crm_customer_companies","description":"Stores erp crm customer companies data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_crm_save_email_replies","full_table_name":"wp_erp_crm_save_email_replies","description":"Stores erp crm save email replies data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"text","nullable":true,"primary_key":false},{"name":"subject","type":"text","nullable":true,"primary_key":false},{"name":"template","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erp_crm_save_email_replies` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` text, `subject` text, `template` longtext, PRIMARY KEY (`id`) ) $collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $schema );"},{"table_name":"erp_crm_save_search","full_table_name":"wp_erp_crm_save_search","description":"Stores erp crm save search data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"erp_holidays_indv","full_table_name":"wp_erp_holidays_indv","description":"Stores erp holidays indv data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"holiday_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"request_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erp_holidays_indv` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `holiday_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE IF NOT EXISTS `wp_erp_user_leaves` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `request_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $table_schema as $table ) { dbDelta( $table );"},{"table_name":"erp_hr_announcement","full_table_name":"wp_erp_hr_announcement","description":"Stores erp hr announcement data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_dependents","full_table_name":"wp_erp_hr_dependents","description":"Stores erp hr dependents data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_depts","full_table_name":"wp_erp_hr_depts","description":"Stores erp hr depts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_designations","full_table_name":"wp_erp_hr_designations","description":"Stores erp hr designations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_education","full_table_name":"wp_erp_hr_education","description":"Stores erp hr education data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_employee_history","full_table_name":"wp_erp_hr_employee_history","description":"Stores erp hr employee history data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_employee_notes","full_table_name":"wp_erp_hr_employee_notes","description":"Stores erp hr employee notes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_employee_performance","full_table_name":"wp_erp_hr_employee_performance","description":"Stores erp hr employee performance data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_employees","full_table_name":"wp_erp_hr_employees","description":"Stores erp hr employees data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_financial_years","full_table_name":"wp_erp_hr_financial_years","description":"Stores erp hr financial years data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_financial_years_new","full_table_name":"wp_erp_hr_financial_years_new","description":"Stores erp hr financial years new data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_holiday","full_table_name":"wp_erp_hr_holiday","description":"Stores erp hr holiday data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_approval_status","full_table_name":"wp_erp_hr_leave_approval_status","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_approval_status_new","full_table_name":"wp_erp_hr_leave_approval_status_new","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_encashment_requests","full_table_name":"wp_erp_hr_leave_encashment_requests","description":"Stores erp hr leave encashment requests data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_encashment_requests_new","full_table_name":"wp_erp_hr_leave_encashment_requests_new","description":"Stores erp hr leave encashment requests new data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_entitlements","full_table_name":"wp_erp_hr_leave_entitlements","description":"Stores erp hr leave entitlements data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_entitlements_new","full_table_name":"wp_erp_hr_leave_entitlements_new","description":"Stores erp hr leave entitlements new data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_policies","full_table_name":"wp_erp_hr_leave_policies","description":"Stores erp hr leave policies data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_policies_segregation","full_table_name":"wp_erp_hr_leave_policies_segregation","description":"Stores erp hr leave policies segregation data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_policies_segregation_new","full_table_name":"wp_erp_hr_leave_policies_segregation_new","description":"Stores erp hr leave policies segregation new data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_request_details","full_table_name":"wp_erp_hr_leave_request_details","description":"Stores erp hr leave request details data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_request_details_new","full_table_name":"wp_erp_hr_leave_request_details_new","description":"Stores erp hr leave request details new data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_requests","full_table_name":"wp_erp_hr_leave_requests","description":"Stores erp hr leave requests data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leave_requests_new","full_table_name":"wp_erp_hr_leave_requests_new","description":"Stores erp hr leave requests new data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leaves","full_table_name":"wp_erp_hr_leaves","description":"Stores erp hr leaves data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leaves_new","full_table_name":"wp_erp_hr_leaves_new","description":"Stores erp hr leaves new data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE wp_erp_hr_leaves_new ( id smallint(6) NOT NULL AUTO_INCREMENT, name varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, description text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_policies_new ( id int(10) UNSIGNED NOT NULL AUTO_INCREMENT, leave_id smallint(5) UNSIGNED NOT NULL, old_policy_id int(11) UNSIGNED DEFAULT NULL, description text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, days tinyint(3) UNSIGNED NOT NULL DEFAULT '0', color varchar(10) DEFAULT NULL, apply_limit tinyint(3) UNSIGNED NOT NULL DEFAULT '0', employee_type enum('-1','permanent','parttime','contract','temporary','trainee') NOT NULL DEFAULT 'permanent', department_id int(11) NOT NULL DEFAULT '-1', location_id int(11) NOT NULL DEFAULT '-1', designation_id int(11) NOT NULL DEFAULT '-1', gender enum('-1','male','female','other') NOT NULL DEFAULT '-1', marital enum('-1','single','married','widowed') NOT NULL DEFAULT '-1', f_year smallint(5) UNSIGNED DEFAULT NULL, apply_for_new_users tinyint(3) UNSIGNED NOT NULL DEFAULT '0', carryover_days tinyint(3) UNSIGNED NOT NULL DEFAULT '0', carryover_uses_limit tinyint(3) UNSIGNED NOT NULL DEFAULT '0', encashment_days tinyint(3) UNSIGNED NOT NULL DEFAULT '0', encashment_based_on enum('pay_rate','basic','gross') DEFAULT NULL, forward_default enum('encashment','carryover') NOT NULL DEFAULT 'encashment', applicable_from_days smallint(5) UNSIGNED NOT NULL DEFAULT '0', accrued_amount decimal(10,2) NOT NULL DEFAULT '0.00', accrued_max_days smallint(4) UNSIGNED NOT NULL DEFAULT '0', halfday_enable tinyint(3) UNSIGNED NOT NULL DEFAULT '0', created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_id (leave_id), KEY f_year (f_year) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_policies_segregation_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_policy_id bigint(20) UNSIGNED NOT NULL, jan tinyint(3) UNSIGNED NOT NULL DEFAULT '0', feb tinyint(3) UNSIGNED NOT NULL DEFAULT '0', mar tinyint(3) UNSIGNED NOT NULL DEFAULT '0', apr tinyint(3) UNSIGNED NOT NULL DEFAULT '0', may tinyint(3) UNSIGNED NOT NULL DEFAULT '0', jun tinyint(3) UNSIGNED NOT NULL DEFAULT '0', jul tinyint(3) UNSIGNED NOT NULL DEFAULT '0', aug tinyint(3) UNSIGNED NOT NULL DEFAULT '0', sep tinyint(3) UNSIGNED NOT NULL DEFAULT '0', oct tinyint(3) UNSIGNED NOT NULL DEFAULT '0', nov tinyint(3) UNSIGNED NOT NULL DEFAULT '0', decem tinyint(3) UNSIGNED NOT NULL DEFAULT '0', created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_policy_id (leave_policy_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_entitlements_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, created_by bigint(20) UNSIGNED DEFAULT NULL, trn_id bigint(20) UNSIGNED NOT NULL, trn_type enum('leave_policies','leave_approval_status','leave_encashment_requests','leave_entitlements','unpaid_leave','leave_encashment', 'leave_carryforward', 'manual_leave_policies', 'Accounts', 'others', 'leave_accrual', 'carry_forward_leave_expired') NOT NULL DEFAULT 'leave_policies', day_in decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', day_out decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', description text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, f_year smallint(6) NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY comp_key_1 (user_id,leave_id,f_year,trn_type), KEY trn_id (trn_id), KEY leave_id (leave_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_requests_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, leave_entitlement_id bigint(20) UNSIGNED NOT NULL default '0', day_status_id smallint(5) UNSIGNED NOT NULL DEFAULT '1', days decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', start_date int(11) NOT NULL, end_date int(11) NOT NULL, reason text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, last_status smallint(6) UNSIGNED NOT NULL DEFAULT '2', created_by bigint(20) UNSIGNED DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY user_leave (user_id,leave_id), KEY user_entitlement (user_id,leave_entitlement_id), KEY last_status (last_status), KEY leave_entitlement_id (leave_entitlement_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_approval_status_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_request_id bigint(20) UNSIGNED NOT NULL, approval_status_id tinyint(3) UNSIGNED NOT NULL DEFAULT '0', approved_by bigint(20) UNSIGNED DEFAULT NULL, message text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_request_id (leave_request_id), KEY approval_status_id (approval_status_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_request_details_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_request_id bigint(20) UNSIGNED NOT NULL, leave_approval_status_id bigint(20) UNSIGNED NOT NULL, workingday_status tinyint(3) UNSIGNED NOT NULL DEFAULT '1', user_id bigint(20) UNSIGNED NOT NULL, f_year smallint(6) NOT NULL, leave_date int(11) NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_request_id (leave_request_id), KEY user_id (user_id), KEY user_fyear_leave (user_id,f_year,leave_date) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leave_encashment_requests_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, approved_by bigint(20) UNSIGNED DEFAULT NULL, approval_status_id tinyint(3) UNSIGNED NOT NULL DEFAULT '1', encash_days decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', forward_days decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', amount decimal(20,2) NOT NULL DEFAULT '0.00', total decimal(20,2) NOT NULL DEFAULT '0.00', f_year smallint(5) UNSIGNED NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY leave_id (leave_id), KEY f_year (f_year) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_leaves_unpaid_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_id smallint(6) UNSIGNED NOT NULL, leave_request_id bigint(20) UNSIGNED NOT NULL, leave_approval_status_id bigint(20) UNSIGNED NOT NULL, user_id bigint(20) UNSIGNED NOT NULL, days decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', amount decimal(20,2) NOT NULL DEFAULT '0.00', total decimal(20,2) NOT NULL DEFAULT '0.00', f_year smallint(5) UNSIGNED NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY leave_id (leave_id), KEY f_year (f_year), KEY leave_request_id (leave_request_id), KEY leave_approval_status_id (leave_approval_status_id) ) $charset_collate;\", \"CREATE TABLE wp_erp_hr_financial_years_new ( id int(11) UNSIGNED NOT NULL AUTO_INCREMENT, fy_name varchar(255) COLLATE"},{"table_name":"erp_hr_leaves_unpaid","full_table_name":"wp_erp_hr_leaves_unpaid","description":"Stores erp hr leaves unpaid data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_leaves_unpaid_new","full_table_name":"wp_erp_hr_leaves_unpaid_new","description":"Stores erp hr leaves unpaid new data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_hr_work_exp","full_table_name":"wp_erp_hr_work_exp","description":"Stores erp hr work exp data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_people_type_relations","full_table_name":"wp_erp_people_type_relations","description":"Stores erp people type relations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_people_types","full_table_name":"wp_erp_people_types","description":"Stores erp people types data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"people_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"people_types_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_erp_people_types` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) $collate;\"; $relations_table = \"CREATE TABLE IF NOT EXISTS `wp_erp_people_type_relations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `people_id` bigint(20) unsigned DEFAULT NULL, `people_types_id` int(11) unsigned DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `people_id` (`people_id`), KEY `people_types_id` (`people_types_id`) ) $collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $types_table );"},{"table_name":"erp_peoplemeta","full_table_name":"wp_erp_peoplemeta","description":"Stores erp peoplemeta data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"erp_peoples","full_table_name":"wp_erp_peoples","description":"Stores erp peoples data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"erp_user_leaves","full_table_name":"wp_erp_user_leaves","description":"Stores erp user leaves data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"request_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"holiday_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"title","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"start","type":"timestamp","nullable":false,"primary_key":false},{"name":"end","type":"timestamp","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"range_status","type":"varchar(5)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"employee_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"company_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"job_title","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"from","type":"date","nullable":true,"primary_key":false},{"name":"to","type":"date","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"employee_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"school","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"degree","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"field","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"result","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"result_type","type":"enum('grade', 'percentage')","nullable":true,"primary_key":false},{"name":"finished","type":"int(4) unsigned","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"interest","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"employee_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"relation","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"dob","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"employee_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"reporting_to","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"job_knowledge","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"work_quality","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"attendance","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"communication","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"dependablity","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"reviewer","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"comments","type":"text","nullable":true,"primary_key":false},{"name":"completion_date","type":"datetime","nullable":true,"primary_key":false},{"name":"goal_description","type":"text","nullable":true,"primary_key":false},{"name":"employee_assessment","type":"text","nullable":true,"primary_key":false},{"name":"supervisor","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"supervisor_assessment","type":"text","nullable":true,"primary_key":false},{"name":"type","type":"text","nullable":true,"primary_key":false},{"name":"performance_date","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"post_id","type":"bigint(11)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"email_status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"first_name","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"company","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"mobile","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"other","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"website","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"fax","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"street_1","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"street_2","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(80)","nullable":true,"primary_key":false},{"name":"state","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"postal_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"currency","type":"varchar(5)","nullable":true,"primary_key":false},{"name":"life_stage","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"contact_owner","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"hash","type":"VARCHAR(40)","nullable":true,"primary_key":false},{"name":"created_by","type":"BIGINT(20)","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false},{"name":"erp_people_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"name","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"people_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"people_types_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false},{"name":"component","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"sub_component","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"data_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"old_value","type":"longtext","nullable":true,"primary_key":false},{"name":"new_value","type":"longtext","nullable":true,"primary_key":false},{"name":"message","type":"longtext","nullable":true,"primary_key":false},{"name":"changetype","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"created_by","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"customer_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"company_id","type":"bigint(50)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"message","type":"longtext","nullable":true,"primary_key":false},{"name":"email_subject","type":"text","nullable":true,"primary_key":false},{"name":"log_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"start_date","type":"datetime","nullable":true,"primary_key":false},{"name":"end_date","type":"datetime","nullable":true,"primary_key":false},{"name":"created_by","type":"int(11)","nullable":true,"primary_key":false},{"name":"extra","type":"longtext","nullable":true,"primary_key":false},{"name":"sent_notification","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"done_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"activity_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"private","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"group_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"subscribe_at","type":"datetime","nullable":true,"primary_key":false},{"name":"unsubscribe_at","type":"datetime","nullable":true,"primary_key":false},{"name":"hash","type":"VARCHAR(40)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"type","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"global","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"search_name","type":"text","nullable":true,"primary_key":false},{"name":"search_val","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"name","type":"text","nullable":true,"primary_key":false},{"name":"subject","type":"text","nullable":true,"primary_key":false},{"name":"template","type":"longtext","nullable":true,"primary_key":false},{"name":"type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"currency","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"editable","type":"tinyint","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"bill_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"due_date","type":"date","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"sign","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"invoice_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"qty","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"unit_price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"discount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"shipping","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_cat_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"item_total","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ecommerce_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"transaction_charge","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"invoice_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"due_date","type":"date","nullable":true,"primary_key":false},{"name":"billing_address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"discount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"discount_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"shipping","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"shipping_tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_zone_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"estimate","type":"boolean","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"additional_notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"voucher_amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"chart_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"parent_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"system","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"short_code","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"chart_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"code","type":"int(11)","nullable":true,"primary_key":false},{"name":"unused","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"system","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"balance","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ac_from","type":"int(11)","nullable":true,"primary_key":false},{"name":"ac_to","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"financial_year_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"chart_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"bill_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"transaction_charge","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"purchase_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_cat_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"people_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"people_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"people_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"parent","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"product_type_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"tax_cat_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor","type":"int(11)","nullable":true,"primary_key":false},{"name":"cost_price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"sale_price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"stock_in","type":"int(11)","nullable":true,"primary_key":false},{"name":"stock_out","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"billing_address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"due_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_zone_id","type":"integer","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"purchase_order","type":"boolean","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"purchase_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"qty","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_cat_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"invoice_details_id","type":"int(20)","nullable":false,"primary_key":false},{"name":"agency_id","type":"int(20)","nullable":true,"primary_key":false},{"name":"tax_rate","type":"decimal(20,2)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_by","type":"int(20)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_by","type":"int(20)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"tax_rate_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tax_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"default","type":"boolean","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"tax_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"component_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tax_cat_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"tax_rate","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"ecommerce_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by","type":"int(11)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20, 2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20, 2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"invoice_details_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"tax_rate","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"type_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"system_id","type":"bigint","nullable":false,"primary_key":false},{"name":"sync_id","type":"bigint","nullable":true,"primary_key":false},{"name":"sync_slug","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"sync_type","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"sync_source","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"people_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"people_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_by","type":"int(11)","nullable":true,"primary_key":false},{"name":"transaction_charge","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"bank","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"pay_to","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_erp_user_leaves` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `request_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_holidays_indv` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `holiday_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_holiday` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `description` text NOT NULL, `range_status` varchar(5) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_work_exp` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) DEFAULT NULL, `company_name` varchar(100) DEFAULT NULL, `job_title` varchar(100) DEFAULT NULL, `from` date DEFAULT NULL, `to` date DEFAULT NULL, `description` text, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_education` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) unsigned DEFAULT NULL, `school` varchar(100) DEFAULT NULL, `degree` varchar(100) DEFAULT NULL, `field` varchar(100) DEFAULT NULL, `result` varchar(50) DEFAULT NULL, `result_type` enum('grade', 'percentage') DEFAULT NULL, `finished` int(4) unsigned DEFAULT NULL, `notes` text, `interest` text, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_dependents` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `relation` varchar(100) DEFAULT NULL, `dob` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_employee_performance` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) unsigned DEFAULT NULL, `reporting_to` int(11) unsigned DEFAULT NULL, `job_knowledge` varchar(100) DEFAULT NULL, `work_quality` varchar(100) DEFAULT NULL, `attendance` varchar(100) DEFAULT NULL, `communication` varchar(100) DEFAULT NULL, `dependablity` varchar(100) DEFAULT NULL, `reviewer` int(11) unsigned DEFAULT NULL, `comments` text, `completion_date` datetime DEFAULT NULL, `goal_description` text, `employee_assessment` text, `supervisor` int(11) unsigned DEFAULT NULL, `supervisor_assessment` text, `type` text, `performance_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_announcement` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `post_id` bigint(11) NOT NULL, `status` varchar(30) NOT NULL, `email_status` varchar(30) NOT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY `post_id` (`post_id`), KEY `status` (`status`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_peoples` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT '0', `first_name` varchar(60) DEFAULT NULL, `last_name` varchar(60) DEFAULT NULL, `company` varchar(60) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `mobile` varchar(20) DEFAULT NULL, `other` varchar(50) DEFAULT NULL, `website` varchar(100) DEFAULT NULL, `fax` varchar(20) DEFAULT NULL, `notes` text, `street_1` varchar(255) DEFAULT NULL, `street_2` varchar(255) DEFAULT NULL, `city` varchar(80) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `postal_code` varchar(10) DEFAULT NULL, `country` varchar(20) DEFAULT NULL, `currency` varchar(5) DEFAULT NULL, `life_stage` VARCHAR(100) DEFAULT NULL, `contact_owner` bigint(20) DEFAULT NULL, `hash` VARCHAR(40) DEFAULT NULL, `created_by` BIGINT(20) DEFAULT NULL, `created` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `first_name` (`first_name`), KEY `last_name` (`last_name`), KEY `email` (`email`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_peoplemeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `erp_people_id` bigint(20) DEFAULT NULL, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `erp_people_id` (`erp_people_id`), KEY `meta_key` (`meta_key`(191)) ) $charset_collate;\", \"CREATE TABLE `wp_erp_people_types` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_people_type_relations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `people_id` bigint(20) unsigned DEFAULT NULL, `people_types_id` int(11) unsigned DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `people_id` (`people_id`), KEY `people_types_id` (`people_types_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_audit_log` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `component` varchar(50) NOT NULL DEFAULT '', `sub_component` varchar(50) NOT NULL DEFAULT '', `data_id` bigint(20) DEFAULT NULL, `old_value` longtext, `new_value` longtext, `message` longtext, `changetype` varchar(10) DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `component` (`component`), KEY `sub_component` (`sub_component`), KEY `changetype` (`changetype`), KEY `created_by` (`created_by`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_customer_companies` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `customer_id` bigint(20) DEFAULT NULL, `company_id` bigint(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `customer_id` (`customer_id`), KEY `company_id` (`company_id`) ) $charset_collate;\", \"CREATE TABLE wp_erp_crm_customer_activities ( id int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `message` longtext, email_subject text, log_type varchar(255) DEFAULT NULL, `start_date` datetime DEFAULT NULL, end_date datetime DEFAULT NULL, created_by int(11) DEFAULT NULL, extra longtext, sent_notification tinyint(4) DEFAULT '0', done_at datetime DEFAULT NULL, created_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY `type` (`type`), KEY log_type (log_type), KEY created_by (created_by) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_activities_task` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `activity_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `activity_id` (`activity_id`), KEY `user_id` (`user_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_contact_group` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `description` text, `private` TINYINT(1) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_contact_subscriber` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `group_id` int(11) DEFAULT NULL, `status` varchar(25) DEFAULT NULL, `subscribe_at` datetime DEFAULT NULL, `unsubscribe_at` datetime DEFAULT NULL, `hash` VARCHAR(40) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_group` (`user_id`,`group_id`), KEY `status` (`status`), KEY `hash` (`hash`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_save_search` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `type` VARCHAR(255) DEFAULT NULL, `global` tinyint(4) DEFAULT '0', `search_name` text, `search_val` text, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_save_email_replies` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` text, `subject` text, `template` longtext, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_voucher_no` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(255) DEFAULT NULL, `currency` varchar(50) DEFAULT NULL, `editable` tinyint DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_bill_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bill_no` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_bill_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_bills` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `vendor_id` int(11) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `ref` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `particulars` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_chart_of_accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_currency_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `sign` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_invoice_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `invoice_no` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE wp_erp_acct_invoice_details ( id int(11) NOT NULL AUTO_INCREMENT, trn_no int(11) DEFAULT NULL, product_id int(11) DEFAULT NULL, qty decimal(10,2) DEFAULT NULL, unit_price decimal(20,2) DEFAULT 0, discount decimal(20,2) DEFAULT 0, shipping decimal(20,2) DEFAULT 0, tax decimal(20,2) DEFAULT 0, tax_cat_id int(11) DEFAULT NULL, item_total decimal(20,2) DEFAULT 0, ecommerce_type varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_invoice_receipts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `customer_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `transaction_charge` decimal(20,2) DEFAULT 0, `ref` varchar(255) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `trn_by` varchar(255) DEFAULT NULL, `trn_by_ledger_id` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_invoice_receipts_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `invoice_no` int(11) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_invoices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `customer_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `billing_address` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `discount` decimal(20,2) DEFAULT 0, `discount_type` varchar(255) DEFAULT NULL, `shipping` decimal(20,2) DEFAULT 0, `shipping_tax` decimal(20,2) DEFAULT 0, `tax` decimal(20,2) DEFAULT 0, `tax_zone_id` int(11) DEFAULT NULL, `estimate` boolean DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `additional_notes` TEXT NULL DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_journal_details` ( id int(11) NOT NULL AUTO_INCREMENT, trn_no int(11) DEFAULT NULL, ledger_id int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_journals` ( id int(11) NOT NULL AUTO_INCREMENT, trn_date date DEFAULT NULL, ref varchar(255) DEFAULT NULL, voucher_no int(11) DEFAULT NULL, voucher_amount decimal(20,2) DEFAULT 0, particulars varchar(255) DEFAULT NULL, attachments varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_ledger_categories` ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, slug varchar(255) DEFAULT NULL, chart_id int(11) DEFAULT NULL, parent_id int(11) DEFAULT NULL, `system` tinyint(1) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_ledger_details` ( id int(11) NOT NULL AUTO_INCREMENT, ledger_id int(11) DEFAULT NULL, trn_no int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, trn_date date DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_ledger_settings` ( id int(11) NOT NULL AUTO_INCREMENT, ledger_id int(11) DEFAULT NULL, short_code varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_ledgers` ( id int(11) NOT NULL AUTO_INCREMENT, chart_id int(11) DEFAULT NULL, category_id int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, slug varchar(255) DEFAULT NULL, code int(11) DEFAULT NULL, unused tinyint(1) DEFAULT NULL, `system` tinyint(1) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_cash_at_banks` ( id int(11) NOT NULL AUTO_INCREMENT, ledger_id int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, balance decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_transfer_voucher` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, amount decimal(20,2) DEFAULT NULL, ac_from int(11) DEFAULT NULL, ac_to int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_opening_balances` ( id int(11) NOT NULL AUTO_INCREMENT, financial_year_id int(11) DEFAULT NULL, chart_id int(11) DEFAULT NULL, ledger_id int(11) DEFAULT NULL, `type` varchar(50) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_financial_years` ( id int(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) DEFAULT NULL, `start_date` date DEFAULT NULL, end_date date DEFAULT NULL, `description` varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_pay_bill` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, vendor_id int(11) DEFAULT NULL, vendor_name varchar(255) DEFAULT NULL, trn_date date DEFAULT NULL, amount decimal(20,2) DEFAULT 0, trn_by varchar(255) DEFAULT NULL, trn_by_ledger_id int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, ref varchar(255) DEFAULT NULL, attachments varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_pay_bill_details` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, bill_no int(11) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_pay_purchase` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, vendor_id int(11) DEFAULT NULL, vendor_name varchar(255) DEFAULT NULL, trn_date date DEFAULT NULL, amount decimal(20,2) DEFAULT 0, trn_by varchar(255) DEFAULT NULL, transaction_charge decimal(20,2) DEFAULT 0, ref varchar(255) DEFAULT NULL, trn_by_ledger_id int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, attachments varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE wp_erp_acct_pay_purchase_details ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, purchase_no int(11) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, tax_cat_id int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_people_account_details` ( id int(11) NOT NULL AUTO_INCREMENT, people_id varchar(255) DEFAULT NULL, trn_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, trn_by varchar(255) DEFAULT NULL, voucher_type varchar(255) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_people_trn` ( id int(11) NOT NULL AUTO_INCREMENT, people_id varchar(255) DEFAULT NULL, voucher_no int(11) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, trn_date date DEFAULT NULL, trn_by varchar(255) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, voucher_type varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_people_trn_details` ( id int(11) NOT NULL AUTO_INCREMENT, people_id varchar(255) DEFAULT NULL, voucher_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_product_categories` ( id int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, parent int(11) NOT NULL DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_product_types` ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, slug varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_products` ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, product_type_id int(11) DEFAULT NULL, category_id int(11) DEFAULT NULL, tax_cat_id int(11) DEFAULT NULL, vendor int(11) DEFAULT NULL, cost_price decimal(20,2) DEFAULT 0, sale_price decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_product_details` ( id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) DEFAULT NULL, trn_no int(11) DEFAULT NULL, stock_in int(11) DEFAULT NULL, stock_out int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_purchase` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, vendor_id int(11) DEFAULT NULL, vendor_name varchar(255) DEFAULT NULL, billing_address varchar(255) DEFAULT NULL, trn_date date DEFAULT NULL, due_date date DEFAULT NULL, amount decimal(20,2) DEFAULT 0, tax decimal(20,2) DEFAULT NULL , tax_zone_id integer DEFAULT NULL, ref varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, purchase_order boolean DEFAULT NULL, attachments varchar(255) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_purchase_account_details` ( id int(11) NOT NULL AUTO_INCREMENT, purchase_no int(11) DEFAULT NULL, trn_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20,2) DEFAULT 0, credit decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE wp_erp_acct_purchase_details ( id int(11) NOT NULL AUTO_INCREMENT, trn_no int(11) DEFAULT NULL, product_id int(11) DEFAULT NULL, qty decimal(10,2) DEFAULT NULL, price decimal(20,2) DEFAULT 0, amount decimal(20,2) DEFAULT 0, tax decimal(20,2) DEFAULT NULL, tax_cat_id int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE wp_erp_acct_purchase_details_tax ( id int(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_details_id int(20) NOT NULL, agency_id int(20) DEFAULT NULL, tax_rate decimal(20,2) NOT NULL, created_at datetime DEFAULT NULL, created_by int(20) DEFAULT NULL, updated_at datetime DEFAULT NULL, updated_by int(20) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_tax_categories` ( id int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_taxes` ( id int(11) NOT NULL AUTO_INCREMENT, tax_rate_name varchar(255) DEFAULT NULL, tax_number varchar(100) DEFAULT NULL, `default` boolean DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_tax_cat_agency` ( id int(11) NOT NULL AUTO_INCREMENT, tax_id int(11) DEFAULT NULL, component_name varchar(255) DEFAULT NULL, tax_cat_id int(11) DEFAULT NULL, agency_id int(11) DEFAULT NULL, tax_rate decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_tax_agencies` ( id int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, ecommerce_type varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_tax_pay` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, particulars varchar(255) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, voucher_type varchar(255) DEFAULT NULL, trn_by int(11) DEFAULT NULL, agency_id int(11) DEFAULT NULL, ledger_id int(11) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_tax_agency_details` ( id int(11) NOT NULL AUTO_INCREMENT, agency_id int(11) DEFAULT NULL, trn_no int(11) DEFAULT NULL, trn_date date DEFAULT NULL, particulars varchar(255) DEFAULT NULL, debit decimal(20, 2) DEFAULT 0, credit decimal(20, 2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_invoice_details_tax` ( id int(11) NOT NULL AUTO_INCREMENT, invoice_details_id int(11) DEFAULT NULL, agency_id int(11) DEFAULT NULL, tax_rate decimal(20,2) DEFAULT 0, tax_amount decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_trn_status_types` ( id int(11) NOT NULL AUTO_INCREMENT, type_name varchar(255) DEFAULT NULL, slug varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE wp_erp_acct_synced_taxes ( id int NOT NULL AUTO_INCREMENT, system_id bigint NOT NULL, sync_id bigint DEFAULT NULL, sync_slug varchar(100) DEFAULT NULL, sync_type varchar(100) DEFAULT NULL, sync_source varchar(100) DEFAULT NULL, PRIMARY KEY (id), KEY system_id (system_id), KEY sync_id (sync_id), KEY sync_slug (sync_slug), KEY sync_type (sync_type), KEY sync_source (sync_source) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_payment_methods` ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_expenses` ( id int(11) NOT NULL AUTO_INCREMENT, voucher_no int(11) DEFAULT NULL, people_id int(11) DEFAULT NULL, people_name varchar(255) DEFAULT NULL, address varchar(255) DEFAULT NULL, trn_date date DEFAULT NULL, amount decimal(20,2) DEFAULT 0, ref varchar(255) DEFAULT NULL, check_no varchar(255) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, status int(11) DEFAULT NULL, trn_by int(11) DEFAULT NULL, transaction_charge decimal(20,2) DEFAULT 0, trn_by_ledger_id int(11) DEFAULT NULL, attachments varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_expense_details` ( id int(11) NOT NULL AUTO_INCREMENT, trn_no int(11) DEFAULT NULL, ledger_id int(11) DEFAULT NULL, particulars varchar(255) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `wp_erp_acct_expense_checks` ( id int(11) NOT NULL AUTO_INCREMENT, trn_no int(11) DEFAULT NULL, check_no varchar(255) DEFAULT NULL, voucher_type varchar(255) DEFAULT NULL, amount decimal(20,2) DEFAULT 0, bank varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, pay_to varchar(255) DEFAULT NULL, created_at date DEFAULT NULL, created_by varchar(50) DEFAULT NULL, updated_at date DEFAULT NULL, updated_by varchar(50) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $table_schema as $table ) { $erp_table_created = dbDelta( $table );"}],"table_count":102}