Replace "name" with "title" fields in tables

[ywarnier]

Chamilo 2.0 is a great opportunity to clean the mess up a little bit in our database structure. At the moment, there is a mix between fields called "name" and fields called "title", where they all represent the textual name of the item represented by the table row.

Move all "name" fields to "title", to sanitize this.

Making this a standard with help with the capability to predict the field name and, as such, will improve development speed in the long run.

Beware that some of these fields are also indexed. Indexes should be modified too.

Tables with "name":

• [ ] block.name
• [ ] branch_sync.branch_name
• [ ] c_attendance.name
• [ ] c_blog.blog_name
• [ ] c_dropbox_category.cat_name
• [ ] c_exercise_category.name
• [ ] c_forum_category.cat_title
• [ ] c_forum_forum.forum_title
• [ ] c_forum_post.post_title
• [ ] c_forum_thread.thread_title
• [ ] c_glossary.name
• [ ] c_group_info.name
• [ ] c_link_category.category_title
• [ ] c_lp.name
• [ ] c_lp_category.name
• [ ] c_online_link.name
• [ ] c_quiz_question_option.name
• [ ] c_role.role_name
• [ ] c_survey_group.name
• [ ] c_tool.name
• [ ] career.name
• [ ] chat_video.room_name
• [ ] class_item.name
• [ ] course_category.name
• [ ] course_module.name
• [ ] course_type.name
• [ ] grade_model.name
• [ ] gradebook_category.name
• [ ] gradebook_evaluation.name
• [ ] gradebook_linkeval_log.name
• [ ] mail_template.name
• [ ] promotion.name
• [ ] sequence.name
• [ ] sequence_row_entity.name
• [ ] sequence_type_entity.name
• [ ] sequence_variable.name
• [ ] session.name
• [ ] session_category.name
• [ ] skill.name
• [ ] skill_level.name
• [ ] skill_level_profile.name
• [ ] skill_profile.name
• [ ] specific_field.name
• [ ] ticket_category.name
• [ ] ticket_priority.name
• [ ] ticket_project.name
• [ ] ticket_status.name
• [ ] usergroup.name

So that's 48 changes, vs 39 'title' fields (and 38 pure "name" fields).