-- +-------------------------------------------------+
-- © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
-- +-------------------------------------------------+

-- Si vous avez chargé les données de test de PMB (data_test.sql), vous disposez d'un jeu de notices et d'exemplaires pour tester PMB. 
-- Ce script vous propose de vider ces tables d'exemple de votre application afin de repartir d'une base PMB vierge.
 
truncate abo_liste_lecture;
truncate abts_abts;
truncate abts_abts_modeles;
truncate abts_grille_abt;
truncate abts_grille_modele;
truncate abts_modeles;
truncate acces_profiles;
truncate acces_rights;
truncate actes;
truncate admin_session;
truncate analysis;
truncate audit;
truncate aut_link;
truncate authorities_sources;
truncate authors;
truncate avis;
truncate bannette_abon;
truncate bannette_contenu;
truncate bannette_equation;
truncate bannette_exports;
truncate bannettes;
truncate budgets;
truncate bulletins;
truncate cache_amendes;
truncate caddie_content;
truncate cms;
truncate cms_articles;
truncate cms_articles_descriptors;
truncate cms_build;
truncate cms_cadre_content;
truncate cms_cadres;
truncate cms_editorial_custom;
truncate cms_editorial_custom_lists;
truncate cms_editorial_custom_values;
truncate cms_editorial_fields_global_index;
truncate cms_editorial_publications_states;
truncate cms_editorial_types;
truncate cms_editorial_words_global_index;
truncate cms_hash;
truncate cms_managed_modules;
truncate cms_pages;
truncate cms_pages_env;
truncate cms_sections;
truncate cms_sections_descriptors;
truncate cms_vars;
truncate cms_version;
truncate collections;
truncate collections_state;
truncate collstate_custom;
truncate collstate_custom_lists;
truncate collstate_custom_values;
truncate comptes;
truncate connectors;
truncate connectors_categ;
truncate connectors_categ_sources;
truncate connectors_out;
truncate connectors_out_oai_tokens;
truncate connectors_out_setcache_values;
truncate connectors_out_setcaches;
truncate connectors_out_setcateg_sets;
truncate connectors_out_setcategs;
truncate connectors_out_sets;
truncate connectors_out_sources;
truncate connectors_out_sources_esgroups;
truncate connectors_sources;
truncate coordonnees;
truncate demandes;
truncate demandes_actions;
truncate demandes_notes;
truncate demandes_theme;
truncate demandes_type;
truncate demandes_users;
truncate dsi_archive;
truncate editions_states;
truncate empr;
truncate empr_caddie_content;
truncate empr_custom;
truncate empr_custom_lists;
truncate empr_custom_values;
truncate empr_grilles;
truncate empr_groupe;
truncate empty_words_calculs;
truncate entites;
DROP TABLE entrepot_source_2;
DROP TABLE entrepot_source_4;
DROP TABLE entrepot_source_5;
truncate entrepots_localisations;
truncate equations;
truncate error_log;
truncate es_cache;
truncate es_cache_blob;
truncate es_cache_int;
truncate es_converted_cache;
truncate es_esgroup_esusers;
truncate es_esgroups;
truncate es_esusers;
truncate es_methods;
truncate es_methods_users;
truncate es_searchcache;
truncate es_searchsessions;
truncate exemplaires;
truncate exemplaires_temp;
truncate exercices;
truncate expl_custom_values;
truncate explnum;
truncate explnum_doc;
truncate explnum_doc_actions;
truncate explnum_doc_sugg;
truncate explnum_location;
truncate external_count;
truncate fiche;
truncate frais;
truncate gestfic0_custom;
truncate gestfic0_custom_lists;
truncate gestfic0_custom_values;
truncate grilles;
truncate groupe;
truncate groupexpl;
truncate groupexpl_expl;
truncate harvest_field;
truncate harvest_profil;
truncate harvest_profil_import;
truncate harvest_profil_import_field;
truncate harvest_search_field;
truncate harvest_src;
truncate import_marc;
truncate liens_actes;
truncate lignes_actes;
truncate lignes_actes_relances;
truncate linked_mots;
truncate log_expl_retard;
truncate log_retard;
truncate logopac;
truncate mailtpl;
truncate mots;
truncate notices;
truncate notices_authorities_sources;
truncate notices_categories;
truncate notices_custom;
truncate notices_custom_lists;
truncate notices_custom_values;
truncate notices_externes;
truncate notices_fields_global_index;
truncate notices_global_index;
truncate notices_langues;
truncate notices_mots_global_index;
truncate notices_relations;
truncate notices_titres_uniformes;
truncate offres_remises;
truncate opac_filters;
truncate opac_liste_lecture;
truncate opac_sessions;
truncate opac_views;
truncate opac_views_empr;
truncate ouvertures;
truncate paiements;
truncate param_subst;
truncate perio_relance;
truncate planificateur;
truncate pret;
truncate pret_archive;
truncate publishers;
truncate quotas;
truncate quotas_finance;
truncate quotas_opac_views;
truncate rapport_demandes;
truncate recouvrements;
truncate resa;
truncate resa_archive;
truncate resa_loc;
truncate resa_planning;
truncate resa_ranger;
truncate responsability;
truncate rss_content;
truncate rss_flux;
truncate rss_flux_content;
truncate rubriques;
truncate sauv_lieux;
truncate sauv_log;
truncate search_cache;
truncate search_persopac;
truncate search_persopac_empr_categ;
truncate serialcirc;
truncate serialcirc_ask;
truncate serialcirc_circ;
truncate serialcirc_copy;
truncate serialcirc_diff;
truncate serialcirc_expl;
truncate serialcirc_group;
truncate series;
truncate sessions;
truncate source_sync;
truncate sources_enrichment;
truncate statopac;
truncate sub_collections;
truncate suggestions;
truncate suggestions_origine;
truncate suggestions_source;
truncate sur_location;
truncate taches;
truncate taches_docnum;
truncate taches_type;
truncate tags;
truncate titres_uniformes;
truncate transactions;
truncate transferts;
truncate transferts_demande;
truncate translation;
truncate tris;
truncate tu_distrib;
truncate tu_ref;
truncate tu_subdiv;
truncate tva_achats;
truncate type_abts;
truncate type_comptes;
truncate types_produits;
truncate upload_repertoire;
truncate users_groups;
truncate visionneuse_params;
truncate words;
truncate z_notices;
truncate z_query;
UPDATE `parametres` SET `id_param` = 690,`type_param` = 'opac',`sstype_param` = 'notice_enrichment',`valeur_param` = '0',`comment_param` = 'Activer l''enrichissement des notices\r\n 0: Non \r\n 1: Oui',`section_param` = 'e_aff_notice',`gestion` = 0 WHERE `parametres`.`id_param` = 690;
UPDATE `parametres` SET `id_param` = 691,`type_param` = 'opac',`sstype_param` = 'show_social_network',`valeur_param` = '0',`comment_param` = 'Activer les partages sur les réseaux sociaux \r\n 0: Non \r\n 1: Oui',`section_param` = 'e_aff_notice',`gestion` = 0 WHERE `parametres`.`id_param` = 691;
UPDATE `parametres` SET `id_param` = 757,`type_param` = 'opac',`sstype_param` = 'notices_format_onglets',`valeur_param` = '',`comment_param` = 'Liste des id de template de notice pour ajouter des onglets personnalisés en affichage de notice\r\nExemple: 1,3',`section_param` = 'e_aff_notice',`gestion` = 0 WHERE `parametres`.`id_param` = 757;

