{"slug":"accounting-software-by-giddh","name":"Accounting Software Giddh","description":"Manage your Store Accounting and Invoicing with Giddh!","author":"giddh","active_installs":0,"version":"1.1","wp_org_url":"https://wordpress.org/plugins/accounting-software-by-giddh/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"asg_available_payment_gateways","full_table_name":"wp_asg_available_payment_gateways","description":"Stores asg available payment gateways data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"asg_categories","full_table_name":"wp_asg_categories","description":"Stores asg categories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"asg_customers","full_table_name":"wp_asg_customers","description":"Stores asg customers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"asg_giddh_products","full_table_name":"wp_asg_giddh_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"asg_invoices","full_table_name":"wp_asg_invoices","description":"Stores asg invoices data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"asg_payment_gateways","full_table_name":"wp_asg_payment_gateways","description":"Stores asg payment gateways data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"asg_woocommerce_products","full_table_name":"wp_asg_woocommerce_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"product_id","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"variant_id","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"category_id","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"amount","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"quantity","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"sku","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"stock_unit_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"is_saved","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"amount","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"quantity","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"sku","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"hsn","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"stock_group","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"stock_unit_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"is_saved","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"woocommerce_category_id","type":"INT","nullable":false,"primary_key":false},{"name":"woocommerce_category_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"giddh_stock_group_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"giddh_stock_group_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"woocommerce_customer_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"giddh_account_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"woocommerce_order_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"giddh_invoice_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"giddh_voucher_number","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"invoice_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":false,"primary_key":false},{"name":"product_sku","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"tags","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"code","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"woocommerce_payment_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"giddh_account_id","type":"varchar(100)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_asg_woocommerce_products ( id INT NOT NULL auto_increment, product_id varchar(20) NOT NULL, variant_id varchar(20) NOT NULL, category_id varchar(20) NULL DEFAULT NULL, title varchar(255) NOT NULL, amount varchar(20) NOT NULL, quantity varchar(20) NULL DEFAULT NULL, sku varchar(20) NULL DEFAULT NULL, stock_unit_code varchar(10) NULL DEFAULT NULL, is_saved TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (id) ) $collate; CREATE TABLE wp_asg_giddh_products ( id INT NOT NULL auto_increment, unique_name varchar(255) NOT NULL, title varchar(255) NOT NULL, amount varchar(20) NOT NULL, quantity varchar(20) NULL DEFAULT NULL, sku varchar(50) NULL DEFAULT NULL, hsn varchar(50) NULL DEFAULT NULL, stock_group varchar(100) NULL DEFAULT NULL, stock_unit_code varchar(10) NULL DEFAULT NULL, is_saved TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (id) ) $collate; CREATE TABLE wp_asg_categories ( id INT NOT NULL auto_increment, woocommerce_category_id INT NOT NULL, woocommerce_category_name varchar(255) NOT NULL, giddh_stock_group_id varchar(100) NOT NULL, giddh_stock_group_name varchar(255) NOT NULL, PRIMARY KEY (id) ) $collate; CREATE TABLE wp_asg_customers ( id INT NOT NULL auto_increment, woocommerce_customer_id varchar(100) NOT NULL, giddh_account_id varchar(100) NOT NULL, PRIMARY KEY (id) ) $collate; CREATE TABLE wp_asg_invoices ( id INT NOT NULL auto_increment, woocommerce_order_id varchar(100) NOT NULL, giddh_invoice_id varchar(100) NOT NULL, giddh_voucher_number varchar(100) NOT NULL, invoice_type varchar(20) NOT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $collate; CREATE TABLE wp_asg_woocommerce_temp_products ( id INT NOT NULL auto_increment, product_sku varchar(100) NOT NULL, tags varchar(20) NOT NULL, PRIMARY KEY (id) ) $collate; CREATE TABLE wp_asg_available_payment_gateways ( id INT NOT NULL auto_increment, name varchar(100) NOT NULL, code varchar(100) NOT NULL, PRIMARY KEY (id) ) $collate; CREATE TABLE wp_asg_payment_gateways ( id INT NOT NULL auto_increment, woocommerce_payment_id varchar(100) NOT NULL, giddh_account_id varchar(100) NOT NULL, PRIMARY KEY (id) ) $collate;\"; return $tables; } /* THIS WILL REGISTER THE PLUGIN ACTIVATION/DEACTIVATION WEBHOOKS */ register_activation_hook(__FILE__, 'giddhActivation');"},{"table_name":"asg_woocommerce_temp_products","full_table_name":"wp_asg_woocommerce_temp_products","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":8}