Menu
▾
▴
gemstracker-svn
|
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.
|
|
From: <gem...@li...> - 2011-11-21 16:49:38
|
Revision: 257
http://gemstracker.svn.sourceforge.net/gemstracker/?rev=257&view=rev
Author: matijsdejong
Date: 2011-11-21 16:49:32 +0000 (Mon, 21 Nov 2011)
Log Message:
-----------
Removed database name dependency
Modified Paths:
--------------
trunk/library/configs/db/patches.sql
Modified: trunk/library/configs/db/patches.sql
===================================================================
--- trunk/library/configs/db/patches.sql 2011-11-21 16:33:16 UTC (rev 256)
+++ trunk/library/configs/db/patches.sql 2011-11-21 16:49:32 UTC (rev 257)
@@ -323,5 +323,5 @@
UPDATE `gems__organizations` SET gor_has_patients = COALESCE((SELECT 1 FROM gems__respondent2org WHERE gr2o_id_organization = gor_id_organization GROUP BY gr2o_id_organization), 0);
-- PATCH: Log failed logins
-INSERT INTO `zsd`.`gems__log_actions` (`glac_id_action`, `glac_name`, `glac_change`, `glac_log`, `glac_created`)
+INSERT INTO `gems__log_actions` (`glac_id_action`, `glac_name`, `glac_change`, `glac_log`, `glac_created`)
VALUES (NULL , 'loginFail', '0', '1', CURRENT_TIMESTAMP);
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <gem...@li...> - 2012-04-03 15:33:29
|
Revision: 594
http://gemstracker.svn.sourceforge.net/gemstracker/?rev=594&view=rev
Author: matijsdejong
Date: 2012-04-03 15:33:20 +0000 (Tue, 03 Apr 2012)
Log Message:
-----------
Database was fixed
Modified Paths:
--------------
trunk/library/configs/db/patches.sql
Modified: trunk/library/configs/db/patches.sql
===================================================================
--- trunk/library/configs/db/patches.sql 2012-04-03 15:27:25 UTC (rev 593)
+++ trunk/library/configs/db/patches.sql 2012-04-03 15:33:20 UTC (rev 594)
@@ -391,4 +391,4 @@
ALTER TABLE gems__user_logins CHANGE gul_can_login gul_can_login boolean not null default 0;
-- PATCH: make reset keys unique so we now whose key it is
-ALTER TABLE `pulse`.`gems__user_passwords` ADD UNIQUE (`gup_reset_key`);
+ALTER TABLE `gems__user_passwords` ADD UNIQUE (`gup_reset_key`);
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <gem...@li...> - 2012-05-24 12:38:06
|
Revision: 699
http://gemstracker.svn.sourceforge.net/gemstracker/?rev=699&view=rev
Author: mennodekker
Date: 2012-05-24 12:37:55 +0000 (Thu, 24 May 2012)
Log Message:
-----------
gor_code no longer needs to be unique so related orgs can share this code if needed
Modified Paths:
--------------
trunk/library/configs/db/patches.sql
Modified: trunk/library/configs/db/patches.sql
===================================================================
--- trunk/library/configs/db/patches.sql 2012-05-23 14:42:18 UTC (rev 698)
+++ trunk/library/configs/db/patches.sql 2012-05-24 12:37:55 UTC (rev 699)
@@ -397,4 +397,7 @@
-- GEMS VERSION: 47
-- PATCH: Add return url to tokens
ALTER TABLE gems__tokens ADD gto_return_url varchar(250) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null default null AFTER gto_reception_code;
-ALTER TABLE `gems__organizations` ADD `gor_allowed_ip_ranges` TEXT CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null AFTER `gor_respondent_group`;
\ No newline at end of file
+ALTER TABLE `gems__organizations` ADD `gor_allowed_ip_ranges` TEXT CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null AFTER `gor_respondent_group`;
+
+--PATCH: organization code no longer needs to be unique
+ALTER TABLE `gems__organizations` DROP INDEX `gor_code` , ADD INDEX `gor_code` ( `gor_code` );
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <gem...@li...> - 2012-08-01 13:24:39
|
Revision: 891
http://gemstracker.svn.sourceforge.net/gemstracker/?rev=891&view=rev
Author: mennodekker
Date: 2012-08-01 13:24:30 +0000 (Wed, 01 Aug 2012)
Log Message:
-----------
(testing sync job)
Modified Paths:
--------------
trunk/library/configs/db/patches.sql
Modified: trunk/library/configs/db/patches.sql
===================================================================
--- trunk/library/configs/db/patches.sql 2012-08-01 11:20:30 UTC (rev 890)
+++ trunk/library/configs/db/patches.sql 2012-08-01 13:24:30 UTC (rev 891)
@@ -419,4 +419,4 @@
ALTER TABLE `gems__surveys` ADD gsu_code varchar(64) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NULL AFTER gsu_duration;
-- 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%';
+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%';
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <gem...@li...> - 2013-03-14 08:54:51
|
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.
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X