Ruben Puettmann wrote: > the file: > > /usr/share/doc/libapache2-mod-log-sql/create_tables.sql > > Is missing the sql statement for creating the score_board table. > Also the autocreating doesn't run: > > Ruben
Hi, Thanks for letting me know I forgot it. I'll work on it, however, here is what can be used so you can use the package right now: CREATE TABLE score_board ( id int(14) NOT NULL auto_increment, vhost varchar(50) NOT NULL default '', bytes_sent bigint(14) unsigned NOT NULL default '0', bytes_receive bigint(14) unsigned NOT NULL default '0', count_hosts int(12) NOT NULL default '0', count_visits int(12) NOT NULL default '0', count_status_200 int(12) NOT NULL default '0', count_status_404 int(12) NOT NULL default '0', count_impressions int(18) NOT NULL default '0', last_run int(14) NOT NULL default '0', month int(4) NOT NULL default '0', year int(4) NOT NULL default '0', domain varchar(50) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY `vhost` (`vhost`,`month`,`year`,`domain`) ) TYPE=MyISAM; Thomas -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
