Author: tolusha Date: 2011-11-01 08:26:02 -0400 (Tue, 01 Nov 2011) New Revision: 5137 Modified: jcr/tags/1.14.3-GA/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql Log: EXOJCR-1515: fix mysql script Modified: jcr/tags/1.14.3-GA/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql =================================================================== --- jcr/tags/1.14.3-GA/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql 2011-10-31 12:31:42 UTC (rev 5136) +++ jcr/tags/1.14.3-GA/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql 2011-11-01 12:26:02 UTC (rev 5137) @@ -13,7 +13,7 @@ N_ORDER_NUM INTEGER, P_TYPE INTEGER, P_MULTIVALUED BOOLEAN, - CONSTRAINT JCR_PK_SITEM PRIMARY KEY(ID) + CONSTRAINT JCR_PK_SITEM PRIMARY KEY(ID), CONSTRAINT JCR_FK_SITEM_PARENT FOREIGN KEY(PARENT_ID) REFERENCES JCR_SITEM(ID) ) ENGINE=InnoDB; CREATE UNIQUE INDEX JCR_IDX_SITEM_PARENT ON JCR_SITEM(CONTAINER_NAME, PARENT_ID, NAME(255), I_INDEX, I_CLASS, VERSION DESC); @@ -26,7 +26,7 @@ ORDER_NUM INTEGER NOT NULL, PROPERTY_ID VARCHAR(56) NOT NULL, STORAGE_DESC VARCHAR(512), - CONSTRAINT JCR_PK_SVALUE PRIMARY KEY(ID) + CONSTRAINT JCR_PK_SVALUE PRIMARY KEY(ID), CONSTRAINT JCR_FK_SVALUE_PROPERTY FOREIGN KEY(PROPERTY_ID) REFERENCES JCR_SITEM(ID) ) ENGINE=InnoDB; CREATE UNIQUE INDEX JCR_IDX_SVALUE_PROPERTY ON JCR_SVALUE(PROPERTY_ID, ORDER_NUM);