Subversion Repositories eFlore/Applications.coel

Compare Revisions

Ignore whitespace Rev 1765 → Rev 1766

/trunk/doc/bdd/coel.mwb
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/doc/bdd/maj_supression_projet_22_01_2014.sql
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`;