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

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

Revision: 505
          http://postfixadmin.svn.sourceforge.net/postfixadmin/?rev=505&view=rev
Author:   christian_boltz
Date:     2008-12-23 00:19:51 +0000 (Tue, 23 Dec 2008)

Log Message:
-----------
- upgrade_495_mysql: place local_part field between quota and domain
- upgrade_504_mysql: ensure correct charset for local_part

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

Modified: trunk/upgrade.php
===================================================================
--- trunk/upgrade.php	2008-12-23 00:03:08 UTC (rev 504)
+++ trunk/upgrade.php	2008-12-23 00:19:51 UTC (rev 505)
@@ -1021,8 +1021,13 @@
 # See https://sourceforge.net/forum/message.php?msg_id=5394663
 function upgrade_495_mysql() {
     $table_mailbox = table_by_key('mailbox');
-    db_query_parsed("ALTER TABLE $table_mailbox add local_part varchar(255) "); // allow to be null
+    db_query_parsed("ALTER TABLE $table_mailbox add local_part varchar(255) AFTER quota"); // allow to be null
     db_query_parsed("UPDATE $table_mailbox SET local_part = substring_index(username, '@', 1)");
     db_query_parsed("ALTER TABLE $table_mailbox change local_part local_part varchar(255) NOT NULL"); // remove null-ness...
 }
 
+function upgrade_504_mysql() {
+    $table_mailbox = table_by_key('mailbox');
+    db_query_parsed("ALTER TABLE `$table_mailbox` CHANGE `local_part` `local_part` VARCHAR( 255 ) {LATIN1} NOT NULL");
+}
+


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