From 96656c619439784a97a818e97ac0b37cddac3cb5 Mon Sep 17 00:00:00 2001 From: Julien Lancelot Date: Tue, 26 Jan 2016 10:49:07 +0100 Subject: SONAR-6226 USERS.EXTERNAL_IDENTITY columns has size 255 --- .../src/main/java/org/sonar/db/version/v54/AddUsersIdentityColumns.java | 2 +- sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl | 2 +- .../test/java/org/sonar/db/version/v54/AddUsersIdentityColumnsTest.java | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) (limited to 'sonar-db') diff --git a/sonar-db/src/main/java/org/sonar/db/version/v54/AddUsersIdentityColumns.java b/sonar-db/src/main/java/org/sonar/db/version/v54/AddUsersIdentityColumns.java index 989ae5db81c..e9fcdd6e440 100644 --- a/sonar-db/src/main/java/org/sonar/db/version/v54/AddUsersIdentityColumns.java +++ b/sonar-db/src/main/java/org/sonar/db/version/v54/AddUsersIdentityColumns.java @@ -47,7 +47,7 @@ public class AddUsersIdentityColumns extends DdlChange { private String generateSql() { return new AddColumnsBuilder(db.getDialect(), "users") - .addColumn(newVarcharColumnDefBuilder().setColumnName("external_identity").setLimit(4000).setIsNullable(true).build()) + .addColumn(newVarcharColumnDefBuilder().setColumnName("external_identity").setLimit(255).setIsNullable(true).build()) .addColumn(newVarcharColumnDefBuilder().setColumnName("external_identity_provider").setLimit(100).setIsNullable(true).build()) .build(); } diff --git a/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl b/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl index d6d582573ac..781fa94ed3f 100644 --- a/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl +++ b/sonar-db/src/main/resources/org/sonar/db/version/schema-h2.ddl @@ -320,7 +320,7 @@ CREATE TABLE "USERS" ( "REMEMBER_TOKEN_EXPIRES_AT" TIMESTAMP, "ACTIVE" BOOLEAN DEFAULT TRUE, "SCM_ACCOUNTS" VARCHAR(4000), - "EXTERNAL_IDENTITY" VARCHAR(4000), + "EXTERNAL_IDENTITY" VARCHAR(255), "EXTERNAL_IDENTITY_PROVIDER" VARCHAR(100), "CREATED_AT" BIGINT, "UPDATED_AT" BIGINT diff --git a/sonar-db/src/test/java/org/sonar/db/version/v54/AddUsersIdentityColumnsTest.java b/sonar-db/src/test/java/org/sonar/db/version/v54/AddUsersIdentityColumnsTest.java index 4981763b600..6287a8f3f08 100644 --- a/sonar-db/src/test/java/org/sonar/db/version/v54/AddUsersIdentityColumnsTest.java +++ b/sonar-db/src/test/java/org/sonar/db/version/v54/AddUsersIdentityColumnsTest.java @@ -45,7 +45,7 @@ public class AddUsersIdentityColumnsTest { migration.execute(); db.assertColumnDefinition("users", "external_identity_provider", VARCHAR, 100); - db.assertColumnDefinition("users", "external_identity", VARCHAR, 4000); + db.assertColumnDefinition("users", "external_identity", VARCHAR, 255); } } -- cgit v1.2.3