SF.net SVN: postfixadmin:[1050] trunk/upgrade.php

[<chr...@us...>]

Revision: 1050
          http://postfixadmin.svn.sourceforge.net/postfixadmin/?rev=1050&view=rev
Author:   christian_boltz
Date:     2011-04-23 18:38:31 +0000 (Sat, 23 Apr 2011)

Log Message:
-----------
upgrade_1050(): 
- add index on (domain,timestamp) in log table to make viewlog faster

_add_index():
- fix handling of multi-column aliases in MySQL

Modified Paths:
--------------
    trunk/upgrade.php

Modified: trunk/upgrade.php
===================================================================
--- trunk/upgrade.php	2011-04-19 22:59:00 UTC (rev 1049)
+++ trunk/upgrade.php	2011-04-23 18:38:31 UTC (rev 1050)
@@ -270,6 +270,7 @@
     $table = table_by_key ($table);
 
     if ($CONF['database_type'] == 'mysql' || $CONF['database_type'] == 'mysqli' ) {
+        $fieldlist = str_replace(',', '`,`', $fieldlist); # fix quoting if index contains multiple fields
         return "ALTER TABLE $table ADD INDEX `$indexname` ( `$fieldlist` )";
     } elseif($CONF['database_type'] == 'pgsql') {
         $pgindexname = $table . "_" . $indexname . '_idx';
@@ -1298,6 +1299,10 @@
     db_query_parsed("ALTER TABLE $table_mailbox ALTER COLUMN quota    type bigint");
 }
 
+function upgrade_1050() {
+    db_query_parsed(_add_index('log', 'domain_timestamp', 'domain,timestamp'));
+}
+
 # TODO MySQL:
 # - various varchar fields do not have a default value
 #   https://sourceforge.net/projects/postfixadmin/forums/forum/676076/topic/3419725


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.