Author: tdraier
Date: Wed Jul 4 18:10:43 2007
New Revision: 17876
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D17876&repname=
=3Djahia
Log:
update indexes for jahia_fields_data
Modified:
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
hypersonic/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mssql/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql-tx/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
oracle/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
postgresql/jahia-schema-index.sql
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/hypersonic/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema-i=
ndex.sql&rev=3D17876&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/var/db/sql/schema/=
hypersonic/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
hypersonic/jahia-schema-index.sql Wed Jul 4 18:10:43 2007
@@ -158,9 +158,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: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/mssql/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema-index.=
sql&rev=3D17876&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/var/db/sql/schema/=
mssql/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mssql/jahia-schema-index.sql Wed Jul 4 18:10:43 2007
@@ -158,9 +158,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: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/mysql-tx/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/mysql-tx/jahia-schema-ind=
ex.sql&rev=3D17876&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/var/db/sql/schema/=
mysql-tx/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql-tx/jahia-schema-index.sql Wed Jul 4 18:10:43 2007
@@ -156,9 +156,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: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/mysql/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema-index.=
sql&rev=3D17876&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/var/db/sql/schema/=
mysql/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql/jahia-schema-index.sql Wed Jul 4 18:10:43 2007
@@ -158,9 +158,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: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/oracle/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema-index=
.sql&rev=3D17876&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/var/db/sql/schema/=
oracle/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
oracle/jahia-schema-index.sql Wed Jul 4 18:10:43 2007
@@ -143,9 +143,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: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/postgresql/jahia-schema-index.sql
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-5-0-SP=
-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema-i=
ndex.sql&rev=3D17876&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/var/db/sql/schema/=
postgresql/jahia-schema-index.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
postgresql/jahia-schema-index.sql Wed Jul 4 18:10:43 2007
@@ -158,9 +158,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
