diff options
| author | Guillaume Jambet <guillaume.jambet@sonarsource.com> | 2018-02-27 12:05:54 +0100 |
|---|---|---|
| committer | Guillaume Jambet <guillaume.jambet@gmail.com> | 2018-03-01 15:21:05 +0100 |
| commit | a06b72df4145098826c085f23999bbf911d20260 (patch) | |
| tree | 22c786ccdc5e8e9227e6ad735ae111c4efbd2af7 /server/sonar-db-core/src | |
| parent | fe6b80b7f3f7d8903ec98cbc15684dc31f25c795 (diff) | |
| download | sonarqube-a06b72df4145098826c085f23999bbf911d20260.tar.gz sonarqube-a06b72df4145098826c085f23999bbf911d20260.zip | |
SONAR-10345 Ensure that no orphaned deliveries remains when deleting webhooks.
Diffstat (limited to 'server/sonar-db-core/src')
| -rw-r--r-- | server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl index aad6a316acd..e036bd73dda 100644 --- a/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl +++ b/server/sonar-db-core/src/main/resources/org/sonar/db/version/schema-h2.ddl @@ -769,7 +769,7 @@ CREATE INDEX "PROJECT_WEBHOOK" ON "WEBHOOKS" ("PROJECT_UUID"); CREATE TABLE "WEBHOOK_DELIVERIES" ( "UUID" VARCHAR(40) NOT NULL PRIMARY KEY, - "WEBHOOK_UUID" VARCHAR(40), + "WEBHOOK_UUID" VARCHAR(40) NOT NULL, "COMPONENT_UUID" VARCHAR(40) NOT NULL, "ANALYSIS_UUID" VARCHAR(40), "CE_TASK_UUID" VARCHAR(40), @@ -777,7 +777,7 @@ CREATE TABLE "WEBHOOK_DELIVERIES" ( "URL" VARCHAR(2000) NOT NULL, "SUCCESS" BOOLEAN NOT NULL, "HTTP_STATUS" INT, - "DURATION_MS" INT, + "DURATION_MS" INT NOT NULL, "PAYLOAD" CLOB NOT NULL, "ERROR_STACKTRACE" CLOB, "CREATED_AT" BIGINT NOT NULL |