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

   1 CREATE TABLE "PROJECTS"(
   2     "UUID" VARCHAR(40) NOT NULL,
   3     "KEE" VARCHAR(400) NOT NULL,
   4     "QUALIFIER" VARCHAR(10) NOT NULL,
   5     "ORGANIZATION_UUID" VARCHAR(40) NOT NULL,
   6     "NAME" VARCHAR(2000),
   7     "DESCRIPTION" VARCHAR(2000),
   8     "PRIVATE" BOOLEAN NOT NULL,
   9     "TAGS" VARCHAR(500),
  10     "CREATED_AT" BIGINT,
  11     "UPDATED_AT" BIGINT NOT NULL
  12 );
  13 ALTER TABLE "PROJECTS" ADD CONSTRAINT "PK_NEW_PROJECTS" PRIMARY KEY("UUID");
  14 CREATE UNIQUE INDEX "UNIQ_PROJECTS_KEE" ON "PROJECTS"("KEE");
  15 CREATE INDEX "IDX_QUALIFIER" ON "PROJECTS"("QUALIFIER");
  16
  17 CREATE TABLE "WEBHOOKS"(
  18     "UUID" VARCHAR(40) NOT NULL,
  19     "ORGANIZATION_UUID" VARCHAR(40),
  20     "PROJECT_UUID" VARCHAR(40),
  21     "NAME" VARCHAR(100) NOT NULL,
  22     "URL" VARCHAR(2000) NOT NULL,
  23     "SECRET" VARCHAR(200),
  24     "CREATED_AT" BIGINT NOT NULL,
  25     "UPDATED_AT" BIGINT
  26 );
  27 ALTER TABLE "WEBHOOKS" ADD CONSTRAINT "PK_WEBHOOKS" PRIMARY KEY("UUID");
  28 CREATE INDEX "ORGANIZATION_WEBHOOK" ON "WEBHOOKS"("ORGANIZATION_UUID");
  29 CREATE INDEX "PROJECT_WEBHOOK" ON "WEBHOOKS"("PROJECT_UUID");