Changes between Version 25 and Version 26 of DbChanges

Timestamp:

2010-10-15T16:40:09Z (14 years ago)

Author:

Serge Okon

Comment:

--

DbChanges

@@ -10 +10 @@
  * The *exact and complete* SQL statement that will perform the change.
 
+== Version 2.1 to 2.2 Updates==
+=== July 23, 2010 ===
+- compass
+{{{
+#!sql
+ALTER TABLE `personalizes` ADD INDEX ( `user_id` , `attribute_code` ) ;
+}}}
+
+=== August 18, 2010 ===
+To speed up the AjaxList for Users (~300x speed-up with 3000 users database). - Serge.
+{{{
+#!sql
+CREATE INDEX user_id_index on user_enrols(user_id)
+}}}
+
+=== September (?) ===
+To allow unlimited comments in evaluation_mixevals.  - compass & serge
+{{{
+#!sql
+ALTER TABLE `evaluation_mixeval_details` MODIFY COLUMN `question_comment` TEXT DEFAULT NULL;
+}}}
+[[BR]]
+[[BR]]
+
 == Version 2.0 to 2.1 Updates ==
-
 === 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
@@ -44 +67 @@
 [[BR]]
 [[BR]]
-== Version 2.1 to 2.2 Updates==
-=== July 23, 2010 ===
-- compass
-{{{
-#!sql
-ALTER TABLE `personalizes` ADD INDEX ( `user_id` , `attribute_code` ) ;
-}}}
-
-=== August 18, 2010 ===
-To speed up the AjaxList for Users (~300x speed-up with 3000 users database). - Serge.
-{{{
-#!sql
-CREATE INDEX user_id_index on user_enrols(user_id)
-}}}
-
-=== September (?) ===
-To allow unlimited comments in evaluation_mixevals.  - compass & serge
-{{{
-#!sql
-ALTER TABLE `evaluation_mixeval_details` MODIFY COLUMN `question_comment` TEXT DEFAULT NULL;
-}}}