{"table_name":"digages_direct_invoices_invoices","full_table_name":"wp_digages_direct_invoices_invoices","description":"Stores digages direct invoices invoices data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_digages_direct_invoices_invoices ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_id VARCHAR(50) NOT NULL UNIQUE, access_key VARCHAR(128) DEFAULT NULL, title VARCHAR(255) NOT NULL DEFAULT '', customer_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, currency VARCHAR(10) NOT NULL DEFAULT 'USD', subtotal DECIMAL(15,2) NOT NULL DEFAULT 0.00, discount DECIMAL(15,2) NOT NULL DEFAULT 0.00, discount_type VARCHAR(10) NOT NULL DEFAULT 'fixed', tax DECIMAL(15,2) NOT NULL DEFAULT 0.00, tax_rate DECIMAL(5,2) NOT NULL DEFAULT 0.00, stripe_platform_fee DECIMAL(15,2) NOT NULL DEFAULT 0.00, total DECIMAL(15,2) NOT NULL DEFAULT 0.00, status VARCHAR(30) NOT NULL DEFAULT 'draft', note TEXT, payment_accounts TEXT, enable_woocommerce_checkout TINYINT(1) NOT NULL DEFAULT 0, enable_stripe_payment TINYINT(1) NOT NULL DEFAULT 0, stripe_payment_mode VARCHAR(10) DEFAULT NULL, stripe_payment_intent_id VARCHAR(255) DEFAULT NULL, stripe_customer_id VARCHAR(255) DEFAULT NULL, stripe_payment_method_id VARCHAR(255) DEFAULT NULL, stripe_next_charge_at DATETIME DEFAULT NULL, stripe_last_charge_at DATETIME DEFAULT NULL, stripe_recurring_error TEXT DEFAULT NULL, stripe_recurring_retry_count SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0, stripe_recurring_cancelled_at DATETIME DEFAULT NULL, woo_product_id BIGINT(20) UNSIGNED DEFAULT NULL, woo_order_id BIGINT(20) UNSIGNED DEFAULT NULL, recurring TINYINT(1) NOT NULL DEFAULT 0, frequency VARCHAR(20) DEFAULT NULL, end_date DATE DEFAULT NULL, sent_date DATETIME DEFAULT NULL, due_date DATETIME DEFAULT NULL, paid_date DATETIME DEFAULT NULL, sent_payment_account_id BIGINT(20) UNSIGNED DEFAULT NULL, sent_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;\"; $items = \"CREATE TABLE IF NOT EXISTS wp_digages_direct_invoices_invoice_items ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_id VARCHAR(50) NOT NULL, item_type VARCHAR(30) NOT NULL DEFAULT 'custom', name VARCHAR(255) NOT NULL, quantity DECIMAL(10,2) NOT NULL DEFAULT 1, unit_price DECIMAL(15,2) NOT NULL DEFAULT 0.00, total DECIMAL(15,2) NOT NULL DEFAULT 0.00, sort_order INT NOT NULL DEFAULT 0, PRIMARY KEY (id) ) $charset_collate;\"; $customers = \"CREATE TABLE IF NOT EXISTS wp_digages_direct_invoices_customers ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, wp_user_id BIGINT(20) UNSIGNED DEFAULT NULL, full_name VARCHAR(255) NOT NULL DEFAULT '', email VARCHAR(255) NOT NULL DEFAULT '', business_name VARCHAR(255) DEFAULT NULL, use_business TINYINT(1) NOT NULL DEFAULT 0, phone VARCHAR(50) DEFAULT NULL, whatsapp VARCHAR(50) DEFAULT NULL, telegram VARCHAR(100) DEFAULT NULL, address TEXT DEFAULT NULL, state VARCHAR(100) DEFAULT NULL, zip_code VARCHAR(20) DEFAULT NULL, country VARCHAR(100) DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;\"; $activity = \"CREATE TABLE IF NOT EXISTS wp_digages_direct_invoices_activity ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_id VARCHAR(50) NOT NULL, action VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;\"; $payment_accounts = \"CREATE TABLE IF NOT EXISTS wp_digages_direct_invoices_payment_accounts ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, account_type VARCHAR(30) NOT NULL, currency VARCHAR(10) NOT NULL DEFAULT 'USD', name VARCHAR(255) NOT NULL DEFAULT '', account_name VARCHAR(255) DEFAULT NULL, account_number VARCHAR(100) DEFAULT NULL, sort_code VARCHAR(50) DEFAULT NULL, iban VARCHAR(100) DEFAULT NULL, bic_swift VARCHAR(50) DEFAULT NULL, routing_number VARCHAR(50) DEFAULT NULL, phone_number VARCHAR(50) DEFAULT NULL, wallet_address VARCHAR(255) DEFAULT NULL, network_name VARCHAR(100) DEFAULT NULL, platform_name VARCHAR(100) DEFAULT NULL, account_id VARCHAR(255) DEFAULT NULL, id_type VARCHAR(50) DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $invoices );","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"invoice_id","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"access_key","type":"VARCHAR(128)","nullable":true,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"customer_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"subtotal","type":"DECIMAL(15,2)","nullable":false,"primary_key":false},{"name":"discount","type":"DECIMAL(15,2)","nullable":false,"primary_key":false},{"name":"discount_type","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"tax","type":"DECIMAL(15,2)","nullable":false,"primary_key":false},{"name":"tax_rate","type":"DECIMAL(5,2)","nullable":false,"primary_key":false},{"name":"stripe_platform_fee","type":"DECIMAL(15,2)","nullable":false,"primary_key":false},{"name":"total","type":"DECIMAL(15,2)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"note","type":"TEXT","nullable":true,"primary_key":false},{"name":"payment_accounts","type":"TEXT","nullable":true,"primary_key":false},{"name":"enable_woocommerce_checkout","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"enable_stripe_payment","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"stripe_payment_mode","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"stripe_payment_intent_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"stripe_customer_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"stripe_payment_method_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"stripe_next_charge_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"stripe_last_charge_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"stripe_recurring_error","type":"TEXT","nullable":true,"primary_key":false},{"name":"stripe_recurring_retry_count","type":"SMALLINT(5) UNSIGNED","nullable":false,"primary_key":false},{"name":"stripe_recurring_cancelled_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"woo_product_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"woo_order_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"recurring","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"frequency","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"end_date","type":"DATE","nullable":true,"primary_key":false},{"name":"sent_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"due_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"paid_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"sent_payment_account_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"sent_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"invoice_id","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"item_type","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"quantity","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"unit_price","type":"DECIMAL(15,2)","nullable":false,"primary_key":false},{"name":"total","type":"DECIMAL(15,2)","nullable":false,"primary_key":false},{"name":"sort_order","type":"INT","nullable":false,"primary_key":false},{"name":"wp_user_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"full_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"business_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"use_business","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"whatsapp","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"telegram","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"address","type":"TEXT","nullable":true,"primary_key":false},{"name":"state","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"zip_code","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"country","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"invoice_id","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"account_type","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"account_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"account_number","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"sort_code","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"iban","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"bic_swift","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"routing_number","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"phone_number","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"wallet_address","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"network_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"platform_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"account_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"id_type","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"digages-direct-invoices","name":"Direct Invoices – Invoicing & Payment Requests for WordPress","active_installs":200,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/digages-direct-invoices/"}}