[exo-jcr-commits] exo-jcr SVN: r3595 - jcr/branches/1.12.x/exo.jcr.component.core/src/main/resources/conf/storage.

Author: dkuleshov Date: 2010-12-02 09:02:19 -0500 (Thu, 02 Dec 2010) New Revision: 3595 Modified: jcr/branches/1.12.x/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.mysql-utf8.sql jcr/branches/1.12.x/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql Log: JCR-1532: MySQL-UTF8 dialect collation set to case-sensitive Modified: jcr/branches/1.12.x/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.mysql-utf8.sql =================================================================== --- jcr/branches/1.12.x/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.mysql-utf8.sql 2010-12-02 13:52:47 UTC (rev 3594) +++ jcr/branches/1.12.x/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.mysql-utf8.sql 2010-12-02 14:02:19 UTC (rev 3595) @@ -5,7 +5,7 @@ CREATE TABLE JCR_MITEM( ID VARCHAR(56) NOT NULL, PARENT_ID VARCHAR(56) NOT NULL, - NAME VARCHAR(512) CHARACTER SET utf8 NOT NULL, + NAME VARCHAR(512) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, VERSION INTEGER NOT NULL, I_CLASS INTEGER NOT NULL, I_INDEX INTEGER NOT NULL, @@ -36,4 +36,4 @@ ORDER_NUM INTEGER NOT NULL, CONSTRAINT JCR_PK_MREF PRIMARY KEY(NODE_ID, PROPERTY_ID, ORDER_NUM) ); -CREATE UNIQUE INDEX JCR_IDX_MREF_PROPERTY ON JCR_MREF(PROPERTY_ID, ORDER_NUM); \ No newline at end of file +CREATE UNIQUE INDEX JCR_IDX_MREF_PROPERTY ON JCR_MREF(PROPERTY_ID, ORDER_NUM); Modified: jcr/branches/1.12.x/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql =================================================================== --- jcr/branches/1.12.x/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql 2010-12-02 13:52:47 UTC (rev 3594) +++ jcr/branches/1.12.x/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql 2010-12-02 14:02:19 UTC (rev 3595) @@ -5,7 +5,7 @@ CREATE TABLE JCR_SITEM( ID VARCHAR(56) NOT NULL, PARENT_ID VARCHAR(56) NOT NULL, - NAME VARCHAR(512) CHARACTER SET utf8 NOT NULL, + NAME VARCHAR(512) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, VERSION INTEGER NOT NULL, CONTAINER_NAME VARCHAR(24) NOT NULL, I_CLASS INTEGER NOT NULL, @@ -37,4 +37,4 @@ ORDER_NUM INTEGER NOT NULL, CONSTRAINT JCR_PK_SREF PRIMARY KEY(NODE_ID, PROPERTY_ID, ORDER_NUM) ); -CREATE UNIQUE INDEX JCR_IDX_SREF_PROPERTY ON JCR_SREF(PROPERTY_ID, ORDER_NUM); \ No newline at end of file +CREATE UNIQUE INDEX JCR_IDX_SREF_PROPERTY ON JCR_SREF(PROPERTY_ID, ORDER_NUM);