Changes between Version 15 and Version 16 of AdminTips

Timestamp:

2013-10-02T23:08:59Z (11 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ -169 +169 @@
 }}}
 
-=== Merge Accounts by Id ===
+=== Merge Student Accounts by Id ===
 {{{
 #!sql
@@ -208 +208 @@
 }}}
 
+=== Merge Instructor/Admin Accounts by Id ===
+{{{
+#!sql
+DROP PROCEDURE IF EXISTS merge_instructor_by_id;
+
+delimiter //
+
+CREATE PROCEDURE merge_instructor_by_id(IN target_id INT, IN source_id INT)
+BEGIN
+       DECLARE temp_id INT;
+
+       SELECT CONCAT("Merging user ", source_id, " into ", target_id) as "";
+       UPDATE courses set creator_id = target_id where creator_id = source_id; 
+       UPDATE courses set updater_id = target_id where updater_id = source_id; 
+       UPDATE email_schedules set creator_id = target_id where creator_id = source_id; 
+       UPDATE email_templates set creator_id = target_id where creator_id = source_id; 
+       UPDATE email_templates set updater_id = target_id where updater_id = source_id; 
+       UPDATE events set creator_id = target_id where creator_id = source_id; 
+       UPDATE events set updater_id = target_id where updater_id = source_id; 
+       UPDATE groups set creator_id = target_id where creator_id = source_id; 
+       UPDATE groups set updater_id = target_id where updater_id = source_id; 
+       UPDATE IGNORE groups_members set user_id = target_id where user_id = source_id; 
+       UPDATE group_events set creator_id = target_id where creator_id = source_id; 
+       UPDATE group_events set updater_id = target_id where updater_id = source_id; 
+       UPDATE mixevals set creator_id = target_id where creator_id = source_id; 
+       UPDATE mixevals set updater_id = target_id where updater_id = source_id; 
+       UPDATE oauth_clients set user_id = target_id where user_id = source_id; 
+       UPDATE personalizes set user_id = target_id where user_id = source_id; 
+       UPDATE roles_users set user_id = target_id where user_id = source_id; 
+       UPDATE rubrics set creator_id = target_id where creator_id = source_id; 
+       UPDATE rubrics set updater_id = target_id where updater_id = source_id; 
+       UPDATE simple_evaluations set creator_id = target_id where creator_id = source_id; 
+       UPDATE simple_evaluations set updater_id = target_id where updater_id = source_id; 
+       UPDATE surveys set creator_id = target_id where creator_id = source_id; 
+       UPDATE surveys set updater_id = target_id where updater_id = source_id;
+       UPDATE survey_group_members set user_id = target_id where user_id = source_id; 
+       UPDATE survey_inputs set user_id = target_id where user_id = source_id; 
+       UPDATE IGNORE user_courses set user_id = target_id where user_id = source_id; 
+       UPDATE user_courses set creator_id = target_id where creator_id = source_id; 
+       UPDATE user_courses set updater_id = target_id where updater_id = source_id; 
+       UPDATE IGNORE user_tutors set user_id = target_id where user_id = source_id; 
+       UPDATE user_tutors set creator_id = target_id where creator_id = source_id; 
+       UPDATE user_tutors set updater_id = target_id where updater_id = source_id; 
+       DELETE from user_faculties where user_id = source_id;
+       DELETE from users where id = source_id LIMIT 1;
+END//
+
+delimiter ;
+}}}
+
 === Remove the Leading "s" in Username ===
 {{{