Files
backPRO/migrations/007_remote_service_fields.sql
Jacek Pyziak 4d5e220b3c Add BackPRO News theme and update database schema for article tracking
- 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.
2026-02-17 20:08:02 +01:00

7 lines
327 B
SQL

-- BackPRO remote service metadata for WordPress management script
ALTER TABLE sites
ADD COLUMN remote_service_file VARCHAR(255) NULL AFTER wp_admin_email,
ADD COLUMN remote_service_token VARCHAR(255) NULL AFTER remote_service_file,
ADD COLUMN remote_service_installed_at DATETIME NULL AFTER remote_service_token;