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

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

Revision: 1179
          http://sourceforge.net/p/gemstracker/code/1179
Author:   mennodekker
Date:     2013-03-14 08:54:48 +0000 (Thu, 14 Mar 2013)
Log Message:
-----------
Added missing gtr_completed_event in patch 48, so the alter statement in patch 49 will work

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

Modified: trunk/library/configs/db/patches.sql
===================================================================
--- trunk/library/configs/db/patches.sql	2013-03-14 08:42:54 UTC (rev 1178)
+++ trunk/library/configs/db/patches.sql	2013-03-14 08:54:48 UTC (rev 1179)
@@ -421,6 +421,9 @@
 -- PATCH: Assign deletion of track parts to super role
 UPDATE gems__roles SET grl_privileges = CONCAT(grl_privileges,',pr.track-maintenance.delete') WHERE grl_privileges NOT LIKE '%pr.track-maintenance.edit%' AND grl_privileges NOT LIKE '%pr.track-maintenance.delete%';
 
+-- PATCH: Add track completion event
+ALTER TABLE `gems__tracks` ADD gtr_completed_event varchar(128) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null;
+
 -- GEMS VERSION: 49
 -- PATCH: Speed up show respondent
 ALTER TABLE `gems__respondent2org` ADD INDEX ( `gr2o_reception_code` );

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