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
