Author: tdraier
Date: Tue Jun 26 19:10:26 2007
New Revision: 17785
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D17785&repname=
=3Djahia
Log:
index for container load
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=3D17785&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 Tue Jun 26 19:10:26 2007
@@ -24,6 +24,8 @@
=
DROP INDEX jahia_ctn_lists_index4 ON jahia_ctn_lists ;
=
+DROP INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists ;
+
DROP INDEX jahia_ctn_struct_index ON jahia_ctn_struct ;
=
DROP INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop ;
@@ -134,6 +136,8 @@
=
CREATE INDEX jahia_ctn_lists_index4 ON jahia_ctn_lists (parententryid_jahi=
a_ctn_lists);
=
+CREATE INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists (pageid_jahia_ctn_l=
ists);
+
CREATE INDEX jahia_ctn_struct_index ON jahia_ctn_struct (rank_jahia_ctn_st=
ruct, ctnsubdefid_jahia_ctn_struct);
=
CREATE INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop (ctnlistid_c=
tnlists_prop);
@@ -148,7 +152,7 @@
=
CREATE INDEX jahia_fields_data_index5 ON jahia_fields_data (rights_jahia_f=
ields_data);
=
-CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, rank_jahia_fields_data, id_jahia_fields_data);
+CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, id_jahia_fields_data);
=
CREATE INDEX jahia_fields_data_index7 ON jahia_fields_data (value_jahia_fi=
elds_data, type_jahia_fields_data, workflow_state, version_id);
=
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=3D17785&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 Tue Jun 26 19:10:26 2007
@@ -24,6 +24,8 @@
=
DROP INDEX jahia_ctn_lists_index4 ON jahia_ctn_lists ;
=
+DROP INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists ;
+
DROP INDEX jahia_ctn_struct_index ON jahia_ctn_struct ;
=
DROP INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop ;
@@ -134,6 +136,8 @@
=
CREATE INDEX jahia_ctn_lists_index4 ON jahia_ctn_lists (parententryid_jahi=
a_ctn_lists);
=
+CREATE INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists (pageid_jahia_ctn_l=
ists);
+
CREATE INDEX jahia_ctn_struct_index ON jahia_ctn_struct (rank_jahia_ctn_st=
ruct, ctnsubdefid_jahia_ctn_struct);
=
CREATE INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop (ctnlistid_c=
tnlists_prop);
@@ -148,7 +152,7 @@
=
CREATE INDEX jahia_fields_data_index5 ON jahia_fields_data (rights_jahia_f=
ields_data);
=
-CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, rank_jahia_fields_data, id_jahia_fields_data);
+CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, id_jahia_fields_data);
=
CREATE INDEX jahia_fields_data_index7 ON jahia_fields_data (value_jahia_fi=
elds_data, type_jahia_fields_data, workflow_state, version_id);
=
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=3D17785&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 Tue Jun 26 19:10:26 2007
@@ -24,6 +24,8 @@
=
DROP INDEX jahia_ctn_lists_index4 ON jahia_ctn_lists ;
=
+DROP INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists ;
+
DROP INDEX jahia_ctn_struct_index ON jahia_ctn_struct ;
=
DROP INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop ;
@@ -132,6 +134,8 @@
=
CREATE INDEX jahia_ctn_lists_index4 ON jahia_ctn_lists (parententryid_jahi=
a_ctn_lists);
=
+CREATE INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists (pageid_jahia_ctn_l=
ists);
+
CREATE INDEX jahia_ctn_struct_index ON jahia_ctn_struct (rank_jahia_ctn_st=
ruct, ctnsubdefid_jahia_ctn_struct);
=
CREATE INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop (ctnlistid_c=
tnlists_prop);
@@ -146,7 +150,7 @@
=
CREATE INDEX jahia_fields_data_index5 ON jahia_fields_data (rights_jahia_f=
ields_data);
=
-CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, rank_jahia_fields_data, id_jahia_fields_data);
+CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, id_jahia_fields_data);
=
CREATE INDEX jahia_fields_data_index7 ON jahia_fields_data (value_jahia_fi=
elds_data, type_jahia_fields_data, workflow_state, version_id);
=
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=3D17785&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 Tue Jun 26 19:10:26 2007
@@ -24,6 +24,8 @@
=
DROP INDEX jahia_ctn_lists_index4 ON jahia_ctn_lists ;
=
+DROP INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists ;
+
DROP INDEX jahia_ctn_struct_index ON jahia_ctn_struct ;
=
DROP INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop ;
@@ -134,6 +136,8 @@
=
CREATE INDEX jahia_ctn_lists_index4 ON jahia_ctn_lists (parententryid_jahi=
a_ctn_lists);
=
+CREATE INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists (pageid_jahia_ctn_l=
ists);
+
CREATE INDEX jahia_ctn_struct_index ON jahia_ctn_struct (rank_jahia_ctn_st=
ruct, ctnsubdefid_jahia_ctn_struct);
=
CREATE INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop (ctnlistid_c=
tnlists_prop);
@@ -148,7 +152,7 @@
=
CREATE INDEX jahia_fields_data_index5 ON jahia_fields_data (rights_jahia_f=
ields_data);
=
-CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, rank_jahia_fields_data, id_jahia_fields_data);
+CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, id_jahia_fields_data);
=
CREATE INDEX jahia_fields_data_index7 ON jahia_fields_data (value_jahia_fi=
elds_data, type_jahia_fields_data, workflow_state, version_id);
=
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=3D17785&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 Tue Jun 26 19:10:26 2007
@@ -20,6 +20,8 @@
=
DROP INDEX jahia_ctn_lists_index4;
=
+DROP INDEX jahia_ctn_lists_index5;
+
DROP INDEX jahia_ctn_struct_index;
=
DROP INDEX jahia_ctnlists_prop_index;
@@ -119,6 +121,8 @@
=
CREATE INDEX jahia_ctn_lists_index4 ON jahia_ctn_lists (parententryid_jahi=
a_ctn_lists);
=
+CREATE INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists (pageid_jahia_ctn_l=
ists);
+
CREATE INDEX jahia_ctn_struct_index ON jahia_ctn_struct (rank_jahia_ctn_st=
ruct, ctnsubdefid_jahia_ctn_struct);
=
CREATE INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop (ctnlistid_c=
tnlists_prop);
@@ -133,7 +137,7 @@
=
CREATE INDEX jahia_fields_data_index5 ON jahia_fields_data (rights_jahia_f=
ields_data);
=
-CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, rank_jahia_fields_data, id_jahia_fields_data);
+CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, id_jahia_fields_data);
=
CREATE INDEX jahia_fields_data_index7 ON jahia_fields_data (value_jahia_fi=
elds_data, type_jahia_fields_data, workflow_state, version_id);
=
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=3D17785&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 Tue Jun 26 19:10:26 2007
@@ -24,6 +24,8 @@
=
DROP INDEX jahia_ctn_lists_index4;
=
+DROP INDEX jahia_ctn_lists_index5;
+
DROP INDEX jahia_ctn_struct_index;
=
DROP INDEX jahia_ctnlists_prop_index;
@@ -134,6 +136,8 @@
=
CREATE INDEX jahia_ctn_lists_index4 ON jahia_ctn_lists (parententryid_jahi=
a_ctn_lists);
=
+CREATE INDEX jahia_ctn_lists_index5 ON jahia_ctn_lists (pageid_jahia_ctn_l=
ists);
+
CREATE INDEX jahia_ctn_struct_index ON jahia_ctn_struct (rank_jahia_ctn_st=
ruct, ctnsubdefid_jahia_ctn_struct);
=
CREATE INDEX jahia_ctnlists_prop_index ON jahia_ctnlists_prop (ctnlistid_c=
tnlists_prop);
@@ -148,7 +152,7 @@
=
CREATE INDEX jahia_fields_data_index5 ON jahia_fields_data (rights_jahia_f=
ields_data);
=
-CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, rank_jahia_fields_data, id_jahia_fields_data);
+CREATE INDEX jahia_fields_data_index6 ON jahia_fields_data (ctnid_jahia_fi=
elds_data, id_jahia_fields_data);
=
CREATE INDEX jahia_fields_data_index7 ON jahia_fields_data (value_jahia_fi=
elds_data, type_jahia_fields_data, workflow_state, version_id);
=
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
