{"slug":"invoicing","name":"Payment forms, Buy now buttons, and Invoicing System | GetPaid","description":"Payments & Invoicing plugin for WordPress to quickly and easily sell online. Create Buy Now buttons or inline checkout forms in seconds to accept  …","author":"Stiofan","active_installs":5000,"version":"2.8.54","wp_org_url":"https://wordpress.org/plugins/invoicing/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"getpaid_anonymization_logs","full_table_name":"wp_getpaid_anonymization_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"getpaid_customer_meta","full_table_name":"wp_getpaid_customer_meta","description":"Stores additional metadata (key-value pairs) for getpaid customer records.","detection_method":"static","confidence":"medium","columns":[{"name":"meta_id","type":"BIGINT(20)","nullable":false,"primary_key":true},{"name":"customer_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"meta_key","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"meta_value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"data_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"timestamp","type":"DATETIME","nullable":false,"primary_key":false},{"name":"additional_info","type":"TEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_getpaid_customer_meta ( meta_id BIGINT(20) NOT NULL AUTO_INCREMENT, customer_id BIGINT(20) NOT NULL, meta_key VARCHAR(255) NOT NULL, meta_value LONGTEXT, PRIMARY KEY (meta_id), KEY customer_id (customer_id), KEY meta_key (meta_key(191)) ) $charset_collate;\"; // Anonymization Logs. $schema['anonymization_logs'] = \"CREATE TABLE wp_getpaid_anonymization_logs ( log_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, action VARCHAR(50) NOT NULL, data_type VARCHAR(50) NOT NULL, timestamp DATETIME NOT NULL, additional_info TEXT, PRIMARY KEY (log_id), KEY user_id (user_id), KEY action (action), KEY data_type (data_type), KEY timestamp (timestamp) ) $charset_collate;\"; // Filter. $schema = apply_filters( 'getpaid_db_schema', $schema );"},{"table_name":"getpaid_customers","full_table_name":"wp_getpaid_customers","description":"Stores getpaid customers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"getpaid_invoice_items","full_table_name":"wp_getpaid_invoice_items","description":"Stores getpaid invoice items data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"getpaid_invoices","full_table_name":"wp_getpaid_invoices","description":"Stores getpaid invoices data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wpinv_subscriptions","full_table_name":"wp_wpinv_subscriptions","description":"Stores wpinv subscriptions data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"customer_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"frequency","type":"int(11)","nullable":false,"primary_key":false},{"name":"period","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"initial_amount","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"recurring_amount","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"bill_times","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"transaction_id","type":"varchar(60)","nullable":false,"primary_key":false},{"name":"parent_payment_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"product_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"created","type":"datetime","nullable":false,"primary_key":false},{"name":"expiration","type":"datetime","nullable":false,"primary_key":false},{"name":"trial_period","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"profile_id","type":"varchar(60)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"customer_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"number","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"invoice_key","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"type","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"mode","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"user_ip","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"first_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"last_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"address","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"city","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"state","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"country","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"zip","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"adddress_confirmed","type":"INT(10)","nullable":true,"primary_key":false},{"name":"gateway","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"transaction_id","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"subtotal","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"tax","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"fees_total","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"total","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"discount","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"discount_code","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"disable_taxes","type":"INT(2)","nullable":false,"primary_key":false},{"name":"due_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"completed_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"company","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"vat_number","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"vat_rate","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"custom_meta","type":"TEXT","nullable":true,"primary_key":false},{"name":"is_anonymized","type":"INT(2)","nullable":false,"primary_key":false},{"name":"post_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"item_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"item_name","type":"TEXT","nullable":false,"primary_key":false},{"name":"item_description","type":"TEXT","nullable":false,"primary_key":false},{"name":"vat_rate","type":"FLOAT","nullable":false,"primary_key":false},{"name":"vat_class","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"tax","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"item_price","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"custom_price","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"quantity","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"discount","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"subtotal","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"price","type":"DECIMAL(16,4)","nullable":false,"primary_key":false},{"name":"meta","type":"TEXT","nullable":true,"primary_key":false},{"name":"fees","type":"TEXT","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"email_cc","type":"TEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"purchase_value","type":"DECIMAL(18,9)","nullable":false,"primary_key":false},{"name":"purchase_count","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"user_id","type":"and","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_wpinv_subscriptions ( id bigint(20) unsigned NOT NULL auto_increment, customer_id bigint(20) NOT NULL, frequency int(11) NOT NULL DEFAULT '1', period varchar(20) NOT NULL, initial_amount DECIMAL(16,4) NOT NULL, recurring_amount DECIMAL(16,4) NOT NULL, bill_times bigint(20) NOT NULL, transaction_id varchar(60) NOT NULL, parent_payment_id bigint(20) NOT NULL, product_id bigint(20) NOT NULL, created datetime NOT NULL, expiration datetime NOT NULL, trial_period varchar(20) NOT NULL, profile_id varchar(60) NOT NULL, status varchar(20) NOT NULL, PRIMARY KEY (id), KEY profile_id (profile_id), KEY customer (customer_id), KEY transaction (transaction_id), KEY customer_and_status (customer_id, status) ) $charset_collate;\"; // Invoices. $schema['invoices'] = \"CREATE TABLE wp_getpaid_invoices ( post_id BIGINT(20) NOT NULL, customer_id BIGINT(20) NOT NULL DEFAULT 0, `number` VARCHAR(100), invoice_key VARCHAR(100), `type` VARCHAR(100) NOT NULL DEFAULT 'invoice', mode VARCHAR(100) NOT NULL DEFAULT 'live', user_ip VARCHAR(100), first_name VARCHAR(100), last_name VARCHAR(100), `address` VARCHAR(100), city VARCHAR(100), `state` VARCHAR(100), country VARCHAR(100), zip VARCHAR(100), adddress_confirmed INT(10), gateway VARCHAR(100), transaction_id VARCHAR(100), currency VARCHAR(10), subtotal DECIMAL(16,4) NOT NULL DEFAULT 0, tax DECIMAL(16,4) NOT NULL DEFAULT 0, fees_total DECIMAL(16,4) NOT NULL DEFAULT 0, total DECIMAL(16,4) NOT NULL DEFAULT 0, discount DECIMAL(16,4) NOT NULL DEFAULT 0, discount_code VARCHAR(100), disable_taxes INT(2) NOT NULL DEFAULT 0, due_date DATETIME, completed_date DATETIME, company VARCHAR(100), vat_number VARCHAR(100), vat_rate VARCHAR(100), custom_meta TEXT, is_anonymized INT(2) NOT NULL DEFAULT 0, PRIMARY KEY (post_id), KEY `number` (`number`), KEY invoice_key (invoice_key) ) $charset_collate;\"; // Invoice items. $schema['items'] = \"CREATE TABLE wp_getpaid_invoice_items ( ID BIGINT(20) NOT NULL AUTO_INCREMENT, post_id BIGINT(20) NOT NULL, item_id BIGINT(20) NOT NULL, item_name TEXT NOT NULL, item_description TEXT NOT NULL, vat_rate FLOAT NOT NULL DEFAULT 0, vat_class VARCHAR(100), tax DECIMAL(16,4) NOT NULL DEFAULT 0, item_price DECIMAL(16,4) NOT NULL DEFAULT 0, custom_price DECIMAL(16,4) NOT NULL DEFAULT 0, quantity DECIMAL(16,4) NOT NULL DEFAULT 1, discount DECIMAL(16,4) NOT NULL DEFAULT 0, subtotal DECIMAL(16,4) NOT NULL DEFAULT 0, price DECIMAL(16,4) NOT NULL DEFAULT 0, meta TEXT, fees TEXT, PRIMARY KEY (ID), KEY item_id (item_id), KEY post_id (post_id) ) $charset_collate;\"; // Customers. $schema['customers'] = \"CREATE TABLE wp_getpaid_customers ( id BIGINT(20) NOT NULL AUTO_INCREMENT, user_id BIGINT(20) NOT NULL, email VARCHAR(100) NOT NULL, email_cc TEXT, status VARCHAR(100) NOT NULL DEFAULT 'active', purchase_value DECIMAL(18,9) NOT NULL DEFAULT 0, purchase_count BIGINT(20) NOT NULL DEFAULT 0, \"; // Add address fields. foreach ( array_keys( getpaid_user_address_fields( true ) ) as $field ) { // Skip id, user_id and email. if ( in_array( $field, array( 'id', 'user_id', 'email', 'purchase_value', 'purchase_count', 'date_created', 'date_modified', 'uuid' ), true ) ) { continue; } $field = sanitize_key( $field );"}],"table_count":6}