svn commit: [jahia] r17984 - in /trunk/core/src/webapp/WEB-INF/var/db/sql/schema: hypersonic/ mssql/ mysql-tx/ mysql/ oracle/ postgresql/

cmailleux Thu, 12 Jul 2007 09:49:07 -0700

Author: cmailleux
Date: Thu Jul 12 18:48:58 2007
New Revision: 17984

URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D17984&repname=
=3Djahia
Log:
Port [17656] Add index on jahia fields data


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=3D17984&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 Thu Jul 12 18:48:58 2007
@@ -54,6 +54,8 @@
 =

 DROP INDEX jahia_fields_data_index13 ON jahia_fields_data ;
 =

+DROP INDEX jahia_fields_data_index14 ON jahia_fields_data ;
+
 DROP INDEX jahia_fields_def_index ON jahia_fields_def ;
 =

 DROP INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop ;

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=3D17984&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 Thu Jul 12 18:48:58 2007
@@ -54,6 +54,8 @@
 =

 DROP INDEX jahia_fields_data_index13 ON jahia_fields_data ;
 =

+DROP INDEX jahia_fields_data_index14 ON jahia_fields_data ;
+
 DROP INDEX jahia_fields_def_index ON jahia_fields_def ;
 =

 DROP INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop ;
@@ -162,6 +164,8 @@
 =

 CREATE INDEX jahia_fields_data_index13 ON jahia_fields_data (id_jahia_fiel=
ds_data, workflow_state,language_code);
 =

+CREATE INDEX jahia_fields_data_index14 ON jahia_fields_data (id_jahia_obj,=
 type_jahia_obj, workflow_state);
+
 CREATE INDEX jahia_fields_def_index ON jahia_fields_def (name_jahia_fields=
_def);
 =

 CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop (flddefi=
d_jahia_fields_def_prop);

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=3D17984&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 Thu Jul 12 18:48:58 2007
@@ -54,6 +54,8 @@
 =

 DROP INDEX jahia_fields_data_index13 ON jahia_fields_data ;
 =

+DROP INDEX jahia_fields_data_index14 ON jahia_fields_data ;
+
 DROP INDEX jahia_fields_def_index ON jahia_fields_def ;
 =

 DROP INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop ;
@@ -160,6 +162,8 @@
 =

 CREATE INDEX jahia_fields_data_index13 ON jahia_fields_data (id_jahia_fiel=
ds_data, workflow_state,language_code);
 =

+CREATE INDEX jahia_fields_data_index14 ON jahia_fields_data (id_jahia_obj,=
 type_jahia_obj, workflow_state);
+
 CREATE INDEX jahia_fields_def_index ON jahia_fields_def (name_jahia_fields=
_def);
 =

 CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop (flddefi=
d_jahia_fields_def_prop);

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=3D17984&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 Thu Jul 12 18:48:58 2007
@@ -54,6 +54,8 @@
 =

 DROP INDEX jahia_fields_data_index13 ON jahia_fields_data ;
 =

+DROP INDEX jahia_fields_data_index14 ON jahia_fields_data ;
+
 DROP INDEX jahia_fields_def_index ON jahia_fields_def ;
 =

 DROP INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop ;
@@ -162,6 +164,8 @@
 =

 CREATE INDEX jahia_fields_data_index13 ON jahia_fields_data (id_jahia_fiel=
ds_data, workflow_state,language_code);
 =

+CREATE INDEX jahia_fields_data_index14 ON jahia_fields_data (id_jahia_obj,=
 type_jahia_obj, workflow_state);
+
 CREATE INDEX jahia_fields_def_index ON jahia_fields_def (name_jahia_fields=
_def);
 =

 CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop (flddefi=
d_jahia_fields_def_prop);

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=3D17984&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 Thu Jul 12 18:48:58 2007
@@ -54,6 +54,8 @@
 =

 DROP INDEX jahia_fields_data_index13;
 =

+DROP INDEX jahia_fields_data_index14;
+
 DROP INDEX jahia_fields_def_index;
 =

 DROP INDEX jahia_fields_def_prop_index;
@@ -162,6 +164,8 @@
 =

 CREATE INDEX jahia_fields_data_index13 ON jahia_fields_data (id_jahia_fiel=
ds_data, workflow_state,language_code);
 =

+CREATE INDEX jahia_fields_data_index14 ON jahia_fields_data (id_jahia_obj,=
 type_jahia_obj, workflow_state);
+
 CREATE INDEX jahia_fields_def_index ON jahia_fields_def (name_jahia_fields=
_def);
 =

 CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop (flddefi=
d_jahia_fields_def_prop);

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=3D17984&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 Thu Jul 12 18:48:58 2007
@@ -54,6 +54,8 @@
 =

 DROP INDEX jahia_fields_data_index13;
 =

+DROP INDEX jahia_fields_data_index14;
+
 DROP INDEX jahia_fields_def_index;
 =

 DROP INDEX jahia_fields_def_prop_index;
@@ -162,6 +164,8 @@
 =

 CREATE INDEX jahia_fields_data_index13 ON jahia_fields_data (id_jahia_fiel=
ds_data, workflow_state,language_code);
 =

+CREATE INDEX jahia_fields_data_index14 ON jahia_fields_data (id_jahia_obj,=
 type_jahia_obj, workflow_state);
+
 CREATE INDEX jahia_fields_def_index ON jahia_fields_def (name_jahia_fields=
_def);
 =

 CREATE INDEX jahia_fields_def_prop_index ON jahia_fields_def_prop (flddefi=
d_jahia_fields_def_prop);

_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list

svn commit: [jahia] r17984 - in /trunk/core/src/webapp/WEB-INF/var/db/sql/schema: hypersonic/ mssql/ mysql-tx/ mysql/ oracle/ postgresql/

Reply via email to