|
From: <gem...@li...> - 2011-10-17 12:18:19
|
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.
|