From a06b72df4145098826c085f23999bbf911d20260 Mon Sep 17 00:00:00 2001 From: Guillaume Jambet Date: Tue, 27 Feb 2018 12:05:54 +0100 Subject: SONAR-10345 Ensure that no orphaned deliveries remains when deleting webhooks. --- .../src/main/resources/org/sonar/db/version/schema-h2.ddl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'server/sonar-db-core/src') 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 -- cgit v1.2.3