{"slug":"myinvoice-sync","name":"MyInvoice Sync","description":"Automated invoice submission to LHDN MyInvois system for Malaysian businesses.","author":"TikusL4ju","active_installs":0,"version":"2.1.2","wp_org_url":"https://wordpress.org/plugins/myinvoice-sync/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"lhdn_cert","full_table_name":"wp_lhdn_cert","description":"Stores lhdn cert data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT","nullable":true,"primary_key":true},{"name":"pem_content","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"organization","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"organization_identifier","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"cn","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"serial_number","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"email_address","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"issuer","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"valid_from","type":"DATETIME","nullable":true,"primary_key":false},{"name":"valid_to","type":"DATETIME","nullable":true,"primary_key":false},{"name":"is_active","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"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}; \");"},{"table_name":"lhdn_myinvoice","full_table_name":"wp_lhdn_myinvoice","description":"Stores lhdn myinvoice data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT","nullable":true,"primary_key":true},{"name":"invoice_no","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"order_id","type":"BIGINT","nullable":true,"primary_key":false},{"name":"uuid","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"longid","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"item_class","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"document_hash","type":"CHAR(64)","nullable":true,"primary_key":false},{"name":"payload","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"code","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"response","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"retry_count","type":"INT","nullable":true,"primary_key":false},{"name":"queue_status","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"queue_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"refund_complete","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"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}; \");"},{"table_name":"lhdn_settings","full_table_name":"wp_lhdn_settings","description":"Stores lhdn settings data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT","nullable":true,"primary_key":true},{"name":"setting_key","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"setting_value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_lhdn_settings ( id BIGINT AUTO_INCREMENT PRIMARY KEY, setting_key VARCHAR(100) UNIQUE, setting_value LONGTEXT, updated_at DATETIME ) {$charset}; \");"},{"table_name":"lhdn_tokens","full_table_name":"wp_lhdn_tokens","description":"Stores access tokens for authentication or API access.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT","nullable":true,"primary_key":true},{"name":"access_token","type":"TEXT","nullable":true,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_lhdn_tokens ( id BIGINT AUTO_INCREMENT PRIMARY KEY, access_token TEXT, expires_at DATETIME, created_at DATETIME ) {$charset}; \");"}],"table_count":4}