Author: pnedonosko
Date: 2010-01-28 07:03:22 -0500 (Thu, 28 Jan 2010)
New Revision: 1604
Modified:
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.sybase.sql
Log:
EXOJCR-432 Sybase value datatype IMAGE
Modified:
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.sybase.sql
===================================================================
---
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.sybase.sql 2010-01-28
11:00:52 UTC (rev 1603)
+++
jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-mjdbc.sybase.sql 2010-01-28
12:03:22 UTC (rev 1604)
@@ -60,7 +60,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 IDENTITY NOT NULL,
- DATA VARBINARY(255) NULL,
+ DATA IMAGE NULL,
ORDER_NUM INT NOT NULL,
PROPERTY_ID VARCHAR(96) NOT NULL,
STORAGE_DESC VARCHAR(512) NULL,
Show replies by date