diff options
| author | Pierre <pierre.guillot@sonarsource.com> | 2022-05-20 14:19:37 +0200 |
|---|---|---|
| committer | sonartech <sonartech@sonarsource.com> | 2022-05-24 20:10:13 +0000 |
| commit | 065455b4612697f9529e91a883ad74db2c2d8e6b (patch) | |
| tree | 393c7e532ba7b7a5dfeae6d4dff2bb2fec887d4d /server/sonar-db-dao/src/schema/schema-sq.ddl | |
| parent | 00520fc1d9a9c5cb0e7b75a0c703b8cecc6d9f6e (diff) | |
| download | sonarqube-065455b4612697f9529e91a883ad74db2c2d8e6b.tar.gz sonarqube-065455b4612697f9529e91a883ad74db2c2d8e6b.zip | |
SONAR-16419 Creation of new metadata columns in the rule table
Diffstat (limited to 'server/sonar-db-dao/src/schema/schema-sq.ddl')
| -rw-r--r-- | server/sonar-db-dao/src/schema/schema-sq.ddl | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/server/sonar-db-dao/src/schema/schema-sq.ddl b/server/sonar-db-dao/src/schema/schema-sq.ddl index 66155e186f4..dacc969bb29 100644 --- a/server/sonar-db-dao/src/schema/schema-sq.ddl +++ b/server/sonar-db-dao/src/schema/schema-sq.ddl @@ -848,7 +848,19 @@ CREATE TABLE "RULES"( "IS_EXTERNAL" BOOLEAN NOT NULL, "CREATED_AT" BIGINT, "UPDATED_AT" BIGINT, - "TEMPLATE_UUID" CHARACTER VARYING(40) + "TEMPLATE_UUID" CHARACTER VARYING(40), + "NOTE_DATA" CHARACTER LARGE OBJECT, + "NOTE_USER_UUID" CHARACTER VARYING(255), + "NOTE_CREATED_AT" BIGINT, + "NOTE_UPDATED_AT" BIGINT, + "REMEDIATION_FUNCTION" CHARACTER VARYING(20), + "REMEDIATION_GAP_MULT" CHARACTER VARYING(20), + "REMEDIATION_BASE_EFFORT" CHARACTER VARYING(20), + "TAGS" CHARACTER VARYING(4000), + "AD_HOC_NAME" CHARACTER VARYING(200), + "AD_HOC_DESCRIPTION" CHARACTER LARGE OBJECT, + "AD_HOC_SEVERITY" CHARACTER VARYING(10), + "AD_HOC_TYPE" TINYINT ); ALTER TABLE "RULES" ADD CONSTRAINT "PK_RULES" PRIMARY KEY("UUID"); CREATE UNIQUE INDEX "RULES_REPO_KEY" ON "RULES"("PLUGIN_RULE_KEY" NULLS FIRST, "PLUGIN_NAME" NULLS FIRST); |