Subversion Repositories eFlore/Applications.coel

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
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`;