gemstracker-svn

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

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

Revision: 107
          http://gemstracker.svn.sourceforge.net/gemstracker/?rev=107&view=rev
Author:   mennodekker
Date:     2011-10-17 12:10:47 +0000 (Mon, 17 Oct 2011)
Log Message:
-----------
Updated #17: Database upgrade to assign needed privilege to super role

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

Modified: trunk/library/configs/db/patches.sql
===================================================================
--- trunk/library/configs/db/patches.sql	2011-10-17 12:03:09 UTC (rev 106)
+++ trunk/library/configs/db/patches.sql	2011-10-17 12:10:47 UTC (rev 107)
@@ -199,3 +199,6 @@
 -- GEMS VERSION: 41
 -- PATCH: Corrected misspelling of gtr_organisations
 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

Modified: trunk/library/configs/db/tables/gems__roles.20.sql
===================================================================
--- trunk/library/configs/db/tables/gems__roles.20.sql	2011-10-17 12:03:09 UTC (rev 106)
+++ trunk/library/configs/db/tables/gems__roles.20.sql	2011-10-17 12:10:47 UTC (rev 107)
@@ -33,4 +33,4 @@
     ('physician','physician','','staff', CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, 1),
     ('researcher','researcher','pr.invitation,pr.result,pr.islogin','', CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, 1),
     ('admin','admin','pr.consent,pr.consent.create,pr.consent.edit,pr.group,pr.role,pr.mail,pr.mail.create,pr.mail.delete,pr.mail.edit,pr.organization,pr.organization-switch,pr.plan.overview.excel,pr.plan.respondent,pr.plan.respondent.excel,pr.plan.token.excel,pr.project-information,pr.reception,pr.reception.create,pr.reception.edit,pr.respondent.choose-org,pr.respondent.delete,pr.respondent.result,pr.source,pr.staff.create,pr.staff.delete,pr.staff.edit,pr.staff.see.all,pr.survey-maintenance,pr.track-maintenance,pr.token.mail.freetext','staff,researcher,security', CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, 1),
-    ('super','super','pr.consent.delete,pr.country,pr.country.create,pr.country.delete,pr.country.edit,pr.database,pr.database.create,pr.database.delete,pr.database.edit,pr.database.execute,pr.database.patches,pr.group.create,pr.group.edit,pr.role.create,pr.role.edit,pr.language,pr.organization.create,pr.organization.edit,pr.plan.choose-org,pr.plan.mail-as-application,pr.reception.delete,pr.source.create,pr.source.edit,pr.source.synchronize,pr.source.synchronize-all,pr.staff.edit.all,pr.survey-maintenance.edit,pr.track-maintenance.create,pr.track-maintenance.edit','admin', CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, 1);
+    ('super','super','pr.consent.delete,pr.country,pr.country.create,pr.country.delete,pr.country.edit,pr.database,pr.database.create,pr.database.delete,pr.database.edit,pr.database.execute,pr.database.patches,pr.group.create,pr.group.edit,pr.role.create,pr.role.edit,pr.language,pr.organization.create,pr.organization.edit,pr.plan.choose-org,pr.plan.mail-as-application,pr.reception.delete,pr.source.create,pr.source.edit,pr.source.synchronize,pr.source.synchronize-all,pr.staff.edit.all,pr.survey-maintenance.edit,pr.track-maintenance.create,pr.track-maintenance.edit,pr.maintenance','admin', CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, 1);

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

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

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

Revision: 114
          http://gemstracker.svn.sourceforge.net/gemstracker/?rev=114&view=rev
Author:   michieltcs
Date:     2011-10-19 18:01:56 +0000 (Wed, 19 Oct 2011)
Log Message:
-----------
Fix small errors related to first-time import

Modified Paths:
--------------
    trunk/library/configs/db/patches.sql
    trunk/library/configs/db/tables/gems__mail_jobs.300.sql
    trunk/library/configs/db/tables/gems__reception_codes.10.sql

Modified: trunk/library/configs/db/patches.sql
===================================================================
--- trunk/library/configs/db/patches.sql	2011-10-18 16:35:34 UTC (rev 113)
+++ trunk/library/configs/db/patches.sql	2011-10-19 18:01:56 UTC (rev 114)
@@ -203,4 +203,4 @@
 -- PATCH: Assign maintenance mode toggle to super role
 UPDATE gems__roles SET grl_privileges = CONCAT(grl_privileges,',pr.maintenance') WHERE grl_name = 'super' AND grl_privileges NOT LIKE '%pr.maintenance%';
 
--- GEMS VERSION: 42
\ No newline at end of file
+-- GEMS VERSION: 42

Modified: trunk/library/configs/db/tables/gems__mail_jobs.300.sql
===================================================================
--- trunk/library/configs/db/tables/gems__mail_jobs.300.sql	2011-10-18 16:35:34 UTC (rev 113)
+++ trunk/library/configs/db/tables/gems__mail_jobs.300.sql	2011-10-19 18:01:56 UTC (rev 114)
@@ -4,8 +4,6 @@
 
         gmj_id_organization bigint unsigned not null
                 references gems__organizations (gor_id_organization),
-        gmj_id_message bigint unsigned not null
-                references gems__mail_templates (gmt_id_message),
 
         gmj_id_user_as bigint unsigned not null
                 references gems__staff (gsf_id_user),

Modified: trunk/library/configs/db/tables/gems__reception_codes.10.sql
===================================================================
--- trunk/library/configs/db/tables/gems__reception_codes.10.sql	2011-10-18 16:35:34 UTC (rev 113)
+++ trunk/library/configs/db/tables/gems__reception_codes.10.sql	2011-10-19 18:01:56 UTC (rev 114)
@@ -29,5 +29,5 @@
       grc_changed, grc_changed_by, grc_created, grc_created_by)
     VALUES
     ('OK', '', 1, 1, 0, 1, 1, 1, CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, 1),
-    ('skip', 'Skipped by calculation', 0, 1, 0, 0, 0, 0, 0, CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, 1);
+    ('skip', 'Skipped by calculation', 0, 1, 0, 0, 0, 0, CURRENT_TIMESTAMP, 1, CURRENT_TIMESTAMP, 1);
 

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