wp_lhdn_myinvoice
StaticStores lhdn myinvoice data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT | YES |
| invoice_no | VARCHAR(100) | YES |
| order_id | BIGINT | YES |
| uuid | VARCHAR(100) | YES |
| longid | VARCHAR(100) | YES |
| item_class | VARCHAR(100) | YES |
| document_hash | CHAR(64) | YES |
| payload | LONGTEXT | YES |
| status | VARCHAR(30) | YES |
| code | VARCHAR(30) | YES |
| response | LONGTEXT | YES |
| retry_count | INT | YES |
| queue_status | VARCHAR(50) | YES |
| queue_date | DATETIME | YES |
| refund_complete | TINYINT(1) | YES |
| created_at | DATETIME | YES |
| updated_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_lhdn_myinvoice ( id BIGINT AUTO_INCREMENT PRIMARY KEY, invoice_no VARCHAR(100) UNIQUE, order_id BIGINT, uuid VARCHAR(100), longid VARCHAR(100), item_class VARCHAR(100), document_hash CHAR(64), payload LONGTEXT, status VARCHAR(30), code VARCHAR(30), response LONGTEXT, retry_count INT DEFAULT 0, queue_status VARCHAR(50), queue_date DATETIME, refund_complete TINYINT(1) DEFAULT 0, created_at DATETIME, updated_at DATETIME, KEY idx_uuid (uuid), KEY idx_status_code (status, code), KEY idx_retry (retry_count), KEY idx_updated (updated_at), KEY idx_queue_status (queue_status) ) {$charset}; ");Safe to delete?
If you have uninstalled MyInvoice Sync, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_lhdn_myinvoice`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from MyInvoice Sync