wiki:DbChanges

Version 2 (modified by Serge Okon, 14 years ago) ( diff )

--

List of Database Changes for iPeer version 2.0 to 2.1

This page will help us migrate iPeer users' databases from version 2.0 to 2.1. Make an entry to this database for each change you make to the iPeer database.

For each entry into this wiki page, please state:

  • Date of the development iPeer Database change.
  • Reason for change, and it's impact.
  • Who performed the change.
  • The *exact and complete* SQL statement that will perform the change.

June 16, 2010

This change was made for student's survey evaluation submissions. Since students submitting surveys are not tied to groups, their group values will be should NULL. Before, the default value for grp_event_id was zero, and, because of the relationship grp_event_id and submitter_id (onl one pair is allowed), the effect was that a single student could only submit one Survey, ever. This change remedies the situation, and no code needs to be changed to accommodate it. - Serge & Pan

ALTER TABLE `ipeer`.`evaluation_submissions` MODIFY COLUMN `grp_event_id` INTEGER  DEFAULT NULL;
Note: See TracWiki for help on using the wiki.