- Introduced a new WordPress theme "BackPRO News" with a lightweight magazine-style design. - Added columns for tracking retry attempts and timestamps for unpublished/generated articles in the articles table. - Included remote service metadata fields in the sites table for better management. - Created log files for image replacements, installer actions, OpenAI article generation, and publishing processes. - Implemented a dashboard template for site management, including permalink settings and theme installation options.
6 lines
214 B
SQL
6 lines
214 B
SQL
-- Track retry attempts for unpublished/generated articles
|
|
ALTER TABLE articles
|
|
ADD COLUMN retry_count INT NOT NULL DEFAULT 0 AFTER error_message,
|
|
ADD COLUMN last_retry_at DATETIME NULL AFTER retry_count;
|
|
|