Changes between Version 14 and Version 15 of AdminTips

Timestamp:

2013-03-25T20:01:42Z (13 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ -169 +169 @@
 }}}
 
+=== Merge Accounts by Id ===
+{{{
+#!sql
+DROP PROCEDURE IF EXISTS merge_by_id;
+
+delimiter //
+
+CREATE PROCEDURE merge_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 IGNORE groups_members set user_id = target_id where user_id = source_id; 
+       UPDATE IGNORE user_enrols set user_id = target_id where user_id = source_id; 
+                UPDATE IGNORE 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 evaluation_submissions set submitter_id = target_id where submitter_id = source_id; 
+       UPDATE evaluation_simples set evaluator = target_id where evaluator = source_id; 
+       UPDATE evaluation_simples set evaluatee = target_id where evaluatee = source_id; 
+                UPDATE evaluation_simples set creator_id = target_id where creator_id = source_id; 
+                UPDATE evaluation_simples set updater_id = target_id where updater_id = source_id; 
+       UPDATE evaluation_rubrics set evaluator = target_id where evaluator = source_id; 
+       UPDATE evaluation_rubrics set evaluatee = target_id where evaluatee = source_id; 
+                UPDATE evaluation_rubrics set creator_id = target_id where creator_id = source_id; 
+                UPDATE evaluation_rubrics set updater_id = target_id where updater_id = source_id; 
+                UPDATE evaluation_rubric_details set creator_id = target_id where creator_id = source_id; 
+                UPDATE evaluation_rubric_details set updater_id = target_id where updater_id = source_id; 
+       UPDATE evaluation_mixevals set evaluator = target_id where evaluator = source_id; 
+       UPDATE evaluation_mixevals set evaluatee = target_id where evaluatee = source_id; 
+                UPDATE evaluation_mixevals set creator_id = target_id where creator_id = source_id; 
+                UPDATE evaluation_mixevals set updater_id = target_id where updater_id = source_id; 
+                UPDATE evaluation_mixeval_details set creator_id = target_id where creator_id = source_id; 
+                UPDATE evaluation_mixeval_details set updater_id = target_id where updater_id = source_id; 
+       DELETE from users where id = source_id LIMIT 1;
+END//
+
+delimiter ;
+}}}
+
 === Remove the Leading "s" in Username ===
 {{{