You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-commits@jackrabbit.apache.org by re...@apache.org on 2018/03/12 14:41:39 UTC
svn commit: r1826551 - in /jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb: RDBBlobStoreDB.java RDBDocumentStoreDB.java

Author: reschke
Date: Mon Mar 12 14:41:39 2018
New Revision: 1826551

URL: http://svn.apache.org/viewvc?rev=1826551&view=rev
Log:
OAK-7329: RDB*Store for SQLServer: name the PK index for better readability

Modified:
    jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBBlobStoreDB.java
    jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreDB.java

Modified: jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBBlobStoreDB.java
URL: http://svn.apache.org/viewvc/jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBBlobStoreDB.java?rev=1826551&r1=1826550&r2=1826551&view=diff
==============================================================================
--- jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBBlobStoreDB.java (original)
+++ jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBBlobStoreDB.java Mon Mar 12 14:41:39 2018
@@ -64,7 +64,8 @@ public enum RDBBlobStoreDB {
         @Override
         public String getDataTableCreationStatement(String tableName) {
             return "create table " + tableName + " (ID varchar(" + RDBBlobStore.IDSIZE
-                    + ") not null primary key, DATA varbinary(max))";
+                    + ") not null, DATA varbinary(max)"
+                    + "constraint "  + tableName + "_PK primary key clustered (ID ASC))";
         }
     },
 

Modified: jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreDB.java
URL: http://svn.apache.org/viewvc/jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreDB.java?rev=1826551&r1=1826550&r2=1826551&view=diff
==============================================================================
--- jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreDB.java (original)
+++ jackrabbit/oak/trunk/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreDB.java Mon Mar 12 14:41:39 2018
@@ -654,10 +654,11 @@ public enum RDBDocumentStoreDB {
         public String getTableCreationStatement(String tableName, int schema) {
             // see https://issues.apache.org/jira/browse/OAK-2395
             return ("create table " + tableName
-                    + " (ID varbinary(512) not null primary key, MODIFIED bigint, HASBINARY smallint, DELETEDONCE smallint, MODCOUNT bigint, CMODCOUNT bigint, DSIZE bigint, "
+                    + " (ID varbinary(512) not null, MODIFIED bigint, HASBINARY smallint, DELETEDONCE smallint, MODCOUNT bigint, CMODCOUNT bigint, DSIZE bigint, "
                     + (schema >= 1 ? "VERSION smallint, " : "")
                     + (schema >= 2 ? "SDTYPE smallint, SDMAXREVTIME bigint, " : "")
-                    + "DATA nvarchar(4000), BDATA varbinary(max))");
+                    + "DATA nvarchar(4000), BDATA varbinary(max), "
+                    + "constraint "  + tableName + "_PK primary key clustered (ID ASC))");
         }
 
         @Override