mromy 2005/04/29 16:08:20 CEST
Modified files:
html README_4_0_6.html
Log:
- updated
Revision Changes Path
1.6 +5 -39 jahia_update/html/README_4_0_6.html
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia_update/html/README_4_0_6.html.diff?r1=1.5&r2=1.6&f=h
Index: README_4_0_6.html
===================================================================
RCS file: /cvs/jahia_update/html/README_4_0_6.html,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- README_4_0_6.html 29 Apr 2005 13:48:39 -0000 1.5
+++ README_4_0_6.html 29 Apr 2005 14:08:20 -0000 1.6
@@ -113,45 +113,11 @@
to <strong>MySQL 4.1.x</strong>, and also to extend the size of some
fields which may reveal too limited in some
cases.<br/>
You will first need to connect to your database (either in command
line or with a third party client) with a
- user who has at least "alter" permission on the database. You can
then execute the following commands :<br/>
- <p class="code">
- ALTER TABLE jahia_grp_prop MODIFY name_jahia_grp_prop
varchar(150);<br/>
- ALTER TABLE jahia_link MODIFY left_oid varchar(100);<br/>
- ALTER TABLE jahia_link MODIFY right_oid varchar(100);<br/>
- ALTER TABLE jahia_link MODIFY type varchar(100);<br/>
- ALTER TABLE jahia_pages_def_prop MODIFY value_pages_def_prop
varchar(200);<br/>
- ALTER TABLE jahia_pages_prop MODIFY prop_name varchar(150);<br/>
- ALTER TABLE jahia_pages_prop MODIFY language_code
varchar(20);<br/>
- ALTER TABLE jahia_slide_branches MODIFY uri varchar(200);<br/>
- ALTER TABLE jahia_slide_branches MODIFY slidens varchar(50);<br/>
- ALTER TABLE jahia_slide_children MODIFY uri varchar(200);<br/>
- ALTER TABLE jahia_slide_children MODIFY slidens varchar(50);<br/>
- ALTER TABLE jahia_slide_label MODIFY uri varchar(200);<br/>
- ALTER TABLE jahia_slide_label MODIFY slidens varchar(50);<br/>
- ALTER TABLE jahia_slide_links MODIFY linkto varchar(200);<br/>
- ALTER TABLE jahia_slide_links MODIFY slidens varchar(50);<br/>
- ALTER TABLE jahia_slide_latestrev MODIFY uri varchar(200);<br/>
- ALTER TABLE jahia_slide_latestrev MODIFY slidens
varchar(50);<br/>
- ALTER TABLE jahia_slide_locks MODIFY object varchar(200);<br/>
- ALTER TABLE jahia_slide_locks MODIFY slidens varchar(50);<br/>
- ALTER TABLE jahia_slide_objects MODIFY uri varchar(200);<br/>
- ALTER TABLE jahia_slide_objects MODIFY slidens varchar(50);<br/>
- ALTER TABLE jahia_slide_permissions MODIFY object
varchar(200);<br/>
- ALTER TABLE jahia_slide_permissions MODIFY slidens
varchar(50);<br/>
- ALTER TABLE jahia_slide_property MODIFY uri varchar(200);<br/>
- ALTER TABLE jahia_slide_property MODIFY slidens varchar(50);<br/>
- ALTER TABLE jahia_slide_revision MODIFY uri varchar(200);<br/>
- ALTER TABLE jahia_slide_revision MODIFY slidens varchar(50);<br/>
- ALTER TABLE jahia_slide_revisions MODIFY uri varchar(200);<br/>
- ALTER TABLE jahia_slide_revisions MODIFY slidens
varchar(50);<br/>
- ALTER TABLE jahia_slide_workingrev MODIFY uri varchar(200);<br/>
- ALTER TABLE jahia_slide_workingrev MODIFY slidens
varchar(50);<br/>
- ALTER TABLE jahia_user_prop MODIFY name_jahia_user_prop
varchar(150);<br/>
- </p>
- <br/>
- This set of SQL commands reduces the size of some fields to prevent
problem that may occur when upgrading
- from MySQL 4.0.x to MySQL 4.1.<br/>
- A <a href="varchar_changes.sql">SQL script file</a> is also provided
with all the SQL commands listed above.<br/><br/>
+ user who has at least "alter" permission on the database.
+ <br/><br/>
+ You can now execute the following set of SQL commands available in
this <a href="varchar_changes.sql">SQL script file</a>
+ to reduce the size of some fields to prevent problem that may occur
when upgrading from MySQL 4.0.x to MySQL 4.1.
+ <br/><br/>
Another set of SQL commands extends the maxium length of integer
fields to allow for longer numbers.
As it is rether large, the SQL commands are not copied in this
README file but are available in this
second <a href="mediumint_to_integer.sql">SQL script
file</a>.<br/><br/>
