-- 'センター南'
UPDATE smsevent SET common_code = id ;
UPDATE course_category SET common_code = id;
UPDATE smsevent SET school_id = '84bdcc4b-e96e-b0ed-173a-49c9cf2d952b';
UPDATE course_category SET school_id = '84bdcc4b-e96e-b0ed-173a-49c9cf2d952b';

UPDATE smsevent SET date_modified = '2009-07-28 10:20:20', date_entered = '2009-07-28 10:20:20' ;
UPDATE course_category SET date_modified = '2009-07-28 10:20:20', date_entered = '2009-07-28 10:20:20';

UPDATE smsevent, smsnew SET smsevent.id = smsnew.new_id WHERE smsevent.id = smsnew.id;
UPDATE course_category, course_cat SET course_category.id = course_cat.new_id WHERE course_category.id = course_cat.id;

UPDATE category_tree, course_category SET self_id = course_category.id WHERE self_id = common_code;
UPDATE category_tree, smsevent SET self_id = smsevent.id WHERE self_id = common_code;

UPDATE category_tree SET node_id = node_id + 2311 ;
UPDATE category_tree SET parent_node_id = parent_node_id + 2311 WHERE paren_node_id != 0;

UPDATE smsevent, course_category SET smsevent.parent_id = course_category.id WHERE smsevent.parent_id = course_category.common_code;

UPDATE smsevent SET common_code = NULL ;
UPDATE course_category SET common_code = NULL;


-- '南高前' 
UPDATE smsevent SET common_code = id ;
UPDATE course_category SET common_code = id;
UPDATE smsevent SET school_id = 'f0ddfbdd-dc7f-ab6f-be19-49c9cfe4a624';
UPDATE course_category SET school_id = 'f0ddfbdd-dc7f-ab6f-be19-49c9cfe4a624';

UPDATE smsevent SET date_modified = '2009-07-28 10:10:10', date_entered = '2009-07-28 10:10:10' ;
UPDATE course_category SET date_modified = '2009-07-28 10:10:10', date_entered = '2009-07-28 10:10:10';

UPDATE smsevent, smsnew SET smsevent.id = smsnew.new_id WHERE smsevent.id = smsnew.id;
UPDATE course_category, course_cat SET course_category.id = course_cat.new_id WHERE course_category.id = course_cat.id;

UPDATE category_tree, course_category SET self_id = course_category.id WHERE self_id = common_code;
UPDATE category_tree, smsevent SET self_id = smsevent.id WHERE self_id = common_code;

UPDATE category_tree SET node_id = node_id + 2311+2311 ;
UPDATE category_tree SET parent_node_id = parent_node_id + 2311+2311 WHERE parent_node_id != 0;

UPDATE smsevent, course_category SET smsevent.parent_id = course_category.id WHERE smsevent.parent_id = course_category.common_code;

UPDATE smsevent SET common_code = NULL ;
UPDATE course_category SET common_code = NULL;



-- '吉原' 41f2a164-3f08-0839-c8ce-49c9cb828009
UPDATE smsevent SET common_code = id ;
UPDATE course_category SET common_code = id;
UPDATE smsevent SET school_id = '41f2a164-3f08-0839-c8ce-49c9cb828009';
UPDATE course_category SET school_id = '41f2a164-3f08-0839-c8ce-49c9cb828009';
UPDATE smsevent SET date_modified = '2009-07-28 10:30:30', date_entered = '2009-07-28 10:30:30' ;
UPDATE course_category SET date_modified = '2009-07-28 10:30:30', date_entered = '2009-07-28 10:30:30';

UPDATE smsevent, smsnew SET smsevent.id = smsnew.new_id WHERE smsevent.id = smsnew.id;
UPDATE course_category, course_cat SET course_category.id = course_cat.new_id WHERE course_category.id = course_cat.id;

UPDATE category_tree, course_category SET self_id = course_category.id WHERE self_id = common_code;
UPDATE category_tree, smsevent SET self_id = smsevent.id WHERE self_id = common_code;

UPDATE category_tree SET node_id = node_id + 2311+2311+2311 ;
UPDATE category_tree SET parent_node_id = parent_node_id + 2311+2311+2311 WHERE parent_node_id != 0;

UPDATE smsevent, course_category SET smsevent.parent_id = course_category.id WHERE smsevent.parent_id = course_category.common_code;

UPDATE smsevent SET common_code = NULL ;
UPDATE course_category SET common_code = NULL;


-- '日限山' 80777274-35aa-45aa-9bae-49c9cf7a9f56
UPDATE smsevent SET common_code = id ;
UPDATE course_category SET common_code = id;
UPDATE smsevent SET school_id = '80777274-35aa-45aa-9bae-49c9cf7a9f56',date_modified = '2009-07-28 10:40:40', date_entered = '2009-07-28 10:40:40' ;
UPDATE course_category SET school_id = '80777274-35aa-45aa-9bae-49c9cf7a9f56', date_modified = '2009-07-28 10:40:40', date_entered = '2009-07-28 10:40:40';

UPDATE smsevent, smsnew SET smsevent.id = smsnew.new_id WHERE smsevent.id = smsnew.id;
UPDATE course_category, course_cat SET course_category.id = course_cat.new_id WHERE course_category.id = course_cat.id;

UPDATE category_tree, course_category SET self_id = course_category.id WHERE self_id = common_code;
UPDATE category_tree, smsevent SET self_id = smsevent.id WHERE self_id = common_code;

UPDATE category_tree SET node_id = node_id + 2311+2311+2311+2311 ;
UPDATE category_tree SET parent_node_id = parent_node_id + 2311+2311+2311+2311 WHERE parent_node_id != 0;

UPDATE smsevent, course_category SET smsevent.parent_id = course_category.id WHERE smsevent.parent_id = course_category.common_code;

UPDATE smsevent SET common_code = NULL ;
UPDATE course_category SET common_code = NULL;


-- '東山田' 21e52424-f9b5-f27d-4939-49c9d071abcf
UPDATE smsevent SET common_code = id ;
UPDATE course_category SET common_code = id;
UPDATE smsevent SET school_id = '21e52424-f9b5-f27d-4939-49c9d071abcf',date_modified = '2009-07-28 10:50:50', date_entered = '2009-07-28 10:50:50' ;
UPDATE course_category SET school_id = '21e52424-f9b5-f27d-4939-49c9d071abcf', date_modified = '2009-07-28 10:50:50', date_entered = '2009-07-28 10:50:50';

UPDATE smsevent, smsnew SET smsevent.id = smsnew.new_id WHERE smsevent.id = smsnew.id;
UPDATE course_category, course_cat SET course_category.id = course_cat.new_id WHERE course_category.id = course_cat.id;

UPDATE category_tree, course_category SET self_id = course_category.id WHERE self_id = common_code;
UPDATE category_tree, smsevent SET self_id = smsevent.id WHERE self_id = common_code;

UPDATE category_tree SET node_id = node_id + 2311+2311+2311+2311+2311 ;
UPDATE category_tree SET parent_node_id = parent_node_id + 2311+2311+2311+2311+2311 WHERE parent_node_id != 0;

UPDATE smsevent, course_category SET smsevent.parent_id = course_category.id WHERE smsevent.parent_id = course_category.common_code;

UPDATE smsevent SET common_code = NULL ;
UPDATE course_category SET common_code = NULL;


-- '永田' 683117f2-525a-edbb-084c-49c9cf5a97e9
UPDATE smsevent SET common_code = id ;
UPDATE course_category SET common_code = id;
UPDATE smsevent SET school_id = '683117f2-525a-edbb-084c-49c9cf5a97e9',date_modified = '2009-07-28 10:51:51', date_entered = '2009-07-28 10:51:51' ;
UPDATE course_category SET school_id = '683117f2-525a-edbb-084c-49c9cf5a97e9', date_modified = '2009-07-28 10:51:51', date_entered = '2009-07-28 10:51:51';

UPDATE smsevent, smsnew SET smsevent.id = smsnew.new_id WHERE smsevent.id = smsnew.id;
UPDATE course_category, course_cat SET course_category.id = course_cat.new_id WHERE course_category.id = course_cat.id;

UPDATE category_tree, course_category SET self_id = course_category.id WHERE self_id = common_code;
UPDATE category_tree, smsevent SET self_id = smsevent.id WHERE self_id = common_code;

UPDATE category_tree SET node_id = node_id + 2311+2311+2311+2311+2311+2311 ;
UPDATE category_tree SET parent_node_id = parent_node_id + 2311+2311+2311+2311+2311+2311 WHERE parent_node_id != 0;

UPDATE smsevent, course_category SET smsevent.parent_id = course_category.id WHERE smsevent.parent_id = course_category.common_code;

UPDATE smsevent SET common_code = NULL ;
UPDATE course_category SET common_code = NULL;


-- '環2' 4e6d468a-2a42-b943-9977-49c9cf8a7176
UPDATE smsevent SET common_code = id ;
UPDATE course_category SET common_code = id;
UPDATE smsevent SET school_id = '4e6d468a-2a42-b943-9977-49c9cf8a7176',date_modified = '2009-07-28 10:52:52', date_entered = '2009-07-28 10:52:52' ;
UPDATE course_category SET school_id = '4e6d468a-2a42-b943-9977-49c9cf8a7176', date_modified = '2009-07-28 10:52:52', date_entered = '2009-07-28 10:52:52';

UPDATE smsevent, smsnew SET smsevent.id = smsnew.new_id WHERE smsevent.id = smsnew.id;
UPDATE course_category, course_cat SET course_category.id = course_cat.new_id WHERE course_category.id = course_cat.id;

UPDATE category_tree, course_category SET self_id = course_category.id WHERE self_id = common_code;
UPDATE category_tree, smsevent SET self_id = smsevent.id WHERE self_id = common_code;

UPDATE category_tree SET node_id = node_id + 2311+2311+2311+2311+2311+2311+2311 ;
UPDATE category_tree SET parent_node_id = parent_node_id + 2311+2311+2311+2311+2311+2311+2311 WHERE parent_node_id != 0;

UPDATE smsevent, course_category SET smsevent.parent_id = course_category.id WHERE smsevent.parent_id = course_category.common_code;

UPDATE smsevent SET common_code = NULL ;
UPDATE course_category SET common_code = NULL;