Please unblock libapache-mod-log-sql 1.100-14

[Thomas Goirand <thomas@goirand.fr>]

Hi!

Please unblock libapache-mod-log-sql 1.100-14. It has very few changes:
updated dependency to apache2-mpm-prefork (>= 2.0.53) | apache2-mpm-itk
instead of just apache2-mpm-prefork (>= 2.0.53), plus added a bit of doc
on how to create the tables. This closes 2 bugs in the BTS.

Interdiff between the 2 versions is attached.

Thanks,

Thomas Goirand

diff -u libapache-mod-log-sql-1.100/debian/changelog libapache-mod-log-sql-1.100/debian/changelog
--- libapache-mod-log-sql-1.100/debian/changelog
+++ libapache-mod-log-sql-1.100/debian/changelog
@@ -1,3 +1,12 @@
+libapache-mod-log-sql (1.100-14) unstable; urgency=low
+
+  * Added doc about how to create the score_board table (Closes: #499436).
+  * Updated dependencies to apache2-mpm-prefork | apache2-mpm-itk, so both can
+    be setup (Closes: #494306). As of today, mod_log_sql still doesn't support
+    apache with threads.
+
+ -- Thomas Goirand <thomas@goirand.fr>  Wed, 24 Sep 2008 07:44:30 +0000
+
 libapache-mod-log-sql (1.100-13) unstable; urgency=low
 
   * Reverted the "patch for funny table names" as it's only working for MySQL
diff -u libapache-mod-log-sql-1.100/debian/control libapache-mod-log-sql-1.100/debian/control
--- libapache-mod-log-sql-1.100/debian/control
+++ libapache-mod-log-sql-1.100/debian/control
@@ -8,7 +8,7 @@
 
 Package: libapache2-mod-log-sql
 Architecture: any
-Depends: ${shlibs:Depends}, apache2-mpm-prefork (>= 2.0.53)
+Depends: ${shlibs:Depends}, apache2-mpm-prefork (>= 2.0.53) | apache2-mpm-itk
 Recommends: perl
 Description: Use SQL to store/write your apache queries logs - Base
  mod_log_sql is a log module for Apache 1.3 and 2 which logs all requests to a
only in patch2:
unchanged:
--- libapache-mod-log-sql-1.100.orig/contrib/create_tables.sql
+++ libapache-mod-log-sql-1.100/contrib/create_tables.sql
@@ -49,3 +49,24 @@
     item varchar(80),
     val varchar(80)
 );
+
+# Added by Thomas Goirand (Debian maintainer and score_board patch upstream)
+# take care that the UNIQUE KEY is really VITAL of you don't want your server
+# to die with a huge MySQL load...
+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;