Changes between Version 28 and Version 29 of DbChanges

Timestamp:

2011-05-30T18:03:19Z (14 years ago)

Author:

Pan Luo

Comment:

--

DbChanges

@@ -67 +67 @@
 [[BR]]
 [[BR]]
+
+
+
+== Development Change Log ==
+
+=== Pre r514 ===
+
+{{{
+#!sql
+
+ALTER TABLE `events` CHANGE `title` `title` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT ''
+
+
+CREATE TABLE `roles` (
+`id` INT(11) NOT NULL AUTO_INCREMENT ,
+`name` VARCHAR( 255 ) NOT NULL ,
+`created` DATETIME NOT NULL ,
+`modified` DATETIME NOT NULL ,
+PRIMARY KEY ( `id` )
+) ENGINE = INNODB;
+
+CREATE TABLE `ipeer`.`roles_users` (
+`id` INT( 11 ) NOT NULL AUTO_INCREMENT,
+`role_id` INT( 11 ) NOT NULL ,
+`user_id` INT( 11 ) NOT NULL
+`created` DATETIME NOT NULL ,
+`modified` DATETIME NOT NULL
+) ENGINE = INNODB;
+
+
+
+ALTER TABLE `users` CHANGE `role` `role` ENUM( 'A', 'I', 'S', 'T' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'S'
+
+
+insert into roles_users (role_id, user_id) select 4, id from users where role LIKE "S";
+insert into roles_users (role_id, user_id) select 3, id from users where role LIKE "I";
+insert into roles_users (role_id, user_id) select 2, id from users where role LIKE "A" AND id !=1;
+
+ALTER TABLE `groups_members` ADD INDEX ( `group_id` )
+
+ALTER TABLE `surveys` CHANGE `name` `name` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
+
+# change for question ordering
+ALTER TABLE `survey_questions` CHANGE `number` `number` INT( 11 ) NOT NULL DEFAULT '9999'
+
+# change for auto generating description input textarea
+ALTER TABLE `events` CHANGE `description` `description` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL
+
+
+
+
+# change rubrics_criteria_comments to associate with rubrics_criterias by criteria id
+ALTER TABLE `rubrics_criteria_comments` ADD `criteria_id` INT NOT NULL AFTER `id`
+ALTER TABLE `rubrics_criteria_comments` ADD INDEX ( `criteria_id` )
+
+UPDATE rubrics_criteria_comments as rcc set criteria_id = (SELECT id from rubrics_criterias as rc WHERE rc.rubric_id = rcc.rubric_id AND rc.criteria_num = rcc.criteria_num)
+
+ALTER TABLE `rubrics_criteria_comments` ADD FOREIGN KEY ( `criteria_id` ) REFERENCES `ipeer`.`rubrics_criterias` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
+
+ALTER TABLE `rubrics_criteria_comments` DROP `rubric_id`
+ALTER TABLE `rubrics_criteria_comments` DROP `criteria_num`
+
+# change Criteria comments lom_num to LOM ids
+UPDATE rubrics_criteria_comments as rcc, rubrics_criterias as rc, rubrics as r, rubrics_loms as rl set rcc.lom_num=rl.id where rcc.criteria_id = rc.id AND rc.rubric_id = r.id  AND rl.rubric_id = r.id AND rl.lom_num = rcc.lom_num
+
+ALTER TABLE  `rubrics_criteria_comments` CHANGE  `rubrics_loms_id`  `rubrics_loms_id` INT( 11 ) NOT NULL
+
+ALTER TABLE  `rubrics_criteria_comments` ADD INDEX (  `rubrics_loms_id` )
+
+ALTER TABLE  `rubrics_criteria_comments` ADD FOREIGN KEY (  `rubrics_loms_id` ) REFERENCES  `ipeer`.`rubrics_loms` (
+`id`
+) ON DELETE RESTRICT ON UPDATE RESTRICT ;
+
+# change the default order number to 999
+ALTER TABLE `rubrics_loms` CHANGE `lom_num` `lom_num` INT( 11 ) NOT NULL DEFAULT '999'
+ALTER TABLE `rubrics_criterias` CHANGE `criteria_num` `criteria_num` INT( 11 ) NOT NULL DEFAULT '999'
+
+
+# remove total_marks column, using calculated value instead.
+ALTER TABLE `rubrics` DROP `total_marks`
+
+
+# change mixeval question description question number to question_id
+UPDATE mixevals_question_descs as qd, mixevals_questions as q set qd.question_num = q.id where qd.mixeval_id = q.mixeval_id AND qd.question_num = q.question_num;
+
+ALTER TABLE `mixevals_question_descs` DROP `mixeval_id`;
+
+ALTER TABLE `mixevals_question_descs` ADD INDEX ( `question_num` );
+
+ALTER TABLE `mixevals_question_descs` CHANGE `question_num` `question_id` INT( 11 ) NOT NULL DEFAULT '0';
+
+ALTER TABLE `mixevals_question_descs` ADD FOREIGN KEY ( `question_id` ) REFERENCES `ipeer`.`mixevals_questions` (
+`id`
+) ON DELETE RESTRICT ON UPDATE RESTRICT ;
+
+
+ALTER TABLE `mixevals` DROP `total_marks`
+
+ALTER TABLE `mixevals_questions` CHANGE `required` `required` BOOLEAN NOT NULL DEFAULT '1';
+
+# convert zero_mark columns from enum to boolean
+ALTER TABLE `mixevals` CHANGE `zero_mark` `zero_mark` BOOLEAN NOT NULL DEFAULT '0';
+update mixevals set zero_mark=0 where zero_mark=2;
+
+ALTER TABLE `rubrics` CHANGE `zero_mark` `zero_mark` BOOLEAN NOT NULL DEFAULT '0';
+update rubrics set zero_mark=0 where zero_mark=2;
+
+
+
+
+
+
+ALTER TABLE `mixevals` DROP `lickert_question_max`
+ALTER TABLE `mixevals` DROP `prefill_question_max`
+ALTER TABLE `mixevals` DROP `total_question`
+
+}}}