Author: tdraier
Date: Tue Jul 24 11:16:32 2007
New Revision: 18050
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D18050&repname=
=3Djahia
Log:
update indexes for jahia_fields_data (port 17876)
Modified:
trunk/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema=
-index.sql
trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema-inde=
x.sql
trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mysql-tx/jahia-schema-i=
ndex.sql
trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema-inde=
x.sql
trunk/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema-ind=
ex.sql
trunk/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema=
-index.sql
Modified: trunk/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-=
schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/trunk/core/src/webapp=
/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema-index.sql&rev=3D18050&re=
pname=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
--- trunk/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema=
-index.sql (original)
+++ trunk/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema=
-index.sql Tue Jul 24 11:16:32 2007
@@ -154,9 +154,9 @@
=
CREATE INDEX jahia_fields_data_index8 ON jahia_fields_data (id_jahia_field=
s_data, workflow_state);
=
-CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (ismdata_jahia_=
fields_data, fielddefid_jahia_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (fielddefid_jah=
ia_fields_data, id_jahia_obj, type_jahia_obj);
=
-CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (ismdata_jahia=
_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj);
=
CREATE INDEX jahia_fields_data_index11 ON jahia_fields_data (ctnid_jahia_f=
ields_data, workflow_state);
=
Modified: trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schem=
a-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/trunk/core/src/webapp=
/WEB-INF/var/db/sql/schema/mssql/jahia-schema-index.sql&rev=3D18050&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
--- trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema-inde=
x.sql (original)
+++ trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema-inde=
x.sql Tue Jul 24 11:16:32 2007
@@ -154,9 +154,9 @@
=
CREATE INDEX jahia_fields_data_index8 ON jahia_fields_data (id_jahia_field=
s_data, workflow_state);
=
-CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (ismdata_jahia_=
fields_data, fielddefid_jahia_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (fielddefid_jah=
ia_fields_data, id_jahia_obj, type_jahia_obj);
=
-CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (ismdata_jahia=
_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj);
=
CREATE INDEX jahia_fields_data_index11 ON jahia_fields_data (ctnid_jahia_f=
ields_data, workflow_state);
=
Modified: trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mysql-tx/jahia-sc=
hema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/trunk/core/src/webapp=
/WEB-INF/var/db/sql/schema/mysql-tx/jahia-schema-index.sql&rev=3D18050&repn=
ame=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
--- trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mysql-tx/jahia-schema-i=
ndex.sql (original)
+++ trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mysql-tx/jahia-schema-i=
ndex.sql Tue Jul 24 11:16:32 2007
@@ -152,9 +152,9 @@
=
CREATE INDEX jahia_fields_data_index8 ON jahia_fields_data (id_jahia_field=
s_data, workflow_state);
=
-CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (ismdata_jahia_=
fields_data, fielddefid_jahia_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (fielddefid_jah=
ia_fields_data, id_jahia_obj, type_jahia_obj);
=
-CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (ismdata_jahia=
_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj);
=
CREATE INDEX jahia_fields_data_index11 ON jahia_fields_data (ctnid_jahia_f=
ields_data, workflow_state);
=
Modified: trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schem=
a-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/trunk/core/src/webapp=
/WEB-INF/var/db/sql/schema/mysql/jahia-schema-index.sql&rev=3D18050&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
--- trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema-inde=
x.sql (original)
+++ trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema-inde=
x.sql Tue Jul 24 11:16:32 2007
@@ -154,9 +154,9 @@
=
CREATE INDEX jahia_fields_data_index8 ON jahia_fields_data (id_jahia_field=
s_data, workflow_state);
=
-CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (ismdata_jahia_=
fields_data, fielddefid_jahia_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data ( fielddefid_ja=
hia_fields_data, id_jahia_obj, type_jahia_obj);
=
-CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (ismdata_jahia=
_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj);
=
CREATE INDEX jahia_fields_data_index11 ON jahia_fields_data (ctnid_jahia_f=
ields_data, workflow_state);
=
Modified: trunk/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-sche=
ma-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/trunk/core/src/webapp=
/WEB-INF/var/db/sql/schema/oracle/jahia-schema-index.sql&rev=3D18050&repnam=
e=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
--- trunk/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema-ind=
ex.sql (original)
+++ trunk/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema-ind=
ex.sql Tue Jul 24 11:16:32 2007
@@ -154,9 +154,9 @@
=
CREATE INDEX jahia_fields_data_index8 ON jahia_fields_data (id_jahia_field=
s_data, workflow_state);
=
-CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (ismdata_jahia_=
fields_data, fielddefid_jahia_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (fielddefid_jah=
ia_fields_data, id_jahia_obj, type_jahia_obj);
=
-CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (ismdata_jahia=
_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj);
=
CREATE INDEX jahia_fields_data_index11 ON jahia_fields_data (ctnid_jahia_f=
ields_data, workflow_state);
=
Modified: trunk/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-=
schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/trunk/core/src/webapp=
/WEB-INF/var/db/sql/schema/postgresql/jahia-schema-index.sql&rev=3D18050&re=
pname=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
--- trunk/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema=
-index.sql (original)
+++ trunk/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema=
-index.sql Tue Jul 24 11:16:32 2007
@@ -154,9 +154,9 @@
=
CREATE INDEX jahia_fields_data_index8 ON jahia_fields_data (id_jahia_field=
s_data, workflow_state);
=
-CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (ismdata_jahia_=
fields_data, fielddefid_jahia_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index9 ON jahia_fields_data (fielddefid_jah=
ia_fields_data, id_jahia_obj, type_jahia_obj);
=
-CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (ismdata_jahia=
_fields_data, id_jahia_obj, type_jahia_obj);
+CREATE INDEX jahia_fields_data_index10 ON jahia_fields_data (id_jahia_obj,=
type_jahia_obj);
=
CREATE INDEX jahia_fields_data_index11 ON jahia_fields_data (ctnid_jahia_f=
ields_data, workflow_state);
=
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
