Jacek Pyziak
e9a3602576
- Added optional SEMSTORM domain input field in site creation and editing forms. - Introduced SEO panel links in site dashboard and edit pages. - Created a new cron job for SEMSTORM data synchronization. - Implemented database migrations for cron logs and site SEO metrics. - Developed SiteSeoSyncService to handle SEMSTORM data fetching and storage. - Added logging functionality for cron events. - Created a new LogController to display cron logs with filtering options. - Added SEO statistics dashboard with visual representation of metrics. - Implemented site SEO metrics model for data retrieval and manipulation.
13 lines
468 B
SQL
13 lines
468 B
SQL
-- Cron log table for publish events
|
|
CREATE TABLE IF NOT EXISTS cron_logs (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
datetime DATETIME NOT NULL,
|
|
level VARCHAR(16) NOT NULL,
|
|
message TEXT NOT NULL,
|
|
channel VARCHAR(32) NOT NULL DEFAULT 'publish',
|
|
INDEX idx_channel_datetime (channel, datetime)
|
|
);
|
|
|
|
-- Usuwanie starszych niż 30 dni (możesz dodać do crona lub uruchamiać ręcznie):
|
|
-- DELETE FROM cron_logs WHERE datetime < (NOW() - INTERVAL 30 DAY);
|