| 1766 |
aurelien |
1 |
# Mise à jour des guids
|
|
|
2 |
|
|
|
3 |
#table collection
|
|
|
4 |
UPDATE coel_collection SET cc_guid = REPLACE(cc_guid, ":Herbiers LR", "");
|
|
|
5 |
UPDATE coel_collection SET cc_guid = REPLACE(cc_guid, ":ihf", "");
|
|
|
6 |
UPDATE coel_collection SET cc_guid = REPLACE(cc_guid, "::", ":");
|
|
|
7 |
|
|
|
8 |
#table structure
|
|
|
9 |
UPDATE coel_structure SET cs_guid = REPLACE(cs_guid, ":Herbiers LR", "");
|
|
|
10 |
UPDATE coel_structure SET cs_guid = REPLACE(cs_guid, ":ihf", "");
|
|
|
11 |
UPDATE coel_structure SET cs_guid = REPLACE(cs_guid, "::", ":");
|
|
|
12 |
|
|
|
13 |
#suppression des tables et colonnes projets
|
|
|
14 |
DROP TABLE `coel_projet`;
|
|
|
15 |
DROP TABLE `coel_projet_a_structure`;
|
|
|
16 |
DROP TABLE `coel_projet_version`;
|
|
|
17 |
|
|
|
18 |
ALTER TABLE `coel_collection` DROP `cc_ce_projet`;
|
|
|
19 |
ALTER TABLE `coel_commentaire` DROP `ccm_ce_projet`;
|
|
|
20 |
ALTER TABLE `coel_meta_colonne` DROP `cmc_ce_projet`;
|
|
|
21 |
ALTER TABLE `coel_meta_liste_valeur` DROP `cmlv_ce_projet`;
|
|
|
22 |
ALTER TABLE `coel_personne` DROP `cp_ce_projet`;
|
|
|
23 |
ALTER TABLE `coel_personne_a_relation` DROP `cpar_id_projet`;
|
|
|
24 |
ALTER TABLE `coel_publication` DROP `cpu_ce_projet`;
|
|
|
25 |
ALTER TABLE `coel_structure` DROP `cs_ce_projet`;
|