Author: shuber
Date: Thu Sep 13 09:29:25 2007
New Revision: 18432
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D18432&repname=
=3Djahia
Log:
JAHIA-2256 : Syntax error in patches from 5.0SP2 database to latest build
- Corrected SQL syntax that should now also work on PostgreSQL 8.1
Modified:
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/etc/patches/optimi=
zations_postgresql_18053.sql
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/etc/patches/=
optimizations_postgresql_18053.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/etc/patches/optimizations_postgresql_18053.=
sql&rev=3D18432&repname=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/WEB-INF/etc/patches/optimi=
zations_postgresql_18053.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/etc/patches/optimi=
zations_postgresql_18053.sql Thu Sep 13 09:29:25 2007
@@ -1,10 +1,12 @@
alter table jahia_acl add hasentries_jahia_acl integer;
-update jahia_acl a set hasentries_jahia_acl=3D(select count(*) from jahia_=
acl_entries b where a.id_jahia_acl=3Db.id_jahia_acl);
+update jahia_acl set hasentries_jahia_acl=3D(select count(*) from jahia_ac=
l_entries b where jahia_acl.id_jahia_acl=3Db.id_jahia_acl);
alter table jahia_fields_data drop ismdata_jahia_fields_data;
alter table jahia_fields_data drop rank_jahia_fields_data ;
-alter table jahia_pages_data modify language_code varchar(10) not null;
+alter table jahia_pages_data alter language_code type varchar(10);
+alter table jahia_pages_data alter language_code set not null;
alter table jahia_pages_data drop counter_jahia_pages_data ;
alter table jahia_pages_data drop doc_jahia_pages_data;
alter table jahia_pages_data drop creator_jahia_pages_data;
-alter table jahia_obj modify type_jahia_obj varchar(22) not null;
+alter table jahia_obj alter type_jahia_obj type varchar(22);
+alter table jahia_obj alter type_jahia_obj set not null;
delete from jahia_link where type=3D'reference';
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
