Author: srouaud
Date: Mon Oct 15 16:41:58 2007
New Revision: 18866
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D18866&repname=
=3Djahia
Log:
add migration from 5.0.0
Modified:
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/html/startup/howtoupgrade5=
03.html
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/html/startup/howtoup=
grade503.html
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/html/startup/howtoupgrade503.html&rev=3D18866&repna=
me=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/html/startup/howtoupgrade5=
03.html (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/html/startup/howtoupgrade5=
03.html Mon Oct 15 16:41:58 2007
@@ -2,7 +2,7 @@
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www=
.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns=3D"http://www.w3.org/1999/xhtml";>
<head>
-<title>How to upgrade from Jahia 5.0 to Jahia 5.0.1</title>
+<title>How to upgrade from Jahia 5.0 to Jahia 5.0.3</title>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859=
-1" />
<style type=3D"text/css">
<!--
@@ -154,19 +154,246 @@
</div>
</div>
<div class=3D"maincontent">
-
-<h1>
- How to upgrade from Jahia 5.0.2 to Jahia 5.0.3
+ <h1>
+ How to upgrade from Jahia 5.0.0 to Jahia 5.0.3
</h1>
+This document explain how to upgrade from Jahia 5.0.0 to Jahia 5.0.3. Basi=
cally, after launching sql script if you have a jahia version under 5.0.2, =
you need to setup a separate installation of Jahia 5.0.3, then recover from=
your existing Jahia 5.0.2 the data, content and specific setup you may hav=
e made (connexion to LDAP server, etc).
+You will also need to run an sql script to update your existing database. =
The following procedure should get you up and running :
+<h2>
+ How to upgrade from Jahia 5.0.0 to Jahia 5.0.1
+</h2>
=
<p>
-This document will explain how to upgrade from Jahia 5.0.2 to Jahia 5.0.3.=
Basically, you need to setup a separate installation of Jahia 5.0.3,
-then recover from your existing Jahia 5.0.2 the data, content and specific=
setup you may have made (connexion to LDAP server, etc).
-You will also need to launch a patch through Jahia to update your existing=
database. The following procedure should get you up and
-running :
+
+ <p>
+ You need to create 2 additional tables in your existing 5.0.0 data=
base. Connect to your database server with a tool that allow you
+ to run a sql query on it, and execute the following commands. <br/>
+ <br/>
+ <strong>For Microsoft SQLServer :</strong> <br/>
+
+<pre>
+ ALTER TABLE CUSTOM_PORTLET_MODE DROP CONSTRAINT CUSTOM_PORTLET_MODE_FK=
_1;
+
+CREATE TABLE CUSTOM_PORTLET_MODE
+(
+ ID INT NOT NULL,
+ APPLICATION_ID INT NOT NULL,
+ CUSTOM_NAME NVARCHAR (150) NOT NULL,
+ MAPPED_NAME NVARCHAR (150) NULL,
+ DESCRIPTION NTEXT NULL,
+
+ CONSTRAINT CUSTOM_PORTLET_MODE_PK PRIMARY KEY(ID));
+
+
+ ALTER TABLE CUSTOM_WINDOW_STATE DROP CONSTRAINT CUSTOM_WINDOW_STATE_FK=
_1;
+CREATE TABLE CUSTOM_WINDOW_STATE
+(
+ ID INT NOT NULL,
+ APPLICATION_ID INT NOT NULL,
+ CUSTOM_NAME NVARCHAR (150) NOT NULL,
+ MAPPED_NAME NVARCHAR (150) NULL,
+ DESCRIPTION NTEXT NULL,
+
+ CONSTRAINT CUSTOM_WINDOW_STATE_PK PRIMARY KEY(ID));
+
+</pre>
+
+ <strong>For MySQL :</strong> <br/>
+
+<pre>
+ drop table if exists CUSTOM_PORTLET_MODE;
+
+ CREATE TABLE CUSTOM_PORTLET_MODE
+ (
+ ID MEDIUMINT NOT NULL,
+ APPLICATION_ID MEDIUMINT NOT NULL,
+ CUSTOM_NAME VARCHAR(150) NOT NULL,
+ MAPPED_NAME VARCHAR(150),
+ DESCRIPTION MEDIUMTEXT,
+ PRIMARY KEY(ID),
+ FOREIGN KEY (APPLICATION_ID) REFERENCES PORTLET_APPLICATION (APPLI=
CATION_ID)
+ ON DELETE CASCADE
+ );
+
+ drop table if exists CUSTOM_WINDOW_STATE;
+
+ CREATE TABLE CUSTOM_WINDOW_STATE
+ (
+ ID MEDIUMINT NOT NULL,
+ APPLICATION_ID MEDIUMINT NOT NULL,
+ CUSTOM_NAME VARCHAR(150) NOT NULL,
+ MAPPED_NAME VARCHAR(150),
+ DESCRIPTION MEDIUMTEXT,
+ PRIMARY KEY(ID),
+ FOREIGN KEY (APPLICATION_ID) REFERENCES PORTLET_APPLICATION (APPLI=
CATION_ID)
+ ON DELETE CASCADE
+ );
+
+</pre>
+
+ <strong>For PostgreSQL :</strong> <br/>
+
+<pre>
+ DROP TABLE CUSTOM_PORTLET_MODE CASCADE;
+
+ CREATE TABLE CUSTOM_PORTLET_MODE
+ (
+ ID INTEGER NOT NULL,
+ APPLICATION_ID INTEGER NOT NULL,
+ CUSTOM_NAME VARCHAR(150) NOT NULL,
+ MAPPED_NAME VARCHAR(150),
+ DESCRIPTION TEXT,
+ PRIMARY KEY (ID)
+ );
+
+
+ DROP TABLE CUSTOM_WINDOW_STATE CASCADE;
+
+ CREATE TABLE CUSTOM_WINDOW_STATE
+ (
+ ID INTEGER NOT NULL,
+ APPLICATION_ID INTEGER NOT NULL,
+ CUSTOM_NAME VARCHAR(150) NOT NULL,
+ MAPPED_NAME VARCHAR(150),
+ DESCRIPTION TEXT,
+ PRIMARY KEY (ID)
+ );
+
+</pre>
+
+ <strong>For Oracle :</strong> <br/>
+
+<pre>
+ DROP TABLE CUSTOM_PORTLET_MODE CASCADE CONSTRAINTS;
+
+ CREATE TABLE CUSTOM_PORTLET_MODE
+ (
+ ID NUMBER(10,0) NOT NULL,
+ APPLICATION_ID NUMBER(10,0) NOT NULL,
+ CUSTOM_NAME VARCHAR2(150) NOT NULL,
+ MAPPED_NAME VARCHAR2(150),
+ DESCRIPTION VARCHAR2(2000)
+ );
+
+ ALTER TABLE CUSTOM_PORTLET_MODE
+ ADD CONSTRAINT CUSTOM_PORTLET_MODE_PK
+ PRIMARY KEY (ID);
+
+
+ DROP TABLE CUSTOM_WINDOW_STATE CASCADE CONSTRAINTS;
+
+ CREATE TABLE CUSTOM_WINDOW_STATE
+ (
+ ID NUMBER(10,0) NOT NULL,
+ APPLICATION_ID NUMBER(10,0) NOT NULL,
+ CUSTOM_NAME VARCHAR2(150) NOT NULL,
+ MAPPED_NAME VARCHAR2(150),
+ DESCRIPTION VARCHAR2(2000)
+ );
+
+ ALTER TABLE CUSTOM_WINDOW_STATE
+ ADD CONSTRAINT CUSTOM_WINDOW_STATE_PK
+ PRIMARY KEY (ID);
+
+</pre>
+
+ <strong>For HyperSonic :</strong> <br/>
+
+<pre>
+ drop table CUSTOM_PORTLET_MODE if exists;
+
+ CREATE TABLE CUSTOM_PORTLET_MODE
+ (
+ ID INTEGER,
+ APPLICATION_ID INTEGER,
+ CUSTOM_NAME VARCHAR (150),
+ MAPPED_NAME VARCHAR (150),
+ DESCRIPTION VARCHAR,
+ PRIMARY KEY(ID)
+ );
+
+ drop table CUSTOM_WINDOW_STATE if exists;
+
+ CREATE TABLE CUSTOM_WINDOW_STATE
+ (
+ ID INTEGER,
+ APPLICATION_ID INTEGER,
+ CUSTOM_NAME VARCHAR (150),
+ MAPPED_NAME VARCHAR (150),
+ DESCRIPTION VARCHAR,
+ PRIMARY KEY(ID)
+ );
+
+</pre>
+
+ Make sure the tables are correctly created in the database.
+ </p>
+
+
</p>
<BR>
=
+<h2>
+ How to upgrade from Jahia 5.0.1 to Jahia 5.0.2
+</h2>
+
+<p>
+
+ <p>
+ You need to drop some constraints in your existing 5.0.1 database.=
<BR>
+ Connect to your database server with a tool that allow you to run =
a sql query on it, and execute the following commands.<BR><BR>
+
+ <strong>For Oracle, PostgreSQL and Microsoft SQLServer : </strong>=
<br/>
+<pre>
+ alter table jahia_sl2_binding drop constraint fkab79b8e923e1f4c2;
+ alter table jahia_sl2_binding drop constraint fkab79b8e94605c954;
+ alter table jahia_sl2_locks drop constraint fk53da340c22ea3034;
+ alter table jahia_sl2_locks drop constraint fk53da340c33924d02;
+ alter table jahia_sl2_locks drop constraint fk53da340c69f368a3;
+ alter table jahia_sl2_locks drop constraint fk53da340cfcf9e20f;
+ alter table jahia_sl2_parent_binding drop constraint fk21da510c23e=
1f4c2;
+ alter table jahia_sl2_parent_binding drop constraint fk21da510c603=
f6ee2;
+ alter table jahia_sl2_version_history drop constraint fkb5a4b69145=
4fef2;
+ alter table jahia_sl2_version_history drop constraint fkb5a4b69123=
e1f4c2;
+ alter table jahia_users drop constraint fkc1adc5327a6024d5;
+ alter table jahia_site_prop drop constraint fkc9188385fcf86241;
+ alter table jahia_sites_users drop constraint fkea2bf1bf6496a1b8;
+
+</pre><BR><BR>
+<strong>For MySQL : </strong> <br/>
+<pre>
+ alter table jahia_sl2_binding drop foreign key fkab79b8e923e1f4c2;
+ alter table jahia_sl2_binding drop foreign key fkab79b8e94605c954;
+ alter table jahia_sl2_locks drop foreign key fk53da340c22ea3034;
+ alter table jahia_sl2_locks drop foreign key fk53da340c33924d02;
+ alter table jahia_sl2_locks drop foreign key fk53da340c69f368a3;
+ alter table jahia_sl2_locks drop foreign key fk53da340cfcf9e20f;
+ alter table jahia_sl2_parent_binding drop foreign key fk21da510c23=
e1f4c2;
+ alter table jahia_sl2_parent_binding drop foreign key fk21da510c60=
3f6ee2;
+ alter table jahia_sl2_version_history drop foreign key fkb5a4b6914=
54fef2;
+ alter table jahia_sl2_version_history drop foreign key fkb5a4b6912=
3e1f4c2;
+ alter table jahia_users drop foreign key fkc1adc5327a6024d5;
+ alter table jahia_site_prop drop foreign key fkc9188385fcf86241;
+ alter table jahia_sites_users drop foreign key fkea2bf1bf6496a1b8;
+ <BR>
+ ALTER TABLE jahia_link DROP COLUMN status;
+ ALTER TABLE jahia_link DROP COLUMN creation_date;
+ ALTER TABLE jahia_link DROP COLUMN creation_user;
+ ALTER TABLE jahia_link DROP COLUMN lastmodif_date;
+ ALTER TABLE jahia_link DROP COLUMN lastmodif_user;
+
+</pre>
+<br/>
+If your MySQL instance is case-senstive, you may need to use uppercase for=
the constraints names.
+
+ </p>
+</p>
+<BR>
+
+<h2>
+ How to upgrade from Jahia 5.0.2 to Jahia 5.0.3
+</h2>
+
<ol>
=
<B> New Jahia installation </B>
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
