source.dussan.org Git - sonarqube.git/blob

   1 CREATE TABLE "WEBHOOK_DELIVERIES"(
   2     "UUID" CHARACTER VARYING(40) NOT NULL,
   3     "WEBHOOK_UUID" CHARACTER VARYING(40) NOT NULL,
   4     "PROJECT_UUID" CHARACTER VARYING(40) NOT NULL,
   5     "CE_TASK_UUID" CHARACTER VARYING(40),
   6     "ANALYSIS_UUID" CHARACTER VARYING(40),
   7     "NAME" CHARACTER VARYING(100) NOT NULL,
   8     "URL" CHARACTER VARYING(2000) NOT NULL,
   9     "SUCCESS" BOOLEAN NOT NULL,
  10     "HTTP_STATUS" INTEGER,
  11     "DURATION_MS" BIGINT NOT NULL,
  12     "PAYLOAD" CHARACTER LARGE OBJECT NOT NULL,
  13     "ERROR_STACKTRACE" CHARACTER LARGE OBJECT,
  14     "CREATED_AT" BIGINT NOT NULL
  15 );
  16 ALTER TABLE "WEBHOOK_DELIVERIES" ADD CONSTRAINT "PK_WEBHOOK_DELIVERIES" PRIMARY KEY("UUID");
  17 CREATE INDEX "CE_TASK_UUID" ON "WEBHOOK_DELIVERIES"("CE_TASK_UUID" NULLS FIRST);
  18 CREATE INDEX "IDX_WBHK_DLVRS_WBHK_UUID" ON "WEBHOOK_DELIVERIES"("WEBHOOK_UUID" NULLS FIRST);