wp_lhdn_cert
StaticStores lhdn cert data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT | YES |
| pem_content | LONGTEXT | YES |
| organization | VARCHAR(255) | YES |
| organization_identifier | VARCHAR(255) | YES |
| cn | VARCHAR(255) | YES |
| serial_number | VARCHAR(255) | YES |
| email_address | VARCHAR(255) | YES |
| issuer | VARCHAR(500) | YES |
| valid_from | DATETIME | YES |
| valid_to | DATETIME | YES |
| is_active | TINYINT(1) | YES |
| created_at | DATETIME | YES |
| updated_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_lhdn_cert ( id BIGINT AUTO_INCREMENT PRIMARY KEY, pem_content LONGTEXT, organization VARCHAR(255), organization_identifier VARCHAR(255), cn VARCHAR(255), serial_number VARCHAR(255), email_address VARCHAR(255), issuer VARCHAR(500), valid_from DATETIME, valid_to DATETIME, is_active TINYINT(1) DEFAULT 1, created_at DATETIME, updated_at DATETIME ) {$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_cert`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from MyInvoice Sync