Author: pnedonosko
Date: 2010-02-01 12:45:38 -0500 (Mon, 01 Feb 2010)
New Revision: 1630
Modified:
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.db2.sql
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.db2v8.sql
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.db2.sql
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.db2v8.sql
Log:
EXOJCR-455 DB2 dialects support BLOBs upto 2G
Modified:
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.db2.sql
===================================================================
---
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.db2.sql 2010-02-01
12:22:56 UTC (rev 1629)
+++
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.db2.sql 2010-02-01
17:45:38 UTC (rev 1630)
@@ -20,7 +20,7 @@
CREATE UNIQUE INDEX JCR_IDX_MITEM_PARENT_ID ON JCR_MITEM(I_CLASS, PARENT_ID, ID, VERSION
DESC);
CREATE TABLE JCR_MVALUE(
ID BIGINT generated by default as identity (START WITH 2, INCREMENT BY 1) NOT NULL,
- DATA BLOB,
+ DATA BLOB(2G) NOT LOGGED COMPACT,
ORDER_NUM INTEGER NOT NULL,
PROPERTY_ID VARCHAR(96) NOT NULL,
STORAGE_DESC VARCHAR(512),
Modified:
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.db2v8.sql
===================================================================
---
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.db2v8.sql 2010-02-01
12:22:56 UTC (rev 1629)
+++
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.db2v8.sql 2010-02-01
17:45:38 UTC (rev 1630)
@@ -20,7 +20,7 @@
CREATE UNIQUE INDEX JCR_IDX_MITEM_PID ON JCR_MITEM(I_CLASS, PARENT_ID, ID, VERSION
DESC);
CREATE TABLE JCR_MVALUE(
ID BIGINT generated by default as identity (START WITH 2, INCREMENT BY 1) NOT NULL,
- DATA BLOB,
+ DATA BLOB(2G) NOT LOGGED COMPACT,
ORDER_NUM INTEGER NOT NULL,
PROPERTY_ID VARCHAR(96) NOT NULL,
STORAGE_DESC VARCHAR(512),
Modified:
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.db2.sql
===================================================================
---
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.db2.sql 2010-02-01
12:22:56 UTC (rev 1629)
+++
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.db2.sql 2010-02-01
17:45:38 UTC (rev 1630)
@@ -22,7 +22,7 @@
CREATE INDEX JCR_IDX_SITEM_PARENT_FK ON JCR_SITEM(PARENT_ID);
CREATE TABLE JCR_SVALUE(
ID BIGINT generated by default as identity (START WITH 2, INCREMENT BY 1) NOT NULL,
- DATA BLOB,
+ DATA BLOB(2G) NOT LOGGED COMPACT,
ORDER_NUM INTEGER NOT NULL,
PROPERTY_ID VARCHAR(96) NOT NULL,
STORAGE_DESC VARCHAR(512),
Modified:
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.db2v8.sql
===================================================================
---
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.db2v8.sql 2010-02-01
12:22:56 UTC (rev 1629)
+++
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.db2v8.sql 2010-02-01
17:45:38 UTC (rev 1630)
@@ -22,7 +22,7 @@
CREATE INDEX JCR_IDX_SITEM_PFK ON JCR_SITEM(PARENT_ID);
CREATE TABLE JCR_SVALUE(
ID BIGINT generated by default as identity (START WITH 2, INCREMENT BY 1) NOT NULL,
- DATA BLOB,
+ DATA BLOB(2G) NOT LOGGED COMPACT,
ORDER_NUM INTEGER NOT NULL,
PROPERTY_ID VARCHAR(96) NOT NULL,
STORAGE_DESC VARCHAR(512),