[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.