Project

General

Profile

Bug #4726

missing indexes after upgrade

Added by Laurent Opprecht over 7 years ago. Updated over 7 years ago.

Status:
Bug resolved
Priority:
Normal
Category:
-
Target version:
Start date:
09/05/2012
Due date:
% Done:

100%

Estimated time:
Complexity:
Normal
SCRUM pts - complexity:
?

Description

/* Header line. Object: c_chat_connected. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_c_chat_connected`;

CREATE TABLE `_temp_c_chat_connected` (
`c_id` int(11) NOT NULL,
`user_id` int(10) unsigned NOT NULL default '0',
`last_connection` datetime NOT NULL default '0000-00-00 00:00:00',
`session_id` int(11) NOT NULL default '0',
`to_group_id` int(11) NOT NULL default '0',
KEY `char_connected_index` ( `user_id`, `session_id`, `to_group_id` ),
PRIMARY KEY ( `c_id`, `user_id`, `last_connection` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Fixed
;

INSERT INTO `_temp_c_chat_connected`
( `c_id`, `last_connection`, `session_id`, `to_group_id`, `user_id` )
SELECT
`c_id`, `last_connection`, `session_id`, `to_group_id`, `user_id`
FROM `c_chat_connected`;

DROP TABLE `c_chat_connected`;

ALTER TABLE `_temp_c_chat_connected` RENAME `c_chat_connected`;

/* Header line. Object: c_forum_mailcue. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_c_forum_mailcue`;

CREATE TABLE `_temp_c_forum_mailcue` (
`c_id` int(11) NOT NULL,
`thread_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`post_id` int(11) NOT NULL default '0',
PRIMARY KEY ( `c_id`, `thread_id`, `user_id`, `post_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Fixed
;

INSERT INTO `_temp_c_forum_mailcue`
( `c_id`, `post_id`, `thread_id`, `user_id` )
SELECT
`c_id`, `post_id`, `thread_id`, `user_id`
FROM `c_forum_mailcue`;

DROP TABLE `c_forum_mailcue`;

ALTER TABLE `_temp_c_forum_mailcue` RENAME `c_forum_mailcue`;

/* Header line. Object: c_forum_notification. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_c_forum_notification`;

CREATE TABLE `_temp_c_forum_notification` (
`c_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL default '0',
`forum_id` int(11) NOT NULL default '0',
`thread_id` int(11) NOT NULL default '0',
`post_id` int(11) NOT NULL default '0',
KEY `forum_id` ( `forum_id` ),
PRIMARY KEY ( `c_id`, `user_id`, `forum_id`, `thread_id`, `post_id` ),
KEY `user_id` ( `user_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Fixed
;

INSERT INTO `_temp_c_forum_notification`
( `c_id`, `forum_id`, `post_id`, `thread_id`, `user_id` )
SELECT
`c_id`, `forum_id`, `post_id`, `thread_id`, `user_id`
FROM `c_forum_notification`;

DROP TABLE `c_forum_notification`;

ALTER TABLE `_temp_c_forum_notification` RENAME `c_forum_notification`;

/* Header line. Object: c_role_group. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_c_role_group`;

CREATE TABLE `_temp_c_role_group` (
`c_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL default '0',
`scope` varchar(20) NOT NULL default 'course',
`group_id` int(11) NOT NULL default '0',
PRIMARY KEY ( `group_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_c_role_group`
( `c_id`, `group_id`, `role_id`, `scope` )
SELECT
`c_id`, `group_id`, `role_id`, `scope`
FROM `c_role_group`;

DROP TABLE `c_role_group`;

ALTER TABLE `_temp_c_role_group` RENAME `c_role_group`;

/* Header line. Object: c_role_permissions. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_c_role_permissions`;

CREATE TABLE `_temp_c_role_permissions` (
`c_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL default '0',
`tool` varchar(250) NOT NULL,
`action` varchar(50) NOT NULL,
`default_perm` tinyint(4) NOT NULL default '0',
PRIMARY KEY ( `c_id`, `role_id`, `tool`, `action` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_c_role_permissions`
( `action`, `c_id`, `default_perm`, `role_id`, `tool` )
SELECT
`action`, `c_id`, `default_perm`, `role_id`, `tool`
FROM `c_role_permissions`;

DROP TABLE `c_role_permissions`;

ALTER TABLE `_temp_c_role_permissions` RENAME `c_role_permissions`;

/* Header line. Object: c_role_user. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_c_role_user`;

CREATE TABLE `_temp_c_role_user` (
`c_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL default '0',
`scope` varchar(20) NOT NULL default 'course',
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY ( `c_id`, `role_id`, `user_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_c_role_user`
( `c_id`, `role_id`, `scope`, `user_id` )
SELECT
`c_id`, `role_id`, `scope`, `user_id`
FROM `c_role_user`;

DROP TABLE `c_role_user`;

ALTER TABLE `_temp_c_role_user` RENAME `c_role_user`;

/* Header line. Object: c_wiki_conf. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_c_wiki_conf`;

CREATE TABLE `_temp_c_wiki_conf` (
`c_id` int(11) NOT NULL,
`page_id` int(11) NOT NULL default '0',
`task` text NOT NULL,
`feedback1` text NOT NULL,
`feedback2` text NOT NULL,
`feedback3` text NOT NULL,
`fprogress1` varchar(3) NOT NULL,
`fprogress2` varchar(3) NOT NULL,
`fprogress3` varchar(3) NOT NULL,
`max_size` int(11) default NULL,
`max_text` int(11) default NULL,
`max_version` int(11) default NULL,
`startdate_assig` datetime NOT NULL default '0000-00-00 00:00:00',
`enddate_assig` datetime NOT NULL default '0000-00-00 00:00:00',
`delayedsubmit` int(11) NOT NULL default '0',
KEY `page_id` ( `page_id` ),
PRIMARY KEY ( `c_id`, `page_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_c_wiki_conf`
( `c_id`, `delayedsubmit`, `enddate_assig`, `feedback1`, `feedback2`, `feedback3`, `fprogress1`, `fprogress2`, `fprogress3`, `max_size`, `max_text`, `max_version`, `page_id`, `startdate_assig`, `task` )
SELECT
`c_id`, `delayedsubmit`, `enddate_assig`, `feedback1`, `feedback2`, `feedback3`, `fprogress1`, `fprogress2`, `fprogress3`, `max_size`, `max_text`, `max_version`, `page_id`, `startdate_assig`, `task`
FROM `c_wiki_conf`;

DROP TABLE `c_wiki_conf`;

ALTER TABLE `_temp_c_wiki_conf` RENAME `c_wiki_conf`;

/* Header line. Object: c_wiki_mailcue. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_c_wiki_mailcue`;

CREATE TABLE `_temp_c_wiki_mailcue` (
`c_id` int(11) NOT NULL,
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`type` text NOT NULL,
`group_id` int(11) default NULL,
`session_id` smallint(6) default '0',
KEY `c_id` ( `c_id`, `id` ),
PRIMARY KEY ( `c_id`, `id`, `user_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_c_wiki_mailcue`
( `c_id`, `group_id`, `id`, `session_id`, `type`, `user_id` )
SELECT
`c_id`, `group_id`, `id`, `session_id`, `type`, `user_id`
FROM `c_wiki_mailcue`;

DROP TABLE `c_wiki_mailcue`;

ALTER TABLE `_temp_c_wiki_mailcue` RENAME `c_wiki_mailcue`;

/* Header line. Object: course_category. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_course_category`;

CREATE TABLE `_temp_course_category` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`code` varchar(40) NOT NULL,
`parent_id` varchar(40) default NULL,
`tree_pos` int(10) unsigned default NULL,
`children_count` smallint(6) default NULL,
`auth_course_child` enum('TRUE','FALSE') default 'TRUE',
`auth_cat_child` enum('TRUE','FALSE') default 'TRUE',
UNIQUE INDEX `code` ( `code` ),
KEY `parent_id` ( `parent_id` ),
PRIMARY KEY ( `id` ),
KEY `tree_pos` ( `tree_pos` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
AUTO_INCREMENT = 4
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_course_category`
( `auth_cat_child`, `auth_course_child`, `children_count`, `code`, `id`, `name`, `parent_id`, `tree_pos` )
SELECT
`auth_cat_child`, `auth_course_child`, `children_count`, `code`, `id`, `name`, `parent_id`, `tree_pos`
FROM `course_category`;

DROP TABLE `course_category`;

ALTER TABLE `_temp_course_category` RENAME `course_category`;

/* Header line. Object: message. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_message`;

CREATE TABLE `_temp_message` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user_sender_id` int(10) unsigned NOT NULL,
`user_receiver_id` int(10) unsigned NOT NULL,
`msg_status` tinyint(3) unsigned NOT NULL default '0',
`send_date` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(255) NOT NULL,
`content` text NOT NULL,
`group_id` int(10) unsigned NOT NULL default '0',
`parent_id` int(10) unsigned NOT NULL default '0',
`update_date` datetime NOT NULL default '0000-00-00 00:00:00',
KEY `idx_message_group` ( `group_id` ),
KEY `idx_message_parent` ( `parent_id` ),
KEY `idx_message_user_receiver` ( `user_receiver_id` ),
KEY `idx_message_user_sender` ( `user_sender_id` ),
KEY `idx_message_user_sender_user_receiver` ( `user_sender_id`, `user_receiver_id` ),
PRIMARY KEY ( `id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
AUTO_INCREMENT = 1
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_message`
( `content`, `group_id`, `id`, `msg_status`, `parent_id`, `send_date`, `title`, `update_date`, `user_receiver_id`, `user_sender_id` )
SELECT
`content`, `group_id`, `id`, `msg_status`, `parent_id`, `send_date`, `title`, `update_date`, `user_receiver_id`, `user_sender_id`
FROM `message`;

DROP TABLE `message`;

ALTER TABLE `_temp_message` RENAME `message`;

/* Header line. Object: reservation_category_rights. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_reservation_category_rights`;

CREATE TABLE `_temp_reservation_category_rights` (
`category_id` int(11) NOT NULL default '0',
`class_id` int(11) NOT NULL default '0',
`m_items` tinyint(4) NOT NULL default '0',
PRIMARY KEY ( `category_id`, `class_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Fixed
;

INSERT INTO `_temp_reservation_category_rights`
( `category_id`, `class_id`, `m_items` )
SELECT
`category_id`, `class_id`, `m_items`
FROM `reservation_category_rights`;

DROP TABLE `reservation_category_rights`;

ALTER TABLE `_temp_reservation_category_rights` RENAME `reservation_category_rights`;

/* Header line. Object: stored_values. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_stored_values`;

CREATE TABLE `_temp_stored_values` (
`user_id` int(11) NOT NULL,
`sco_id` int(11) NOT NULL,
`course_id` char(40) NOT NULL,
`sv_key` char(64) NOT NULL,
`sv_value` text NOT NULL,
PRIMARY KEY ( `user_id`, `sco_id`, `course_id`, `sv_key` ),
KEY `user_id` ( `user_id`, `sco_id`, `course_id`, `sv_key` ),
UNIQUE INDEX `user_id_2` ( `user_id`, `sco_id`, `course_id`, `sv_key` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_stored_values`
( `course_id`, `sco_id`, `sv_key`, `sv_value`, `user_id` )
SELECT
`course_id`, `sco_id`, `sv_key`, `sv_value`, `user_id`
FROM `stored_values`;

DROP TABLE `stored_values`;

ALTER TABLE `_temp_stored_values` RENAME `stored_values`;

/* Header line. Object: stored_values_stack. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_stored_values_stack`;

CREATE TABLE `_temp_stored_values_stack` (
`user_id` int(11) NOT NULL,
`sco_id` int(11) NOT NULL,
`stack_order` int(11) NOT NULL,
`course_id` char(40) NOT NULL,
`sv_key` char(64) NOT NULL,
`sv_value` text NOT NULL,
PRIMARY KEY ( `user_id`, `sco_id`, `stack_order`, `course_id`, `sv_key` ),
KEY `user_id` ( `user_id`, `sco_id`, `course_id`, `sv_key`, `stack_order` ),
UNIQUE INDEX `user_id_2` ( `user_id`, `sco_id`, `course_id`, `sv_key`, `stack_order` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_stored_values_stack`
( `course_id`, `sco_id`, `stack_order`, `sv_key`, `sv_value`, `user_id` )
SELECT
`course_id`, `sco_id`, `stack_order`, `sv_key`, `sv_value`, `user_id`
FROM `stored_values_stack`;

DROP TABLE `stored_values_stack`;

ALTER TABLE `_temp_stored_values_stack` RENAME `stored_values_stack`;

/* Header line. Object: track_e_attempt. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_track_e_attempt`;

CREATE TABLE `_temp_track_e_attempt` (
`exe_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`question_id` int(11) NOT NULL default '0',
`answer` text NOT NULL,
`teacher_comment` text NOT NULL,
`marks` float(6,2) NOT NULL default '0.00',
`course_code` varchar(40) NOT NULL,
`position` int(11) default '0',
`tms` datetime NOT NULL default '0000-00-00 00:00:00',
`session_id` int(11) NOT NULL default '0',
`filename` varchar(255) default NULL,
KEY `exe_id` ( `exe_id` ),
PRIMARY KEY ( `exe_id`, `user_id`, `question_id` ),
KEY `question_id` ( `question_id` ),
KEY `session_id` ( `session_id` ),
KEY `user_id` ( `user_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_track_e_attempt`
( `answer`, `course_code`, `exe_id`, `filename`, `marks`, `position`, `question_id`, `session_id`, `teacher_comment`, `tms`, `user_id` )
SELECT
`answer`, `course_code`, `exe_id`, `filename`, `marks`, `position`, `question_id`, `session_id`, `teacher_comment`, `tms`, `user_id`
FROM `track_e_attempt`;

DROP TABLE `track_e_attempt`;

ALTER TABLE `_temp_track_e_attempt` RENAME `track_e_attempt`;

/* Header line. Object: track_e_attempt_recording. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_track_e_attempt_recording`;

CREATE TABLE `_temp_track_e_attempt_recording` (
`exe_id` int(10) unsigned NOT NULL,
`question_id` int(10) unsigned NOT NULL,
`marks` int(11) NOT NULL,
`insert_date` datetime NOT NULL default '0000-00-00 00:00:00',
`author` int(10) unsigned NOT NULL,
`teacher_comment` text NOT NULL,
`session_id` int(11) NOT NULL default '0',
KEY `exe_id` ( `exe_id` ),
PRIMARY KEY ( `exe_id`, `question_id` ),
KEY `question_id` ( `question_id` ),
KEY `session_id` ( `session_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_track_e_attempt_recording`
( `author`, `exe_id`, `insert_date`, `marks`, `question_id`, `session_id`, `teacher_comment` )
SELECT
`author`, `exe_id`, `insert_date`, `marks`, `question_id`, `session_id`, `teacher_comment`
FROM `track_e_attempt_recording`;

DROP TABLE `track_e_attempt_recording`;

ALTER TABLE `_temp_track_e_attempt_recording` RENAME `track_e_attempt_recording`;

/* Header line. Object: track_e_hotpotatoes. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_track_e_hotpotatoes`;

CREATE TABLE `_temp_track_e_hotpotatoes` (
`exe_name` varchar(255) NOT NULL,
`exe_user_id` int(10) unsigned NOT NULL default '0',
`exe_date` datetime NOT NULL default '0000-00-00 00:00:00',
`exe_cours_id` varchar(40) NOT NULL,
`exe_result` smallint(6) NOT NULL default '0',
`exe_weighting` smallint(6) NOT NULL default '0',
KEY `exe_cours_id` ( `exe_cours_id` ),
KEY `exe_user_id` ( `exe_user_id` ),
PRIMARY KEY ( `exe_name`, `exe_user_id`, `exe_date` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Dynamic
;

INSERT INTO `_temp_track_e_hotpotatoes`
( `exe_cours_id`, `exe_date`, `exe_name`, `exe_result`, `exe_user_id`, `exe_weighting` )
SELECT
`exe_cours_id`, `exe_date`, `exe_name`, `exe_result`, `exe_user_id`, `exe_weighting`
FROM `track_e_hotpotatoes`;

DROP TABLE `track_e_hotpotatoes`;

ALTER TABLE `_temp_track_e_hotpotatoes` RENAME `track_e_hotpotatoes`;

/* Header line. Object: user_rel_course_vote. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_user_rel_course_vote`;

CREATE TABLE `_temp_user_rel_course_vote` (
`id` int(10) unsigned NOT NULL auto_increment,
`c_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`session_id` int(10) unsigned NOT NULL default '0',
`url_id` int(10) unsigned NOT NULL default '0',
`vote` int(10) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
AUTO_INCREMENT = 1
ROW_FORMAT = Fixed
;

INSERT INTO `_temp_user_rel_course_vote`
( `c_id`, `id`, `session_id`, `url_id`, `user_id`, `vote` )
SELECT
`c_id`, `id`, `session_id`, `url_id`, `user_id`, `vote`
FROM `user_rel_course_vote`;

DROP TABLE `user_rel_course_vote`;

ALTER TABLE `_temp_user_rel_course_vote` RENAME `user_rel_course_vote`;

/* Header line. Object: user_rel_user. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_user_rel_user`;

CREATE TABLE `_temp_user_rel_user` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user_id` int(10) unsigned NOT NULL,
`friend_user_id` int(10) unsigned NOT NULL,
`relation_type` int(11) NOT NULL default '0',
`last_edit` datetime default NULL,
KEY `idx_user_rel_user__friend_user` ( `friend_user_id` ),
KEY `idx_user_rel_user__user` ( `user_id` ),
KEY `idx_user_rel_user__user_friend_user` ( `user_id`, `friend_user_id` ),
PRIMARY KEY ( `id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
AUTO_INCREMENT = 1
ROW_FORMAT = Fixed
;

INSERT INTO `_temp_user_rel_user`
( `friend_user_id`, `id`, `last_edit`, `relation_type`, `user_id` )
SELECT
`friend_user_id`, `id`, `last_edit`, `relation_type`, `user_id`
FROM `user_rel_user`;

DROP TABLE `user_rel_user`;

ALTER TABLE `_temp_user_rel_user` RENAME `user_rel_user`;

/* Header line. Object: usergroup_rel_course. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_usergroup_rel_course`;

CREATE TABLE `_temp_usergroup_rel_course` (
`usergroup_id` int(11) NOT NULL,
`course_id` int(11) NOT NULL,
PRIMARY KEY ( `usergroup_id`, `course_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Fixed
;

INSERT INTO `_temp_usergroup_rel_course`
( `course_id`, `usergroup_id` )
SELECT
`course_id`, `usergroup_id`
FROM `usergroup_rel_course`;

DROP TABLE `usergroup_rel_course`;

ALTER TABLE `_temp_usergroup_rel_course` RENAME `usergroup_rel_course`;

/* Header line. Object: usergroup_rel_session. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_usergroup_rel_session`;

CREATE TABLE `_temp_usergroup_rel_session` (
`usergroup_id` int(11) NOT NULL,
`session_id` int(11) NOT NULL,
PRIMARY KEY ( `usergroup_id`, `session_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Fixed
;

INSERT INTO `_temp_usergroup_rel_session`
( `session_id`, `usergroup_id` )
SELECT
`session_id`, `usergroup_id`
FROM `usergroup_rel_session`;

DROP TABLE `usergroup_rel_session`;

ALTER TABLE `_temp_usergroup_rel_session` RENAME `usergroup_rel_session`;

/* Header line. Object: usergroup_rel_user. Script date: 09.05.2012 11:02:43. */
DROP TABLE IF EXISTS `_temp_usergroup_rel_user`;

CREATE TABLE `_temp_usergroup_rel_user` (
`usergroup_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY ( `usergroup_id`, `user_id` )
)
ENGINE = MyISAM
CHARACTER SET = utf8
ROW_FORMAT = Fixed
;

INSERT INTO `_temp_usergroup_rel_user`
( `user_id`, `usergroup_id` )
SELECT
`user_id`, `usergroup_id`
FROM `usergroup_rel_user`;

DROP TABLE `usergroup_rel_user`;

ALTER TABLE `_temp_usergroup_rel_user` RENAME `usergroup_rel_user`;

History

#1

Updated by Laurent Opprecht over 7 years ago

  • Assignee set to Laurent Opprecht
#2

Updated by Laurent Opprecht over 7 years ago

  • % Done changed from 0 to 40

I have added the few I found in create_course.
For the rest I intend to run a script as this is likely due to old issues.

#3

Updated by Yannick Warnier over 7 years ago

  • Target version set to 1.9 Beta
#4

Updated by Laurent Opprecht over 7 years ago

  • % Done changed from 40 to 100

For me this is fine as I believe most of that was due to an old installation.
Now it may be worth redoing a schema compare after upgrade to see if some issues remains.

#5

Updated by Laurent Opprecht over 7 years ago

  • Status changed from New to Needs more info
#6

Updated by Yannick Warnier over 7 years ago

  • Status changed from Needs more info to Bug resolved

Also available in: Atom PDF