Changes between Initial Version and Version 1 of Fr_HowToMigrateTo23

Timestamp:

Apr 11, 2010, 11:18:08 PM (14 years ago)

Author:

fxp

Comment:

--

Fr_HowToMigrateTo23

@@ +1 @@
+== Procédure de migration de la version 2.2 à la version 2.3 ==
+
+=== Migration de la base de données ===
+La structure de la base de données a été légèrement modifiée entre les 2 versions.
+
+
+Le script suivant permet d'ajouter les nouvelles colonnes :
+{{{
+ALTER TABLE Users ADD city varchar(128);
+ALTER TABLE Metadata ADD displayorder int;
+}}}
+
+
+
+Le script suivant permet d'ajouter les nouvelles valeurs :
+{{{
+INSERT INTO Groups VALUES (-1, 'GUEST', 'self-registered users', null, null);
+INSERT INTO GroupsDes VALUES (-1, 'en', 'GUEST');
+INSERT INTO GroupsDes VALUES (-1, 'fr', 'GUEST');
+UPDATE IsoLanguages SET code = 'fre' WHERE code = 'fra';
+INSERT INTO Operations VALUES (2, 'editing', 'y');
+INSERT INTO OperationsDes VALUES (2, 'en', 'Editing');
+INSERT INTO OperationsDes VALUES (2, 'fr', 'Editing');
+-- Settings
+INSERT INTO Settings VALUES (90, 1, 'selectionmanager', null);
+INSERT INTO Settings VALUES (91, 90, 'maxrecords', 1000);
+INSERT INTO Settings VALUES (170,1,'shib,'');
+INSERT INTO Settings VALUES (171,170,'use,'false');
+INSERT INTO Settings VALUES (172,170,'path,'/geonetwork/srv/en/shib.user.login');
+INSERT INTO Settings VALUES (173,170,'attrib,'');
+INSERT INTO Settings VALUES (174,173,'username,'REMOTE_USER');
+INSERT INTO Settings VALUES (175,173,'surname,'Shib-Person-surname');
+INSERT INTO Settings VALUES (176,173,'firstname,'Shib-InetOrgPerson-givenName');
+INSERT INTO Settings VALUES (177,173,'profile,'Shib-EP-Entitlement');
+INSERT INTO Settings VALUES (190,1,'userSelfRegistration,'');
+INSERT INTO Settings VALUES (191,190,'enable,'false');
+INSERT INTO Settings VALUES (200,1,'clickablehyperlinks,'');
+INSERT INTO Settings VALUES (201,200,'enable,'true');
+INSERT INTO Settings VALUES (210,1,'localrating,'');
+INSERT INTO Settings VALUES (211,210,'enable,'false');
+INSERT INTO Settings VALUES (220,1,'xlinkResolver,'');
+INSERT INTO Settings VALUES (221,220,'enable,'true');
+INSERT INTO Settings VALUES (600,1,'indexoptimizer,'');
+INSERT INTO Settings VALUES (601,,'600,'enable,'true');
+INSERT INTO Settings VALUES (602,600,'at,'');
+INSERT INTO Settings VALUES (603,602,'hour,'0');
+INSERT INTO Settings VALUES (604,602,'min,'0');
+INSERT INTO Settings VALUES (605,602,'sec,'0');
+INSERT INTO Settings VALUES (606,600,'interval,'');
+INSERT INTO Settings VALUES (607,606,'day,'0');
+INSERT INTO Settings VALUES (608,606,'hour,'24,'');
+INSERT INTO Settings VALUES (609,606,'min,'0');
+
+}}}
+
+TODO : Vérifier les interactions avec les noeuds moissonnés (problème d'identifiant)
+
+
+
+=== Installation de l'application ===
+
+