Author: tdraier
Date: Tue Jul 24 18:10:33 2007
New Revision: 18054
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D18054&repname=
=3Djahia
Log:
update schema & indexes for jahia-references
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/=
hypersonic/jahia-schema.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/=
mssql/jahia-schema.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/=
mysql/jahia-schema.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/=
oracle/jahia-schema.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
postgresql/jahia-schema-index.sql
branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
postgresql/jahia-schema.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=3D18054&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 Jul 24 18:10:33 2007
@@ -110,7 +110,9 @@
=
DROP INDEX jahia_languages_states_index ON jahia_languages_states ;
=
- =
+DROP INDEX jahia_reference_index;
+
+DROP INDEX jahia_reference_index2;
=
CREATE INDEX jahia_acl_index ON jahia_acl (id_jahia_acl);
=
@@ -234,4 +236,8 @@
=
CREATE INDEX jahia_indexingjobs_index ON jahia_indexingjobs (id_indexingjo=
b);
=
-CREATE INDEX jahia_languages_states_index ON jahia_languages_states (workf=
low_state, siteid);
\ No newline at end of file
+CREATE INDEX jahia_languages_states_index ON jahia_languages_states (workf=
low_state, siteid);
+
+CREATE INDEX jahia_reference_index ON jahia_reference (ref_type, ref_id);
+
+CREATE INDEX jahia_reference_index2 ON jahia_reference (page_id);
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/hypersonic/jahia-schema.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.s=
ql&rev=3D18054&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.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
hypersonic/jahia-schema.sql Tue Jul 24 18:10:33 2007
@@ -104,6 +104,7 @@
drop table jahia_pwd_policies if exists;
drop table jahia_pwd_policy_rule_params if exists;
drop table jahia_pwd_policy_rules if exists;
+drop table jahia_reference if exists;
drop table jahia_resources if exists;
drop table jahia_retrule if exists;
drop table jahia_retrule_range if exists;
@@ -564,6 +565,12 @@
periodical bit not null,
primary key (jahia_pwd_policy_rule_id)
);
+create table jahia_reference (
+ page_id integer not null,
+ ref_id integer not null,
+ ref_type integer not null,
+ primary key (page_id, ref_id, ref_type)
+);
create table jahia_resources (
name_resource varchar(200) not null,
languagecode_resource varchar(10) not null,
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=3D18054&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 Jul 24 18:10:33 2007
@@ -110,7 +110,9 @@
=
DROP INDEX jahia_languages_states_index ON jahia_languages_states ;
=
- =
+DROP INDEX jahia_reference_index;
+
+DROP INDEX jahia_reference_index2;
=
CREATE INDEX jahia_acl_index ON jahia_acl (id_jahia_acl);
=
@@ -222,4 +224,8 @@
=
CREATE INDEX jahia_indexingjobs_index ON jahia_indexingjobs (id_indexingjo=
b);
=
-CREATE INDEX jahia_languages_states_index ON jahia_languages_states (workf=
low_state, siteid);
\ No newline at end of file
+CREATE INDEX jahia_languages_states_index ON jahia_languages_states (workf=
low_state, siteid);
+
+CREATE INDEX jahia_reference_index ON jahia_reference (ref_type, ref_id);
+
+CREATE INDEX jahia_reference_index2 ON jahia_reference (page_id);
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/mssql/jahia-schema.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.sql&re=
v=3D18054&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.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mssql/jahia-schema.sql Tue Jul 24 18:10:33 2007
@@ -104,6 +104,7 @@
drop table jahia_pwd_policies;
drop table jahia_pwd_policy_rule_params;
drop table jahia_pwd_policy_rules;
+drop table jahia_reference;
drop table jahia_resources;
drop table jahia_retrule;
drop table jahia_retrule_range;
@@ -561,6 +562,12 @@
periodical tinyint not null,
primary key (jahia_pwd_policy_rule_id)
);
+create table jahia_reference (
+ page_id int not null,
+ ref_id int not null,
+ ref_type int not null,
+ primary key (page_id, ref_id, ref_type)
+);
create table jahia_resources (
name_resource nvarchar(200) not null,
languagecode_resource nvarchar(10) not null,
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=3D18054&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 Jul 24 18:10:33 2007
@@ -110,6 +110,9 @@
=
DROP INDEX jahia_languagestates_index ON jahia_languages_states ;
=
+DROP INDEX jahia_reference_index;
+
+DROP INDEX jahia_reference_index2;
=
CREATE INDEX jahia_acl_index ON jahia_acl (id_jahia_acl);
=
@@ -235,4 +238,8 @@
=
CREATE INDEX jahia_indexingjobs_index ON jahia_indexingjobs (id_indexingjo=
b);
=
-CREATE INDEX jahia_languagestates_index ON jahia_languages_states (workflo=
w_state, siteid);
\ No newline at end of file
+CREATE INDEX jahia_languagestates_index ON jahia_languages_states (workflo=
w_state, siteid);
+
+CREATE INDEX jahia_reference_index ON jahia_reference (ref_type, ref_id);
+
+CREATE INDEX jahia_reference_index2 ON jahia_reference (page_id);
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/mysql/jahia-schema.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.sql&re=
v=3D18054&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.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
mysql/jahia-schema.sql Tue Jul 24 18:10:33 2007
@@ -104,6 +104,7 @@
drop table if exists jahia_pwd_policies;
drop table if exists jahia_pwd_policy_rule_params;
drop table if exists jahia_pwd_policy_rules;
+drop table if exists jahia_reference;
drop table if exists jahia_resources;
drop table if exists jahia_retrule;
drop table if exists jahia_retrule_range;
@@ -561,6 +562,12 @@
periodical bit not null,
primary key (jahia_pwd_policy_rule_id)
);
+create table jahia_reference (
+ page_id integer not null,
+ ref_id integer not null,
+ ref_type integer not null,
+ primary key (page_id, ref_id, ref_type)
+);
create table jahia_resources (
name_resource varchar(200) not null,
languagecode_resource varchar(10) not null,
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=3D18054&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 Jul 24 18:10:33 2007
@@ -100,6 +100,9 @@
=
DROP INDEX jahia_languagestates_index;
=
+DROP INDEX jahia_reference_index;
+
+DROP INDEX jahia_reference_index2;
=
CREATE INDEX jahia_acl_index2 ON jahia_acl (parent_id_jahia_acl, id_jahia_=
acl);
=
@@ -202,3 +205,7 @@
CREATE INDEX jahia_indexingjobsserver_index ON jahia_indexingjobsserver (i=
ndexingjobid, serverid);
=
CREATE INDEX jahia_languagestates_index ON jahia_languages_states (workflo=
w_state, siteid);
+
+CREATE INDEX jahia_reference_index ON jahia_reference (ref_type, ref_id);
+
+CREATE INDEX jahia_reference_index2 ON jahia_reference (page_id);
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/oracle/jahia-schema.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.sql&r=
ev=3D18054&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.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
oracle/jahia-schema.sql Tue Jul 24 18:10:33 2007
@@ -52,6 +52,7 @@
drop table jahia_pwd_policies cascade constraints;
drop table jahia_pwd_policy_rule_params cascade constraints;
drop table jahia_pwd_policy_rules cascade constraints;
+drop table jahia_reference cascade constraints;
drop table jahia_resources cascade constraints;
drop table jahia_retrule cascade constraints;
drop table jahia_retrule_range cascade constraints;
@@ -509,6 +510,12 @@
periodical number(1,0) not null,
primary key (jahia_pwd_policy_rule_id)
);
+create table jahia_reference (
+ page_id number(10,0) not null,
+ ref_id number(10,0) not null,
+ ref_type number(10,0) not null,
+ primary key (page_id, ref_id, ref_type)
+);
create table jahia_resources (
name_resource varchar2(200) not null,
languagecode_resource varchar2(10) not null,
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=3D18054&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 Jul 24 18:10:33 2007
@@ -110,7 +110,9 @@
=
DROP INDEX jahia_languagestates_index;
=
+DROP INDEX jahia_reference_index;
=
+DROP INDEX jahia_reference_index2;
=
CREATE INDEX jahia_acl_index ON jahia_acl (id_jahia_acl);
=
@@ -236,4 +238,8 @@
=
CREATE INDEX jahia_indexingjobs_index ON jahia_indexingjobs (id_indexingjo=
b);
=
-CREATE INDEX jahia_languagestates_index ON jahia_languages_states (workflo=
w_state, siteid);
\ No newline at end of file
+CREATE INDEX jahia_languagestates_index ON jahia_languages_states (workflo=
w_state, siteid);
+
+CREATE INDEX jahia_reference_index ON jahia_reference (ref_type, ref_id);
+
+CREATE INDEX jahia_reference_index2 ON jahia_reference (page_id);
Modified: branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/s=
chema/postgresql/jahia-schema.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.s=
ql&rev=3D18054&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.sql (original)
+++ branches/JAHIA-5-0-SP-BRANCH/core/src/webapp/WEB-INF/var/db/sql/schema/=
postgresql/jahia-schema.sql Tue Jul 24 18:10:33 2007
@@ -104,6 +104,7 @@
drop table jahia_pwd_policies;
drop table jahia_pwd_policy_rule_params;
drop table jahia_pwd_policy_rules;
+drop table jahia_reference;
drop table jahia_resources;
drop table jahia_retrule;
drop table jahia_retrule_range;
@@ -561,6 +562,12 @@
periodical bool not null,
primary key (jahia_pwd_policy_rule_id)
);
+create table jahia_reference (
+ page_id int4 not null,
+ ref_id int4 not null,
+ ref_type int4 not null,
+ primary key (page_id, ref_id, ref_type)
+);
create table jahia_resources (
name_resource varchar(200) not null,
languagecode_resource varchar(10) not null,
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
