Schema Scalpel

2.0.3

• Fix: Resolved SQL syntax error during database migration on certain MariaDB/MySQL environments.
• Database Enhancement: Upgraded custom_schema column to MEDIUMBLOB (16MB capacity). This fixes “Invalid JSON” errors caused by large schema payloads being truncated at 64KB.
• Database Enhancement: Upgraded id column to BIGINT UNSIGNED for better scalability on high-volume sites.
• Standards Compliance: Refactored migration queries to satisfy WordPress Coding Standards (PHPCS) while maintaining strict identifier escaping.

2.0.2

• Security & Database Hardening: Switched all custom table queries to the modern %i identifier placeholder for full compatibility with current WordPress standards and stronger protection against SQL injection.
• Performance: Refactored bulk schema generation to use efficient batch DELETE/INSERT operations.
• Compatibility: Full audit and fixes for PHP 8.4 compatibility.

2.0.1

• Performance: Third-party schema disabling (Yoast, All in One SEO, Rank Math) now uses a single efficient database query instead of three separate queries on every page load.
• Updated query to use the modern %i identifier placeholder for table names.
• Code cleanup and removal of temporary debug logging.

2.0.0

Major Feature
– Introduced full-featured Schema Scalpel metabox in the post/page editor.
– Create, edit, delete per-post/page JSON-LD schemas directly.
– Real-time AJAX saving.
– Modern UI with syntax highlighting and smooth animations.
– “Examples” tab with copyable Google-recommended templates.

Enhancements
– Added compatibility support for Rank Math SEO.
– Improved UI/UX with enhanced animations and visual clarity.
– Preserved and integrated all existing schema data into the new metabox.

Other
– Major version increment to highlight the usability leap.
– Dashboard schema management remains for global/advanced use.

1.6.4

• Compatibility fix: Removed readonly property modifiers for full PHP 7.4 support.

1.6.3

• Added strict typing and void return declarations.
• Improved PHPDoc and WordPress Coding Standards compliance.

1.6.2

• Security: Fixed Stored XSS vulnerability via post titles in JSON-LD output.
• Sanitized titles, hardened JSON encoding, secured URL/breadcrumb handling.