aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJulien Lancelot <julien.lancelot@sonarsource.com>2015-12-07 15:37:14 +0100
committerJulien Lancelot <julien.lancelot@sonarsource.com>2015-12-07 15:37:14 +0100
commit12f5b6d7a2b865d979e54b39b225afb88499af26 (patch)
tree6df821e239a08d9b46941f2a774b3cde012ba739
parent96405d5fbeddecffbf6723a99bd7cf3fae43739e (diff)
downloadsonarqube-12f5b6d7a2b865d979e54b39b225afb88499af26.tar.gz
sonarqube-12f5b6d7a2b865d979e54b39b225afb88499af26.zip
SONAR-6884 Add missing clob columns migration
The following columns were not migrated activities.data_field, file_sources .line_hashes, issue_filters.data, measure_filters.data, properties.text_value and rules.note_data
-rw-r--r--sonar-db/src/main/java/org/sonar/db/version/v53/FixMsSqlCollation.java6
1 files changed, 6 insertions, 0 deletions
diff --git a/sonar-db/src/main/java/org/sonar/db/version/v53/FixMsSqlCollation.java b/sonar-db/src/main/java/org/sonar/db/version/v53/FixMsSqlCollation.java
index fa40e20fa26..2c4ef18cab4 100644
--- a/sonar-db/src/main/java/org/sonar/db/version/v53/FixMsSqlCollation.java
+++ b/sonar-db/src/main/java/org/sonar/db/version/v53/FixMsSqlCollation.java
@@ -138,6 +138,7 @@ public class FixMsSqlCollation extends DdlChange {
.addVarcharColumn("name", 200)
.addVarcharColumn("status", 40)
.addVarcharColumn("language", 20)
+ .addClobColumn("note_data")
.addVarcharColumn("note_user_login", 255)
.addVarcharColumn("remediation_function", 20)
.addVarcharColumn("default_remediation_function", 20)
@@ -183,6 +184,7 @@ public class FixMsSqlCollation extends DdlChange {
new UpdateTableCollation(context, db, "properties")
.addIndex("properties_key", "prop_key")
.addVarcharColumn("prop_key", 512)
+ .addClobColumn("text_value")
.execute();
// project_links
@@ -317,6 +319,7 @@ public class FixMsSqlCollation extends DdlChange {
.addIndex("measure_filters_name", "name")
.addNotNullableVarcharColumn("name", 100)
.addVarcharColumn("description", 4000)
+ .addClobColumn("data")
.execute();
// issues
@@ -362,6 +365,7 @@ public class FixMsSqlCollation extends DdlChange {
.addNotNullableVarcharColumn("name", 100)
.addVarcharColumn("user_login", 255)
.addVarcharColumn("description", 4000)
+ .addClobColumn("data")
.execute();
// issue_filter_favourites
@@ -396,6 +400,7 @@ public class FixMsSqlCollation extends DdlChange {
.addVarcharColumn("log_type", 250)
.addVarcharColumn("log_action", 250)
.addVarcharColumn("log_message", 250)
+ .addClobColumn("data_field")
.execute();
// file_sources
@@ -404,6 +409,7 @@ public class FixMsSqlCollation extends DdlChange {
.addUniqueIndex("file_sources_uuid_type", "file_uuid", "data_type")
.addNotNullableVarcharColumn("project_uuid", 50)
.addNotNullableVarcharColumn("file_uuid", 50)
+ .addClobColumn("line_hashes")
.addVarcharColumn("data_type", 20)
.addVarcharColumn("data_hash", 50)
.addVarcharColumn("src_hash", 50)