[exo-jcr-commits] exo-jcr SVN: r5172 - jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage.

Author: tolusha Date: 2011-11-08 07:57:43 -0500 (Tue, 08 Nov 2011) New Revision: 5172 Modified: jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-myisam-utf8.sql jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql Log: EXOJCR-1612: fix mysql scripts Modified: jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-myisam-utf8.sql =================================================================== --- jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-myisam-utf8.sql 2011-11-08 11:06:51 UTC (rev 5171) +++ jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-myisam-utf8.sql 2011-11-08 12:57:43 UTC (rev 5172) @@ -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=MyISAM; 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=MyISAM; CREATE UNIQUE INDEX JCR_IDX_SVALUE_PROPERTY ON JCR_SVALUE(PROPERTY_ID, ORDER_NUM); Modified: jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql =================================================================== --- jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql 2011-11-08 11:06:51 UTC (rev 5171) +++ jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage/jcr-sjdbc.mysql-utf8.sql 2011-11-08 12:57:43 UTC (rev 5172) @@ -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);