Cоздание таблицы протоколирования хостов HTTP для MySQL Server

Минимальный набор полей:

create table hosts (
   rtime timestamp default CURRENT_TIMESTAMP,
   filterid smallint NOT NULL,
   rtype smallint,
   method smallint,
   reason smallint,
   clt_ip char(16),
   clt_port smallint unsigned,
   srv_ip char(16),
   srv_port smallint unsigned,
   clt_bytes int unsigned, 
   srv_bytes int unsigned,
   host char(100)); 

 

 Обратите внимание