Historique de la page
...
Les champs obsolètes peuvent être supprimés manuellement :
| Bloc de code |
|---|
ALTER TABLE h_acti DROP FOREIGN KEY FKB6E0538EF9CD6EB0; ALTER TABLE h_acti DROP KEY FKB6E0538EF9CD6EB0; 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 FOREIGN KEY FKB6E1B7A961B67C78; ALTER TABLE h_depa DROP KEY FKB6E1B7A961B67C78; 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`; |
| Astuce |
|---|
Avec MySql, le nom des clés étrangères est obtenu par |
| Avertissement |
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 et h_depa.real_cate_id (pour MySql, utiliser SHOW CREATE TABLE h_acti; (resp. h_depa) pour connaître les noms des index et des clés étrangères puis exécuter ALTER TABLE h_acti DROP FOREIGN KEY FKxxxxxx; et ALTER TABLE h_acti DROP FOREIGN KEY FKxxxxxx;FKB6E0538EF9CD6EB0; (resp. h_depa et FKB6E1B7A961B67C78), cf http://lists.mysql.com/mysql/204151). |
...