# Linea21 DB patch - UTF-8 format
# patch v2.4.x To v2.5




# Adding `project_impact` and `project_indic_order` fields in table
ALTER TABLE `l21_project` ADD `project_impact` TEXT NULL DEFAULT NULL AFTER `project_cal_comment`, ADD `project_indic_order` TEXT NULL DEFAULT NULL AFTER `project_impact`; 

# we rebuild index on project by adding missing opgoal field
ALTER TABLE l21_project DROP INDEX project_index, ADD FULLTEXT KEY project_index (`project_name`, `project_goal`, `project_opgoal`, `project_description`, `project_body`, `project_comment`, `project_budget_comment`, `project_cal_comment`, `project_elected`, `project_team`);

# adding page_heading field to l21_page table
ALTER TABLE `l21_page` ADD `page_heading` VARCHAR(50) NOT NULL DEFAULT '' AFTER `page_body`; 

# adding workshop_visible field to l21_workshop table
ALTER TABLE `l21_workshop` ADD `workshop_visible` INT NOT NULL DEFAULT '1' AFTER `workshop_restricted`; 