Author: cmailleux
Date: Tue Sep 18 15:24:48 2007
New Revision: 18546
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D18546&repname=
=3Djahia
Log:
Reduce size to 150 fro groups key to avoid key problem on MySQL
Modified:
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.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.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.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=3D18546&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 Sep 18 15:24:48 2007
@@ -331,14 +331,14 @@
primary key (fieldid_jahia_fields_prop, propertyname_jahia_fields_prop)
);
create table jahia_grp_access (
- id_jahia_member varchar(200) not null,
- id_jahia_grps varchar(200) not null,
+ id_jahia_member varchar(150) not null,
+ id_jahia_grps varchar(150) not null,
membertype_grp_access integer not null,
primary key (id_jahia_member, id_jahia_grps, membertype_grp_access)
);
create table jahia_grp_prop (
id_jahia_grp integer not null,
- name_jahia_grp_prop varchar(150) not null,
+ name_jahia_grp_prop varchar(50) not null,
provider_jahia_grp_prop varchar(50) not null,
grpkey_jahia_grp_prop varchar(200) not null,
value_jahia_grp_prop varchar(255),
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=3D18546&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 Sep 18 15:24:48 2007
@@ -329,14 +329,14 @@
primary key (fieldid_jahia_fields_prop, propertyname_jahia_fields_prop)
);
create table jahia_grp_access (
- id_jahia_member nvarchar(200) not null,
- id_jahia_grps nvarchar(200) not null,
+ id_jahia_member nvarchar(150) not null,
+ id_jahia_grps nvarchar(150) not null,
membertype_grp_access int not null,
primary key (id_jahia_member, id_jahia_grps, membertype_grp_access)
);
create table jahia_grp_prop (
id_jahia_grp int not null,
- name_jahia_grp_prop nvarchar(150) not null,
+ name_jahia_grp_prop nvarchar(50) not null,
provider_jahia_grp_prop nvarchar(50) not null,
grpkey_jahia_grp_prop nvarchar(200) not null,
value_jahia_grp_prop nvarchar(255) null,
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=3D18546&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 Sep 18 15:24:48 2007
@@ -329,14 +329,14 @@
primary key (fieldid_jahia_fields_prop, propertyname_jahia_fields_prop)
);
create table jahia_grp_access (
- id_jahia_member varchar(200) not null,
- id_jahia_grps varchar(200) not null,
+ id_jahia_member varchar(150) not null,
+ id_jahia_grps varchar(150) not null,
membertype_grp_access integer not null,
primary key (id_jahia_member, id_jahia_grps, membertype_grp_access)
);
create table jahia_grp_prop (
id_jahia_grp integer not null,
- name_jahia_grp_prop varchar(150) not null,
+ name_jahia_grp_prop varchar(50) not null,
provider_jahia_grp_prop varchar(50) not null,
grpkey_jahia_grp_prop varchar(200) not null,
value_jahia_grp_prop varchar(255),
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=3D18546&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 Sep 18 15:24:48 2007
@@ -278,14 +278,14 @@
primary key (fieldid_jahia_fields_prop, propertyname_jahia_fields_prop)
);
create table jahia_grp_access (
- id_jahia_member varchar2(200) not null,
- id_jahia_grps varchar2(200) not null,
+ id_jahia_member varchar2(150) not null,
+ id_jahia_grps varchar2(150) not null,
membertype_grp_access number(10,0) not null,
primary key (id_jahia_member, id_jahia_grps, membertype_grp_access)
);
create table jahia_grp_prop (
id_jahia_grp number(10,0) not null,
- name_jahia_grp_prop varchar2(150) not null,
+ name_jahia_grp_prop varchar2(50) not null,
provider_jahia_grp_prop varchar2(50) not null,
grpkey_jahia_grp_prop varchar2(200) not null,
value_jahia_grp_prop varchar2(255),
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=3D18546&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 Sep 18 15:24:48 2007
@@ -329,14 +329,14 @@
primary key (fieldid_jahia_fields_prop, propertyname_jahia_fields_prop)
);
create table jahia_grp_access (
- id_jahia_member varchar(200) not null,
- id_jahia_grps varchar(200) not null,
+ id_jahia_member varchar(150) not null,
+ id_jahia_grps varchar(150) not null,
membertype_grp_access int4 not null,
primary key (id_jahia_member, id_jahia_grps, membertype_grp_access)
);
create table jahia_grp_prop (
id_jahia_grp int4 not null,
- name_jahia_grp_prop varchar(150) not null,
+ name_jahia_grp_prop varchar(50) not null,
provider_jahia_grp_prop varchar(50) not null,
grpkey_jahia_grp_prop varchar(200) not null,
value_jahia_grp_prop varchar(255),
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
