{"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","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 );","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}],"plugin":{"slug":"erp","name":"ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support","active_installs":5000,"version":"1.17.5","wp_org_url":"https://wordpress.org/plugins/erp/"}}