New file |
0,0 → 1,25 |
# 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`; |