mromy 2005/04/29 16:10:08 CEST
Added files:
src/scripts/mysql varchar_changes.sql
Log:
added script
Revision Changes Path
1.1 +32 -0 jahia_update/src/scripts/mysql/varchar_changes.sql (new)
http://jahia.mine.nu:8080/cgi-bin/cvsweb.cgi/jahia_update/src/scripts/mysql/varchar_changes.sql?rev=1.1&content-type=text/plain
Index: varchar_changes.sql
====================================================================
ALTER TABLE jahia_grp_prop MODIFY name_jahia_grp_prop varchar(150);
ALTER TABLE jahia_link MODIFY left_oid varchar(100);
ALTER TABLE jahia_link MODIFY right_oid varchar(100);
ALTER TABLE jahia_link MODIFY type varchar(100);
ALTER TABLE jahia_pages_def_prop MODIFY value_pages_def_prop varchar(200);
ALTER TABLE jahia_pages_prop MODIFY prop_name varchar(150);
ALTER TABLE jahia_pages_prop MODIFY language_code varchar(20);
ALTER TABLE jahia_slide_branches MODIFY uri varchar(200);
ALTER TABLE jahia_slide_branches MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_children MODIFY uri varchar(200);
ALTER TABLE jahia_slide_children MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_label MODIFY uri varchar(200);
ALTER TABLE jahia_slide_label MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_links MODIFY linkto varchar(200);
ALTER TABLE jahia_slide_links MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_latestrev MODIFY uri varchar(200);
ALTER TABLE jahia_slide_latestrev MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_locks MODIFY object varchar(200);
ALTER TABLE jahia_slide_locks MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_objects MODIFY uri varchar(200);
ALTER TABLE jahia_slide_objects MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_permissions MODIFY object varchar(200);
ALTER TABLE jahia_slide_permissions MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_property MODIFY uri varchar(200);
ALTER TABLE jahia_slide_property MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_revision MODIFY uri varchar(200);
ALTER TABLE jahia_slide_revision MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_revisions MODIFY uri varchar(200);
ALTER TABLE jahia_slide_revisions MODIFY slidens varchar(50);
ALTER TABLE jahia_slide_workingrev MODIFY uri varchar(200);
ALTER TABLE jahia_slide_workingrev MODIFY slidens varchar(50);
ALTER TABLE jahia_user_prop MODIFY name_jahia_user_prop varchar(150);