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

   1 CREATE TABLE "LIVE_MEASURES"(
   2     "UUID" VARCHAR(40) NOT NULL,
   3     "PROJECT_UUID" VARCHAR(50) NOT NULL,
   4     "COMPONENT_UUID" VARCHAR(50) NOT NULL,
   5     "METRIC_ID" INTEGER NOT NULL,
   6     "VALUE" DOUBLE,
   7     "TEXT_VALUE" VARCHAR(4000),
   8     "VARIATION" DOUBLE,
   9     "MEASURE_DATA" BLOB,
  10     "UPDATE_MARKER" VARCHAR(40),
  11     "CREATED_AT" BIGINT NOT NULL,
  12     "UPDATED_AT" BIGINT NOT NULL
  13 );
  14 ALTER TABLE "LIVE_MEASURES" ADD CONSTRAINT "PK_LIVE_MEASURES" PRIMARY KEY("UUID");
  15 CREATE INDEX "LIVE_MEASURES_PROJECT" ON "LIVE_MEASURES"("PROJECT_UUID");
  16 CREATE UNIQUE INDEX "LIVE_MEASURES_COMPONENT" ON "LIVE_MEASURES"("COMPONENT_UUID", "METRIC_ID");