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

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

Revision: 1685
          http://sourceforge.net/p/postfixadmin/code/1685
Author:   christian_boltz
Date:     2014-09-12 09:47:22 +0000 (Fri, 12 Sep 2014)
Log Message:
-----------
upgrade.php:
- upgrade_1685_mysql()/upgrade_1685_pgsql:
  Fix existing log entries broken by 
  https://sourceforge.net/p/postfixadmin/bugs/317/

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

Modified: trunk/upgrade.php
===================================================================
--- trunk/upgrade.php	2014-09-12 09:22:09 UTC (rev 1684)
+++ trunk/upgrade.php	2014-09-12 09:47:22 UTC (rev 1685)
@@ -1347,6 +1347,19 @@
     _db_add_field('vacation', 'interval_time', '{INT}', 'domain');
 }
 
+function upgrade_1685_mysql() {
+    # Fix existing log entries broken by https://sourceforge.net/p/postfixadmin/bugs/317/
+    $table = table_by_key('log');
+    db_query_parsed("UPDATE $table SET data = domain WHERE data = '' AND domain LIKE '%@%'");
+    db_query_parsed("UPDATE $table SET domain=SUBSTRING_INDEX(domain, '@', -1) WHERE domain=data;");
+}
+function upgrade_1685_pgsql() {
+    $table = table_by_key('log');
+    db_query_parsed("UPDATE $table SET data = domain WHERE data = '' AND domain LIKE '%@%'");
+    db_query_parsed("UPDATE $table SET domain=SPLIT_PART(domain, '@', 2) WHERE domain=data;");
+}
+
+
 # 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.