Changes between Version 19 and Version 20 of DbChanges


Ignore:
Timestamp:
2010-10-13T16:36:11Z (14 years ago)
Author:
Serge Okon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DbChanges

    v19 v20  
    11[[PageOutline]]
    2 == List of Database Changes for iPeer version 2.0 to 2.1 ==
     2
     3== About this page ==
    34This 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.
    45
     
    910 * The *exact and complete* SQL statement that will perform the change.
    1011
    11 ==== June 16, 2010 ====
     12== Version 2.0 to 2.1 Updates ==
     13
     14=== June 16, 2010 ===
    1215This 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
    1316{{{
     
    1619}}}
    1720
    18 ==== July 9, 2010 ====
     21=== July 9, 2010 ===
    1922This change is made for student's rubrics evaluation submissions. Since students submitted rubric evaluations are not tied to the rubric, deleting a rubric does not fully remove students' evaluation data of that rubric. With the added 'rubric_id' field, the linkage is now complete and references would not be lost in the relationship specified between evaluation_rubrics and rubric tables.  - Henry
    2023{{{
     
    2427
    2528
    26 ==== July 16, 2010 ====
     29=== July 16, 2010 ===
    2730Sets up the new System function code, to match the users controller. - Serge
    2831{{{
     
    3235
    3336
    34 ==== July 22, 2010 ====
     37=== July 22, 2010 ===
    3538Add index for user_enrols table to improve the query time
    3639{{{
     
    4245[[BR]]
    4346[[BR]]
    44 == List of Database Changes for iPeer version 2.1 to 2.2 ==
    45 === Proposed change 1 ===
     47== Version 2.1 to 2.2 Updates==
     48=== Proposed change ===
    4649{{{
    4750#!sql