Historique de la page
...
Les champs obsolètes peuvent être supprimés manuellement :
| Bloc de code |
|---|
ALTER TABLE `h_acti` DROP `faq_conn_afte_id`; ALTER TABLE `h_cate` DROP `defa_prio_leve`, DROP `new_tick_assi_cust_clas`, DROP `dele`, DROP `use_defa_tick_temp`; ALTER TABLE `h_depa` DROP `algo_stat`, DROP `auto_expi`, DROP `comp_url_cust_clas`, DROP `new_tick_prop_cust_clas`, DROP `tick_moni_cust_clas`, DROP `defa_new_tick_assi_cust_clas`, DROP `real_cate_id`, DROP `use_defa_tick_temp`; ALTER TABLE `h_depa_mana` DROP `tick_moni_crea_all`, DROP `tick_moni_crea_mana`, DROP `tick_moni_crea_cate_memb`, DROP `tick_moni_crea_free`, DROP `tick_moni_crea_orph`, DROP `tick_moni_clos_all`, DROP `tick_moni_clos_mana`, DROP `tick_moni_clos_cate_memb`, DROP `tick_moni_clos_free`, DROP `tick_moni_clos_orph`, DROP `tick_moni_othe_all`, DROP `tick_moni_othe_mana`, DROP `tick_moni_othe_cate_memb`, DROP `tick_moni_othe_free`, DROP `tick_moni_othe_orph`; ALTER TABLE `h_stat` DROP `tick_crea_stat_last_time`, DROP `user_tick_crea_stat_last_time`; ALTER TABLE `h_tick` DROP `owne_disp_name`, DROP `depa_labe`, DROP `cate_labe`; ALTER TABLE `h_user` DROP `pers_tick_moni`, DROP `invo_tick_moni`, DROP `lang_id`, DROP `html_emai_form`, DROP `text_emai_form`, DROP `show_new_tick_welc`, DROP `embo_chan_tick`, DROP `depa_filt_set`, DROP `cont_pane_refr_time`, DROP `cont_pane_stat_filt`, DROP `cont_pane_invo_filt`, DROP `sear_page_size`, DROP `jour_refr_time`, DROP `jour_date_filt`, DROP `text_widt`, DROP `text_heig`, DROP `last_visi`, DROP `show_popu_on_tick_clos`, DROP `cont_pane_orde_by`, DROP `star_on_cont_pane`; ALTER TABLE `h_vers_mana` DROP `inde_upda`; DROP TABLE `h_faq_dele`; TRUNCATE TABLE `h_faq_entr`; TRUNCATE TABLE `h_faq_part`; TRUNCATE TABLE `h_file`; TRUNCATE TABLE `h_temp_tick`; DROP TABLE `h_day_user_tick_crea_stat`; DROP TABLE `h_hour_tick_crea_stat`; |
| Avertissement |
|---|
Depending on your database, it may be needed to manually delete the foreign keys and associated indexes Selon votre base de données, il peut être nécessaire de supprimer manuellement les index et clés étrangères h_acti.faq_conn_afte_id and et h_depa.real_cate_id (use pour MySql, utiliser SHOW CREATE TABLE h_acti; (resp. h_depa) to get the names of the foreign key and the index and then pour connaître les noms des index et des clés étrangères puis exécuter ALTER TABLE h_acti DROP KEY FKxxxxxx; and et ALTER TABLE h_acti DROP FOREIGN KEY FKxxxxxx;, see cf http://lists.mysql.com/mysql/204151). |
...