Hello all,
ich have some troubles in 2 psa-tables.
One of them is DomainsTraffic, the other is module_watchdog_sys_stat.
I think in both are data who is not really high necessary, so i can drop the tables an make it new.
I found the structure for "DomainsTraffic":
CREATE TABLE `DomainsTraffic` (
`dom_id` int(10) unsigned NOT NULL,
`date` date NOT NULL,
`http_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`http_out` bigint(20) unsigned NOT NULL DEFAULT '0',
`ftp_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`ftp_out` bigint(20) unsigned NOT NULL DEFAULT '0',
`smtp_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`smtp_out` bigint(20) unsigned NOT NULL DEFAULT '0',
`pop3_imap_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`pop3_imap_out` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`dom_id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
Now the check for this table works fine. So i want to do the same with watchdog_sys_stat. But i don´t find the structure. Who can me help to repair the table or make a new one?
Thanks, Klaus
ich have some troubles in 2 psa-tables.
One of them is DomainsTraffic, the other is module_watchdog_sys_stat.
I think in both are data who is not really high necessary, so i can drop the tables an make it new.
I found the structure for "DomainsTraffic":
CREATE TABLE `DomainsTraffic` (
`dom_id` int(10) unsigned NOT NULL,
`date` date NOT NULL,
`http_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`http_out` bigint(20) unsigned NOT NULL DEFAULT '0',
`ftp_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`ftp_out` bigint(20) unsigned NOT NULL DEFAULT '0',
`smtp_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`smtp_out` bigint(20) unsigned NOT NULL DEFAULT '0',
`pop3_imap_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`pop3_imap_out` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`dom_id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
Now the check for this table works fine. So i want to do the same with watchdog_sys_stat. But i don´t find the structure. Who can me help to repair the table or make a new one?
Thanks, Klaus