[Gemstracker-svn] SF.net SVN: gemstracker:[1213] trunk/library

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

Revision: 1213
          http://sourceforge.net/p/gemstracker/code/1213
Author:   matijsdejong
Date:     2013-04-04 15:34:26 +0000 (Thu, 04 Apr 2013)
Log Message:
-----------
The agenda is still on the agenda

Modified Paths:
--------------
    trunk/library/classes/Gems/Default/SurveyMaintenanceAction.php

Added Paths:
-----------
    trunk/library/configs/db/tables/gems__respondent2appointment.sql

Modified: trunk/library/classes/Gems/Default/SurveyMaintenanceAction.php
===================================================================
--- trunk/library/classes/Gems/Default/SurveyMaintenanceAction.php	2013-04-04 09:41:13 UTC (rev 1212)
+++ trunk/library/classes/Gems/Default/SurveyMaintenanceAction.php	2013-04-04 15:34:26 UTC (rev 1213)
@@ -464,6 +464,7 @@
             $events = $this->loader->getEvents();
 
             $model->set('gsu_result_field',          'label', $this->_('Result field'));
+            $model->set('gsu_agenda_result',         'label', $this->_('Agenda field'));
             $model->set('gsu_duration',              'label', $this->_('Duration description'), 'description', $this->_('Text to inform the respondent, e.g. "20 seconds" or "1 minute".'));
         }
         $model->setIfExists('gsu_code', 'label', $this->_('Code name'), 'size', 10, 'description', $this->_('Only for programmers.'));

Added: trunk/library/configs/db/tables/gems__respondent2appointment.sql
===================================================================
--- trunk/library/configs/db/tables/gems__respondent2appointment.sql	                        (rev 0)
+++ trunk/library/configs/db/tables/gems__respondent2appointment.sql	2013-04-04 15:34:26 UTC (rev 1213)
@@ -0,0 +1,27 @@
+
+CREATE TABLE if not exists gems__respondent2appointment (
+    gr2a_id_appointment    bigint unsigned not null auto_increment,
+    gr2a_id_user           bigint unsigned not null references gems__respondents (grs_id_user),
+    gr2a_id_organization   bigint unsigned not null references gems__organizations (gor_id_organization),
+
+    gr2a_appointment       datetime not null,
+    gr2a_whole_day         boolean not null default 0,
+    gr2a_until             datetime null,
+    gr2a_active            boolean not null default 1,
+
+    gr2a_subject           varchar(250) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null default null,
+    gr2a_location          varchar(250) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null default null,
+    gr2a_comment           TEXT CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' null default null,
+
+    gr2a_changed           timestamp not null default current_timestamp on update current_timestamp,
+    gr2a_changed_by        bigint unsigned not null,
+    gr2a_created           timestamp not null,
+    gr2a_created_by        bigint unsigned not null,
+
+    PRIMARY KEY (gr2a_id_appointment),
+    INDEX (gr2a_id_user, gr2a_id_organization),
+    INDEX (gr2a_appointment)
+)
+ENGINE=InnoDB
+auto_increment = 2000000
+CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

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