svn commit: r311534 - head

[Dmitry Marakasov]

Author: amdmi3
Date: Mon Feb  4 01:23:33 2013
New Revision: 311534
URL: http://svnweb.freebsd.org/changeset/ports/311534

Log:
  - Add note about upgrading dns/poweradmin
  
  PR:		175699

Modified:
  head/UPDATING

Modified: head/UPDATING
==============================================================================
--- head/UPDATING	Mon Feb  4 01:22:56 2013	(r311533)
+++ head/UPDATING	Mon Feb  4 01:23:33 2013	(r311534)
@@ -5,6 +5,23 @@ they are unavoidable.
 You should get into the habit of checking this file for changes each time
 you update your ports collection, before attempting any port upgrades.
 
+20130204:
+  AFFECTS: users of dns/poweradmin
+  AUTHOR: Edmondas Girkantas <eg at fbsd.lt>
+
+  Some database changes have been made between version 2.1.5 and 2.1.6,
+  upgrading needs to be done manually by running the following SQL:
+
+  For MySQL users:
+
+  ALTER TABLE users MODIFY username VARCHAR(64) NOT NULL DEFAULT '0';
+  ALTER TABLE users MODIFY password VARCHAR(128) NOT NULL DEFAULT '0';
+
+  For PostgreSQL users:
+
+  ALTER TABLE users ALTER COLUMN username TYPE VARCHAR(64);
+  ALTER TABLE users ALTER COLUMN password TYPE VARCHAR(128);
+
 20130203:
   AFFECTS: users of KDE SC 4
   AUTHOR: kde at FreeBSD.org