[Gemstracker-svn] SF.net SVN: gemstracker:[108] trunk/library/configs/db/patches.sql

[<gem...@li...>]

Revision: 108
          http://gemstracker.svn.sourceforge.net/gemstracker/?rev=108&view=rev
Author:   mennodekker
Date:     2011-10-17 12:18:08 +0000 (Mon, 17 Oct 2011)
Log Message:
-----------
Updated #17: Improved database patch a little

Modified Paths:
--------------
    trunk/library/configs/db/patches.sql

Modified: trunk/library/configs/db/patches.sql
===================================================================
--- trunk/library/configs/db/patches.sql	2011-10-17 12:10:47 UTC (rev 107)
+++ trunk/library/configs/db/patches.sql	2011-10-17 12:18:08 UTC (rev 108)
@@ -201,4 +201,4 @@
 ALTER TABLE gems__tracks CHANGE gtr_organisations gtr_organizations varchar(250) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
 
 -- PATCH: Assign maintenance mode toggle to super role
-UPDATE gems__roles SET grl_privileges = CONCAT(grl_privileges,',pr.maintenance') WHERE grl_name = 'super';
\ No newline at end of file
+UPDATE gems__roles SET grl_privileges = CONCAT(grl_privileges,',pr.maintenance') WHERE grl_name = 'super' AND grl_privileges NOT LIKE '%pr.maintenance%';
\ No newline at end of file

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