# Linea21 DB patch - UTF-8 format
# patch v1.3.1 To v1.4


# ************** Warning **************
# If you use linea version < 1.2 apply first, patch_1.2.mysql.xx.sql and patch_1.3.mysql.sql !!!
#
# USE linea;

ALTER TABLE `luser` ADD `user_forget_passkey` VARCHAR( 50 ) NOT NULL default '' AFTER `user_profile` ;

RENAME TABLE bibliography_resources TO l21_bibliography_resources;
RENAME TABLE category_user TO l21_category_user;
RENAME TABLE email_collector TO l21_email_collector;
RENAME TABLE j_biblio TO l21_j_biblio;
RENAME TABLE j_link TO l21_j_link;
RENAME TABLE j_multi TO l21_j_multi;
RENAME TABLE j_parts TO l21_j_parts;
RENAME TABLE j_work_users TO l21_j_work_users;
RENAME TABLE j_project_sdi TO l21_j_project_sdi;
RENAME TABLE level TO l21_level;
RENAME TABLE link_resources TO l21_link_resources;
RENAME TABLE luser TO l21_user;
RENAME TABLE multimedia_resources TO l21_multimedia_resources;
RENAME TABLE news TO l21_news;
RENAME TABLE newsletter TO l21_newsletter;
RENAME TABLE priority TO l21_priority;
RENAME TABLE profile TO l21_profile;
RENAME TABLE project TO l21_project;
RENAME TABLE publication TO l21_publication;
RENAME TABLE publication_contents TO l21_publication_contents;
RENAME TABLE rights TO l21_rights;
RENAME TABLE scale TO l21_scale;
RENAME TABLE sdi_evaluation TO l21_sdi_evaluation;
RENAME TABLE sdi_info TO l21_sdi_info;
RENAME TABLE sdi_provider TO l21_sdi_provider;
RENAME TABLE sdi_reglementation TO l21_sdi_reglementation;
RENAME TABLE sdi_value TO l21_sdi_value;
RENAME TABLE sd_theme TO l21_sd_theme;
RENAME TABLE theme TO l21_theme;
RENAME TABLE workshop TO l21_workshop;
RENAME TABLE workshop_calendar TO l21_workshop_calendar;
RENAME TABLE workshop_com TO l21_workshop_com;
RENAME TABLE workshop_report TO l21_workshop_report;
RENAME TABLE workshop_report_contents TO l21_workshop_report_contents;
RENAME TABLE yellowpages TO l21_yellowpages;
