# Mise à jour des guids

#table collection
UPDATE coel_collection SET cc_guid = REPLACE(cc_guid, ":Herbiers LR", "");
UPDATE coel_collection SET cc_guid = REPLACE(cc_guid, ":ihf", "");
UPDATE coel_collection SET cc_guid = REPLACE(cc_guid, "::", ":");

#table structure 
UPDATE coel_structure SET cs_guid = REPLACE(cs_guid, ":Herbiers LR", "");
UPDATE coel_structure SET cs_guid = REPLACE(cs_guid, ":ihf", "");
UPDATE coel_structure SET cs_guid = REPLACE(cs_guid, "::", ":");

#suppression des tables et colonnes projets 
DROP TABLE `coel_projet`;
DROP TABLE `coel_projet_a_structure`;
DROP TABLE `coel_projet_version`;

ALTER TABLE `coel_collection` DROP `cc_ce_projet`;
ALTER TABLE `coel_commentaire` DROP `ccm_ce_projet`;
ALTER TABLE `coel_meta_colonne` DROP `cmc_ce_projet`;
ALTER TABLE `coel_meta_liste_valeur` DROP `cmlv_ce_projet`;
ALTER TABLE `coel_personne` DROP `cp_ce_projet`;
ALTER TABLE `coel_personne_a_relation` DROP `cpar_id_projet`;
ALTER TABLE `coel_publication` DROP `cpu_ce_projet`;
ALTER TABLE `coel_structure` DROP `cs_ce_projet`;
